---
# System prepended metadata

title: Power BI customize course

---

---
title: Power BI customize course
tag: powerbi, powerbi-online
---

## Day 1

Estimated time: 2 hours

- Review Power BI knowledge, includes Power Query, Data Model, DAX calculation, and Advanced visualization.
- Sharing: A common flow when doing a data analysis task.
- Practice a simple lab ([dashboard in a day lab](https://powerbi.microsoft.com/en-us/diad/)), part loading and transforming data.
- Reflect on what you've practiced: Important things to consider when load, clean, and transform data.

## Day 2

Estimated time: 2 hours

- Introduce different data structure that you're likely to work with: structured, unstructured, and semi-structured data.
- Practice lab AdventureWorks, in which you will start load data from SQL database and flat files.
- Reflect on what you've practiced: Key concepts of Power BI related to working with database.
- Learn the importance of profiling data and analyzing metadata as well as how to profile data with Power BI the right way.

## Day 3

Estimated time: 4 hours

- Introduce Data Model and Star Schema in Power BI.
- Learn how to reverse-engineer your database data model to better understand the business data model.
    - By learning fundamental techniques of fact and dimension tables in star schema.
    - By practicing a case study (with paper and pen) about analyze a sample data model of Retail Business.
- Learn create and manage model relationship in Power BI.

Homework: Create data model for two case studies in Day 1 and Day 2.

## Day 4

Estimated time: 2 hours

- Review and feedback homework.
- Learn advanced model concepts in Power BI and how to deal with it:
    - Many-to-many relationship
    - Circular dependencies

- Practice working with semi-structured data and build data model with semi-structured data with Power BI (lab: Covid in Vnexpress - might choose a different lab if it's possible).

## Day 5

Estimated time: 2 hours

- Review Data Analysis Expression (DAX) fundamental concepts.
    + Syntax, operators, data type, BLANK value, etc.
    + Analytics Query
    + Implicit vs Explicit measures
- Practice common DAX pattern to distinguish between Row context and Filter context in DAX.
    + Iterator functions which apply row context
    + Common functions which follow filter context 
- Introduce `CALCULATE` function and its importance in modifying filter context.

## Day 6

Estimated time: 2 hours

- Learn intermediate DAX patterns
- Learn how to test your data model

## Day 7

Estimated time: 2 hours

- Learn advanced DAX patterns
- Review DAX

## Day 8

Estimated time: 2 hours

- Learn visualization in Power BI (review basic feature to advanced features like drill through, use DAX to control how visual presented in Power BI report).

## Day 9

Estimated time: 2 hours

- Learn how to use Power BI service (data flow, schedule refresh) to automate your data pipeline.
- (If no Power BI Service, and already learned about Python) Learn how to use Python script to improve your Power BI report.

## Day 10

Estimated time: 2 hours

- Depends on the attendees.