Autoplay
Autocomplete
Previous Lesson
Complete and Continue
[LEGACY ]Microsoft Power BI - A Complete Introduction
Introduction
Welcome to this Course! (1:27)
What is Power BI? (7:28)
First Project 1/3: Installing Power BI Desktop & Source File Connection (11:11)
First Project 2/3: Working in the Query Editor (9:19)
First Project 3/3: The Data View & Creating our First Visuals (8:11)
Course Outline - What's Inside the Course? (5:23)
How to Get the Most out of the Course (3:53)
Useful Resources & Links
The Academind Pro Referral Program
An Introduction to Power BI Desktop
Module Introduction (1:36)
Using the Attached Project Files (4:01)
Understanding the Power BI Desktop Workflow (2:34)
Exploring the Data Model Interface (6:05)
Understanding the Query Editor Interface (4:48)
Important! Creating the Project File & Recommended Settings (4:10)
Course Slides
Useful Resources & Links
Working in the Query Editor
Module Introduction (1:48)
Connecting Power BI Desktop to Source Files (7:08)
Keeping & Removing Rows (6:19)
Working with Filters (4:18)
Removing Empty Rows (5:08)
Saving the Project Draft (3:23)
Appending Queries (7:08)
Working with Columns (5:22)
Replacing Values (5:34)
Formatting Data & Handling Formatting Errors (8:09)
Pivoting & Unpivoting Data (10:18)
Splitting Columns (8:15)
Creating Groups & Cleaning Up our Project (5:16)
What we Achieved & How to Continue (1:04)
Theory Time: The Star Schema (5:27)
How we Use the Star Schema in our Project (2:24)
Query Duplicates vs References (7:20)
Creating the DIM-Region Table & Removing Duplicates (9:33)
Creating Tables Manually (4:03)
Theory Time: Merging Queries (5:14)
Understanding "Join Kind" (4:40)
Merging Queries Applied (7:24)
Finishing the DIM-Region Table (10:45)
The Next Steps (1:05)
Creating the DIM-Age Table (6:51)
Understanding "Extract" (5:37)
Working with Conditional Columns (4:04)
Creating the FACT-Table (4:46)
Understanding Basic Mathematical Operations (2:04)
Performance Optimization (6:50)
Assignment - Query Editor (Problem) (0:53)
Assignment - Query Editor (Solution) (10:20)
Wrap Up (2:53)
Useful Resources & Links
Understanding the Data Model: Data & Relationship View
Module Introduction (1:28)
Understanding Relationships (7:55)
Cardinality: Many-to-One & One-to-One (4:53)
Cross Filter Direction & Many-to-Many (6:29)
Understanding Active Properties (3:08)
M-Language vs DAX (Data Analysis Expressions) (3:11)
M vs DAX - A Practical Example (11:28)
Understanding the DAX Basics (2:39)
The DAX Syntax (3:30)
Supported DAX Data Types (2:06)
Diving Into Operators (3:51)
DAX Functions - An Overview (3:25)
Understanding the CALENDAR Function (10:13)
Applying the DAX Basics (4:42)
Understanding IF & RELATED (6:52)
Calculated Columns vs Measures (1:48)
Creating our First Measures (5:26)
Understanding CALCULATE & FILTER (3:38)
Applying CALCULATE & FILTER in Measures (8:45)
Creating Measures with Measures (4:59)
Understanding "Data Category" (2:09)
Assignment - Data Model (Problem) (0:57)
Assignment - Data Model (Solution) (14:41)
Wrap Up (3:14)
Useful Resources & Links
Creating Visuals in the Report View
Module Introduction (1:13)
Understanding Basic Visual Concepts (3:12)
Getting Started with Visuals & Reports (7:00)
Creating our First Visuals (5:48)
Understanding Tooltips & Interactions (6:52)
Diving Intro Hierarchies & Drill Mode (6:32)
Data Colors & Conditional Formatting (6:54)
Formatting Report Pages (4:34)
Formatting Visuals (9:03)
Working with Report Themes (10:29)
Using the Slicer (8:03)
Understanding Default Summarization & Sorting (4:05)
Working with Treemaps & Tables (9:30)
Syncing Slicers (3:22)
Understanding Filter Types (Visual, Page & Report) (7:02)
Working with (Multi) Row Cards (4:51)
Creating Combined Visuals & Waterfalls (8:35)
Using Custom Visuals (2:36)
Assignment - Report View (Problem) (0:47)
Assignment - Report View (Solution) (10:01)
Wrap Up (3:36)
Useful Resources & Links
Taking the Project to the Cloud with Power BI Pro (Service)
Module Introduction (1:02)
Why we Need Power BI Pro (Service) (4:19)
Power BI: Service vs Pro vs Premium (3:25)
Exploring the Power BI Pro Interface (4:41)
Understanding Workspaces (3:00)
Connecting Power BI Pro & Power BI Desktop (3:57)
Understanding Datasets in Power BI Pro (5:13)
Working with Reports (5:21)
Creating Dashboards (6:38)
Exploring "My Workspace" (5:10)
Refreshing Data with Gateways (10:23)
Sharing Data From "My Workspace" (6:54)
Understanding Collaboration Workspaces (8:40)
Workspaces vs Apps vs Content Packs (1:40)
Publishing an App (10:50)
Workspace or App - Which one Should I Choose? (2:09)
Working with Power BI Mobile (9:17)
Wrap Up (2:40)
Useful Resources & Links
Other Data Sources
Module Introduction (1:21)
Importing JSON Data (6:28)
Importing Data from REST APIs (5:00)
Preparation: Setting up a MySQL Server (8:09)
Importing Data from a MySQL Server (and other SQL Servers) (6:38)
Wrap Up (0:56)
How to Stay Up-to-Date in the Power BI World?
Module Introduction (0:43)
Helpful Resources (5:01)
Using Preview Features (1:17)
Creating Custom Visuals (Power BI for Developers)
Module Introduction (0:44)
Why Custom Visuals? (5:01)
The Required Tools (3:06)
Setting Up & Installing the Required Tools (11:19)
Creating a New Visual (6:05)
Analyzing the Project & the Code (13:02)
Rendering Content to the Screen (5:42)
Using d3.js & a First Shape (12:26)
Getting Started with the Bars (10:07)
Rendering a Chart for Dummy Data (11:59)
Binding Real Data (16:24)
Coloring the Bars (4:26)
Adding an Axis (5:37)
Package & Wrap Up (3:14)
Useful Resources & Links
Course Round Up
Congratulations! What you Learned & How to Continue (6:36)
Bonus: Selected Features by Example & Refresher Project
About this Module
Understanding Column from Examples (6:34)
Group By, Big Data & DAX Studio (9:42)
Please Read: Bonus Project Introduction
Taxi Project - Query Editor (22:12)
Taxi Project - Data Model & Visuals (22:20)
Taxi Project - Power BI Service (15:32)
Creating the FACT-Table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock