Facebook Twitter LinkedIn YouTube E-mail
Home Posts tagged "Microsoft BI" (Page 3)
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
Comments Off on Dynamic BI Pareto Analysis using PowerPivot for Excel  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
Comments Off on Create a Dynamic Median MDX Calculation on a PerformancePoint KPI Scorecard  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
Comments Off on Visualize Trends with Power View Motion Scatter Charts  comments 
formats

Excel with PowerPivot for Custom Dimensions in Reports Blended with EDW Data

Share

Comprehensive Enterprise Data Warehouse (EDW) architecture and management requires a disciplined, centrally-managed strategy. Often, analysts within an organization require dimension designs that are complex and evolving. For example, subject matter experts for healthcare organizations often deal with dimensional attributes for healthcare performance measures such as ORYX, HEDIS, and Meaningful Use.  Such cohort inclusion lists can

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Excel with PowerPivot for Custom Dimensions in Reports Blended with EDW Data  comments 
formats

PowerPivot as a Documentation Browsing Tool Using CMS EHR Data

Share

PowerPivot is a versatile tool that can be used for many purposes.  Mash-up data from different sources, rapidly create BI dashboards, or use PowerPivot as a data modeling tool for development of an Enterprise Data Warehouse.  This post will focus on another use that can be useful for PowerPivot, a tool for optimizing the browsing

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on PowerPivot as a Documentation Browsing Tool Using CMS EHR Data  comments