In tutorial we will continue with the Power BI series. In the previous session we cleaned up our data model by combining multiple tables product tables. I left you with an exercise to combine the customer with geography and Sales Territory table. We have a single table with customer, geography and territory columns.
We will perform data transformation in this session to add calculated columns, replace nulls, and combine columns.
Link to GitHub: https://github.com/hnawaz007/PowerBIA...
Link to previous video: • Develop a Power BI Data Model | Dimen...
Subscribe to our channel:
/ haqnawaz
-----------------------------------------
Follow me on social media!
GitHub: https://github.com/hnawaz007
Instagram: / bi_insights_inc
LinkedIn: / haq-nawaz
-----------------------------------------
#powerbi #datamodeling #datatransformation
Topics covered in this video:
0:00 - Introduction to Data Model
1:07 - Data Exploration
1:43 - Data Classification
2:34 - Data Cleansing
3:00 - Data Transformation
5:02 - Conditional Logic
8:13 - Replace Nulls
9:56 - Data Model Cleanup
11:18 - Data Hierarchies
12:39 - Format Date