Dive into an intermediate-level Power BI tutorial designed for Business Analysts, Data Analysts, and professionals seeking to enhance their data processing and visualization skills. Learn foundational concepts of building queries and preparing data for analysis, construct relationships across multiple databases using Power Pivot, and master useful functions to elevate your data analysis capabilities. Explore the process of building and navigating live dashboards and interactive reports while gaining insights into data shaping techniques, enhancing data structure, designing data models, and implementing Row-Level Security (RLS). Through hands-on exercises and comprehensive explanations, develop a deeper understanding of Power BI's capabilities to organize, analyze, and visualize large datasets effectively.
Overview
Syllabus
Start
Introduction
Data Shaping - Renaming Tables
Data Shaping - Promoting the First Row
Data Shaping - Duplicating Column Replace Values
Data Shaping - Removing Columns
Data Shaping - Filtering, Sorting, and Applying Changes
Introduction to Enhancing Data Structure
Enhancing Data Structure - Join Types Merge Queries
Data Profiling Recap
Introduction to Designing a Data Model
Working with Tables
Fact vs Dimension
Breaking Down Tables
Creating Hierarchy
Relationships aka Cardinality
Creating Relationships
Reviewing the Model Interface
Creating RLS Roles in Desktop
Assigning Users to RLS Roles in Service
Conclusion
Taught by
Learnit Training
