Blog & Company Updates

Correlating Coronavirus Outbreaks with Business Data Using Power BI

At the time of this post, the world is dealing with a serious health and economic crisis. The COVID-19, Coronavirus, is impacting the lives of people around the world and in turn, it is affecting world markets and industries in many different ways. For example, I am working with a client whose material shipping and supply chain are being are impacted by the breakout and they need to quickly respond by making order changes and logistics choices. Forecasting and planning analysts must make adjustments to help the company prepare for these impactful changes.

This demonstration shows you how to create a multi-layer map to correlate current outbreak case locations with your own data, using Power BI and the ESRI map visual. I’m using sample data for demonstration but this is the same technique I am using for our client. In the real data set, correlation is impactful where shipping orders are being delayed and cancelled in areas most affected. For more, visit my blog at SqlServerBiBlog.com.

The technique used in this map report is relatively easy to implement because both data sources are separate feeds to the map service. There are different ways to correlate map data from two different sources. In our solution, we are also integrating the CDC data into the data model, which will allow us to perform comparison calculations. Using AI and machine learning, we may be able to perform predictions and associations.

 

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

Author

  • I love creating BI solutions, wrangling data, writing, blogging & speaking at events that provide leadership & direction for the BI community. With over 25 years in the IT industry, I offer deep BI expertise, leadership & the experience of hundreds of successful projects.

Paul TurleyCorrelating Coronavirus Outbreaks with Business Data Using Power BI