♦ Power BI Introduction, Brief History of Power BI, Data, Data Visualization, Reporting, Business Intelligence
   (BI), Traditional BI, Self-Serviced BI, Cloud Based BI, On Premise BI.
♦ Power BI Report Server, Power BI Service, Power BI Mobile, Paginated Reports
♦  Flow of Work in Power BI / Power BI Architecture
♦ Power BI Desktop Installation and Hands on practice

 Power BI Desktop Components (Power Query, Power Pivot, Power View, Power Map, Q&A, Data Gateway)
♦  Building Blocks of Power BI (Fields, Filters, Visualizations, Reports, Data, Model Dashboards and Tiles)
♦  Data Connectivity Modes (Import, Direct, Live & Composite Models)
♦   Get Data Connecting Multiple source and represent the data
♦   Overview of default and Custom visualizations
♦   Power BI Desktop User Interface.
♦   Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas, Visual Edit Interactions, Sync Slicer,
      Selection Pane, Buttons, Book Marks, Conditional formatting.

♦  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

Hierarchies and Drill-Down Reports
♦ 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  

Power BI Visualizations
♦ Visualizing Data, , Visualization types, Field Values, Visuals for Filtering, Visualizing, Categorical Data,
Visualizing Trend Data, Visualizing KPI Data, Visualizing Tabular Data, Visualizing Geographical Data,
Leveraging Power BI Custom Visuals 

Visuals for Filtering
 ♦ Slicer / Sync 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

Visualizing Categorical Data  
 ♦ Line Chart, 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 

Visualizing KPI Data
 ♦ Create and Format Gauge Visual, KPI Visual, Create and Format Card Visualization, Multi Row Card

Visualizing Tabular Data, Geographical Data & R Script Visual
♦ Create and Format Table Visual, Matrix Visualization, Create and Format Map Visual, Filled Map Visual, Arc
GIS Maps Visual, Create and Format R Script Visual 
♦Interview Questions Discussion and Practical Scenario based Tasks Interview Questions Discussion and Practical Scenario based Tasks

Introduction to Power Query – Extract, Transform and Load (ETL)
 The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar, Advanced Editor –
Complete ETL Code.
♦ Overview of Power Query / Transform Editor
♦  Data types, Changing the Data type of a Column
♦  Filters in Power Query, Auto Filter / Basic Filtering, Filter a Column using Text Filters
♦  Filter a Columns using Number, Date and Text

Inbuilt Column Transformations
♦ Remove Columns / Remove Other Columns, Name / Rename a Column, Reorder Columns or Sort
Columns, Add Column / Custom Column, Split Columns, Merge Columns, PIVOT, UNPIVOT Columns,
Transpose Columns, Invoke functions

In built Row Transformations
♦ 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

 Combine Queries (Append Queries & Merge Queries) 
♦ 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 / Join Queries
♦ 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).

 Grouping, Binning & Sorting
♦ 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,
Sort Order, Sort using column that is not used in the Visualization, Sort using the Sort by Column button.

Power BI Data Modeling – Relationship View
♦ 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

Enhancing the Data Model – DAX
♦ Introduction of DAX, Calculated Columns, Measures, Example of Creating Calculated Columns, Creating
Measures and Calculated Tables, Implicit Vs Explicit Measures, Row Filter vs. Context filters, DAX
Operators, Types of Operators, Arithmetic Operators, Comparison Operators, Text Concatenation
Operator, Logical Operators.

DAX Functions Categories
♦ Date and Time Functions
♦ Text Functions
♦ Logical Functions
♦  Aggregate Functions
♦  Filter Functions
♦  Information Functions
♦ Relationship Functions
♦ Time Intelligence Functions
♦ Table Manipulation Functions

Date & Time Functions
♦ YEAR, MONTH, DAY, WEEKDAY, WEEKNUM, FORMAT (Text Function) a Month Name, Weekday Name
♦ DATE, TODAY, NOW, HOUR, MINUTE, SECOND, TIME,DATEDIFF, CALENDAR, Calendar Auto,            Creating Dimension Table

Text Functions
♦ COMBINEVALUES,CONCATENATE,CONCATENATEX,EXACT,FIND,FORMAT,LEFT,LEN,LOWER,REPLACE,RIGH
T,SEARCH,SUBSTITUTE,TRIM,UPPER,VALUE
Aggregate Functions
 ♦ AVERAGE, AVERAGEA, AVERAGEX, COUNT, COUNTA, COUNTAX, COUNTBLANK, COUNTROWS, COUNTX,
DISTINCTCOUNT, DISTINCTCOUNTNOBLANK ,MAX, MAXA, MAXX, MIN, MINA, MINX, SUM, SUMX.

Filter Functions
♦ALL,ALL CROSS FILTERED,ALL EXCEPT,ALL SELECTED,CALCULATE,CALCULATE TABLE,EARLIER,EARLIEST,
FILTER,KEEP FILTERS,LOOKUP VALUE,SELECTED VALUE

