Facebook Twitter LinkedIn YouTube E-mail
Home Microsoft Archive for category "PowerPivot" (Page 3)
formats

Farmers Market Data on a BI Map in Excel 2013

Share

In the Upper Midwest, August is the best time of year for the greatest variety and the most abundant supply of produce at local Farmers Markets.  Different vegetables, fruits, and other locally sourced products are available in numerous hierarchies of variety.  What better time than now to create a Business Intelligence map using Excel 2013

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Farmers Market Data on a BI Map in Excel 2013  comments 
formats

Create a BI Pareto Chart with a PowerPivot Data Model in Excel

Share

A couple of years ago I posted a video demonstrating the process by which to create a Pareto Chart in Excel using an SSAS cube data connection.  As a follow-up to that video, this post will walk through the process by which to create a Pareto Chart in Excel 2010 using a PowerPivot data model

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Create a BI Pareto Chart with a PowerPivot Data Model in Excel  comments 
formats

Create a Dynamic BI Distribution Chart in PowerPivot using DAX

Share

A few weeks ago I published a post detailing the process by which to create a histogram with dynamic bins using DAX in PowerPivot.  While standard histograms are useful to visualize distribution, even greater analytic value can be derived from that same data by converting a histogram into a distribution chart.  Those of you who

(More)…

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

Video: The GNet Group SightN2 for Healthcare BI Solution

Share

GNet Group’s SightN2TM for Healthcare is a Business Intelligence solution that provides a standardized foundation for the integration of healthcare information into a data warehouse for interactive, intuitive dashboards and reports that can become the foundation for unified data within a Business Intelligence solution.  The solution is designed to integrate data that most hospitals already report

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Video: The GNet Group SightN2 for Healthcare BI Solution  comments 
formats

Create a BI Histogram with Dynamic Bins using DAX in PowerPivot

Share

When building a histogram, how many bins should it have?  There’s no definitive answer to the question, but the number of bins used for a histogram can drastically impact how visualized data is interpreted.  Details such as data distribution patterns and sample quantity can impact how data is displayed in bins, and quite often the

(More)…

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