Derek

/Derek

About Derek

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

Power BI Data Quality

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 impact of data corrections.  Business Analyst can create Power BI Data Quality Dashboards directly against source data to uncover data issues. In this Power BI Dashboard for Product Sales, I built data grids and graphs that show sales by Product Type, Retailer Type and Product Line.  Power BI automatically groups the data on the content available in the data.  Below are examples of data issues that popped out as I was building my dashboard. Spotting Data Quality Issues Product Type - The data shows sales for Eye wear and Eyewear, Latern and Laterns, Sun Screen [...]

By |2019-04-22T02:10:44+00:00August 26th, 2018|Power BI|0 Comments

Executive Dashboard with Power BI

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 Power BI Dashboard Benefits Businesses that leverage dashboards gain more value from their data by enabling more employees to view data in an easy to use format.  No longer do you need to export data to Excel and create pivot tables and charts and then email those around the office.  Dashboards created and deployed on PowerBI.com.  Enable users to access data through a browser and securely through their tablet or smartphone using the PowerBI app. The goal of any dashboard is to visually present the most relevant data to the target audience.  By using various [...]

By |2019-04-22T02:12:04+00:00August 6th, 2018|Power BI|0 Comments

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

Better Understand Your Credit Union Members

Increase Membership with Analytics Leverage advanced data visualization tools to better understand your members and increase membership with analytics.  By combining your credit union member information and external postal code level demographic data.  Maps can be created that color code each postal code based on the concentration of members.  For example, in the graph below postal code 78222 has 40 active members.  In addition, there are 3,685 households that earn under $50K dollars.  There are also 2,440 households that earned between $50K and $100K.  As well as 1,096 households that earn over $150K.   There is also information available for each postal code that lets you know the number of people that rent vs buy their homes, how many cars people have, average number of children and age in each household.  By using this information you can market to your existing customers like never before.  In addition, you can better understand [...]

By |2019-08-09T10:52:21+00:00May 23rd, 2018|Credit Union|0 Comments

Increase Membership and Revenue with Predictive Analytics

Credit Union Membership Increased by Data Mining I am speaking on Friday May 18th, 2018 in Savannah, GA at the National Credit Union Conference for Directors and Senior Management.  My session topic in on how to use predictive analytics to leverage your data to increase membership and revenue.   For financial institutions, the ability to determine cross selling and targeted marketing campaigns can be achieved by leveraging the data you already have.  In this session I leverage multiple technologies to put together a complete picture of member behavior, location and impact.  The image below (for my fictional credit union) shows how many members live in each postal code along with the opportunity of households in postal code.  This type of report can help you focus on areas to increase or decrease marketing to gain membership. Credit Union Member Penetration by Zipcode Session Abstract: Predictive Analytics can provide credit unions [...]

By |2019-08-09T10:54:52+00:00May 18th, 2018|Power BI, RapidMiner|0 Comments

2018 CIO Review Business Intelligence Solution Provider

CDO Advisors included in the Top 20 Business Intelligence Solution Providers We were just included as a 2018 CIO Review Business Intelligence Solution Provider. While data analytics solutions such as BI and predictive analytics have already emerged as an integral factor in bolstering the value chain of big businesses, the Small and Medium Businesses (SMB) are yet far from leveraging their impeccable benefits. The existing rumor that these services are highly expensive, and the challenge of poor data quality and sheer lack of awareness on progressive technology, have become the biggest blocks in preventing SMBs from availing data analytical services. Drawn by the situation, Derek Wilson, an astute entrepreneur endeavored on a journey to aid SMBs to extract maximum value from their data sets. Thus, saw the creation of CDO Advisors, the IT advisory and consultant firm, providing end-to-end data services ranging from data management, business intelligence, predictive analytics, to data [...]

By |2019-08-09T10:51:15+00:00May 6th, 2018|Data Mining, Power BI, RapidMiner|0 Comments

SQL Server Tabular Models (SSAS) and Power BI

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 of their reporting environments and maximize their investment in SQL Server technology.  Transforming your data into a tabular model will allow you to get more performance from Power BI, Excel or other reporting software. Top 3 Reasons to Use SQL Server SSAS Tabular Models Speed - The data in tabular models are deployed to an in-memory data structure that makes your Power BI reports return visualizations faster than using data tables.  If your executive team hates waiting for answers or spinning circle of death Tabular models can help.  Using data compression and in-memory objects allows [...]

By |2019-08-09T10:58:44+00:00April 28th, 2018|Power BI|0 Comments
Load More Posts