Information Functions
♦CONTAINS,HASONEFILTER,HASONEVALUE,ISBLANK,ISCROSSFILTERED,ISEMPTY,ISERROR,ISFILTERED,
SELECTEDMEASURE,USERNAME,USEROBJECTID,USERPRINCIPALNAME.  

Relationship Functions
♦ CROSSFILTER, RELATED, RELATEDTABLE, USERELATIONSHIP

Time Intelligence Functions
♦ CLOSINGBALANCEMONTH,CLOSINGBALANCEQUARTER,CLOSINGBALANCEYEAR,DATEADD,DATESBETWE
EN,DATESINPERIOD,DATESMTD,DATESQTD,DATESYTD,ENDOFMONTH,ENDOFQUARTER,ENDOFYEAR,FIRS
TDATE,FIRSTNONBLANK,LASTDATE,LASTNONBLANK,NEXTDAY,NEXTMONTH,NEXTQUARTER,NEXTYEAR,O
PENINGBALANCEMONTH,OPENINGBALANCEQUARTER,OPENINGBALANCEYEAR,PARALLELPERIOD,PREVI
OUSDAY,PREVIOUSMONTH,PREVIOUSQUARTER,PREVIOUSYEAR,SAMEPERIODLASTYEAR,
STARTOFMONTH,STARTOFQUARTER,STARTOFYEAR,TOTALMTD,TOTALQTD,TOTALYTD

Table Manipulation Functions
♦ADDCOLUMNS,CROSSJOIN,DISTINCTcolumn,DISTINCTtable,EXCEPT,FILTERS,GENERATESERIES,GROUPBY,
INTERSECT,NATURALINNERJOIN,NATURALLEFTOUTERJOIN,ROLLUP,ROLLUPGROUP,SELECTCOLUMNS,
SUMMARIZE,SUMMARIZECOLUMNS,TOPN,UNION,VALUES

♦ Power BI Service Introduction  Power BI Service Introduction, Power BI Cloud Architecture, Creating Power BI Service Account, SIGN IN to Power BI Service Account, Publishing Reports to the Power BI service, Import / Getting the Report to PBI Service, My Workspace / App Workspaces Tabs, DATASETS, WORKBOOKS, REPORTS, DASHBOARDS, Working with Datasets, Creating Reports in Cloud using Published Datasets, Power BI Datasets Live Connection using Desktop, Working with Workbooks, working with Reports, Sharing Reports

Dashboards Development
♦ Creating Dashboards, Pin Visuals and Pin LIVE Report Pages to Dashboard, Advantages of Dashboards,
Interacting with Dashboards, Adding Tiles to Dashboards, Web Content, Image, Text Box, Video,
Formatting Dashboard, Sharing Dashboard

Data Gateways
♦  Introduction to Data Gateways, Download Data Gateway , Installing a Data Gateway, Types of Gateways,
On-premises Data Gateway(Standard Gateway), On-premises Data Gateway (personal mode\Private),Data
Gateways work Connect to an on premise Data Source by using a Data Gateway, Manage Data Gateway,
Add and Remove Administrators, Add Data Source, Add or Remove Users to a Data Source, Refresh On
Premise Data, Configuring Automatic Refresh using Schedules

Collaboration in Power BI using App Workspace
Introduction to App Workspaces, Create an App Workspace, Add Members to App Workspace to
Collaborate, App Workspace Roles Access, Admin, Member, Contributor, Assign Workspace to
Deployment Pipelines.

Sharing Power BI Content using Apps and Content Packs
Introduction to App, Publish an App, Update a Published App, Organization, Specific individuals or group,
Un publishing an App, Content Pack Introduction to App, Publish an App, Update a Published App, Organization, Specific individuals or group,Unpublishing an App, Content Pack Introduction, Create Content Pack, Sharing Content Packs, Specific Groups, My Entire Organization

Row Level Security in Power BI (RLS)
Introduction to Row Level Security, Row Level Security (RLS) with DAX Dynamic & Static, Manage Roles,
Creating Roles, Testing Roles, Adding Members to Roles in Power BI Service, Dynamic Row Level Security,
Creating Users Table and Adding to the Model, Capturing users using Username () or UserPrincipalName
() Functions.

Data Flows – Over view of Datasets & Data Flows.

Report Server, Report Builder
♦ Need for Report Server in PROD, Install, Configure Report Server, Report Server DB, Temp Database,
Web service URL, Web portal URL, Power BI DesktopRS, Uploading Interactive Reports, Report Builder,
Report Builder For Power BI Cloud, Designing Paginated Reports (RDL), Deploy to Power BI Report
Server, Data Source Connections, Report, Power BI Report Server to Cloud, Tenant IDs, Mobile Report
Publisher.