Derek

/Derek

About Derek

This author has not yet filled in any details.
So far Derek has created 15 blog entries.

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

Primed-AP (Analytic Process)

What is the Primed-AP Methodology? CDO Advisors has launched Primed Analytics Process Homepage to publish content related to our newly published Analytic Process.  The Primed-AP © process was created based on years of experience working with business users to implement predictive analytics.  Existing methodologies focus on the data science tasks but do not include the required tasks for business users.  In order to have a successful project everyone involved needs to understand the roles and responsibilities of the entire process.  Some phases of the process require collaboration between the business and data scientist.  While other phases require more time from the data scientist.  The following section outlines the phases and highlights the responsibilities for the project team.   Full details will be available on the website that describe each step in the process along with typical tasks for business users and data scientists.  This process will enable you to get more value [...]

By |2019-04-22T13:15:10+00:00April 1st, 2018|Data Mining|0 Comments