Machine Learning for BI, PART 1: Data Profiling & QA
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
- Prepare raw data for analysis using QA tools like variable types, range calculations & table structures
- Analyze datasets using common univariate & multivariate profiling metrics
- Describe & visualize distributions with histograms, kernel densities, heat maps and violin plots
- Explore multivariate relationships with scatterplots and correlation
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
Description
This course is PART 1 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 1 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:
Section 1: Machine Learning Intro & Landscape
Machine learning process, definition, and landscape
Section 2: Preliminary Data QA
Variable types, empty values, range & count calculations, left/right censoring, etc.
Section 3: Univariate Profiling
Histograms, frequency tables, mean, median, mode, variance, skewness, etc.
Section 4: Multivariate Profiling
Violin & box plots, kernel densities, heat maps, correlation, etc.
Throughout the course we’ll introduce real-world scenarios designed to help solidify key concepts and tie them back to actual business intelligence case studies. You’ll use profiling metrics to clean up product inventory data for a local grocery, explore Olympic athlete demographics with histograms and kernel densities, visualize traffic accident frequency with heat maps, 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: Data Profiling 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
Course content
- Preview02:08
- 02:13READ ME: Important Notes for New Students
- Preview02:06
- 00:20DOWNLOAD: Course Resources
- 02:39Setting Expectations
Instructors
![Maven Analytics](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.6 Instructor Rating
- 196,692 Reviews
- 579,615 Students
- 25 Courses
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience.
Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.
- 4.5 Instructor Rating
- 1,160 Reviews
- 3,777 Students
- 3 Courses
Josh has 10+ Years of applying machine learning and data science to challenging business problems like marketing mix and pricing optimization, forecasting, clustering, natural language processing, and predictive modeling. He is passionate about breaking down seemingly complex machine learning topics and explaining them in business context. He believes that diving into machine learning should be accessible to everyone.