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

posted on

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?