Overview
Context
Proper data modeling is the foundation of data analysis and creating reports in Power BI. This Data Modeling in Power BI course offered by Data Camp lets you explore a toolbox of data cleaning, shaping, and loading techniques, which you can apply to your data.
Diving into Power Query
You'll get to know how to choose between Power Query and Power BI, and discover the foundations of data modeling by going into star and snowflake schemas. You'll apply all of this to real-world datasets issued by the United States Census Bureau.
What you'll learn:
- Differentiate facts and dimensions to design effective star-schema models.
- Distinguish between star and snowflake schemas and assess their performance impact.
- Evaluate data model choices that drive accurate insights and fast Power BI reports.
- Identify essential Power Query transformations for clean, reliable data.
- Optimize Model and Visual Performance in Power BI
Programme Structure
Chapters include:
- Defining Tables
- Dimensional Modeling
- Shaping Tables
- Star and Snowflake schemas
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
Language
Delivered
Campus Location
- New York City, United States
Disciplines
Data Science & Big Data View 467 other Short Courses in Data Science & Big Data in United StatesWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
Prerequisites
- Introduction to Power BI
Tuition Fees
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions