MS Power BI: Use-cases

The immense capability of Microsoft Power BI combined with Geo-Spatial services (GIS), and some super-interactive user thrown in: What does it have for you? Whether you are a business, a state department, a hospital administration, a law enforcement agency, a service provider, or just about anybody, you will be equipped with insightful and highly interactive dashboards. It will help you have greater control of your respective areas of activity and address concerns, ever-so-proactively.

Microsoft Power BI can be employed effectively in various walks of life such as law enforcement, insurance, , energy, manufacturing, social networks (sentiment analysis), life sciences, agriculture, sports, education, hospitality, elections, entertainment, etc.

Let’s look at some case studies (arrived at with the help of sample data) that showcase some of the best uses of MS Power BI.

1. Law Enforcement (Crime spotting):

As in the case of most modern technologies, Power BI is also likely to be embraced whole-heartedly by law enforcement agencies are benefiting immensely from  big-data analytics and other technological innovations.

Power BI dashboards can be used very effectively to get insights into aspects such as the deployment of personnel at critical locations during specific periods of the year by plotting various parameters such as types of crime, incidences, crime patterns, etc.

Sample Dashboards for UK Crime Spotting (Using public data):

These visualizations provide a 360-degree view of crimes that took place in terms of type and the last outcome (the latest status) of each reported crime. Thus helping the local police with additional guidance to deploy their forces to prevent crimes.

Dashboard1:

This interactive dashboard has the following key depictions:

• Dropdowns – Users can select by crime type, city, last Outcome, and/or Reported by
• Map – Depicts the incidences and frequency of various crimes in the selected region
• Pie Chart – Depicts the total count of a crime type
• Waffle Chart – Depicts the percentage of a crime type (from the overall crime count)

Dashboard2:

This interactive dashboard has the following key depictions:

• Horizontal Slicer – Shows the city names for the incidence of selected crime type(s)
• Scatter Chart – Is a visual representation of the crime in terms of ‘Reported by’ and ‘Crime type’
• Dropdowns – Depicts crime type, last outcome in each case, and month during which it occurred.
• Bar Chart – Depicts the count of crimes in terms of who reported it (Reported by)
• Map – Depicts the crime frequency in the selected region

Dashboard3:

This interactive dashboard has the following key depictions:

• Horizontal Slicer – Allows the users to select a city for crime spotting
• Funnel Chart – Count of crimes by Crime Type in a selected region/city
• Donut Chart – Count of Crime types by Last Outcome category
• Horizontal Funnel Chart – Count of Crime types by Reported by
• Lists – Crime type, Last Outcome and Month
• Map – Crime Frequency by Region

Dashboard4:

This interactive dashboard has the following key depictions:

• Ticker – Depicts City-wise count of crimes
• Chord Chart – depicts the correlation (extent) between Crime types to Last Outcome
• Tree Map – Count of Crime Types
• Bow Tie Chart – Count of Crime Type to Reported by connection
• Forced Direct Graph – Crime types by Region
• Dropdowns – City names, Reported by and Last outcome

(Data Source: https://data.police.uk/data/)

2. US healthcare providers’ competitor analysis

MS Power BI can help health-care providers / hospital managements to compare the hospital’s financial performance with its competitors, based on patient population.

This interactive dashboard has the following key depictions:

• Total Covered Charges, Total Payments, Total Medicare Payments, and Total Discharges
• Donut Chart – Total Payments by Provider Name
• Map – Total Payments by Provider State and Provider City
• Stacked bar chart – Average Payments by Provider
• List – Drug Definition

(Data Source: https://www.cms.gov/Research-Statistics-Data-and-Systems)

3. Florida Health Insurance Dashboard

MS Power BI can help insurance agencies with the power to visualize financial performance of policies (based on policy type wise claims) and much more.

This interactive dashboard has the following key depictions:

• Ticker – Count of Claim Policy
• Gauge – Total Revenue
• Aster Plot – Net Loss by Claim Policy
• Stacked Bar Chart – Total revenue by Claim Policy
• Line and Clustered Column Chart – Monthly Profit and Gross Loss by Claim Policy
• Map – Frequency of Claim Policy by Region

(Data Source: https://services1.arcgis.com/G84Qg78md8fRCEAD/ArcGIS/rest/services)

4. US Energy Generation Dashboards

Administrators and various stake-holders related to the energy sector can quickly visualize the energy generation as well as consumption patterns of various states/region/cities to achieve effective and dynamic energy management.

These visualizations provide a quick view of state-wise generation of energy (in Mega Watts) in terms of various energy sources such as coal, nuclear, natural gas, petroleum, wind, etc.

This interactive dashboard has the following key depictions:

• Dropdowns – User choose from the filters Energy Source, Location, Type of Producer and Year
• Sun Burst – Generation (in Megawatts) by Energy Source
• Chicklet Slicer – States of the USA
• Mekko Chart – Energy generation in terms of energy Source and Type of Producer.

(Data Source: https://www.eia.gov/electricity/data/state/)

Do check out the capabilities of MS Power BI through these sample dashboards created by the MSRCosmos Power BI team. Watch out for more in this space – very detailed use-cases and their clear cut benefits.

Science-Art-Signs: of business transformation!