Monthly Archives: July 2018

//July

Power BI and Capital Projects

Tracking Capital Projects with Power BI This example pulls data related to projects and creates a dashboard that enables users to quickly see actual vs budget and variance.  The status of the projects are shown as well as the breakout of projects by sponsor.  The graphs are interactive and can be filtered by selecting a checkbox on the right such as CapEx or OpEx or by selecting a section on a graph such as Refinery.  There are two pages on this report to provide a comprehensive view of your projects.   To see the complete report - Capital Project Dashboard

By |2019-04-22T02:15:47+00:00July 23rd, 2018|Power BI|0 Comments

Power BI and Credit Union Membership

Credit Union Membership Map in Power BI This example uses membership data for a fictional credit union to map the members by zipcode.  A heatmap is then created to show which zip codes have the most members.  The darker the color the more members are in that zip code.  In addition, the 4 branch locations are added as red pins with a 10 minute drive time.  The map is interactive and clicking on a zip code or push pin will highlight the appropriate data.  This information was also combined with US Census data to show the number of households by income bands to help you determine where to build new locations or target your marketing efforts. Click here for the full interactive report - Credit Union  

By |2019-04-22T02:17:27+00:00July 23rd, 2018|Power BI|0 Comments

Power BI and Retail Sales

Retail Sales Dashboard with Power BI The example below creates a Power BI solution to visualize retail sales data from each store.  The data is loaded into Power BI to create several views that enable everyone from store managers to regional executives to gain insights into the performance of stores and products.  Easily see the percentage of sale by different categories such as Business Segment, Region, Category or Location. To see the complete solution on PowerBI - Retail Sales Dashboard

By |2019-04-22T02:18:25+00:00July 17th, 2018|Power BI|0 Comments

Power BI and Text Mining

  Finding the Loch Ness Monster The example below uses the sighting information from LochNessSightings.com to determine the area that provides your best chance of viewing the Loch Ness Monster.  This report is based on the out of mining the text descriptions using RapidMiner to find the common nouns in the text.  Then the out is stored and visualized with Power BI to produce a heatmap with the sightings.  In your business, you can use this same technique to text mine any description fields such as call center notes, claim notes, part failure information, project notes.  To quickly spot trends or anomalies in your data. View the report here - Loch Ness Monster Sightings in Power BI  

By |2019-04-22T02:21:12+00:00July 9th, 2018|Power BI|0 Comments