• 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)
• Datatypes, Changing the Datatype of a Column Filter 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
• 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
• Header Row or Use First Row as Headers
• Keep Top Rows, Keep Bottom Rows
• Keep Duplicates, Keep Errors
• Remove Top Rows, Remove Bottom Rows,
  Remove Alternative Rows
• Remove Duplicates, Remove Blank Rows, Remove Errors

• Data Modeling Introduction
• Relationship, Need of Relationship
• Relationship Types / Cardinality in General One-to-One, One-to-Many (or Many-to-One), Manyto-Many
• Autodetect the relationship, Create a new relationship, Edit existing relationships
• Make Relationship Active or Inactive
• Delete a relationship

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

• Date and Time Functions
• Text Functions
• Logical Functions
• Math & Statistical Functions
• Filter Functions

Date and Time Functions   

• YEAR, MONTH, DAY
• WEEKDAY, WEEKNUM
• FORMAT (Text Function) à Month Name, Weekday Name
• DATE, TODAY, NOW
• HOUR, MINUTE, SECOND, TIME
• DATEDIFF, CALENDAR
• Creating Date Dimension Table functions

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

•   IF  
•   TRUE, FALSE NOT, OR, IN, AND  
•   SWITCH  

• INT
• ROUND, ROUNDUP, ROUNDDOWN
• DIVIDE
• EVEN, ODD
• POWER, SIGN  
• SQRT, FACT  
• SUM, SUMX
• MIN, MINX
• MAX, MAXX
• COUNT, COUNTX
• AVERAGE, AVERAGEX
• COUNTROWS, COUNTBLANK

•   ALL  
•  RELATED  
•  ALL EXCEPT  

•   Visualizing Data, Why Visualizations    v Visualization types, Create and Format Bar and Column Charts  
•   Create and Format Stacked Bar Chart Stacked Column Chart Create   v and Format Clustered Bar Chart, Clustered Column Chart  
•   Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart Create and  
•   Create and Format Scatter Charts  
•   Create and Format Table Visual, Matrix Visualization  
•   Line and Area Charts  
•   Create and Format Line Chart, Area and Chart, Stacked Area Chart  
•   Combo Charts  
•   Create and Format Line and Stacked Chart, Line and Clustered Column Chart  
•   Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart  

•   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  

Pin Visuals and Pin LIVE Report Pages to Dashboard  

•   Advantages of Dashboards  
•  Interacting with Dashboards  
•  Formatting Dashboard  
•  Sharing Dashboard