Blog - CDO Advisors

How to Publish to Power BI from Power BI Desktop

Publish to Power BI to Share Your Reporting In order to share your reporting and create dashboards you need to publish to Power BI service to share your work. Power BI desktop enables you to connect to data, model your data and build data visualizations. Once you are ready to share your reporting connecting to Power BI in the cloud is the next step. How to Publish to Power BI Service In Power BI Desktop, it's a very straight forward process to publish your reporting. Each Power BI file needs to be published when you are ready. Likewise, as you make changes to your local .pbix files, changes will need to be republished to PowerBI.com. First, open the report that you want to publish to Power BI. Then on the Home ribbon select the far right Publish button as shown below: Publish to Power BI CDO Advisors [...]

By Derek|2020-06-17T20:36:42-05:00June 17th, 2020|Uncategorised|Comments Off

3 Types of Dashboards Executives Need Today

3 Types of Dashboards that Executives Need Now In this blog, we will be doing a quick review of the benefits associated with each of the 3 types of dashboards to determine which is right for your business. The common dashboards are operational, strategic, and tactical. To learn the basics of dashboards, refer to our previous blog detailing the properties of dashboards in Power BI. Operational Dashboards An operational dashboard is a tool that is used to monitor business processes that fluctuate constantly and the current performance metrics vital to your business. These dashboards often update on a minute to minute basis providing the most accurate and up to date information. Operational dashboards frequently used to monitor a company's progress towards a specific metric or goal, usually a specific department or branch. Azure Monitor tracks the usage and capacity of Azure applications IndustrySafe provides up [...]

By Jakob Wilson|2020-06-05T13:57:54-05:00June 5th, 2020|Business Intelligence, Power BI|Comments Off

Introduction to Business Dashboards

What are Business Dashboards? Just like your car, a business dashboard collects in one location all of the critical information you need to run your business. A management or executive dashboard should be easily accessible and like an automotive dashboard organizes and visually displays your data from various sources in one location. They are critical for business intelligence solutions and enable self-service analytics for your employees. If your employees do not know how you are performing against KPIs they are unable to make the best decision to improve performance. Why You Need Business Dashboards? Dashboards differ from traditional reporting in many ways. First they are designed to visually see lots of data in a single location. Management dashboards mash up data from your various sources to make it easy to for you to monitor your business. Easily merge KPIs from you various departments into a single organization view. No [...]

By Derek|2020-06-26T13:51:03-05:00June 2nd, 2020|Business Intelligence|Comments Off

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-06-26T11:41:12-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-06-26T13:23:05-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 [...]

By Derek|2020-06-26T13:52:16-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-06-26T11:43:33-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 the Johns Hopkins Covid GitHub project that is collecting data around Covid-19 on cases based on countries from around the world. 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 19 report from the GitHub data. Many are familiar with the Johns Hopkins Coronavirus online tool. Learning these skills you can make your [...]

By Jakob Wilson|2020-06-26T08:56:13-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 [...]

By Derek|2020-06-26T13:09:59-05:00March 11th, 2020|Business Intelligence, Power BI|Comments Off