Blog - CDO Advisors

Power BI Desktop Overview for Beginners

What is Microsoft Power BI Desktop? Unlock your data with Microsoft Power BI Desktop the developer tool for the Microsoft Power BI platform. Power BI is a self-service business intelligence platform designed to enable automation and insights into your business. Create interactive data visualizations and reports with Microsoft’s flagship data visualization software. Connect to over 90+ data sources, including Azure data or SQL Server. Import and transform your data set in Power BI then build reports that let you see trends, patterns and outliers in your data. Frequent software enhancements are automatically applied with Power BI updates. Publish your reports to PowerBI.com and access the data via the web or Power BI mobile. Get started for free and upgrade to Power BI Pro to share your content. CDO Advisors Power BI Desktop Canvas Integrate Your Data in Power BI Desktop Unlock your data by combining data inside [...]

By Derek|2020-05-21T09:45:48-05:00May 20th, 2020|Power BI|Comments Off

Health Informatics What You Should Know

What is Health Informatics? When you search the internet for health informatics the first few pages of results are mostly college programs. These do a good job explaining their programs and what you might do after graduation with healthcare data. However, they explore what it's like to work in the field and the variety of data and questions you will cover. I've been doing reporting and data analytic projects for over 20 years. I've worked specifically in healthcare analytics for over 10 years and often get asked what is the difference between working in healthcare and other industries. The answer is the data and regulations around the data. Health informatics is what business intelligence is to non-healthcare companies. Depending upon what type of business your healthcare company is such as provider, payer, hospital, etc. How you use data and your goals can vary based upon your business objectives. Data [...]

By Derek|2020-05-12T10:04:29-05:00May 12th, 2020|HealthCare|Comments Off

Getting Started with Power BI for Healthcare Analytics

Get Started Using Power BI for Healthcare Analytics Do you currently rely on ad-hoc queries and Excel for your healthcare analytics data? Is your team spending more time trying to find the data you need instead of performing analysis on your data? Are you using VLookups to try to mash up your data from different systems? If so, stop wasting time data wrangling and implement a modern data analytic solution like Power BI for healthcare analytics. Transform how you leverage your data and get more value with self-service reporting. Create interactive visualizations to see trends, patterns and outliers in your healthcare data Decrease cost, increase revenue, and improve service by gaining better insights into your data Integrate data from various applications into consolidated reports to deliver better insights Enable self-service reporting by automating data refreshes and keep your reports up to date Gain new insights from your data [...]

By Derek|2020-05-17T12:19:31-05:00April 18th, 2020|HealthCare, Power BI|Comments Off

Data Wrangling Power BI COVID-19 Data

Data Wrangling Power BI Covid-19 Data Layout Changes In the last few weeks CDO Advisors created 2 blog posts to show you how to connect to GitHub and access the Covid-19 time series data. Since the first blog post was created the GitHub data has been modified at least 2 times. While frustrating this shows a great challenge that data scientist and analyst have when sourcing data from systems they do not control. Often you will have to change your Power BI reports to keep up with these data sources. In this post, I show you how to modify your existing report to use the new data by data wrangling Power BI. The GitHub main repository can be found here - https://github.com/CSSEGISandData/COVID-19 CDO Advisors Microsoft Power BI Solutions: BI as a Service - Low Monthly Fees, Pay Per Month Per User Executive Dashboards - Get Dashboards in [...]

By Derek|2020-05-22T09:58:00-05:00April 12th, 2020|Power BI|Comments Off

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. 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 easier to use. Let's get started and Model Power BI Covid data. Build Power BI Covide Reports from [...]

By Jakob Wilson|2020-05-22T10:06:22-05:00April 1st, 2020|Power BI|Comments Off

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. Updates to Original Blog Post Since my first publication of this [...]

By Jakob Wilson|2020-05-19T10:52:47-05:00March 30th, 2020|Power BI|Comments Off

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|Comments Off

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-05-17T10:53:22-05:00February 22nd, 2020|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-05-17T10:54:16-05:00February 21st, 2020|Power BI|Comments Off

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

By Derek|2020-05-17T12:00:14-05:00January 5th, 2020|Business Intelligence, Power BI|2 Comments