Introduction to M Query - Part 1 | HAVISH M CONSULTING

POWER BI - DATA ANALYTICS AND VISUALIZATION

LATEST VIDEOS (2021 JUNE)

001 - WHAT IS POWER BI + DOWNLOAD (16:25)
002 - INTERFACE AND CONNECTING TO DATASETS (15:55)
003 - YOUR FIRST DASHBOARD (6:18)
004 - DEEP DIVE INTO YOUR FIRST CHART (18:57)
005 - CHARTS (BAR - COLUMN - AREA - LINE - COMBO - RIBBON - FORECAST - WATERFALL - FUNNEL) (15:25)
006 - CHARTS (SCACTTER - PIE - DONUT - TREEMAP - TABLE - MATRIX - MAP - DECOMPOSITION) (16:03)
007 - AI VISUALS (ANALYZE - SUMMARIZE - QandA (10:40)
008 - CUSTOM VISUALS (SANKEY, CHORD, BOX-WHISKER, PULSE, ANIMATED BAR, MEKKO, BUBBLE) (12:25)
009 - ADVANCED VISUALS (INFOGRAPHIC DESIGNER - CHARTICULATOR - SDK) (7:29)
010 - INTERACTION - SLICER - FILTER - BOOKMARK - CUSTOM TOOLTIPS (14:42)
011 - POWER QUERY (COMBINE FILES, MERGE, CLEAN AND PREP) (18:27)
012 - POWER QUERY (COLUMN FROM EXAMPLES, CONDITIONAL COLUMN, FUNCTIONS) (8:45)
013 - DAX (CALCULATED COLUMNS - DATE TABLES - MEASURES - DATA MODELS) (22:40)
014 - POWER BI SERVICE (PUBLISH - SHARE - EMBED - DASHBOARD - REFRESH - DATAFLOWS) (25:22)
015 - WHAT NEXT (7:25)
Get Your Certificate
Files

Introducing Power BI Desktop (Note: These lectures have been updated)

Power BI Interface Introducing Power BI Desktop (Note: These lectures have been updated)

Overview of the Interface (5:16)
Changes to Settings (2:48)
Connecting to Superstore Data (4:00)
Data Types + Hierarchy (2:06)
Creating a Data Table and Relationship in Model View (6:53)
Quiz

Visualizations Introducing Power BI Desktop (Note: These lectures have been updated)

Bar Charts and Column Charts - Part 1 (4:19)
Bar Charts and Column Charts - Part 2 (2:46)
Formatting and Tooltips (6:22)
Bar Charts and Column Charts - Part 3 (3:06)
Line and Area Charts - Part 1 (3:33)
Line and Area Charts - Part 2 (2:58)
Ribbon Chart (2:55)
Waterfall Chart (3:58)
Funnel (2:41)
Scatter Chart (4:26)
Pie and Donut Chart (2:10)
Treemap (4:19)
Map (2:51)
Gauge (4:33)
Card and Multi-row card (3:03)
Slicer (2:41)
Table and Matrix (3:32)
AI Visuals - Decomposition Tree (5:12)
AI Visuals - Q&A (7:07)
Quiz

Custom Visuals Introducing Power BI Desktop (Note: These lectures have been updated)

How to Download Custom Visuals (3:50)
Word Cloud (2:33)
Infographic Designer (7:00)
Tornado Chart (1:23)
Sankey Chart - Tassels Parallel Sets Slicer - Force-Directed Graph (5:40)
Marimekko Chart (4:25)
Arria (2:49)
Scroller (1:39)
Advanced Donut Visual (1:29)
Animated Bar Chart Race (1:59)
Bubble Chart (3:46)
Radar Chart (1:04)
Quiz

Create Interactivity Introducing Power BI Desktop (Note: These lectures have been updated)

Interactivity between Charts (2:51)
Edit Interactions (5:38)
Selection Pane (1:21)
Bookmarks (2:01)
Tooltip (6:24)
Filter Pane (4:36)
Quiz

Working with DAX Measures Introducing Power BI Desktop (Note: These lectures have been updated)

Introduction to DAX - Creating your First Measure (8:20)
Using Quick Measures (8:09)
Average Per Category (9:05)
Month-Over-Month change (8:21)
Sales from new cutomers (6:11)
Wrapping Up - DAX (0:47)
Quiz

Data Mashup with Power Query Introducing Power BI Desktop (Note: These lectures have been updated)

Introduction to M Query - Part 1 (6:11)
Introduction to M Query - Part 2 (8:56)
Split Column and Column From Examples (5:59)
Conditional Column (3:54)
Group By (2:12)
Split in Rows - Top Customers (10:45)
Unpivoting Data (4:15)
Advanced Editor (2:06)
Wrapping Up - Power Query (1:55)
Quiz

Putting it Together Introducing Power BI Desktop (Note: These lectures have been updated)

Lesson content locked

If you're already enrolled, you'll need to login.