Derek

/Derek

About Derek

I am the founder and CEO of CDO Advisors a data and analytics consulting and training company. We specialize in helping companies get more value from their data with high value low risk projects. I have been publishing articles and books for over 20 years on SQL Server, data and architecture.

Top 5 Reasons Why CFOs Need Dashboards with Microsoft Power BI

How CFO Dashboards are Better with Power BI Imagine having the ability to see the data you need where and when you need it.  Dashboards enable a visual representation of your companies data in a consolidated platform.  This data can be from a variety of sources pulled together into a seamless experience for the management team.  By visualizing your data you can quickly spot trends and anomalies in your operations.  Then take action and improve your operations and service to your customers.  Having a CFO Dashboard in Power BI can save time finding information.  In addition it will enable faster decisions and provide a clear view of your business.  By using Microsoft's Power BI to power your dashboards you get 5 key advantages. 5 Advantages of Power BI Dashboards Nominal Cost of Licenses - The standard user license is $10 USD per user per month.  Get your team up and running [...]

By |2020-05-17T11:04:23-05:00January 21st, 2019|Power BI|1 Comment

RapidMiner Auto Model for Online Data Mining

Get started with Data Mining using RapidMiner Auto Model RapidMiner recently released their online data modeling tool called Auto Model.  This product allows you to upload data and have RapidMiner build initial data models for you.  Currently there are limited algorithms that are available, however, the tool is a great way to get started with RapidMiner and learning data science. Available algorithms: Decision Tree Naive Bayes Generalized Linear Model Logistical Regression Watch the our youtube video - Auto Model Titanic Example Try out the product - automodel.rapidminer.com        

By |2019-04-22T02:06:52-05:00October 21st, 2018|Data Mining, RapidMiner|Comments Off on RapidMiner Auto Model for Online Data Mining

RapidMiner Wisdom Conference Sponsor

RapidMiner Conference Sponsor Come join me at RapidMiner Wisdom Conference on October 10-12, 2018 in New Orleans.  CDO Advisors is proud to be a RapidMiner sponsor for this event.  It should be a great few days of learning how to get the most from RapidMiner and apply it to business problems.    

By |2019-08-09T10:48:45-05:00October 9th, 2018|RapidMiner|Comments Off on RapidMiner Wisdom Conference Sponsor

Power BI and Sales

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 see the complete solution - Power BI Sales Dashboard   CDO Advisors Microsoft Power BI Solutions: BI as a Service – Low Monthly Fees, Pay Per Month Per User Executive Dashboards – Get Dashboards in 4 Weeks Healthcare Dashboard Proof of Concept – SEE your data visualized Microsoft Power BI Demo – Compare your current reporting to Power BI Power BI Quick Start Solutions – Ready to start or enhance your Power BI? Train Your Team – Remote Power BI Developer and End User Training Use Power BI for Finance Teams – Learn how Power BI can improve operations Virtual Chief Data Officer – [...]

By |2020-05-17T12:04:47-05:00August 31st, 2018|Power BI|Comments Off on Power BI and Sales

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 [...]

By |2020-05-17T12:13:26-05:00August 26th, 2018|Power BI|Comments Off on Power BI Data Quality

Executive Dashboards Examples with Power BI

Create Executive Dashboards using Power BI Executives 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.  An executive dashboard with Power BI help you visualize your data and enables your employees to make better data driven decisions.  Unlock your data from databases and Excel spreadsheets being shown only in large grids.  Interactive reports and dashboards can be designed specifically for each of your CXOs.  For instance, a CDO dashboard can pull together information on the quality of the data around your company. 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 [...]

By |2020-05-19T07:54:38-05:00August 6th, 2018|Power BI|Comments Off on Executive Dashboards Examples with Power BI

Use Power BI Project Tracking Reports on Capital Projects

Power BI Project Tracking - Capital Projects 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   CDO Advisors Microsoft Power BI Solutions: BI as a Service – Low Monthly Fees, Pay Per Month Per User Executive Dashboards – Get Dashboards in 4 Weeks Healthcare Dashboard Proof of Concept – SEE your data visualized Microsoft Power BI Demo – Compare your current reporting to Power BI Power BI Quick Start [...]

By |2020-05-17T12:09:56-05:00July 23rd, 2018|Power BI|Comments Off on Use Power BI Project Tracking Reports on Capital Projects

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     CDO Advisors Microsoft Power BI Solutions: BI as a Service – Low Monthly Fees, Pay Per Month Per User Executive Dashboards – Get Dashboards [...]

By |2020-05-17T12:11:53-05:00July 23rd, 2018|Power BI|Comments Off on Power BI and Credit Union Membership

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 CDO Advisors Microsoft Power BI Solutions: BI as a Service – Low Monthly Fees, Pay Per Month Per User Executive Dashboards – Get Dashboards in 4 Weeks Healthcare Dashboard Proof of Concept – SEE your data visualized Microsoft Power BI Demo – Compare your current reporting to Power BI Power BI Quick Start Solutions – Ready to start or enhance your Power BI? Train Your Team – Remote Power BI Developer and End User Training Use Power [...]

By |2020-05-17T12:12:38-05:00July 17th, 2018|Power BI|Comments Off on Power BI and Retail Sales

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-05:00July 9th, 2018|Power BI|Comments Off on Power BI and Text Mining