Facebook Twitter LinkedIn YouTube E-mail
Home Microsoft Archive for category "Excel" (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

Charts in Excel and Adding a Second Axis

Share

We all use Microsoft Excel for our data analysis needs. A major part of that analysis is data visualization with the use of charts and graphs. But how about the scenario where you’d like to add a second axis to a graph to show two different data sets? Recently, I was working on creating a

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Charts in Excel and Adding a Second Axis  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