Example Curriculum
16 July
Available in
days
days
after you enroll
22nd July
Available in
days
days
after you enroll
23rd July
Available in
days
days
after you enroll
29th July
Available in
days
days
after you enroll
30th July
Available in
days
days
after you enroll
5th August
Available in
days
days
after you enroll
6th August
Available in
days
days
after you enroll
12 August
Available in
days
days
after you enroll
13 August
Available in
days
days
after you enroll
20th August
Available in
days
days
after you enroll
26th August
Available in
days
days
after you enroll
27th August
Available in
days
days
after you enroll
2nd September
Available in
days
days
after you enroll
3rd September
Available in
days
days
after you enroll
10 September
Available in
days
days
after you enroll
16th September
Available in
days
days
after you enroll
17th September
Available in
days
days
after you enroll
24th September
Available in
days
days
after you enroll
30th September
Available in
days
days
after you enroll
1st October
Available in
days
days
after you enroll
7 October
Available in
days
days
after you enroll
8th October
Available in
days
days
after you enroll
15th October
Available in
days
days
after you enroll
21 October
Available in
days
days
after you enroll
22nd October
Available in
days
days
after you enroll
28th October
Available in
days
days
after you enroll
29th October
Available in
days
days
after you enroll
4th November
Available in
days
days
after you enroll
5 November
Available in
days
days
after you enroll
Task File
Available in
days
days
after you enroll
26th November
Available in
days
days
after you enroll
2nd December
Available in
days
days
after you enroll
3rd December
Available in
days
days
after you enroll
9th December
Available in
days
days
after you enroll
10th December
Available in
days
days
after you enroll
16th December
Available in
days
days
after you enroll
17th December
Available in
days
days
after you enroll
23rd December
Available in
days
days
after you enroll
24th December
Available in
days
days
after you enroll
6th January
Available in
days
days
after you enroll
7th January
Available in
days
days
after you enroll
Career Building Session 1 - 30th December
Available in
days
days
after you enroll
31st December
Available in
days
days
after you enroll
Resumes building and Sample Interview Questions
Available in
days
days
after you enroll
13th January
Available in
days
days
after you enroll
14th January
Available in
days
days
after you enroll
21st January
Available in
days
days
after you enroll
Getting Started
Available in
days
days
after you enroll
- What is PowerBi ? (9:20)
- PowerBi Desktop Installation (5:12)
- PowerBi Walkthrough (6:19)
- Introduction to Database (26:50)
- Introduction to Database objects (48:28)
- Installing SQL Server (8:44)
- Installing Sample Database (7:19)
- Introduction to Relational Database - Codds Rules (52:14)
- Learning ER Diagram (42:17)
- Create Tables and Insert using SQL Server (26:24)
- Reading content from the Database (51:14)
- Introduction to OLAP Database (14:55)
- Schema Modelling - Star vs Snowflake (29:55)
Connecting to Data
Available in
days
days
after you enroll
- How to Configure SSMS and SQL Server DB Power BI (48:15)
- Connecting to CSV (7:19)
- Practice with CSV file (7:52)
- Connecting to Excel File with Data (9:22)
- Connecting to Hidden Sheet in Excel (3:36)
- Connecting with Excel sheet with blank columns (4:00)
- Read password protected excel file (3:04)
- Read formula from Excel (6:39)
- Practice with Excel Data (12:12)
- Connecting to Folder of Data (6:22)
- Practice with Folder Data (10:57)
- Getting Data from Web (4:36)
- Web Data Practice (21:03)
- Overview of Connecting to SQL Server (6:23)
- Connecting to SQL Server and Understanding the data (12:12)
- Creating and Importing SQL Views using Import (12:23)
- Reading using SQL Query (6:38)
- Connecting to ESPN CricInfo (4:26)
- Connecting to MYSQL DB (5:34)
- Connecting to SQLITE DB (5:17)
- Connecting to Wikipedia (3:26)
- Include or Exclude part of Visualization (2:20)
Creating Visuals
Available in
days
days
after you enroll
- Line Chart (6:22)
- Stacked Bar Chart (4:49)
- 100 pc Stacked Bar Chart (4:54)
- Pie Chart (5:24)
- Donut Chart (3:56)
- Area Chart (6:04)
- Stacked Area Chart (4:23)
- Line and Stack Chart (5:48)
- Line and Clustered Chart (2:45)
- Waterfall Model (7:11)
- Key Influencer Chart (6:56)
- Funnel Chart (6:28)
- Gauge Chart (4:50)
- Ribbon Chart (7:24)
- Card KPI (4:07)
- Sankey Chart (6:30)
- Scatter Chart (7:34)
- Indicator KPI (6:01)
- Bow Tie Chart (7:38)
- Tree Map (5:17)
- Advance Infographic (7:23)
- How to change Aggregation or Calculation type (6:29)
- How to create matrix or pivot chart (4:10)
- Table Chart (5:12)
- Animated Bar Race Chart (7:13)
- Bullet Chart (6:38)
- Tree Based Custom Visualization (5:45)
- World Cloud Visualization (5:10)
- Tornado Chart (6:24)
- Visual For Natural Language Processing (5:34)
- Show or Hide Visualization on Dash board (3:12)
Data Wrangling
Available in
days
days
after you enroll
- Relative Date Filter Tutorial for selecting Previous and Period Range (3:27)
- Create a new custom PowerBi table (3:11)
- Create a summarized table from existing table (3:31)
- Mini Project Connect clean and Model Data (15:50)
- Create a new measure PowerBi to keep all measures at one place (4:03)
- PowerBi Advance Date Filtering Tutorial with Example (6:21)
- Create a new table in PowerBi from existing table based on filter conditions (3:55)
- Drill through Filter Tutorial with example to connect pages (7:43)
- Create and Use PowerBi Hierarchy (3:56)
- Numeric Field Formatting and Conditional Formatting (5:13)
- Totals and Sub Totals in Matrix or Pivot Table (4:22)
- Visual vs Page vs Page All Filters (3:42)
- Changing or Formatting Slicer (6:30)
- How to create PowerBi Text Slicer (7:26)
- How to create Date Slicer (7:45)
DAX FORMULAE
Available in
days
days
after you enroll
- Dax Introduction (5:19)
- Discussion on DAX funtions (7:01)
- DAX Example (4:16)
- DAX Calculated Column (14:17)
- Find Values for Every Last Day of the Year (4:23)
- DAX Function DATESINPERIOD (4:08)
- DAX Function ClosingBalanceQuarter to find the value at the last day of Quarter (3:03)
- DAX Function ClosingBalanceYear to capture on the last day of the year (3:07)
- DAX Function DatesMTD and Calculation for running month to date cumulative values (3:37)
- DAX Function DatesQTD and calculating for running quarter to date cumulative values (3:27)
- DAX Time Intellingence Date Add Function Calculation to get Historical and Future Values (9:37)
- DAX Function DatesYTD and Calculation for running year to date cumulative values (3:35)
- DAX Time Intelligence Date Function to calculate values between two dates (4:04)
- Time Intelligence Dax Function to find the value on last day of the month (3:53)
End to end Visualization
Available in
days
days
after you enroll
5th February
Available in
days
days
after you enroll