Facebook Twitter LinkedIn YouTube E-mail RSS
Home Posts tagged "business intelligence" (Page 3)
formats

MDM and BI: Why a Single View to Corporate Data is Still Critical

Share

As we gear up for the second GNet Group/Profisee seminar — this time in Dallas — our team synced on key historical and present-day MDM and BI issues.  This post includes a few thoughts and considerations from that team sync. We’ll follow-up with more after the 7/18 seminar in Dallas.   MDM and BI, Then

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Dynamic MDX for when the Last Day of Data isn’t Always “Day-1”

Share

When building a report or a dashboard, have you ever encountered a situation where the last day of data in a cube isn’t a consistent distance from the current day?  For example, what if “Yesterday” is sometimes “Two Days Ago”?  When building a KPI that displays the last day of data for a scorecard on

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Dynamic BI Pareto Analysis using PowerPivot for Excel

Share

In July I posted an article detailing the process by which to create a Dynamic BI Pareto Chart in Excel using PowerPivot.  That post can be reviewed at this link.  A video from a few years ago with a walk-through for creating a Pareto Chart can be also found at this link.  While a Pareto

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Create a Dynamic Median MDX Calculation on a PerformancePoint KPI Scorecard

Share

Have you ever been asked to add a new KPI to a scorecard, only to find that there is not a corresponding calculation or measure in the cube?  With PerformancePoint 2010 KPIs for SharePoint 2010 scorecards, custom MDX expressions can be created as actual and target values without requiring modifications to be made to the

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Visualize Trends with Power View Motion Scatter Charts

Share

When visualizing data, multiple measures and attributes can often be difficult to display in a manner that is both useful and easily consumed.  Power View for SQL Server 2012 can be used to create motion scatter charts that display multiple measures, attributes, and trends in a manner that exudes simplicity. For this example, sample demo

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments