Posts tagged #Flat Files

Transforming Beast Tables into Beauty Models in Power BI

Learn how to use Power Query to transform wide single tables into relational models that leverage fact and dimension table design with relationships. This process optimizes the tables for the tabular model in Power BI resulting in smaller file/model size, and faster performance! While aiming towards a star schema design, which works best in Power BI. Tune in to learn more!

Video by: Reid Havens

RELATED CONTENT 🔗

Understand Star Schema Importance in Power BI
Building Your First Calendar Table

Extracting Text/CSV Data Using Text From Example in Power Query!

Video by: Reid Havens

Learn how to utilize the new Text from Example feature in the Power Query Editor within Power BI Desktop.

Posted on August 18, 2020 and filed under Beginner, Power Query.