Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
 Posted - 2013-06-29 : 07:45:29
|
| Hi Guys,I have a requirements to do a Dashboard. this will be publishand display in TV monitor in production.presently we did a Dashboard made in powerpoint.it is manually operated. daily we change the data manually.we are planning to automate the dashboard.the requirements will refresh the data every 30 min or every hour.the data will be coming from our DAX system.can you give me any advice what should i use to make the Dashboard.its possible to use the Powerpivot or SSRS.this is the sample format of Dashboard.Cumulative Shipment--this is month to date data-------------------4,000-------------------Daily Shipment --daily output of production-------------------1000at the bottom i will place a chat/graph that contains the month to date transaction.thanks.JOV |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-29 : 14:49:22
|
| you can use powerpivot or powerview or even Performancepoint services in Sharepoint------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2013-06-29 : 22:45:44
|
| what if i don't have the sharepoint any other option? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-01 : 01:28:43
|
quote:
Originally posted by Villanuev
what if i don't have the sharepoint any other option?
powerpivot is also available on Excel as a plugin from 2012 onwards------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2013-07-01 : 02:53:23
|
| Hi Visakh,I have an existing Powerpivot excel 2010 which i tried to make a sample dashboard.I just created an script for Daily shipment which is the actual output. just select tge fromdatabasethe select the from SQL server. my concern is the other query.How could i put the other query for actual shipments? they have different requirements and output.i the result set of this 2 scruipt i will place it into 1 dashboard. its possible to combine these query into one pivot table? meaning different tab/sheet. thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-01 : 02:56:49
|
quote:
Originally posted by Villanuev
Hi Visakh,I have an existing Powerpivot excel 2010 which i tried to make a sample dashboard.I just created an script for Daily shipment which is the actual output. just select tge fromdatabasethe select the from SQL server. my concern is the other query.How could i put the other query for actual shipments? they have different requirements and output.i the result set of this 2 scruipt i will place it into 1 dashboard. its possible to combine these query into one pivot table? meaning different tab/sheet. thanks.
you need to create a table based on relationship in powerpivot model. Use query as a source and write query involving the tables based on your join condition. Then you'll get resultset as a table in powerpivot which you can utilize for reportsIf its in different sheets you can also bring them as different tables in powerpivot and set relationships inside it. Then you can write DAX formulas to create calculated columns depending on your requirement and use them onto your reports.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Dashboard