Explore data modeling and prototyping techniques using Power BI Desktop in this comprehensive conference talk from PASS Data Community Summit. Learn how to leverage this versatile tool for quick and efficient data modeling from various sources, including websites, databases, cubes, online services, and flat files. Discover built-in M and DAX functions for data cleansing and connecting multiple sources. Create rapid prototypes and reports to support project approval and funding. Gain insights into star and snowflake schemas, tabular models, shared data sets, and the tabular engine. Master Power BI Desktop's Model View, relationships, and Power Query features to streamline your data modeling process. No licensing or Power BI login required for this free and powerful tool.
Overview
Syllabus
Intro
Agenda
Data Connections
Direct Query
Import Connection
Demo Setup
Getting Data
Editing Queries
Finding Data
Data Modeling
Star Snowflake Schemas
Power BI Desktop
Model View
Relationships
Power Query and M
Tips
Tabular Models
Shared Data Sets
Updating Power BI Desktop
The Tabular Engine
Taught by
PASS Data Community Summit
