Use Power BI Snowflake Connector to Visual Your Data

Build Power BI Snowflake Based Reports In this post I will walk you through the steps required to use the Power BI Snowflake Connector to access data in a Snowflake warehouse.  If you are new either Power BI or Snowflake this will be a quick reference for you to make the connection and where to find the server name. Step 1 - Open Power BI and then select Get Data to see the available data connectors.  Type "snowflake" in the search box to bring up the Snowflake connector as shown below. Power BI Snowflake Connector Settings Now you need to input the connection string and warehouse that you would like to connect to.  To determine your Snowflake instance, login to your Snowflake account and then navigate to your Warehouses.  In the screenshot below you can see the URL, copy the string to be used as the server [...]

By |2020-07-05T08:49:36-05:00July 5th, 2020|Power BI|0 Comments

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 |2020-06-26T13:51:03-05:00June 2nd, 2020|Business Intelligence|Comments Off on Introduction to Business Dashboards

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 |2020-05-12T10:04:29-05:00May 12th, 2020|HealthCare|Comments Off on Health Informatics What You Should Know

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 |2020-06-26T13:23:05-05:00April 18th, 2020|HealthCare, Power BI|Comments Off on Getting Started with Power BI for Healthcare Analytics

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 |2020-06-26T13:52:16-05:00April 12th, 2020|Power BI|Comments Off on Data Wrangling Power BI COVID-19 Data

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 |2020-06-26T11:43:33-05:00April 1st, 2020|Power BI|Comments Off on How to Model Power BI Covid 19 Data

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 |2020-06-26T08:56:13-05:00March 30th, 2020|Power BI|Comments Off on Build Power BI Covid Reports from GitHub Data

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 |2020-05-17T10:53:22-05:00February 22nd, 2020|Power BI|Comments Off on 3 Ways to Improve Manufacturing Analytics with Dashboards

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

Where is Your Company on the Data Maturity Roadmap

Data Maturity Model for Data and Analytics Where are you on your data management maturity 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 on your data journey.  Data governance can help you establish your current level and help improve your use of data.  To increase your company's data maturity levels you can see what IT and Operational changes need to be implemented.  Increasing you data maturity will also lead to an increase in your analytics maturity model.  To achieve higher analytics you must have clean and well organized data architecture. According to Gartner, "A worldwide survey of 196 organizations by Gartner, Inc. showed that 91 percent of organizations [...]

By |2020-06-26T11:16:14-05:00November 10th, 2019|Power BI|Comments Off on Where is Your Company on the Data Maturity Roadmap
Load More Posts