POWER BI COURSE OUTLINE

Power BI Desktop:

1. Introduction (2 hr)

• Introduction to business intelligence

• Introduction to data analysis

• Introduction to data visualization

• Overview of self-service BI

• Considerations of self-service BI

• Microsoft tools for self-service BI

• Power BI vs. SSRS Report

• Installation – Power BI Desktop

• Configure tools

2. Getting and Shaping Data (3 hr)

• Using databases as a Power BI data source

1. SQL Server Database                         

2. Microsoft Access Database                

• Using Excel as a Power BI data source

• Using databases as a Power BI data source

• The Power BI service

• Import data into Power BI

• Data Clean up

• Transforming Data

• Append Operation

• Merge Operations

• Lab : 

1. Import data into Power BI

2. Data Clean up

3. Transforming Data

4. Append Operation

5. Merge Operations

3. M Language: (2 hr)

The Power Query M formula language is optimized for building highly flexible data mashup queries. It's a functional, case sensitive language similar to F#.
Power Query statements are made up of individual language elements such as functions, variables, expressions, and primitive and structured values that together define the logic necessary to shape the data. In this module, we will share 

• Quick tour of the Power Query M formula language

• Commonly used functions

1. let expression

2. RemoveColumns function

3. PromoteHeaders function

4. RenameColumns function

5. SelectRows Function

6. ReplaceValue function

7. TransformColumns function

8. Adding a Calculated column

4. Power BI Model (3 hr) 

• Creating Relationships

1. Append

2. Merge

• Joins

1. Left, Inner, Join, Full Outer Join, Left Anti Joins, Right Anti Join

• Extracting Columns From XML

• Setting Datatypes

• Transforming Columns

• Splitting Columns

• Defining New Columns

• Concatenating Columns

• Performing Lookup

• Translating

• Adding Date Table

• Lab:

1. Creating Relationships

2. Defining New Columns

3. Concatenating Columns

4. Performing Lookup

5. Translating

6. Adding Date Table

5. Enhancing Power BI Model (3 hrs)

• Defining Hierarchies

• Configuring Properties e.g. Data Categories , Formatting

• Creating Measures

• Creating Parameters

• Import from Reports

• Lab

1. Creating Measures

2. Creating Parameters

3. Import from Reports

6. Data Flows (1 hr)

• What is Data Flow

• Why /When to use Data Flow?

• Lab: 

1. Implementing Data Flow

Here-in the data will be uploaded to Power BI Service, and different visualizations /reports will be created, and 

7. Visualizing (3hrs)

• Visualizing Data

• Adding Visuals

• Filtering

• Slicer Filtering

• Highlighting

• Setting Properties

• Drilling within the Hierarchy

• Creating Bookmarks

• Power BI Mobile

• Custom Visuals

8. Security (1 hr)

• Data Storage Security

• Row Level Security

• Demo: Security

9. Refreshing Data (2 hrs)

• Publishing DataSets

• Refreshing Data

• Power BI Mobile Apps

• Using Power BI Gateway - Personal

• Understanding Power BI Gateway – Enterprise

• Power BI Pro vs. Free

• Publishing To Power BI

• Setting Up Auto-Refresh

• Content Packs

• Sharing Within the team /with organization

• Creating Dashboards 

• Sharing Reports /Dashboards

DAX 

1. Introducing DAX  (1 hr)

1. Understanding DAX Calculations

2. Understanding Calculated Columns And Measures 

3. Variables 

4. Handling Errors In DAX Expressions 

5. Formatting DAX Code

6. Common DAX Functions 

2. Using Basic Table Functions (2 hrs)

1. Introducing Table Functions 

2. Evaluate Syntax 

3. Using Table Expressions 

4. Understanding Filter 

5. Understanding All, Allexcept, And Allnoblankrow 

6. UNDERSTANDING VALUES AND DISTINCT

3. Understanding Evaluation Contexts  (2 hrs)

1. Introduction To Evaluation Contexts 

2. Testing Your Evaluation Context Understanding 

3. Creating A Row Context With Iterators 

4. Understanding Filter, All, And Context Interactions 

5. Working With Many Tables 

6. Evaluation Contexts Recap 

7. Creating A Parameter Table 

4. Understanding CALCULATE And CALCULATETABLE  (2 hrs)

1. Understanding Calculate 

2. Calculate Examples 

3. Understanding Context Transition 

4. Variables And Evaluation Contexts 

5. Understanding Circular Dependencies 

6. Calculate Rules 

7. Introducing Allselected

5. DAX Examples (2 hrs)

1. Computing Ratios And Percentages 

2. Computing Cumulative Totals 

6. Optimizing Data Models and Strategy (1 hr)

1. Gathering Information About The Data Model 

2. Denormalization 

3. Columns Cardinality 

4. Calculated Columns

5. Choosing The Right Columns To Store

6. Optimizing Column Storage