Machine Learning For Bi Part 3

Demystify Machine Learning and build foundational Data Science skills like regression & forecasting, 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
- Predict numerical outcomes using regression modeling and time-series forecasting techniques

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
Predict numerical outcomes using regression modeling and time-series forecasting techniques
Calculate diagnostic metrics like R-Squared
Mean Error
F-Significance and P-Values to diagnose model quality
Explore unique
hands-on case studies to see how regression analysis can be applied to real-world business intelligence use cases

* 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 3 of our Machine Learning for BI series (we recommend taking Parts 1 & 2 first)

Description

This course is PART 3 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 3 course, we’ll start by introducing core building blocks like linear relationships and least squared error, then show you how these concepts can be applied to univariate, multivariate, and non-linear regression models.

From there we'll review common diagnostic metrics like R-squared, mean error, F-significance, and P-Values, along with important concepts like homoscedasticity and multicollinearity.

Last but not least we’ll dive into time-series forecasting, and explore powerful techniques for identifying seasonality, predicting nonlinear trends, and measuring the impact of key business decisions using intervention analysis:


  • Section 1: Intro to Regression

    • Supervised Learning landscape

    • Regression vs. Classification

    • Feature engineering

    • Overfitting & Underfitting

    • Prediction vs. Root-Cause Analysis


  • Section 2: Regression Modeling 101

    • Linear Relationships

    • Least Squared Error (SSE)

    • Univariate Regression

    • Multivariate Regression

    • Nonlinear Transformation


  • Section 3: Model Diagnostics

    • R-Squared

    • Mean Error Metrics (MSE, MAE, MAPE)

    • Null Hypothesis

    • F-Significance

    • T-Values & P-Values

    • Homoskedasticity

    • Multicollinearity


  • Section 4: Time-Series Forecasting

    • Seasonality

    • Auto Correlation Function (ACF)

    • Linear Trending

    • Non-Linear Models (Gompertz)

    • Intervention Analysis


Throughout the course we’ll introduce hands-on case studies to solidify key concepts and tie them back to real world scenarios. You’ll see how regression analysis can be used to estimate property prices, forecast seasonal trends, predict sales for a new product launch, and even measure the business impact of a new website design.

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: Regression & Forecasting 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 forecasting & predictive analytics

Course content

6 sections • 51 lectures

Course Structure & Outline Preview 02:19

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

About This Series Preview 00:32

DOWNLOAD: Course Resources Preview 00:20

Setting Expectations Preview 02:52

Supervised vs. Unsupervised Learning Preview 02:20

RECAP: Key Concepts Preview 02:44

Regression 101 Preview 02:54

Regression Workflow Preview 01:19

Feature Engineering Preview 02:45

Splitting & Overfitting Preview 02:31

Prediction vs. Root-Cause Analysis Preview 01:22

QUIZ: Intro to Regression

Intro to Regression Modeling Preview 01:11

Linear Relationships Preview 03:59

Least Squared Error Preview 05:17

Univariate Linear Regression Preview 01:27

CASE STUDY: Univariate Linear Regression Preview 08:45

Multiple Linear Regression Preview 05:58

Non-Linear Regression Preview 03:42

CASE STUDY: Non-Linear Regression Preview 08:29

QUIZ: Regression Modeling

Intro to Model Diagnostics Preview 01:54

Sample Model Output Preview 00:50

R-Squared Preview 04:51

Mean Error Metrics (MSE, MAE, MAPE) Preview 05:59

Homoskedasticity Preview 02:12

Null Hypothesis Preview 01:17

F-Significance Preview 02:02

T-Values & P-Values Preview 03:27

Multicollinearity Preview 01:34

Variance Inflation Factor Preview 03:30

RECAP: Sample Model Output Preview 03:53

QUIZ: Model Diagnostics

Intro to Forecasting Preview 02:13

Seasonality Preview 01:48

Auto Correlation Function Preview 02:16

CASE STUDY: Seasonality with ACF Preview 04:03

One-Hot Encoding Preview 02:07

CASE STUDY: Seasonality with One-Hot Encoding Preview 07:33

Linear Trending Preview 02:30

CASE STUDY: Seasonality with Linear Trend Preview 08:28

Smoothing Preview 01:53

CASE STUDY: Smoothing Preview 05:15

Non-Linear Trends Preview 01:33

CASE STUDY: Non-Linear Trend Preview 05:47

Intervention Analysis Preview 03:01

CASE STUDY: Intervention Analysis Preview 07:59

QUIZ: Time-Series Forecasting

Looking Ahead to Part 4 Preview 00:53

BONUS LECTURE: More from Maven Preview 00:59