Top-rated Data Science tutor in Canada
Data science turns raw numbers into real insight, and an online data science tutor shows you how. Lessons cover Python, pandas, statistics, and the basics of machine learning, using real datasets and building on school stats like Ontario's MDM4U. It is one of Canada's most in-demand skills, useful for students, analysts, and career changers. You learn hands-on over video, building projects you can add to a portfolio.
Free Trial
15-days refund
Free tutor swap
No cancel fee
Summary
Podcast
Data science taught through tutor-led classes
Learners attend in Toronto, Edmonton, Calgary
Nikita taught 2 days ago
Student and Tutor addressed a data discrepancy in 2023 commission totals in Excel by correcting a missing date for a negative value. They then prepared multi-year commission data by structuring it with "Year" columns and consolidating it, culminating in the creation of a Pivot Table and a clustered column chart for annual comparison. They planned to continue with more past years and explore printing options for charts.
Resolving Data Discrepancy in Commission Totals
Standardizing Data with a 'Year' Column
Consolidating Multi-Year Data for Analysis
Dynamic Monthly Total Calculation with SUMIF Refinement
Analyzing Trends with Pivot Tables and Clustered Column Charts
Troubleshooting Temporary Excel Display Issues
Darshankumar taught 28 days ago
The class focused on advanced Excel functions for data manipulation and financial calculations. The student practiced using text joining functions such as CONCAT, CONCATENATE, and TEXTJOIN, and learned about financial functions like PMT, IPMT, and PPMT to calculate loan payments and amortization schedules. The session concluded with a practical exercise to build a loan amortization table.
Text Concatenation Functions
IF Function with Textjoin
MID Function for Text Extraction
PMT
IPMT
and PPMT Functions for Loan Calculations
Darshankumar taught about 1 month ago
The Student and Tutor reviewed various Excel statistical and lookup functions, including `MODE`, `INDEX`, `MATCH`, `MEDIAN`, `AVERAGE`, `STDEV`, `MIN`, `MAX`, `LARGE`, `SMALL`, `SUM`, `COUNT`, and `AVERAGEA`. The Student practiced applying these formulas to different datasets. The next session is planned to cover `VLOOKUP` and `XLOOKUP` functions.
Excel Mode Functions: MODE
MODE.SNGL
MODE.MULT
Excel MATCH & INDEX Functions for Advanced Lookups
Excel MEDIAN Function: Locating the Middle Value
Excel Standard Deviation: STDEV.S (Data Dispersion)
Excel LARGE & SMALL Functions (Finding K-th Values)
Excel AVERAGE vs. AVERAGEA Functions (Handling Data Types)
Nikita taught about 1 month ago
The Tutor and Student worked on advanced Excel data analysis and visualization. They focused on filtering data, formatting dates, creating and customizing pie charts to show commission proportions, and refining the overall presentation of tables and charts. Future sessions will involve creating yearly comparative graphs if historical data is provided.
Data Formatting and Customization
Data Filtering and Analysis
Spreadsheet Formulas for Calculation
Data Visualization: Creating Charts
Table Formatting and Layout
Sonali taught about 1 month ago
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.
Data Modeling in Power BI
Importing Data into Power BI
Power BI Views: Navigating Your Data
Data Cleaning and Preparation
Steven taught about 1 month ago
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.
SUMIFS Function
Absolute Referencing ($)
SUM vs. SUMIF vs. SUMIFS
Data Analysis & Question Generation
