Blog - CDO Advisors

How to Model Power BI Covid 19 Data

How to Model Covid-19 Data using Power BI This is the second in my series on helping you turn the Covid data on GitHub into information. In this post, I show you step by step on how to model Power BI Covid data using Power BI, Power Query and DAX formulas. If you are new to Power BI or just interested in how to use Power BI to build your own Covid report this guide was designed for you. Learn More - Power BI Training Learn More - Power BI Consulting Learn More - Microsoft Power BI Follow our YouTube Channel Getting up to Speed - Model Power BI Covid In the last guide (link below) we took GitHub data and transformed it into a model showing the cumulative Covid-19 cases. In today's guide we will be enhancing the model to make it [...]

By Jakob Wilson|2020-04-01T16:47:34-05:00April 1st, 2020|Power BI|0 Comments

Build Power BI Covid Reports from GitHub Data

A Step by Step Guide to Build Power BI Covid Data Reports from GitHub Covid-19 is top of mind and getting to the data can be easy if you know how. Currently, there is a GitHub project that is collecting data around Covid-19. In this step by step guide, I show you how to use Microsoft Power BI and the Web Connector to access the time-series data. The same process can be used for any GitHub repository if you have the proper URL. Follow the steps below or watch my video to see exactly what you need to do for access to this dataset. By the end of the guide you can build a Power BI Covid report from the GitHub data. Many are familiar with the Johns Hopkins Coronavirus online tool. Learning these skills you can make your own and use it on future projects that don’t involve this pandemic. Learn More - Power BI Training Learn More - [...]

By Jakob Wilson|2020-04-01T15:14:46-05:00March 30th, 2020|Power BI|0 Comments

Trend Analysis with Power BI using MLB Data

Trend Analysis with Power BI Businesses use trend analysis to help improve your business operations. This is done by monitoring data to identifying areas where your business is performing well so you can duplicate success. As well as determine areas in your business that is under performing. One way to improve operations is through trend analysis with Power BI reports and dashboards. Unlock you data's hidden secrets by building powerful visualizations that let you quickly spot trend and patterns. Using Power BI you can easily connect to data and then build reports with interactive visualizations. Examples for Trend Analysis All businesses can use trend analysis to gain insights into their business. Common examples include: Call Center Volumes Sales by Customer Expenses by Category Revenue by Product or Service Claim Volume Oil Production Manufacturing CRM Data ERP Data Learn more about Trend Analysis Trend Analysis with Power [...]

By Derek|2020-03-11T15:12:55-05:00March 11th, 2020|Business Intelligence, Power BI|0 Comments

3 Ways to Improve Manufacturing Analytics with Dashboards

Improve Manufacturing Analytics with Dashboards Regardless of your specific role in manufacturing. Using dashboards for data and analytics will improve your ability to make data driven decisions. Dashboards are graphical views of your data that focus on Key Performance Indicators (KPIs) and metrics that are critical to the success of your organization. There are several types of standard dashboards such as Financial, Operations, Sales and Supply Chain. When you want to get more value from your data, start with a simple dashboard that surfaces the 5-10 critical metrics for your company. You can always expand later, but start small and get value from your investment as quickly as possible. Often, I do this in weeks not months. This should not be a prolonged project, getting value quickly is the goal. Here are 3 ways to Improve Manufacturing Analytics with Dashboards 1 - Accessibility of Data Dashboards enable everyone access the [...]

By Derek|2020-02-22T12:29:26-06:00February 22nd, 2020|Manufacturing Analytics, Power BI|1 Comment

3 Ways to Improve Healthcare Analytics with Dashboards

Improve Healthcare Analytics with Dashboards Regardless of your specific role in the healthcare arena. Using dashboards for data and analytics will improve your ability to make data driven decisions. Dashboards are graphical views of your data that focus on Key Performance Indicators (KPIs) and metrics that are critical to the success of your organization. There are several types of standard dashboards such as Financial, Operations, Sales, Clinical, or Claims. When you want to get more value from your data, start with a simple dashboard that surfaces the 5-10 critical metrics for your company. You can always expand later, but start small and get value from your investment as quickly as possible. Often, I do this in weeks not months. This should not be a prolonged project, getting value quickly is the goal. Here are 3 ways to Improve Healthcare Analytics with Dashboards 1 - Accessibility of Data Dashboards enable everyone [...]

By Derek|2020-02-21T08:38:30-06:00February 21st, 2020|HealthCare, Power BI|0 Comments

Visualize Baltimore Crime Reports with Power BI

Use Power BI to Visualize Baltimore Crime Reports Using Power BI to Visualize Baltimore Crime Reports With Power BI you can take raw data and quickly transform it into easy to use visualizations. For this example, I will be using data from the Baltimore police crime reports public dataset that has data points back to 1963. However, most of the data really starts in 2014. I wanted to see what I could build from the dataset and spent a few hours pulling together the data and then building reports that enable me to see various trends about Baltimore crime reports. Here is a sample of the Baltimore Crime Reports available for download. As you can see it is difficult to spot trends and outliers in this format. If you are looking to visualize your crime report data, please contact us for assistance. [...]

By Derek|2020-01-27T12:08:18-06:00January 5th, 2020|Business Intelligence, Power BI|2 Comments

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

By Derek|2019-11-14T08:07:20-06:00November 13th, 2019|Power BI|0 Comments

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

By Derek|2019-12-26T08:58:46-06:00November 10th, 2019|Power BI|0 Comments

Tabular Modeling with SQL Server Analysis Services Cookbook – Contest

By Derek|2019-11-26T09:55:03-06:00October 17th, 2019|Business Intelligence|0 Comments

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

By Derek|2020-03-16T13:32:58-05:00October 5th, 2019|Power BI|0 Comments