Class Introduction

This was a Power BI training session focused on data transformation techniques, specifically covering unpivoting and pivoting concepts. The instructor demonstrated how to transform data from Excel sheets using Power Query, explaining when to use the "Unpivot Other Columns" feature and when to use "Pivot Column" functionality. The class included practical exercises using various datasets including balance sheets, product data, and cosmetics information, with participants learning how to properly structure data by separating attributes from values. The session also covered merging datasets and creating custom columns with formulas, including a practical example of applying tariff pricing based on whether products have tariffs or not. The instructor emphasized that proper data transformation is crucial for analysis and that Power BI should be learned from a data analytics approach rather than an Excel-based approach.

Related Offerings

Power BI Data Transformation Training
Hussein taught the team about data transformation concepts in Power BI, focusing on unpivoting data to properly structure it for analysis. He demonstrated how to unpivot store data from an Excel sheet format and explained the importance of separating attributes (like store names) from values (like sales figures). Hussein emphasized that unpivoting is crucial for enabling proper analysis in Power BI, contrasting it with loading data directly from Excel where analysis becomes impossible. He also showed how to clean and transform balance sheet data by removing null values and subtotals, while explaining that proper data typing (like using date format) is essential for effective data analysis.

Power BI Data Unpivoting Techniques
Hussein demonstrated the proper technique for unpivoting data in Power BI, explaining that users should unpivot all columns except for key identifiers like product names, month names, and WBS codes. He emphasized that unpivoting should be used to transform resource names into attributes and hours worked into values, rather than just removing null values. Hussein shared his own experience of struggling with Power BI in 2019-2020 due to lack of knowledge about unpivoting and date tables, and stressed the importance of learning Power BI from a data analytics approach rather than treating it as an Excel alternative.

Power BI Data Transformation Techniques
The team discussed data transformation techniques in Power BI, focusing on unpivoting and pivoting data. They explained how to unpivot product data using the right-click option and demonstrated the process of pivoting data using the Transform tab to separate planned and actual costs into different columns. The session was paused for a break, with plans to continue learning about transposing data and proceed with a case study using the Northwind Traders dataset after the break.

Power BI Data Transformation Training
The team conducted a Power BI training session focused on data transformation techniques. They covered unpivoting, pivoting, and transposing data, with practical exercises involving Excel workbooks and CSV files. The session included a hands-on exercise where participants learned to merge datasets using fuzzy matching to handle variations in product names, and created a custom column to calculate new tariff prices based on existing unit prices and tariff information. The instructor announced that the next class would focus on data modeling after completing Power Query training.

Learn how to transform raw data into structured, analysis-ready datasets using practical Power Query techniques. Join Team Academy’s Power BI training to develop the skills needed to clean, combine, and prepare data for meaningful business analysis.

👉 Explore Team Academy’s Power BI training program and build your data transformation skills.