Join my live tutorial with Power BI product group

Join my live tutorial with Power BI product group

Sep 1st, 2020 update: Here is the recording of the first session. The Microsoft Power BI team will have me as a guest speaker tomorrow (8/20 2pm ET) for a live tutorial on building a COVID-19 dashboard in Power BI. Learn more about the session here. I am looking...
Import & Combine multiple PDF files from WHO

Import & Combine multiple PDF files from WHO

In the last tutorial of the COVID-19 dashboard series here, you learned how to import a single COVID-19 situation report directly from WHO website using Power Query PDF connector. In today’s tutorial, you will earn how to combine multiple PDF files from WHO into...
Weekly-Based Time Intelligence in Power BI

Weekly-Based Time Intelligence in Power BI

Follow @gilra Follow @datachant In one of my last tutorials here, we learned how to apply time-intelligence in DAX to analyze the COVID-19 data that is provided by Johns Hopkins University. The focus so far was to provide correct calculations on a daily level or to...
Import WHO COVID-19 data from PDF

Import WHO COVID-19 data from PDF

In the last tutorials of the COVID-19 dashboard series, you learned how to build your own COVID-19 dashboard from CSV files that were provided by Johns Hopkins University. In today’s tutorial, we will import one of the WHO situation reports and learn how to...
COVID-19 dashboard in Power BI: Offset the curve

COVID-19 dashboard in Power BI: Offset the curve

Follow @gilra In my last tutorial here, you learned how to apply a dynamic running average in DAX. In this part, you will learn how to offset the daily new confirmed cases vertically and horizontally. Horizontal offset – Normalize cases by population Different...