Power Query Power BI: Transform 2 Fact Tables to Star Schema Data Model (Invoice Data) EMT 1498

Learners: 3

Instructor: ExcelIsFun

Duration: 1.00

This course provides an introduction to the Star Schema data model and how to use Power Query and Power BI to transform two fact tables into this model. Participants will learn how to import the two fact tables into Power BI Desktop, multiply columns to calculate line sales, merge to lookup product weight, and create a star schema data model. This course is ideal for those looking to gain a better understanding of the Star Schema data model and how to use Power Query and Power BI to transform data. ▼▲

Course Feature Course Overview Course Provider Discussion and Reviews

Go to class

Course Feature

Cost:

Free

Provider:

Youtube

Certificate:

Paid Certification

Language:

English

Start Date:

On-Demand

Course Overview

❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [February 21st, 2023]

This course provides users with the knowledge and skills to transform two fact tables into a star schema data model in Power BI Desktop using Power Query. Through this course, users will learn how to import data, multiply columns, merge to lookup data, group by to aggregate data, divide columns, create custom columns, and edit columns. In addition, users will learn how to create relationships between the single line item fact table and the three dimension tables, as well as create five measures and hide columns in the report view.
Possible Development Paths include data analyst, data scientist, business intelligence analyst, and data engineer. These roles require knowledge of data modeling, data analysis, and data visualization.
Learning Suggestions for learners include taking courses in data analysis, data modeling, data visualization, and Power BI. Additionally, learners should practice their skills by working on projects and exploring different datasets. They should also stay up to date on the latest trends in data science and business intelligence.