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
Example Featured Products
Showcase other available courses, bundles, and coaching products you’re selling with the Featured Products block to provide alternatives to visitors who may not be interested in this specific product.
EXAMPLE
