Course Code: pbicustom
Duration: 14 hours
Course Outline:

1. The Power BI Interface

2. Connecting to Data

3. Creating Reports 1

4. Data Visualization Best Practices

Transform Data with Power Query

1. Query Editor

2. Column Transformations

3. Conditional Columns

4. Filter Columns

5. Unpivot

6. Custom Columns

Transform Data with Data Analysis Expression (DAX)

1. What DAX is

2. Columns and Measures

3. Conditional DAX expressions

4. Quick measures

5. Formatting measures

Creating Reports

1.    Tree Map

2.    Scatter Plot

3.    Line Chart

4.    Combo Charts

5.    The Ribbon Chart

6.    The Waterfall Chart

7.    The Funnel Chart

8.    The KPI Visual

9.    Visualizing geographical data

10.    The Map Visual

11.    The Filled Map Visual

12.    The Pie Chart

13.    The Donut Chart

14.    The Chiclet Slicer

15.    Gantt Chart

Modelling Data

1. Basic Modelling Concepts

2. Creating new relationships

3. Filtering direction

Sharing Reports

1.    Publishing reports to Power BI Service

2.    Workspaces

3.    Adjusting reports in Power BI Service

4.    Creating Dashboards

5.    Adding tiles to dashboards

6.    Refreshing data

7.    Data Access – Row Level Security