While we are in the midst of this pandemic, are we calculating the mortality rate correctly? If we number of cases is growing exponentially, does the standard calculation of Mortality Rate = Sum(Deaths)/Sum(Confirmed Cases) accurately represent what is really going on? In this video, I argue that it does not, and I suggest an alternative … Continue reading COVID-19 Mortality Rates… Is there a better way to calculate them?
Author: Business Intelligist
Coronavirus (COVID-19) Trends Analysis
We are continuing to make enhancements to our Coronavirus dashboard (https://bit.ly/2voUAbx ). We have added a new tab that allows us to analyze mortality rates by country and by number of infected per 1M of population. This tab has yielded some interesting insight. You can learn more about it as well as some of my … Continue reading Coronavirus (COVID-19) Trends Analysis
New features are added to the Knowledgebank.pro COVID-19 (Coronavirus) dashboard
Lots of new features added to the dashboard.. also a video has been posted for those who need help with how to use it. Link to dashboard: https://bit.ly/2voUAbx Link to video: https://www.youtube.com/watch?v=T21h46ZDh14
Coronavirus (COVID-19) Power BI Report
Knowledgebank.pro has released a Power BI report with Coronavirus (COVID-19) statistics by Country/State. The data set is updated daily. You can find it following this link:
How to Fix Azure Databricks Refresh Issue in PowerBI.com
The full credit for this goes to the Guy in the Cube for his video where Adam talks about how to fix direct query to Azure Databricks models deployed to PowerBI.com . Unfortunately, this issue also affects import models as well. If you have an import model from Azure Databricks and you try to set … Continue reading How to Fix Azure Databricks Refresh Issue in PowerBI.com
How to make Azure Databricks work with Azure Data Lake Storage Gen2 and Power BI
This post is a beginning to a series of articles about building analytical capabilities in Azure using data lake, Databricks and Power BI. On the surface, those technologies seem like they were specifically designed to complement each other as they provide a set of foundational capabilities necessary to develop scalable and cost-effective business intelligence … Continue reading How to make Azure Databricks work with Azure Data Lake Storage Gen2 and Power BI
Working with Workdays in Power BI – Translating Workdays into Dates
EDIT: an updated version of this article with a video can be found here: https://businessintelligist.com/?p=2580 Power BI has a robust set of functions to write date-based calculations. One of the areas that has proven to be a challenge is related to doing math on working days instead of normal dates. \ Here is a simple … Continue reading Working with Workdays in Power BI – Translating Workdays into Dates
Giving access to Azure Active Directory Application to Enable Polybase
I have run into this a few times now and every time it took me a while to figure out what's going on, so I figured if I wrote about this on my blog, maybe I would not forget about it next time. Microsoft has a great article here that details how to setup Azure … Continue reading Giving access to Azure Active Directory Application to Enable Polybase
Content Packs vs Power BI App
Sometimes, in order to innovate, we have to take a step back before we take two steps forward. What that statement means in the context of this article is a mystery and for many of us such is the difference between Content Packs and Power BI Apps. Microsoft revealed Power BI Apps in this blog … Continue reading Content Packs vs Power BI App
Power BI and Azure Data Lake
Do you have to be a developer in order to implement a solution that ties together Power BI and Azure Data Lake? I argue that you don't. However, there are a several things that you need to be familiar with before you get going. Therefore, I decided to cover several of them in this article. … Continue reading Power BI and Azure Data Lake
business intelligist 