Top-rated Data Science tutor in Canada

The tutor and student reviewed data analysis fundamentals using Power BI, including data import and establishing table relationships for data modeling. They practiced these concepts through hands-on exercises and discussed potential career transition support services. The next session will focus on building a Power BI dashboard.

The student and tutor worked on Excel, specifically focusing on the SUMIFS function for data analysis. The student successfully calculated total revenue per brand using SUMIFS and correctly implemented absolute referencing. They discussed future steps, including adding more criteria to the SUMIFS function and developing new analytical questions for the dataset.

The Tutor and Student worked on advanced Excel formatting, focusing on the "Format as Table" feature. They practiced converting ranges to tables, managing cell formatting, and applying consistent styles and data types across different data sets. The next session will involve adding columns to remaining tables and further refining their structure.

The student and tutor worked extensively on advanced Excel functionalities, focusing on data manipulation within tables. They practiced using "Format as Table" to improve data management, inserting columns, and controlling formula auto-fill behavior. The session also involved troubleshooting specific calculations for agent and company totals, and manually entering goal-related commission figures.

The Student and Tutor reviewed advanced Excel functions including XLOOKUP, SUMIF, COUNTIFS, and MAX for data consolidation and dashboard creation. They practiced creating dynamic KPIs, calculating spend by status and department, and generating various chart types for data visualization. The Tutor encouraged the Student to practice creating a month-wise revenue report and explore the MIN function.

The Tutor provided an introductory lesson on basic Microsoft Excel functions and formatting. The Student practiced entering data, applying basic formulas, and learned about named ranges, cell formatting, and the `Merge & Center` function. Future sessions will delve into more advanced functions.