Machine Learning For Bi Part 2

Demystify Machine Learning and build foundational Data Science skills for classification & prediction, without any code!

Last updated 2022-01-10 | 4.8

- Build foundational machine learning & data science skills
- without writing complex code
- Use intuitive
- user-friendly tools like Microsoft Excel to introduce & demystify machine learning tools & techniques
- Enrich datasets by using feature engineering techniques like one-hot encoding
- scaling
- and discretization

What you'll learn

Build foundational machine learning & data science skills
without writing complex code
Use intuitive
user-friendly tools like Microsoft Excel to introduce & demystify machine learning tools & techniques
Enrich datasets by using feature engineering techniques like one-hot encoding
scaling
and discretization
Predict categorical outcomes using classification models like K-nearest neighbors
naïve bayes
decision trees
and more
Apply techniques for selecting & tuning classification models to optimize performance
reduce bias
and minimize drift
Calculate metrics like accuracy
precision and recall to measure model performance

* Requirements

* This is a beginner-friendly course (no prior knowledge or math/stats background required)
* We'll use Microsoft Excel (Office 365) for some course demos
* but participation is optional
* This is PART 2 of our Machine Learning for BI series (we recommend taking PART 1: Data Profiling & QA first)

Description

If you're excited to explore Data Science & Machine Learning but anxious about learning complex programming languages or intimidated by terms like "naive bayes", "logistic regression", "KNN" and "decision trees", you're in the right place.

This course is PART 2 of a 4-PART SERIES designed to help you build a strong, foundational understanding of Machine Learning:

  • PART 1: QA & Data Profiling

  • PART 2: Classification

  • PART 3: Regression & Forecasting

  • PART 4: Unsupervised Learning (Coming Soon!)

This course makes data science approachable to everyday people, and is designed to demystify powerful Machine Learning tools & techniques without trying to teach you a coding language at the same time.

Instead, we'll use familiar, user-friendly tools like Microsoft Excel to break down complex topics and help you understand exactly HOW and WHY machine learning works before you dive into programming languages like Python or R. Unlike most Data Science and Machine Learning courses, you won't write a SINGLE LINE of code.


COURSE OUTLINE:

In this Part 2 course, we’ll introduce the supervised learning landscape, review the classification workflow, and address key topics like dependent vs. independent variables, feature engineering, data splitting and overfitting.

From there we'll review common classification models including K-Nearest Neighbors (KNN), Naïve Bayes, Decision Trees, Random Forests, Logistic Regression and Sentiment Analysis, and share tips for model scoring, selection, and optimization.


  • Section 1: Intro to Classification

    • Supervised Learning landscape

    • Classification workflow

    • Feature engineering

    • Data splitting

    • Overfitting & Underfitting


  • Section 2: Classification Models

    • K-Nearest Neighbors

    • Naïve Bayes

    • Decision Trees

    • Random Forests

    • Logistic Regression

    • Sentiment Analysis


  • Section 3: Model Selection & Tuning

    • Hyperparameter tuning

    • Imbalanced classes

    • Confusion matrices

    • Accuracy, Precision & recall

    • Model selection & drift


Throughout the course we’ll introduce case studies to solidify key concepts and tie them back to real world scenarios. You’ll help build a recommendation engine for Spotify, analyze customer purchase behavior for a retail shop, predict subscriptions for a travel company, extract sentiment from customer reviews, and much more.

If you’re ready to build the foundation for a successful career in Data Science, this is the course for you!


__________

Join today and get immediate, lifetime access to the following:

  • High-quality, on-demand video

  • Machine Learning: Classification ebook

  • Downloadable Excel project file

  • Expert Q&A forum

  • 30-day money-back guarantee


Happy learning!

-Josh M. (Lead Machine Learning Instructor, Maven Analytics)


__________

Looking for our full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!


See why our courses are among the TOP-RATED on Udemy:


"Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen!" Russ C.


"This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier!" Tatsiana M.


"Maven Analytics should become the new standard for all courses taught on Udemy!" Jonah M.

Who this course is for:

  • Anyone looking to learn the basics of machine learning through real-world demos and intuitive, crystal clear explanations
  • Data Analysts or BI experts looking to transition into data science or build a fundamental understanding of machine learning
  • R or Python users seeking a deeper understanding of the models and algorithms behind their code
  • Excel users who want to learn powerful tools for predictive analytics

Course content

5 sections • 52 lectures

Course Structure & Outline Preview 02:15

READ ME: Important Notes for New Students Preview 02:13

About this Series Preview 02:12

DOWNLOAD: Course Resources Preview 00:20

Setting Expectations Preview 03:01

Supervised vs. Unsupervised Learning Preview 01:54

Classification vs. Regression Preview 02:05

RECAP: Key Concepts Preview 03:28

Classification 101 Preview 03:55

Classification Workflow Preview 03:01

Feature Engineering Preview 03:40

Data Splitting Preview 01:41

Overfitting Preview 03:39

Intro to Classification

Common Classification Models Preview 01:15

Intro to K-Nearest Neighbors (KNN) Preview 01:06

KNN Examples Preview 04:02

CASE STUDY: KNN Preview 09:26

Intro to Naïve Bayes Preview 01:38

Naïve Bayes | Frequency Tables Preview 02:04

Naïve Bayes | Conditional Probability Preview 05:03

CASE STUDY: Naïve Bayes Preview 07:29

Intro to Decision Trees Preview 01:52

Decision Trees | Entropy 101 Preview 02:43

Entropy & Information Gain Preview 04:38

Decision Tree Examples Preview 04:56

Random Forests Preview 01:17

CASE STUDY: Decision Trees Preview 07:46

Intro to Logistic Regression Preview 02:05

Logistic Regression Example Preview 02:45

False Positives vs. False Negatives Preview 03:02

Logistic Regression Equation Preview 02:00

The Likelihood Function Preview 04:27

Multivariate Logistic Regression Preview 02:47

CASE STUDY: Logistic Regression Preview 07:52

Intro to Sentiment Analysis Preview 02:09

Cleaning Text Data Preview 01:51

"Bag of Words" Analysis Preview 04:11

CASE STUDY: Sentiment Analysis Preview 06:06

Classification Models

Intro to Selection & Tuning Preview 00:57

Hyperparameters Preview 03:00

Imbalanced Classes Preview 03:24

Confusion Matrix Preview 02:18

Accuracy, Precision & Recall Preview 02:46

Multi-class Confusion Matrix Preview 02:27

Multi-class Scoring Preview 04:41

Model Selection Preview 01:50

Model Drift Preview 01:09

Model Selection & Tuning

Looking Ahead to Part 3 Preview 00:34

BONUS LECTURE: More from Maven Preview 00:59