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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Dashboard

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 publish
and 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
-------------------
1000


at 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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?
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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 fromdatabase
the 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.

Go to Top of Page

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 fromdatabase
the 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 reports

If 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -