Power BI Certification Training

✔ Data Visualization, Reporting
✔ Business Intelligence(BI), Traditional BI, Self-Serviced BI
✔ Cloud-Based BI, On-Premise BI
✔ Power BI Products
✔ Power BI Desktop (Power Query, Power Pivot, Power View)
✔ Flow of Work in Power BI Desktop
✔ Power BI Report Server, Power BI Service, Power BI Mobile
✔ Flow of Work in Power BI / Power BI Architecture
✔ A Brief History of Power BI

✔ Power BI Desktop Installation
✔ Building Blocks of Power BI
✔ Datasets, Visualizations, Reports, Dashboards, Tiles
✔ Power BI Desktop User Interface
✔ Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
✔ Overview of Power Query / Query Editor – Extract, Transform & Load Data
✔ Connecting to Data Sources, Establish connection to the Excel source
✔ Importing Data into Power BI or Query Editor
✔ Transforming the Data using Power Query
✔ Model the Data using Power Pivot – Relationship View
✔ Creating New Measures and New Columns using DAX – Data View
✔ Visualizing the Data using Power View and Power Maps – Report View
✔ Saving and Publishing the Visuals or Reports
✔ Logon to Power BI Service
✔ View the Reports in PBI Service and Share the reports

✔ Data Transformation, Benefits of Data Transformation
✔ Shape or Transform Data using Power Query
✔ Overview of Power Query / Query Editor, Query Editor User Interface
✔ The Ribbon (Home, Transform, Add Column, View Tabs)
✔ The Queries Pane, The Data View / Results Pane, The Query Settings Pane,
✔ Formula Bar
✔ Advanced Editor – Complete ETL Code
✔ Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
✔ Power Query Conceptually

✔ Datatypes, Changing the Datatype of a Column
✔ Filters in Power Query  Auto Filter / Basic Filtering
✔ Filter a Column using Text Filters
✔ Filter a Column using Number Filters
✔ Filter a Column using Date Filters
✔ Filter Multiple Columns

✔ Header Row or Use First Row as Headers
✔ Keep Top Rows, Keep Bottom Rows
✔ Keep Range of Rows
✔ Keep Duplicates, Keep Errors
✔ Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
✔ Remove Duplicates, Remove Blank Rows, Remove Errors
✔ Group Rows / Group By

✔ Append Queries
✔ Append Queries as New
✔ Append 2 or more files individually with different queries
✔ Appending multiple files of same type from a folder using single query
✔ Query Options
✔ Copy Query, Paste Query
✔ Delete Query, Rename Query
✔ Enable Load, Include in report Refresh
✔ Duplicate Query, Reference Query
✔ Move to Group, Move Up, Move Down

✔ Merge Queries, Merge Queries as New
✔ Default Types of Joins / Join Kinds / Merge Type

✔ Left Outer (all from first, matching from second)
✔ Right Outer (all from second, matching from first)
✔ Full Outer (all rows from both)
✔ Inner (only matching rows)
✔ Left Anti (rows only in first)
✔ Right Anti (rows only in second)
✔ Cartesian Join or Cross Join

✔ Data Modeling Introduction
✔ Relationship, Need of Relationship
✔ Relationship Types / Cardinality in General
✔ One-to-One, One-to-Many (or Many-to-One), Many-to-Many
✔ AutoDetect the relationship, Create a new relationship, Edit existing relationships
✔ Make Relationship Active or Inactive
✔ Delete a relationship
✔ Cross filter direction (Single, Both), Assume Referential Integrity

✔ What is DAX, Calculated Column, Measures
✔ DAX Table and Column Name Syntax
✔ Creating Calculated Columns, Creating Measures
✔ Implicit Vs Explicit Measures
✔ Calculated Columns Vs Measures
✔ DAX Syntax & Operators
✔ DAX Operators
✔ Types of Operators
✔ Arithmetic Operators, Comparison Operators, Text Concatenation Operator,
✔ Logical Operators

✔ Date and Time Functions
✔ Logical Functions  Text Functions
✔ Math & Statistical Functions
✔ Filter Functions
✔ Time Intelligence Functions

✔ YEAR, MONTH, DAY
✔ WEEKDAY, WEEK NUM
✔ FORMAT (Text Function)
✔ Month Name, Weekday Name
✔ DATE, TODAY, NOW
✔ HOUR, MINUTE, SECOND, TIME
✔ DATEDIFF, CALENDAR
✔ Creating Date Dimension Table

✔ LEN, CONCATENATE (&)
✔ LEFT, RIGHT, MID
✔ UPPER, LOWER
✔ TRIM, SUBSTITUTE, BLANK

✔ IF
✔ TRUE, FALSE
✔ NOT, OR, IN, AND
✔ ERROR, SWITCH

✔ INT
✔ ROUND, ROUNDUP, ROUND DOWN
✔ DIVIDE
✔ EVEN, ODD
✔ POWER, SIGN
✔ SQRT, FACT
✔ SUM, SUMX
✔ MIN, MINX
✔ MAX, MAXX
✔ COUNT, COUNTX
✔ AVERAGE, AVERAGEX
✔ COUNT ROWS, COUNTBLANK

✔ CALCULATE
✔ ALL
✔ RELATED

✔ Time Intelligence Introduction
✔ TOTALMTD, TOTALQTD, TOTALYTD
✔ PREVIOUS DAY, PREVIOUS MONTH, PREVIOUS QUARTER, PREVIOUS YEAR
✔ NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR
✔ SAMEPERIODLASTYEAR
✔ YOY Growth
✔ MOM Growth

✔ Report View User Interface
✔ Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
✔ Visual Interactions
✔ Interaction Type (Filter, Highlight, None)
✔ Visual Interactions Default Behavior, Changing the Interaction

✔ Filter Types

✔ Visual Level Filters, Page Level Filters, Report Level Filters, Drill Through Filters

✔ Filter Sub Types

✔ Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering Numeric field filters, Text field filters, Date and Time field Filters

✔ Grouping and Binning Introduction
✔ Using grouping, Creating Groups on Text Columns
✔ Using binning, Creating Bins on Number Column and Date Columns
✔ Sorting Data in Visuals
✔ Changing the Sort Column, Changing the Sort Order
✔ Sort using column that is not used in the Visualization
✔ Sort using the Sort by Column button

✔ Hierarchy Introduction, Default Date Hierarchy
✔ Creating Hierarchy, Creating Custom Date Hierarchy
✔ Change Hierarchy Levels
✔ Drill-Up and Drill-Down Reports
✔ Data Actions, Drill Down, Drill Up, Show Next Level, Expand Next Level
✔ Drilling filters other visuals option

✔ Visualizing Data, Why Visualizations
✔ Visualization types, Field Wells
✔ Visuals for Filtering, Visualizing Categorical Data, Visualizing Trend Data
✔ Visualizing KPI Data, Visualizing Tabular Data, Visualizing Geographical Data
✔ Leveraging Power BI Custom Visuals

✔ Slicer Visualization
✔ When to use a Slicer
✔ Create and format Slicer Visualization
✔ Hierarchy Slicer (Custom Visualization)
✔ When to use a Hierarchy Slicer
✔ Create and format Hierarchy Slicer
✔ Advantages of Hierarchy Slicer

✔ Create and Format Bar and Column Charts
✔ Create and Format Stacked Bar Chart Stacked Column Chart
✔ Create and Format Clustered Bar Chart, Clustered Column Chart
✔ Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart
✔ Create and Format Pie and Donut Charts
✔ Create and Format the Tree Map Visual
✔ Create and Format Scatter Charts

✔ Line and Area Charts
✔ Create and Format Line Chart, Area Chart, Stacked Area Chart
✔ Combo Charts
✔ Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart
✔ Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

✔ Create and Format Gauge Visual, KPI Visual
✔ Create and Format Card Visualization, Multi-Row Card