
Power BI + SQL Online Training - Batch 09
37 lessons0m total
Course content
Session 01 to 10
10 lessons- S01 What is BI? Traditional vs Modern BI
- S02 Connecting To Excel, Website
- S03 SQL Server Connection, Introduction To Power Query Editor
- S04 Transformation Techniques P1 - Errors, Fill, Transpose
- S05 Transformation Techniques P2 - Pivot & Unpivot
- S06 Transformation Techniques P3 - Merge Queries
- S07 Transformation Techniques P4 - Append Queries, Hands-on Solution, Anti Joins
- S08 Introduction To Data Modelling
- S09 Loops, Schema in Data Modelling
- S10 Cardinality & Cross Filter Direction in Data Modelling
Session 11 to 20
10 lessons- S11 Introduction To Visualization
- S12 Waterfall Chart, Scatter Chart, Do's & Don'ts of Visual
- S13 Ribbon Chart, Maps
- S14 Creating a Report in Power BI
- S15 Page Navigation, Actions & Bookmarks
- S16 Power BI Service, Publishing a Report
- S17 Dashboard In Power BI Service
- S18 Data Gateway in Power BI Service
- S19 Row Level Security
- S20 DAX: Left, Lookupvalue, Related Functions
Session 21 to 25
7 lessons- S21 DAX: Left, Lookupvalue, Related Functions
- S22 DAX: Columns Vs Measures, SUMX
- S23 DAX: Calculate Functions
- S24 DAX: Table, Calendar, & Time Intelligence Functions
- S25 MS Fabric
- S26 DAX: Filter Functions
- S27 Resume Preparation Session
Capstone Projects
3 lessons- Power BI Capstone Project 01
- Power BI Capstone Project 02
- Power BI Capstone Project 03
Assignments(All)
6 lessons- Assignment 01
- Assignment 02
- Assignment 03
- Assignment 04
- Assignment 05
- Assignment 06
General Documents
1 lesson- General Documents
₹16,499
One-time payment. Lifetime access.
- 37 on-demand lessons
- Lifetime access
- Certificate of completion