Example Curriculum
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
- 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)
- Relative Date Filter Tutorial for selecting Previous and Period Range (3:27)
- 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 Function DatesYTD and Calculation for running year to date cumulative values (3:35)
- DAX Time Intellingence Date Add Function Calculation to get Historical and Future Values (9:37)
- 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