Autoplay
Autocomplete
Previous Lecture
Mark as completed
Data analytics using Microsoft Power BI
Getting started with Data analytics
Introduction
Overview of data analysis
Roles in Data
Introduction
The flow of work in Power BI
Use of Power BI
Getting started with Power BI
Getting started with Data analytics (9:05)
Roles in Data analytics (9:44)
Getting started with power bi (10:34)
Building blocks of Power BI (5:09)
Power BI Interface (6:16)
Power BI Interface Conti (5:28)
Power BI Service (20:34)
Getting Data
Downloadable Files
Data Connectors (2:12)
Data Sources (3:14)
Connecting to Excel workbook (3:51)
Connecting to CSV and PDF (4:16)
Connecting to Data from a Folder (5:49)
Connecting to Access Database (1:24)
Connecting to Data from Web (2:03)
Coonecting to Data from Google sheet (2:34)
Preparing Data for Analysis
Downloadable Files
Introduction to Power Query Editor (8:36)
Data Profiling (4:05)
Basic Data Transformation (8:18)
Basic Data Transformation Conti. (7:16)
Appending Queries (6:57)
Appending Data from a Folder (2:14)
Merging Queries (6:35)
Join Kinds (10:12)
Unpivot Columns (4:55)
Summarizing Data with GROUP BY (5:49)
Adding Column: Column from Examples (3:49)
Adding Column: Custom Columns (4:58)
Adding Column: Conditional Column (3:59)
Adding Column: From Number (7:15)
Adding Column: From Date (4:34)
Advanced Editor (5:18)
Reusing M Code (8:51)
Changing Data Source (3:05)
Data transformation Challenge (6:32)
Data Modeling and DAX
Exercise Files
Loading Data (12:06)
Introduction to Power BI Interface (5:22)
Intro Data modeling (9:39)
Creating relationships (9:45)
Autodetect (2:43)
Cardinality (4:36)
Cardinality Part 2 (1:39)
Dimensions and Fact Tables (2:53)
Cross filter Direction (7:31)
Bi-Directional (4:07)
Table Properties (3:56)
Column properties (6:31)
Creating Hierarchies (5:42)
Live session: Advanced DAX
Download Files
Data Modeling Revisited (142:09)
Introduction to DAX (16:31)
Calculated Columns(Related and RelatedTable) (42:24)
Calculated Tables (34:37)
Check your knowledge
Introduction to measures (22:39)
Aggregate Functions (14:23)
Evaluation context (27:10)
Measure Vs Calculated Columns (7:37)
Iterators (18:45)
Advanced CALCULATE (31:49)
REMOVEFILTERS AND ALL (13:08)
FILTER FUNCTION (25:45)
Time Intelligence (43:38)
DAX GUIDE SUPPORT
Worked Power BI File
Live session: Advanced Visualization
Power BI Visuals Guide
Power BI Visuals Guide Power BI Files
Introduction to Power BI Visuals (10:49)
The Card Visual (18:06)
The Card Visual_Question (5:09)
The KPI Visual (12:31)
The KPI Visual Part 2 (6:31)
The KPI Visual_Question (2:42)
The Multi-row Card (3:56)
Creating Multi-Row Card (2:48)
Columns and Bar charts (12:17)
The Gauge (9:55)
Pie and Doughnut (10:12)
Combo chart (10:24)
100% stacked charts (4:38)
Waterfall chart (4:11)
Funnel chart (9:08)
The Q and A visual (15:04)
Decomposition tree (15:27)
Key influencers (10:35)
Smart Narrative (9:59)
Custom Visuals (4:20)
Edit Interactions (11:01)
Object Alignments (5:09)
Dashboard Design
Downloadable Files
Introduction (8:56)
Get Data (5:43)
Transform Data (8:17)
Relationships (2:48)
Data View (3:50)
Calculations Part 1 (13:49)
Calculations Part 2 _ Time Intelligence (21:15)
Building Dashbaord_KPIs (13:46)
Building Dashboard Part 2 (32:37)
Adding Buttons for Page Navigation (5:39)
Creating Free Corporate mail for Power BI signup (15:33)
12 Power BI Services (14:08)
Power BI and PowerPoint Integration (3:30)
19 Final (9:49)
Dashboard Design 2
Dashbaord 3 : Exercise Files
Dashboard 3: Video (266:19)
Dashboard 3: Background Design (5:43)
Final Capstone
📑Datasets
💡Business Case
🚀Submission
Iterators
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock