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
Steven taught 4 days ago
The Student and Tutor reviewed the XLOOKUP function, including optional parameters, nested lookups, and order of operations in complex formulas. They also discussed absolute vs. relative cell references, data cleaning with 'Text to Columns', and strategies for reconciliation in Excel, including potential pitfalls and the use of the COUNTIF function. The Student received intermediate and advanced XLOOKUP practice files and plans to gain hands-on experience with reconciliation data at their new job to inform future lessons.
XLOOKUP Function Fundamentals
Nested XLOOKUPs for Multi-Step Retrieval
Excel's Order of Operations
Absolute and Relative Cell References
Data Cleaning: Text to Columns
Reconciliation Strategies & Avoiding False Positives
Introduction to Excel Automation & VBA
Nikita taught 22 days ago
The Student and Tutor worked on refining an Excel workbook designed for tracking real estate commissions. They focused on updating and verifying commission data, refreshing pivot tables and charts to reflect the changes, and adjusting page breaks to optimize the print layout. The next session will involve integrating new commission data once it becomes available.
Excel Data Entry & Formula Management
Dynamic Data Visualization: Refreshing Pivot Tables and Charts
Optimizing Print Layouts with Page Breaks
Data Verification & Reconciliation with External Sources
Nikita taught 24 days ago
The student and tutor worked on automating Excel formulas for commission tracking. They focused on updating `SUMIF` functions and cell ranges within Excel tables to ensure dynamic calculations for agent commissions and total payouts, with plans to verify accuracy once brokerage data is received.
Formula Automation in Spreadsheets
Data Validation and Accuracy Checks
Understanding Collapsed Deals in Sales Tracking
Spreadsheet Table Designations and Row Numbering
Nikita taught about 1 month ago
The student and tutor focused on implementing and troubleshooting Excel formulas to automate deal counts and total commission calculations across multiple tables. They practiced applying dynamic formulas, correcting syntax errors, and understanding the difference between automated and manual data entry for financial reporting.
Automating Table Calculations
Dynamic Formula Referencing
Handling Column Name Inconsistencies in Formulas
Manual vs. Automated Data Entry
Nikita taught about 1 month ago
The student and tutor worked through issues with Excel spreadsheet automation related to commission tracking. They identified and discussed solutions for manual data entry and formula range adjustments to ensure accurate, automated updates for commission figures and associated charts. The next session was scheduled for the following evening.
Formula Automation and Range Expansion
Manual Data Entry vs. Automated Updates
Data Visualization Accuracy and Source Data
Handling Non-Standard Deals in Calculations
vasundhra taught about 1 month ago
The Student and Tutor focused on learning SQL database table creation, including defining columns, data types (INT, VARCHAR), primary keys, and NOT NULL constraints. They practiced creating a new table and later discussed and implemented foreign keys to establish relationships between tables. The session concluded with an introduction to ER diagrams and a plan for the Student to work on a new project based on an ER diagram.
Database Schema vs. Table
Creating Tables in SQL
Primary Keys and Data Integrity
SQL Data Types: INT vs. VARCHAR
Foreign Keys for Table Relationships
