Class Introduction
The session also included a demonstration of Power BI, where instructor Subanshi reviewed data transformation techniques such as grouping, appending, merging queries, and unpivoting. The training aims to equip participants with practical skills to implement AI solutions in their respective domains.
Power BI Data Transformation Training
The team reviewed basic data transformations in Power BI, focusing on how to clean and format data before loading it into the system. They practiced grouping data by resource names, total working hours, and number of repairs attended using the advanced grouping feature in Power BI. The instructor demonstrated how to use the Group By function and aggregation options to combine similar data entries and calculate totals.
Power BI Data Manipulation Techniques
Team Academy demonstrated how to round decimal values in Power BI by using the Transform tab's rounding option and explained the process of grouping data columns. They then introduced the concept of appending tables, showing how to load data from multiple Excel sheets and rename queries for better organization. The session concluded with an explanation of the difference between regular append queries and append queries as new, which creates a separate appended table without modifying the original data.
Related Offerings
Power BI Query Joins Tutorial
Team Academy explained how to append queries in Power BI, emphasizing the requirement for tables to have identical headings and structure when combining data from multiple tables. They discussed different types of SQL joins, focusing primarily on inner joins, left joins, and full joins, with left joins being the most commonly used in practice. The session concluded with instructions to perform hands-on exercises to better understand the different join types through practical application.
Power BI Database Joins Tutorial
Team Academy demonstrated how to perform different types of database joins in Power BI, specifically focusing on inner joins, left joins, and left anti-joins using Qatar Expo data from 2024 and 2025. The team learned to identify when to use each join type, with inner joins finding common records between tables and left joins showing all records from the first table with matching records from the second. Team Academy explained that left anti-joins are useful for finding records present in one table but not in another, and emphasized that left joins are the most commonly used join type in data modeling.
Power BI Dataset Merge Demonstration
Team Academy demonstrated how to merge datasets in Power BI, focusing on merging product and tariff information. They showed how to use the "Use First Row as Header" feature and explained the process of merging queries using a left outer join. The discussion included an explanation of fuzzy matching, which allows for more lenient product name matching when exact matches aren't possible.
Power BI Data Transformation Techniques
Team Academy demonstrated how to merge and transform data tables in Power BI, including expanding tables, replacing null values, and renaming columns. They explained the concepts of transposing and unpivoting tables, showing how to convert L-shaped data into a more optimized format for data modeling. The session concluded with a walkthrough of unpivoting specific columns to create separate employee columns, marking the completion of the Power Query module. The next module on data modeling will begin in the next class on Wednesday.
Ready to transform complex datasets into clean, structured data for powerful analysis?
👉 Explore our Power BI Data Analytics Training Program and master Power Query techniques such as grouping, appending, merging, joins, fuzzy matching, transposing, and unpivoting through practical, hands-on exercises.
