Top-rated Data Science tutor in Canada

Steven tutored Felix on Excel, focusing on cleaning and formatting a dirty data set. Felix practiced using functions like TRIM and SUBSTITUTE to standardize headers and remove inconsistencies. Steven assigned Felix the task of formatting the data to match a clean example for the next session, reinforcing the concepts learned.

Steven taught Felix how to clean and format data in Excel, focusing on consistent formatting, removing unwanted characters and spaces using functions like TRIM and SUBSTITUTE, and using "Paste Special" for efficient data manipulation. They addressed issues like leading/trailing spaces and inconsistent formatting. Felix was assigned to continue practicing formatting, and they scheduled a follow-up session for Wednesday to address any remaining issues.

Lata Kaushik assisted Gina (cardboard fish) with an Excel assignment, explaining formulas such as LEFT, RIGHT, PROPER, IF, ISBLANK, XLOOKUP, and VLOOKUP for text manipulation and conditional calculations. They addressed handling missing data, ensuring exact matches in lookups, and using error handling. Lata will send a request to transfer one of the booked lessons to an assignment.

Deirdre and Coleman had a Wiingy session focused on Excel spreadsheets. Deirdre struggled with concepts like absolute values, pivot tables, and XLOOKUP. They spent time troubleshooting screen sharing and formula errors, particularly with XLOOKUP, focusing on correct cell references (relative vs. absolute) and data types. They also touched on data cleanup, including removing unwanted characters and addressing capitalization issues. They reviewed a sample actor data template and scheduled their next session, planning to cover flash fill, absolute references, and data cleanup tools further.

Asif guided Aisha through building a marketing data dashboard in Power BI, focusing on data cleaning, transformation, and relationship management. Aisha practiced unpivoting data, creating table relationships, and building initial visualizations to analyze campaign and product performance. They will continue building the dashboard and exploring more advanced visuals in the next session.

Anshuman assisted Tommy in preparing for an Excel test by reviewing financial functions such as PV, FV, PMT, and IRR. Tommy then practiced using Excel's Goal Seeker to solve financial problems and learned to troubleshoot errors, utilizing ChatGPT for practice workbooks.