• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / Courses / Power BI Master Class 1: COVID Tracker

Power BI Master Class 1: COVID Tracker

posted on August 18, 2023

Please log in to access your purchased courses.
Please log in to access your purchased courses.
Please log in to access your purchased courses.

Course content

Here you have some highlights of what you will learn on this course:

  1. Connect directly to real data sources (official governmental sources)
    • Pacific Islands governmental data hub
    • Online sources
    • Excel
  2. Modeling and ETL:
    • Create custom calendars that match the data
    • Create the data model
    • Prepare the model/tables for analysis
  3. Many DAX calculations:
    • Time intelligence
    • New functions
    • Troubleshoot DAX
  4. Document the calculations
  5. Custom maps:
    • Custom Legends
    • Custom maps geoJson
  6. Navigation techniques:
    • Drillthrough pages,
    • Buttons
    • Bookmarks
  7. Complete Figma tutorials for the custom backgrounds
  8. Best practices for documenting reports:
    • Folders
    • Documentation
  9. Publish to powerbi.com
    • Publish to Power BI Service
    • Set up automatic refreshes

Introduction to the COVID Tracker report:

Here you can interact with the report:

Course Contents:

P1: Get COVID data

In this module we will get all the data we need and model it.

Lessons

Get COVID Data

P1: Model data

Model COVID data as star schema and prepare the tables for analysis

Lessons

Model the data

P1: DAX – Tables

Create the DAX calculations

Lessons

Decumulate calculation with OFFSET Decumulate with calculated column Daily Cases Last X Period cases

P1: Documentation

Document the model so far and add a data dictionary

Lessons

Document the report Data dictionary

P1: Visualization

Create the table viz and full Figma tutorial

Lessons

Matrix Visualization Figma Background for Summary Page

P1: DAX – Map

Add the DAX calculations for the Bubble map

Lessons

Last X periods for the Bubble Map

P1: Visualization – Map

Create the bubble map and custom legend

Lessons

Bubble Maps Preview

P2: Visualization – Map

Create the shape map from GeoJSON file

Lessons

Shape Maps

P2: Get Data

Add population data to normalized the new confirmed cases

Lessons

Get Population data

P2: DAX

Add all the population calculations

Lessons

Infections by Population Preview Decumulate with discontinuous dates Vaccinations by population % Vaccinations by population

P2: Documentation

Document the model so far

Lessons

Document vaccination calculations

P2: Visualization

Add the remaining visualizations and another Figma tutorial

Lessons

Daily visualization charts Accumulated visualization charts Figma background for Page 2 Drillthrough Page Prepare for Bookmarks Bookmark Navigation Glossary Page

P3: Power BI service

Publish to web and schedule refresh it.

Lessons

Publish the report Preview
Was this helpful?

Primary Sidebar

Search Website:

Subscribe to our YouTube Channel (+130k subs)!

Apply for Membership (+50,000 members)

Become a Member

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In