Class Introduction
This was the first class of a Power BI training program where the instructor introduced fundamental concepts and lab exercises to students. The instructor explained key Power BI concepts including metadata, append queries, combine queries, group by operations, and refresh functionality, using practical examples with Excel workbooks and folder connections. Students practiced loading data from Excel sheets, transforming data using Power Query, and performing operations like combining multiple data sources and applying filters. The instructor emphasized the importance of learning at a foundational level and applying concepts practically rather than just watching demonstrations. Students were advised to practice the learned techniques and come prepared with questions about their own practical datasets in future classes.
Schedule Changes and New Team Member
The team discussed scheduling adjustments, with Balajee agreeing to attend classes on Monday and Wednesday instead of Sunday and Tuesday, and mentioning potential availability on Friday and Saturday. They welcomed Rommel, who joined from Saudi Arabia and works as a sales coordinator in supply chain, explaining he wants to learn Power BI to help with monitoring stocks and sales data. The conversation ended with a question about whether Rommel had attended previous demonstration classes, which remained unanswered.
Power BI Training Planning Meeting
The team discussed scheduling Power BI training classes for Sunday and Tuesday, with Rommel and Balaji confirming their availability. The trainer emphasized starting with fundamental concepts as if everyone was new to Power BI, regardless of their experience level. They verified that both participants had Power BI version September 2026 installed and discussed optimal setup recommendations, including using two screens for better learning. The discussion included a practical example about pond digging to illustrate the importance of getting things right the first time in both farming and Power BI implementation.
Farm Pond Placement and Data Integration
The team discussed the optimal placement of farm ponds based on elevation zones, with different participants advocating for high, mid, or low zones depending on irrigation needs. Balajee and Rommel shared their preferences for pond construction, highlighting the importance of considering water drainage and storage capabilities in different zones. The discussion then transitioned to comparing data integration approaches for Power BI, where participants debated between extracting data to Excel for processing before visualization versus direct connection to ERP/CRM systems. Balajee expressed a preference for the Excel approach, citing advantages of having more control over data transformation, while acknowledging benefits of both methods.
Excel Data Combination Techniques
The team discussed challenges with connecting Power BI directly to ERP or CRM systems due to IT restrictions, with Rommel explaining his need to combine data from three different applications into Excel files. The instructor announced that today's class would focus on learning how to efficiently work with Excel sheets to address these data combination challenges, rather than using manual copy-paste methods. The session began with instructions for students to download datasets from a specific URL, though the transcript ended before completing these instructions.
Related Offerings
Memory Retention and Learning Strategies
Rommel discussed the importance of limiting information intake to improve memory retention, stating that an intelligent mind can only remember five important things per day. He emphasized the significance of active learning through practice, recording, and application to achieve better retention. Rommel also stressed the importance of problem-solving skills and avoiding laziness in IT training, and instructed the team to download the Power BI dataset from the SharePoint website for lab materials.
Dataset Download Technical Support Meeting
The team discussed downloading a dataset from Team Academy, with Balajee experiencing technical difficulties accessing the link. Team provided step-by-step guidance on using an incognito browser and correctly typing the URL, and helped Balajee extract the Power BI dataset from the downloaded files. The session took a brief break at 7:55 PM local time, with plans to continue at 8:00 PM, noting that six out of forty classes had been completed.
Power BI Excel Data Loading
The team conducted a Power BI training session focused on loading data from Excel sheets and understanding the difference between working with tables versus sheets. The instructor demonstrated how to properly select tables rather than entire sheets to avoid unnecessary headers and footers, explaining that Power BI can load data from tables, sheets, or entire workbooks. During the session, Rommel experienced download issues with the dataset while Balajee encountered system differences, though both were able to follow along with the Power Query interface and transformation process.
Power Query Data Best Practices
The team discussed best practices for working with data in Power Query, emphasizing the importance of loading clean data as tables rather than sheets. They demonstrated how to view and analyze column statistics, including minimum, maximum, average, and standard deviation values. The discussion also introduced the concept of metadata as "data about data" and explained standard deviation as a measure of data deviation from the average.
Math and Power BI Training
The team discussed basic mathematical concepts including integration and differentiation, using examples like how white light disperses into colors and vice versa to explain these concepts. They then moved on to Power BI training, covering how to import data from Excel workbooks using Power Query, with specific instructions on renaming sheets to make data more business-friendly rather than using default "Sheet1" names. The discussion concluded with an introduction to appending queries in Power Query, explaining how to combine multiple data sources into a single report.
Power BI Data Combination Training
The team provided training on Power BI Power Query operations, focusing on combining data tables. They explained how to append queries as new and the difference between appending new queries versus inserting data into existing master tables. The discussion included a practical example of combining sales data from multiple years (2022 and 2023) into a single table, with instructions on how to handle future data by inserting new years into the existing master table rather than creating separate combined tables. The session also introduced a scenario about managing multiple team member timesheets in OneDrive, explaining the concept of loading data from a folder source rather than individual files to efficiently handle growing datasets.
Power Query Training Session
The team conducted a Power Query training session focusing on data transformation techniques. They covered four main concepts: metadata, append queries, combine queries, and group by operations, with the instructor demonstrating how to use these features to work with Excel sheets in a folder structure. The session included a practical exercise where participants learned to navigate folders, set up Power Query transformations, and use the refresh function to update data automatically. The instructor announced that the next class would be held on Tuesday, combining both Sunday-Tuesday and Monday-Wednesday groups into a single cohort, with participants gaining access to recorded video lectures and a learning management system.
Ready to turn multiple Excel files into reliable, refreshable Power BI reports?
