Ready to curb your Power BI skills? Find out more here!

Curbal

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

You are here: Home / Courses / Power BI Master Class 1: COVID Tracker

Power BI Master Class 1: COVID Tracker

About the course:

Curb your Power BI skills with this advance course.

Learn more in the video below:

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?