Power BI Mastery

Course Overview

Week 1

1. Describe the Power BI ecosystem
2. Define Power BI and its relationship with Excel
3. Discuss the Power BI suite of products
4. Describe how the Power BI products integrate
5. Explain the typical analytics process flow
6. Differentiate between the various data sources
7. Connect Power BI to a data source
8. Clean and transform data to ensure data quality
9. Load the data to the Power BI Data Model U

Week 2

1. Differentiate between the various data sources
2. Connect Power BI to a data source
3. Clean and transform data to ensure data quality
4. Load the data to the Power BI

Week 3

CREATING POWER BI REPORTS

1. AUTO FILTERS 
2. Report Design with Legacy & .DAT Files
3. Report Design with Databse Tables
4. Understanding Power BI Report Designer
5. Report Canvas, Report Pages: Creation, Renames Report Visuals, Fields and UI Options
6. Experimenting Visual Interactions, Advantages Reports with Multiple Pages and Advantages Pages with Multiple Visualizations.
7. Data Access PUBLISH Options and Report Verification in Cloud “GET DATA” Options and Report Fields, Filters
8. Report View Options: Full, Fit Page, Width Scale
9. Report Design using Databases & Queries
10. Query Settings and Data Preloads
11. Navigation Options and Report Refresh
12. Stacked bar chart, Stacked column chart
13. Clustered bar chart, Clustered column chart
14. Adding Report Titles. Report Format Options
15. Focus Mode, Explore and Export Settings 

 Week 4

REPORT VISUALIZATIONS and PROPERTIES 

1. Power BI Design: Canvas, Visualizations and Fileds
2.  Import Data Options with Power BI Model, Advantages
3. Direct Query Options and Real-time (LIVE) Data Access
4. Data Fields and Filters with Visualizations
5.  Visualization Filters, Page Filters, Report Filters
6.  Conditional Filters and Clearing. Testing Sets
7. Creating Customised Tables with Power BI Editor
8.  General Properties, Sizing, Dimensions, and Positions
9. Alternate Text and Tiles. Header (Column, Row) Properties
10.  Grid Properties (Vertical, Horizontal) and Styles
11. Table Styles & Alternate Row Colors – Static, Dynamic
12. Sparse, Flashy Rows, Condensed Table Reports. Focus Mode
13. Totals Computations, Background. Boders Properties
14. Column Headers, Column Formatting, Value Properties
15. Conditional Formatting Options – Color Scale
16. Page Level Filters and Report Level Filters
17. Visual-Level Filters and Format Options
18. Report Fields, Formats and Analytics
19. Page-Level Filters and Column Formatting, Filters
20.  Background Properties, Borders and Lock Aspect  

Week 5

CHART AND MAP REPORT PROPERTIES 

1. Chart report types and properties
2. stacked bar chart, stacked column chart
3. clustered bar chart, clustered column chart
4. line charts, area charts, stacked area charts
5. line and stacked row charts
6. line and stacked column charts
7. waterfall chart, scatter chart, pie chart
8. Field Properties: Axis, Legend, Value, Tooltip
9. Field Properties: Color Saturation, Filters Types
10. Formats: Legend, Axis, Data Labels, Plot Area
11. Data Labels: Visibility, Color and Display Units
12. Data Labels: Precision, Position, Text Options
13. Analytics: Constant Line, Position, Labels

Week 6

HIERARCHIES and DRILLDOWN REPORTS 

1. Hierarchies and Drilldown Options
2. Hierarchy Levels and Drill Modes – Usage
3. Drill-thru Options with Tree Map and Pie Chart
4. Higher Levels and Next Level Navigation Options
5. Aggregates with Bottom/Up Navigations. Rules
6. Multi Field Aggregations and Hierarchies in Power BI
7. DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL SEE DATA and SEE RECORDS Options

Week7

POWER QUERY & M LANGUAGE

1. Understanding Power Query Editor – Options
2. Power BI Interface and Query / Dataset Edits
3.  Working with Empty Tables and Load / Edits
4. Empty Table Names and Header Row Promotions
5. Undo Headers Options. Blank Columns Detection
6.  Data Imports and Query Marking in Query Editor
7. JSON Files & Binary Formats with Power Query
8.  JavaScript Object Notation – Usage with M Lang.
9.  Applied Steps and Usage Options. Revert Options
10.  creating Query Groups and Query References. Usage
11.  Query Rename, Load Enable and Data Refresh Options
12. Combine Queries – Merge Join and Anti-Join Options
13.  Combine Queries – Union and Union All as New Dataset
14.  M Language : NestedJoin and JoinKind Functions
15. REPLACE, REMOVE ROWS, REMOVE COL, BLANK – M Lang
16. Column Splits and FilledUp / FilledDown Options
17.  Query Hide and Change Type Options. Code Generation

Week 8

DAX EXPRESSIONS

1. YTD, QTD, MTD Calculations with DAX
2. DAX Calculations and Measures
3.  Using TOPN, RANKX, RANK.EQ
4. Computations using STDEV & VAR
5. SAMPLE Function, COUNTALL, ISERROR
6. ISTEXT, DATEFORMAT, TIMEFORMAT
7. Time Intelligence Functions with DAX
8. Data Analysis Expressions and Functions
9. DATESYTD, DATESQTD, DATESMTD
10. ENDOFYEAR, END OF QUARTER, END OF MONTH
11. FIRSTDATE, LASTDATE, DATESBETWEEN
12.  CLOSING BALANCE YEAR

Week 9

POWER BI CLOUD OPERATIONS 

1. Report Publish Options and Verifications
2. Working with Power BI Cloud Interface & Options
3. Navigation Paths with “My Workspace” Screens
4. FILE, VIEW, EDIT REPORTS, ACCESS, DRILLDOWN
5. Saving Reports into pdf, pptx, etc. Report Embed
6. Report Rendering and EDIT, SAVE, Print Options
7. Report PIN and individual Visual PIN Options
8.  Create and Use Dashboards. Menu Options