Facebook Twitter LinkedIn YouTube E-mail RSS
Home Posts tagged "BI" (Page 2)
formats

How to Master PowerPivot

Share

Time and time again, our customers ask us where they can find more resources and training on Microsoft’s PowerPivot. PowerPivot is an extremely powerful and dynamic tool used for data modeling and exploration that brings self-service BI to everyone through Excel 2013. One suggestion we give to our customers is to visit powerpivotpro.com and explore

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on How to Master PowerPivot  comments 
formats

Deliver on the Promise of Healthcare MDM

Share

Healthcare organizations continue to be challenged by data governance. On one hand there is the legacy challenge of implementing data governance across multiple disparate systems, including those harboring hidden departmental applications. On the other hand, there are new and ongoing challenges presented by the complex requirements of the Affordable Care Act and other compliance mandates.

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Deliver on the Promise of Healthcare MDM  comments 
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
Comments Off on Dynamic MDX for when the Last Day of Data isn’t Always “Day-1”  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
Comments Off on Dynamic BI Pareto Analysis using PowerPivot for Excel  comments