How we help you transform your business with data

Business Intelligence

Business Intelligence

Data Warehouse Create a single source of truth by deploying a custom data warehouse that supports data driven decisions.  Additional features include Master Data Services and Data Quality Services. Power BI We can help you build and deploy Microsoft Power BI solutions.  Creating interactive dashboards and visualizations that enhances your data and enables better…

Power BI Training

Power BI Training

Executive Dashboards with Power BI Create consolidated views of your critical metrics and KPIs that enable actionable insights and trend analysis. Leverage our Power BI consulting Jump Start to quickly get value from your investment.  We work with your team to build customized dashboards based on data visualization best practices. Knowing what graph to use …

Predictive Analytics

Predictive Analytics

Improve Business Operations with Predictive Analytics Unlock the value of your data to make data driven decisions to improve your revenue. Using our accelerator packages we can work with you to create a pilot project in as little as 12 weeks. Common patterns that can be found with advanced analytics are: What are customers …

Sign up for our newsletter

NEED TO SPEAK TO US?

832-819-5744

sales@cdoadvisors.com

Read our latest blog posts...

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. While in Preview mode, you will need to enable the feature in the Power BI options and then restart Power BI.  The screenshot below shows the proper setup. Analyzing Data with a Decomposition Tree I am using a sample dataset of retail sales.  The sample dataset can be found here – […]

Where is Your Company on the Data Maturity Roadmap

Maturity Model for Data and Analytics Where are you on your data and analytics journey?  Are you getting the value you expect from your business intelligence and analytics reporting environment.  Are you still spending more time on gathering data than you spend analyzing your data?  Applying a framework such as Gartner’s Data Maturity Model enables you to evaluate the level of your organization.  To increase your company’s maturity level you can see what IT and Operational changes need to be implemented. According to Gartner, “A worldwide survey of 196 organizations by Gartner, Inc. showed that 91 percent of organizations have not yet reached a “transformational” level of maturity in data and analytics.” Use the model below to see your current data and analytics maturity. Gartner Survey on Data and Analytics  – 4 minute read Level 1 – Basic Maturity Companies in this level have basic reporting from source systems.  They get […]

Tabular Modeling with SQL Server Analysis Services Cookbook – Contest

.rafflepress-giveaway-iframe-wrapper iframe { width: 1px; min-width: 100%; *width: 100%; height: 1000px; } .rafflepress_iframe_loading { background-image: url('data:image/gif;base64,R0lGODlhEAAQAPIAAP///wAAAMLCwkJCQgAAAGJiYoKCgpKSkiH/C05FVFNDQVBFMi4wAwEAAAAh/hpDcmVhdGVkIHdpdGggYWpheGxvYWQuaW5mbwAh+QQJCgAAACwAAAAAEAAQAAADMwi63P4wyklrE2MIOggZnAdOmGYJRbExwroUmcG2LmDEwnHQLVsYOd2mBzkYDAdKa+dIAAAh+QQJCgAAACwAAAAAEAAQAAADNAi63P5OjCEgG4QMu7DmikRxQlFUYDEZIGBMRVsaqHwctXXf7WEYB4Ag1xjihkMZsiUkKhIAIfkECQoAAAAsAAAAABAAEAAAAzYIujIjK8pByJDMlFYvBoVjHA70GU7xSUJhmKtwHPAKzLO9HMaoKwJZ7Rf8AYPDDzKpZBqfvwQAIfkECQoAAAAsAAAAABAAEAAAAzMIumIlK8oyhpHsnFZfhYumCYUhDAQxRIdhHBGqRoKw0R8DYlJd8z0fMDgsGo/IpHI5TAAAIfkECQoAAAAsAAAAABAAEAAAAzIIunInK0rnZBTwGPNMgQwmdsNgXGJUlIWEuR5oWUIpz8pAEAMe6TwfwyYsGo/IpFKSAAAh+QQJCgAAACwAAAAAEAAQAAADMwi6IMKQORfjdOe82p4wGccc4CEuQradylesojEMBgsUc2G7sDX3lQGBMLAJibufbSlKAAAh+QQJCgAAACwAAAAAEAAQAAADMgi63P7wCRHZnFVdmgHu2nFwlWCI3WGc3TSWhUFGxTAUkGCbtgENBMJAEJsxgMLWzpEAACH5BAkKAAAALAAAAAAQABAAAAMyCLrc/jDKSatlQtScKdceCAjDII7HcQ4EMTCpyrCuUBjCYRgHVtqlAiB1YhiCnlsRkAAAOwAAAAAAAAAAAA==') !important; background-repeat: no-repeat !important; background-position: center 100px !important; height: 100%; } try{ iFrameResize({ log: false, messageCallback: function(messageData) { if (messageData.message == 'rafflepress_loaded') { var el = document.querySelector(".rafflepress_iframe_loading"); var className = "rafflepress_iframe_loading"; if (el.classList) el.classList.remove(className); else el.className = el.className.replace(new RegExp('(^|\b)' + className.split(' ').join('|') + '(\b|$)', 'gi'), ' '); } } }, '#rafflepress-1'); }catch(error) {} function rafflepress_resize_iframe_1(){ //alert('loaded'); iFrameResize({ log: false, messageCallback: function(messageData) { if (messageData.message == 'rafflepress_loaded') { var el = document.querySelector(".rafflepress_iframe_loading"); var className = "rafflepress_iframe_loading"; if (el.classList) el.classList.remove(className); else el.className = el.className.replace(new RegExp('(^|\b)' + className.split(' ').join('|') + '(\b|$)', 'gi'), ' '); } } }, '#rafflepress-1'); };

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 was […]

Derek Wilson

Derek Wilson Headshot