Facebook Twitter LinkedIn YouTube E-mail
Home Posts tagged "BI" (Page 4)
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

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 
formats

Video: FAA Wildlife Strike Data BI Dashboards with PowerPivot

Share

A new video has been uploaded to YouTube that summarizes the first two posts in the FAA Wildlife Strike Data series of articles: BI Design for FAA Aircraft Wildlife Strike Data (click here to read) FAA Aircraft Wildlife Strike Data Model and Dashboard in PowerPivot (click here to read) Power View BI Motion Charts in

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Video: FAA Wildlife Strike Data BI Dashboards with PowerPivot  comments 
formats

May 2012 Business Intelligence Month in Review

Share

An entire month has already passed since our inaugural monthly review post.  The links below summarize a few highlights from the month of May, which has been an eventful month: GNet Group won the Microsoft Partner of the Quarter Award for the North Central Region.  Additionally, GNet Group’s Neelesh Raheja won an award for Microsoft

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on May 2012 Business Intelligence Month in Review  comments