Interactive Power BI Report

---

Microsoft Power BI has a feature that allows users to publish PowerBI.com reports to any public website or app that allows for iFrame embedding. The report above is a live, interactive Power BI report.  Take a few minutes to play with it.  This post will walk through the major features and then progress to a step-by-step instruction on how to integrate a Power BI report into your web page.   

The data in the report was integrated using the internuntius inCollatio™ business analytics architecture. The information is a combination of US Census data and NFL team data.  The data was combined based on the city where each NFL team is located. All the Power BI chart elements are linked together, so clicking on any element will dynamically filter the information displaying on the other related elements in the report.  Give it a try. Click on a city from the map and all the data in the other charts is filtered to represent the data and percent of total for that selected city. You can look at groups of teams by using the filters in the bottom right of the report to pick AFC or NFC (American Football Conference and National Football Conference). Then you can further slice the report data by division (north, south, east and west).  So, for example, if you choose NFC and North from the slicers, you’ll see the Vikings, Packers, Bears, and Lions along with the various ethnicity, gender, crime and economic statistics related to the cities.  The data is averaged together to show the median value of the teams selected.

One thing you’ll notice if you look hard at the data is that some of the teams are represented in more than one city. One example is the Rams, who are listed both in St. Louis and also in Los Angeles.  This is because our dataset contains historical team data going back to the inception of the NFL and we have individual player member data going back over 10 years.

There is one significant feature worth mentioning. This feature is only available on the PowerBI.com website while looking at the dashboard.  Dashboards are not able to be exported for web viewing. Only Reports can be exported. Having said that, there’s a feature in Power BI Dashboards called Natural Language Query. To use, just start typing questions in the query entry and Power BI will analyze your question and dynamically create a custom chart using the underlying datasets in the dashboard to attempt to answer your question through a data visualization.

Diversity and Market Dynamism

A more diverse market can lead to growth and more market dynamism. Want to move to an area with both an NFL team and a diverse population? By typing the question: “teams with more black than white” in the natural language query prompt, Power BI automatically provided the following scatter plot of the Census Ethnicity for Black vs. White by NFL team.

Take a look and you can quickly see that Green Bay, Wisconsin has a 73% white population with only 4% black (and other) population. On the other end of the spectrum, Detroit, Michigan has an ethnic mix of 83% black and only 8% white. Minnesota and Chicago are in the middle. So the NFC North has the absolutely most diverse ethnic makeup of any conference division in the entire NFL: