Getting started with Data analytics
Getting started with Power BI
Getting Data
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 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)
Data Analysis Expression
-
Dataset
-
Dataset walkthrough (1:54)
-
Connecting and Transforming the Data (8:31)
-
Data Modeling (8:20)
-
Introduction to DAX (1:05)
-
DAX Calculations (1:28)
-
DAX Functions in Power BI (2:28)
-
DAX Operators (1:15)
-
Referencing Model objects (2:15)
-
Using Variables (0:58)
-
Using variables Demo (6:02)
-
Adding Comments in DAX (1:16)
-
Adding Comments in DAX Demo (3:29)
-
Introduction to calculated tables (2:46)
-
Using the VALUES Function (4:11)
-
Using the VALUES Function with Table Input (3:44)
-
Using the DISTINCT Function (2:51)
-
Create Date Table with the CALENDAR Function (3:06)
-
Create Date_Table with CALENDARAUTO (4:27)
-
Add Columns to a Table with ADDCOLUMNS Function (6:24)
-
Create a Table with the FILTER Function (4:59)
-
Using the FILTER Function with Logical operators (5:55)
-
Calculated Tables Review (1:08)
-
Introduction to Calculated Columns (3:08)
-
Add Calculated Column with the IF Function (3:46)
-
Understanding Row Context (2:02)
-
Using the RELATED Function to retrieve Data (8:58)
-
Using the RELATEDTABLE Function (8:00)
-
Creating Measures Table (3:47)
-
Introduction to AGGREGATE Functions (1:59)
-
Using the SUM Function to aggregate values (6:55)
-
Using the COUNTROWS Function (2:35)
-
Using the AVERAGE Function (3:55)
-
Aggregate values using the MIN and MAX Functions (2:26)
-
Difference between Measures and Calculated Columns (2:18)
-
Understanding Evaluation Context (2:51)
-
Understanding FILTER Context (2:47)
-
How FILTER Context works in Power BI (6:05)
-
FILTER Context and Cross Filter Direction (5:32)
-
Introduction to Iterators(X-Aggregators) (1:36)
-
SUMX Function (7:57)
-
AVERAGEX Function (2:58)
-
MINX Function (3:33)
-
MAXX Function (2:50)
-
Introduction to the CALCULATE Function (1:00)
-
Understanding the CALCULATE Function (3:59)
-
Using the CALCULATE Function Demo 1 (7:54)
-
Using the CALCULATE Function Demo 2 (4:48)
-
Using the CALCULATE Function Demo 3 (5:10)
-
Creating a virtual table with the FILTER Function (11:51)
-
Introduction to Filter Modifiers (0:53)
-
Introduction to REMOVEFILTERS (8:32)
-
Using REMOVEFILTERS with CALCULATE (8:32)
-
Introduction to the ALL Function (2:24)
-
Using the ALL Function with CALCULATE (6:33)
-
Introduction to Time Intelligence (3:46)
-
Using the PREVIOUSYEAR Function to perform YoY Analysis (6:36)
-
Using the DATEADD Function (5:21)
-
Using DATEADD for MoM Analysis (6:28)
-
Using SAMEPERIODLASTYEAR Function (4:41)
-
Calculating Running Total with TOTALYTD Function (4:20)
-
Running Totals with different Fiscal Year (3:23)
-
Using the TOTALMTD Function (2:35)
-
Using the DATESYTD Function (4:20)
-
Introduction to RANKX (2:14)
-
RANKX Demo (7:02)
-
TopN Function Introduction (2:09)
-
Creating table with TopN Function (6:54)
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)
Artificial Intelligence Visualizations
Explain increases and decreases
Naural Language with Q&A visual
Create smart narrative summaries
Decomposition tree visuals in Power BI
Create key influencers visualizations
Anomaly Detection
Apply clustering techniques.
Guided Project
-
Guided Project Sample (3:26)
-
Datasets
-
Connecting the Data (4:34)
-
Performing Data transformation (2:40)
-
Adding Calculations (9:26)
-
Loading the Data (1:46)
-
Data modeling(Calculated Columns) (7:27)
-
Adding calculated Tables (9:16)
-
Creating measures (13:32)
-
Time Intelligence Calculations (11:05)
-
Introduction to Visualization (15:03)
-
Dashboard Layout (12:39)
-
Key Performance Indicators (7:21)
-
Working the Slicers pane (6:00)
-
Visualization 1 (17:03)
-
Grouping Data (4:50)
-
Visualization 2 (9:58)
-
Visualizing trend with KPI visual (3:49)
-
Editing visual interactions (2:54)
-
Sharing the report (1:19)
-
Dashboard Design version 2 (6:35)
Guided Project 2 - Designing Financial Analysis Dashboard
-
Connecting and importing the Dataset (3:05)
-
Transform and Load Data (5:02)
-
Data Modeling (11:22)
-
Data Analysis with DAX (7:03)
-
Time intelligence calculations (5:54)
-
Time intelligence part 2 (3:49)
-
Report development - Report Theme (6:13)
-
Report_Development - Background Design (9:59)
-
Data visualization - Key Perfomance Indicators (8:14)
-
Data visualization - Breakdown of KPIs (6:11)
-
Data visualization - Breakdown of KPIs 2 (17:50)
-
Data visualization - Profit Margin by Segment (6:14)
-
Sharing and Consuming report - Export to PDF (2:54)
-
Export report as Powerpoint Presentation (5:19)
-
Sharing report via Email (2:44)
-
Sharing report on Microsoft Teams (1:16)
