Machine Learning

Use Power BI Decomposition Tree for Root Cause Analysis

Power BI Decomposition Tree Breaking Down Your Data Use the Decomposition Tree Visual in Power BI to explore your data and gain insights into how parts contribute to the whole.  Drill into hierarchies to see how each part contributes to the total.  Enable faster analysis for your team and gain data driven insights.  Using this visual enables you to break down a metric by the dimensions of your data to see the impact of each.  This can be used for root cause analysis such as failure of parts, operational processes or determining where you highest sales are coming from. How to enable decomposition tree in Power BI While in Preview mode, you will need to enable the feature in the Power BI options and then restart Power BI.   First, Open Power BI Desktop and the select File > Options and Settings and then Options.  This will open the Options [...]

By |2020-06-26T10:27:32-05:00November 13th, 2019|Power BI|Comments Off on Use Power BI Decomposition Tree for Root Cause Analysis

Power BI Key Influencers Analytics Example

What is Power BI Key Influencers Visualization? The Power BI Key Influencers visualization is designed to help you understand what data impacts the metric you are interested in.  For example, I used the Titanic dataset to see what data was influencing the survival of a passenger.  In this example, I want to see what factors about the passengers were critical to their survival.  We all have heard women and children first.  Now let us see what the data shows and how to get that information from the Key Influencers visualization. These are the columns I used to derive my results within Power BI Key Influencers. survived - What we want to see the influence on Sex pclass  (Passenger Class) fare cabin age ticket Once these values are setup in the options for the Key Influencers it quickly produced the following result.  As you can see the likelihood of surviving [...]

By |2020-06-26T11:51:04-05:00October 5th, 2019|Power BI|Comments Off on Power BI Key Influencers Analytics Example

DataCon Houston 2019

CDO Advisors Sponsors DataCon Houston 2019 I am proud to partner with DataCon Houston 2019 as a Silver sponsor.  This conference is on October 9th and 10th at Top Golf in Katy, TX.  Come learn about automation and data analytics for oil and gas and petrochemicals.  Not in one of those industries?  That's OK, the focus in about AI and data analytics.  See what other industries are doing and how you can apply it to your own. There are 3 focus areas Data Ontology, Artificial Intelligence, Simulation Capabilities. Come learn about these areas and how they can be used to improve your business operations.  We will have information on how to get better insights with your data through data visualizations.  See how to get data on your phone or tablet and know how your business is performing at any time.  Track critical KPIs and get consolidated dashboards. Learn more and [...]

By |2019-10-02T13:01:09-05:00October 2nd, 2019|Power BI|Comments Off on DataCon Houston 2019

CDO Advisors Quick Start Packages

Power BI, Analytics and Data Science Quick Start CDO Advisors Quick Start packages offer businesses a low cost option to explore Power BI, Analytics or data science.  Executives know they need better information from their data and are often confused on what technologies are available to transform their data.  You know your management team is frustrated by their ability to make data driven decisions based on data science and predictive analytics.  Our quick start packages are designed to get you a working proof of concept in as little as 5 or 10 days.  All of our packages leverage your data to provide better reporting, analytics, or data science.  As a result of these packages, see exactly what your business could gain by investing in these technologies with minimal cost. Power BI Consulting CDO Advisors can help you implement Power BI Dashboard and reporting solutions in many areas such as: Healthcare [...]

By |2020-05-17T12:02:54-05:00May 12th, 2019|Power BI|Comments Off on CDO Advisors Quick Start Packages

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

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 |2020-05-17T10:50:00-05:00May 23rd, 2018|Business Intelligence|Comments Off on Better Understand Your Credit Union Members

Marketing Customer Information File Overview

Marketing Customer Information File (MCIF) Many financial organizations already have a custom customer view called a marketing customer information file.  Other industries have these as well, called by different name such as master patient index in the healthcare space.  These files are created through existing software or internal jobs to merge data from various sources into a master file or database.  This file contains relevant information on each customer from all systems to enable a holistic view of your customers interactions with your organization.  A sample MCIF data set would include information (one row per customer) such as: Customer ID Member Tenure Checking Account Indicator Saving Account Indicator ATM Card Indicator Number of Monthly Transactions by Type Auto Loan Indicator Home Loan Indicator Last Contact Date Number of Calls to the Contact Center In addition, any other information that can be used for marketing, sales, or product development can [...]

By |2020-06-28T09:00:42-05:00March 27th, 2018|Power BI|Comments Off on Marketing Customer Information File Overview

RapidMiner Text Mining Example for Loch Ness Monster Sightings

RapidMiner Text Mining Text mining is a process to pull words from free form text fields, word documents, or other data sources.  Business use cases for text mining include scrubbing text from survey notes, claim notes, project notes or call center notes.  It is applicable in any situation that requires parsing text to find words and the number of times they appear.  These include uses in various business functions such as Risk Management, Customer Service, Project Management, or Knowledge Management.  RapidMiner text mining enables you gain insight from your business information and transform that into knowledge and actionable insights.  In this example, I will use data collected from the Loch Ness Monster sighting website.  Each sighting is posted with a date and free form text field.  The goal of this example is parse the sighting and determine the most common words by frequency from the information provided. Sample siting from website [...]

By |2020-06-29T13:18:15-05:00September 26th, 2017|Business Intelligence|Comments Off on RapidMiner Text Mining Example for Loch Ness Monster Sightings

Cross Selling and Predictive Analytics

Increase Revenue Cross Selling with Predictive Analytics Understand how data mining and predictive analytics can help you target the best customers for cross selling or up selling opportunities?  By building a predictive analytics model that leverages historical data from your company.  A model can be built and applied to your active customer base that identifies your best offer for a customer.  We can get you next best offer models off the ground in 10 days.  See what is possible with machine learning to increase your revenue and decrease expenses.     Learn more about our Data Quick Start Solutions See how to leverage Data Mining to Improve Business Operations Learn more about Machine Learning

By |2020-06-29T08:09:43-05:00June 25th, 2017|Data Mining|Comments Off on Cross Selling and Predictive Analytics

Predicting Employee Churn with Data Mining

Use Data Mining to Identify Employees at Risk of Churn For organizations that have a lot employees that are in high turnover positions.  Predicting employee churn with data mining can help to reduce and retain top talent.  By collecting data on employees and then building a predictive model using employees that have left the organization.  You can create models that will give you new insights into the characteristics of employees that are at risk of leaving.  By having this score you can then match up the performance of the employee to determine options to keep your talent and prevent them from leaving.  For example a call center, sales team, or temporary agencies could all benefit from building models to determine why employees are leaving. Build the Model For this example model, I used a sample dataset that contains various information for each employee.  This data contains both customers that are [...]

By |2020-05-17T11:56:54-05:00May 11th, 2017|Business Intelligence|Comments Off on Predicting Employee Churn with Data Mining
Load More Posts