Category: Power BI

Sales Management Dashboard with Power BI The example below creates a Power BI sales dashboard solution to visualize sales data for a sales manager.  The data is loaded into Power BI to create several views that enable everyone from Sales Managers to Sales Reps to gain insights into the performance of the sales team. To Read More …

Build Power BI Data Quality Dashboards Organizations continue to struggle with data quality in their applications.  Finding and cleaning core data elements can often be time consuming and difficult to organize.  Business users need an easy way to see current issues in their data as well as make changes in source applications to see the Read More …

Create Executive Dashboards using Power BI Managers need the ability to see data from different areas of the business.  Organizing this data into easy to use visualizations enables you to determine trends and discover insights.  In addition, you can create mashups that pull data from different sources into a single dashboard view.  Executive Dashboard with Read More …

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 Read More …

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 Read More …

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 Read More …

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 Read More …

Use SQL Server SSAS Tabular Models to Enhance your Power BI reports Companies with SQL Server licenses running in production most likely already own but are not using SQL Server Analysis Services (SSAS).  To get the most from your existing investment in SQL licenses.  Companies should explore how SQL Server SSAS Tabular Models  can increase the performance Read More …

Selecting the Power BI Version for Your Business Microsoft’s Power BI is their flagship product for data visualization.  It enables businesses to connect to hundreds of data sources, build and deliver dashboards, and share content with others in your organization.  Since it is cloud based, users can view the information from inside their network or Read More …

Power BI Direct Query Power BI can be used in one of two modes to access data.  The import option loads data from the source data to the Power BI model.  Queries are then processed directly against the data in the model.  Using the DirectQuery option, on the other hand, leaves at the source and Power Read More …

Houston Crime Data The city of Houston provides high level details on crime statistics via Excel files on the police website.  These statistics are stored in monthly files available via Excel or Access.  In order to better understand the crime data I created a single Excel file that stored the data from August 2016 to December Read More …