Introduction to Power bi

Introduction to business Intelligence (BI) Various BI tools

Introduction to Power BI Why Power BI

Power BI Components Introduction of Power BI Desktop Installation of power BI Desktop

Data Visualization

Understanding Power View and Power Map Data visualization Techniques

Page layout & Formatting Power BI Desktop visualization

Formatting and customizing visuals column chart, pie chart, Count chart

Scatter Chart, Funnel Chart

Include & Exclude

Geographical data visualization using Maps Drill down

Drill through page navigation Bookmarks

Selection pane to show/hide visuals Comparing volume and value-based analytics Combinations charts (Dual axis charts) Filter pane slicers

Use of Hierarchies in drill down analysis Sync slicers

Tool tips & custom tool-tips tables & matrix

Conditional Formatting On Visuals

Power BI Service, Publishing & Sharing

Introduction to Power BI Service Introduction of Work-spaces Dashboard

Creating & Configuring Dashboards Dashboard theme

Reports vs Dashboards Sharing reports & dashboards

Data Transformation-Shaping & Combining Data

Shaping data using Power Query Editor Formatting data

Transformation of data understanding of Data types

Naming conventions & best practices to consider working with parameters

Merge Query Append Query

Group by of data (aggregation of data) Duplicate & Reference tables fill

Pivot & UN-pivot of data custom columns Conditional columns Replace data from the tables Split columns values

Move columns & sorting of data

Detect data type, count rows & reverse rows Promote Rows as column headers Hierarchies in Power BI

Data Modeling & Dax

Introduction of relationships Creating relationships cardinality

Cross filter direction

Use of inactive relationships Introduction of DAX

Why DAX is used DAX syntax DAX functions Context in DAX

Calculated columns using DAX Measures using DAX Calculated tables using DAX

learning about table, information, logical, text, iterator, Time intelligence functions (YTD, QTD,MTD)

Cumulative values, calculated tables, and ranking and rank over groups Data and time function

Why DAX is used DAX Syntax DAX functions Context in DAX

Calculated columns using DAX Measures using Dax calculated tables using DAX

Learning about table, information, logical, text, iterator, Time intelligence functions (YTD, QTD, MTD)

Cumulative values, calculated tables, and ranking and rank over groups Date and time functions