skip to Main Content

Red Nose Special: 24 Distinctive Ways to Die

By Avi Singh [Twitter]

Folks, May 21st is being celebrated as Red Nose Day across USA. Goal is to have some fun and raise money for children living in poverty. We at PowerPivotPro mix a bit of black humor in today’s post and promise to donate a portion of the proceeds from our upcoming PowerPivot Online Class (Jun 8-9) to Red Nose Day.

For today’s special, we were inspired by the CDC released graph showing distinctive causes of death by state. Not content to stare at a picture, we rebuilt the model from scratch using Power Query, Power Pivot and Power Map. Which lets us slice and dice and visualize the data various ways to our heart’s content.

Our results match closely with that of CDC, slight differences may exist since we use 10 year span from 2004-2013, whereas CDC researchers reportedly used 2001-2010.


Power Map Rendering of Distinctive Cause of Death by State

Distinctive cause of death


Distinctive Cause of Death by State (Click to see full list)

Read the Rest

What is Power BI?

by Rob Collie

Power BI, Definition #1: An Umbrella Term for all of the Power Tools

Power BI, Definition #1:  An “Umbrella” Term for all of the “Power *” Tools
(Click for Full-Size Version)

An Overdue Treatment

I’ve posted before about Power Pivot vs. Power View and then later I added Power Query and other technologies to the explanation, but I’ve never just straight-on tackled the question of “What is Power BI?”  So let’s get that off the list…

…And clean up my prior visuals while we are at it.  (Can you believe that Power Query doesn’t have an icon/logo yet?  Well, boom – I just gave it one.  You’re welcome, Microsoft – although really it was just from one of the buttons already in PQ.)

Unofficial Definition = “Umbrella Term for the ‘Power *’ Tools”

#1, Power BI is an “umbrella” term that is used to describe all of the various “Power” data tools that Microsoft offers us.  This is NOT the definition that you will typically hear from Microsoft, but colloquially, when someone says “Power BI,” there’s a good chance this is what they mean.

Official Definition = “The Cloud Publish & Manage Service from MS”

But I think Microsoft would say, more officially, that Power BI is their paid cloud service for publishing, sharing, managing, and consuming the results of those tools pictured above.

For instance, Microsoft sales reps today are measured, in part, by their customers’ adoption of precisely that online subscription service.  They are NOT measured by how many of their customers are simply using the “free” desktop tools included in the Power BI “umbrella” term.

Read the Rest