Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.
What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.
What you'll learn: In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.
- Introduction (0:46)
- Data Shaping - Renaming Tables (1:38)
- Data Shaping - Promoting the First Row (2:20)
- Data Shaping - Duplicating Column Replace Values (2:47)
- Data Shaping - Removing Columns (2:07)
- Data Shaping - Filtering, Sorting, and Applying Changes (4:15)
- Introduction to Enhancing Data Structure (2:33)
- Enhancing Data Structure - Join Types Merge Queries (4:51)
- Data Profiling Recap (4:46)
- Introduction to Designing a Data Model (1:06)
- Working with Tables (5:54)
- Fact vs Dimension (1:25)
- Breaking Down Tables (6:39)
- Creating Hierarchy (2:16)
- Relationships aka Cardinality (1:53)
- Creating Relationships (6:05)
- Reviewing the Model Interface (3:44)
- Creating RLS Roles in Desktop (4:24)
- Assigning Users to RLS Roles in Service (2:24)
- Conclusion (0:40)