SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Dashboard
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Villanuev
Constraint Violating Yak Guru

443 Posts

Posted - 06/29/2013 :  07:45:29  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 06/29/2013 :  14:49:22  Show Profile  Reply with Quote
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

443 Posts

Posted - 06/29/2013 :  22:45:44  Show Profile  Reply with Quote
what if i don't have the sharepoint any other option?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 07/01/2013 :  01:28:43  Show Profile  Reply with Quote
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

443 Posts

Posted - 07/01/2013 :  02:53:23  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 07/01/2013 :  02:56:49  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000