Machine Learning 1: Data Profiling

This course is PART 1 of a 4-PART SERIES designed to help you build a fundamental understanding of machine learning:

1. QA & Data Profiling
2. Classification
3. Regression & Forecasting
4. Unsupervised Learning

In this course we’ll introduce the machine learning landscape and workflow, and review critical QA tips for cleaning and preparing raw data for analysis, including variable types, empty values, range & count calculations, table structures, and more.

We’ll cover univariate analysis with frequency tables, histograms, kernel densities, and profiling metrics, then dive into multivariate profiling tools like heat maps, violin & box plots, scatter plots, and correlation.

Throughout the course we’ll introduce case studies to solidify key concepts and tie them back to real world scenarios. You’ll clean up product inventory data for a local grocery, explore Olympic athlete demographics, visualize traffic accident frequency in New York Ciy, and more.

NOTE: This is NOT a coding course, and doesn't cover programming languages like Python or R. Our goal is to use familiar tools like Excel to demystify complex topics and explain exactly how they work.

If you’re ready to build the foundation for a successful career in data science, this is the course for you.

COURSE CURRICULUM:

WHO SHOULD TAKE THIS COURSE?

• Data Analysts or BI experts looking to transition into a data science role or build a fundamental understanding of core ML topics

• R or Python users seeking a deeper understanding of the models and algorithms behind their code

• Anyone looking to learn the basics of machine learning through hands-on demos and intuitive, crystal clear explanations

WHAT ARE THE COURSE REQUIREMENTS?

• We'll use Microsoft Excel (Office 365 Pro Plus) for demos, but you are not required to follow along