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

a)    SQL Server Database

b)    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 :

a)    Import data into Power BI

b)    Data Clean up

c)    Transforming Data

d)    Append Operation

e)    Merge Operations

3)    M Language: (2hr)

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

a)    let expression

b)    RemoveColumns function

c)    PromoteHeaders function

d)    RenameColumns function

e)    SelectRows Function

f)     ReplaceValue function

g)    TransformColumns function

h)    Adding a Calculated column

4)    Power BI Model (3 hr)

·         Creating Relationships

a)    Append

b)    Merge

·         Joins

a)    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:

a)    Creating Relationships

b)    Defining New Columns

c)    Concatenating Columns

d)    Performing Lookup

e)    Translating

f)     Adding Date Table

5)    Enhancing Power BI Model (3hrs)

·         Defining Hierarchies

·         Configuring Properties e.g. Data Categories , Formatting

·         Creating Measures

·         Creating Parameters

·         Import from Reports

·         Lab

a)    Creating Measures

b)    Creating Parameters

c)    Import from Reports

6)    Data Flows (1 hr)

·         What is Data Flow

·         Why /When to use Data Flow?

·         Lab:

a)    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 (2hrs)

·         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

a)    Introducing DAX  (1 hr)

i)      Understanding DAX Calculations

ii)     Understanding Calculated Columns And Measures

iii)    Variables

iv)   Handling Errors In DAX Expressions

v)    Formatting DAX Code

vi)   Common DAX Functions

b)    Using Basic Table Functions (2 hrs)

i)      Introducing Table Functions

ii)     Evaluate Syntax

iii)    Using Table Expressions

iv)   Understanding Filter

v)    Understanding All, Allexcept, And Allnoblankrow

vi)   UNDERSTANDING VALUES AND DISTINCT

c)    Understanding Evaluation Contexts  (2 hrs)

i)      Introduction To Evaluation Contexts

ii)     Testing Your Evaluation Context Understanding

iii)    Creating A Row Context With Iterators

iv)   Understanding Filter, All, And Context Interactions

v)    Working With Many Tables

vi)   Evaluation Contexts Recap

vii)  Creating A Parameter Table

d)    Understanding CALCULATE And CALCULATETABLE  (2 hrs)

i)      Understanding Calculate

ii)     Calculate Examples

iii)    Understanding Context Transition

iv)   Variables And Evaluation Contexts

v)    Understanding Circular Dependencies

vi)   Calculate Rules

vii)  Introducing Allselected

e)    DAX Examples (2 hrs)

i)      Computing Ratios And Percentages

ii)     Computing Cumulative Totals

f)     Optimizing Data Models and Strategy (1 hr)

i)      Gathering Information About The Data Model

ii)     Denormalization

iii)    Columns Cardinality

iv)   Calculated Columns

v)    Choosing The Right Columns To Store

vi)   Optimizing Column Storage