Contoso Revenue, Average Selling Price and Gross Profit

Click on the image for the live dashboard

Google Analytics Dashboard

Click on the image for the live dashboard

Other Samples

Power BI: Dynamic Row Level Security (RLS)

Implementing dynamic row level security (RLS) for each table in a Power BI data model based on someone’s username can be tricky to understand, let alone implement. In this sample, I’ve created a scaled down data model from the Power BI Solution Templates for Sales Management with Salesforce and Dynamics CRM, using dynamic RLS based on username. You can see the DAX expressions built into measures used for the implementation, as well as test what subset of all data each username would see when they are logged in.

To see screen shots, click here.

For access to the Power BI data model .pbix file for Power BI Desktop, send a quick email.

 

Power BI: Employment Levels and Weekly Wages by State and County

If you are running a business, what can you learn from Bureau of Labor Statistics data regarding employment levels and average weekly wages in the US for your industry? When paired with some Power BI mapping visualizations, potentially a lot. This sample looks at county and state level data from Q4 2015 in all 50 states for the Mining, Quarrying and Oil & Gas industry (NAICS 21).

To see screen shots, click here.

To access the Power BI dashboard online, send a quick email.

Power BI: Colorado New Business Entity Formation Q2 2016 by City

Using data from the Colorado Secretary of State’s office and the US Census Bureau, a picture of where new business entity formation in Colorado is going on in Q2 2016. The top 10 biggest cities by population are not the top 10 places where new business entities were being formed…in particular, Littleton and Parker are punching above their weight.

To see screen shots, click here.

To access the Power BI dashboard online, send a quick email.

Power BI: The disconnected table as user interface parameter

With all due credit to Mssrs Collie and Singh, an example of a disconnected table that acts as a parameter widget on the user interface. In this instance, converting the average cost of vehicles by Make and Model in USD to their “what if” equivalent in EUR for a selected exchange rate. When no exchange rate is selected, no values are shown for the cost in EUR.

To see screen shots, click here.

To download a copy of the Power BI Desktop file yourself, or to access it online, send a quick email.

Cluster Analysis in R: Motor Trend Cars

Most of the time you’ll see samples of k-means cluster analysis in R with “iris” data, so I thought I’d be different and use “mtcars”. Finding hidden clusters/groups in data, then visualizing some of the attributes for each group (e.g. MPG, HP) with Power BI. This type of analysis can be applied to data about “things” like cars or flowers, as well as “people” like customers and employees. Many kinds of business data lend themselves to finding hidden groupings that provide new insights for better decisions.

To see screenshots, click here.

To download a copy of the R script and Power BI Desktop file for yourself, or to access it online, send a quick email.

 

Power BI: Median Household Income on the I-36 Corridor

It’s not a lot of fun unflattening Census Data, but this ends up being an interesting look at the difference in Median Household Income among Boulder, Broomfield and Denver counties by household type.

To see screen shots, click here.

To download a copy of the Power BI Desktop file for yourself, or to access it online, send a quick email.

Power BI: 2016 Presidential Election Primaries

Who got how many votes in each primary for both parties, by State and County?

To see screen shots, click here.

To download a copy of the Power BI Desktop file for yourself, or to access it online, send a quick email.

Tableau Desktop: Men’s 2016 NCAA March Madness – Games Scores

I wondered if the distance that teams play from their home court was related to winning. So I got the data and answered my own question, plus a few others, using Tableau Desktop.

To see screen shots, click here.

To download a copy of the Tableau packaged workbook for yourself,  send a quick email.

Web Scraping with R: Men’s 2016 NCAA March Madness – Box Scores

Run these R scripts to web scrape the Semifinals and Finals box scores from the Men’s 2016 NCAA basketball tournament into CSV files. You would NOT want to type all this in manually!

To download a copy of the R scripts for yourself,  send a quick email.

Power BI: 10k Race Analysis

Number of participants by age and gender in a histogram, with an overlay of average mile splits by age and gender. Slice and dice your way to see how different age brackets for both men and women compare.

To see screen shots, click here.

To download a copy of the Power BI Desktop file for yourself, or to access it online, send a quick email.

Power BI: Contoso I

Some DAX measures and dashboarding around Sales, Profit and Quantity  by Product Category, Channel, Continent and Day of the Week for one of the best known fictitious companies in the Microsoft world…but never as famous as AdventureWorks :)

To see screen shots, click here.

To download a copy of the Power BI Desktop file for yourself, or to access it online, send a quick email.