Master Microsoft's Power BI business analytics platform in this comprehensive 2-hour 35-minute tutorial. Learn to build queries, prep data, create relationships across multiple databases, and construct live dashboards and interactive reports. Dive into foundational concepts, including SharePoint list querying, M script usage, calendar table creation, and advanced DAX functions. Explore complex topics such as filter context, order of operations, disconnected tables, and row-level security. Gain practical skills in mobile design, custom visuals, and setting up alerts. Perfect for business and data analysts looking to elevate their data processing and visualization capabilities.
Overview
Syllabus
Start
Introduction
Querying SharePoint Lists
Unpivot Columns
Copying and Pasting M Script
M Language Basics
Creating a Calendar Table with List.Dates
Adding Metadata with M Functions
Reusing Calendar M Script in Excel
Custom Query Functions
DATESYTD
DATESYTD and DATESMTD
DATEADD
DATESBETWEEN
Complicated Relationships
Granularity Discrepancies
Inactive Relationships
Many to Many
Introduction
Filter Context Flows Downstream
Order of Operations
ALL to Clear Structural Filters
ALL - Choosing the Right Table
FILTER
Disconnected Tables
Lab Results
Disconnected Visuals
Row Level Security
Custom Visuals
Republish Dashboard
Excel Objects in Power BI Online
Designing for Mobile
Using the Power BI Mobile App
Alerts
Conclusion
Taught by
Learnit Training
