Course Overview
Welcome to my Business Analytics/Intelligence course with over 30+ practical examples!
With the meteoric rise of AI-based technologies, the world of work is changing once again to demand data-driven decisions as industries scramble to become agile and augment with new technology. In this course, I will teach you ALL of the necessary skills using free tools such as Google Sheets (Excel, Analysis ToolPak), MySQL, and Tableau (trial)!
This is an introductory self-paced course with an MBA-level curriculum tailored to suit students from all backgrounds! Whether you're currently a student preparing for the job market, a seasoned professional looking to up-skill / pivot, or a business owner looking to accelerate your growth, you will finish this course with a fundamentally different understanding of how the world operates today.
Our course will consist of theoretical videos, hands-on tutorials where we work through short assignments together, and mock cases to dive into a wide range of topics, including data pipelines, intro/advanced spreadsheets functions + tools, descriptive/inferential statistics, machine learning, time series, SQL, visualization, and nontechnical skills.
I will be constantly updating this course with industry breakthroughs regularly, and adjusting materials based on student feedback to provide an optimized learning experience.
By the end of this course, you'll have a comprehensive understanding of Business Analytics and how to use various tools and techniques to analyze data and make informed business decisions.
So, what exactly will you be learning? Here's a brief breakdown of the course units:
Introduction: Welcome to the course where you'll learn about how agile and AI-powered workflows enable the modern agile business analyst.
Data Pipeline: You'll learn about big data and how data is collected, stored, and organized.
Spreadsheets & Descriptive Statistics: You'll explore spreadsheets and descriptive statistics, understanding normal distributions and relationships between data points.
Probability: You'll study random variables and probability distributions, calculating statistics and making decisions.
Inferential Statistics: You'll dive into inferential statistics, learning about hypothesis testing and decision making based on expected value.
Machine Learning 1: You'll be introduced to machine learning and artificial intelligence, including linear and non-linear regressions.
Time Series: You'll forecast with time series and predict future events.
Machine Learning 2: You'll learn about classification, clustering, and reinforcement learning.
SQL: You'll understand databases, reading, changing and working with multiple tables.
Visualization & Presentation: You'll study business intelligence, creating visualizations (Tableau) and presenting data effectively.
Non-Technical Skills: You'll evaluate businesses and work within teams, prioritizing projects and understanding KPIs.
Conclusion: Quick wrap up of everything that you have learned
Are you ready to dive into the world of Business Analytics? Let's get started!
Shoutout to Mike Yang for dev reviews
FAQ
FAQ area empty
Course curriculum
Chương 1 Introduction 7 bài · 39 phút
- What will we learn? Học thử 6:13
- What do BAs do? Học thử 5:59
- What is agile software development? Học thử 8:14
- What are the different types of analytics? Học thử 8:46
- What is the role of AI in modern workflows? Học thử 1:56
-
Why do we use living documents and mobile apps? 4:11
- What are no-code/low-code softwares? Học thử 3:44
Chương 2 Data Pipeline 5 bài · 27 phút
-
What is big data? 5:41
-
What are data pipelines? 3:23
- How is data collected? Học thử 5:00
-
What kinds of data are there? 10:02
-
How is data stored? 3:18
Chương 3 Spreadsheets & Descriptive Statistics 20 bài · 4 giờ 2 phút
-
What are spreadsheets? 7:26
-
What are spreadsheet functions? 5:54
-
What are descriptive statiistics? 11:40
-
What is a normal distribution? 9:31
-
How do we filter and organize information? 5:46
-
How do we characterize data point relationships? 5:37
-
Exotic Excursions (Excel Intro)
-
Exotic Excursions Solution 34:41
-
Global Travellers (Graphing)
-
Global Travellers Solution 10:33
-
Histogram (Graphing)
-
Histogram Solution 8:43
-
Stationary Sales (Functions, Statistics)
-
Stationary Sales Solution 50:04
-
Company Roles (Pivot Table)
-
Company Roles Solution 24:50
-
Tutoring Company (Pivot Table)
-
Tutoring Company Solution 37:22
-
Customer Orders (Vlookup / IndexMatch)
-
Customer Orders Solution 30:02
Chương 4 Probability 14 bài · 1 giờ 29 phút
-
What are random variables and probability distributions? 11:09
-
How are statistics calculated for random variables? 6:05
-
What are probability distributions? 18:42
-
How do we make decisions based on expected value? 6:54
-
Bachelor Degrees (Gaussian Distribution)
-
Bachelor Degrees Solution 11:04
-
Shop Visitors (Poisson Distribution)
-
Shop Visitors Solution 7:29
-
Grocery Defects (Hypergeometric Distribution)
-
Grocery Defects Solution 9:06
-
Car Dealership (Expected Value)
-
Car Dealership Solution 13:01
-
Grade Calculator (Weighted Average)
-
Grade Calculator Solution 5:05
Chương 5 Inferential Statistics 15 bài · 2 giờ 38 phút
-
What are inferential statistics? 9:03
-
What are hypotheses? 11:10
-
What are error types? 5:02
-
How do we know if our hypothesis is true (pt 1)? 13:55
-
How do we know if our hypothesis is true (pt 2)? 3:08
-
What types of hypothesis tests exist? 10:48
-
What is A/B testing? 6:24
-
Coffee Store (Z Test, 1 tailed)
-
Coffee Store Solution 33:59
-
Travel Consultant (T Test, 1 tailed)
-
Travel Consultant Solution 22:32
-
Marketing Page (A/B Test)
-
Marketing Page Solution 23:03
-
Golf Manufacturer (Z Test, 2 tailed)
-
Golf Manufacturer Solution 18:31
Chương 6 Machine Learning 1 16 bài · 3 giờ 27 phút
-
What is machine learning and artificial intelligence? 7:26
-
Why do we need to clean our data? 3:07
-
What is linear regression? 9:56
-
What are multiple linear regressions? 5:09
-
How do we compare models? 7:32
-
What are non-linear regressions? 1:53
-
Linear Regression
-
Linear Regression Solution 45:06
-
Outlier Removal
-
Outlier Removal Solution 20:05
-
Baby Height (Linear Regression)
-
Baby Height Solution 16:07
-
Multiple Regression
-
Multiple Regression Solution 32:04
-
Admissions Rates (Multiple Regression)
-
Admission Rates Solution 58:08
Chương 7 Machine Learning 2 6 bài · 32 phút
-
What is classification? 6:13
-
What is clustering? 8:28
-
How do we make clusters? 7:09
-
How do we optimize clusteriing? 3:29
-
What is reinforcement learning? 2:32
-
What is model fit? 4:05
Chương 8 Time Series 10 bài · 2 giờ 56 phút
-
What is forecasting with time series? 8:24
-
How do we predict with time series? 6:02
-
Weekly Grades (Moving Average)
-
Weekly Grades Solution 18:49
-
Quarterly Sales (Time Series Decomposition)
-
Quarterly Sales Solution 55:00
-
5-Year Plan (Time Series)
-
5 Year Plan Solution 20:20
-
E-Commerce Store (Time Series Modelling)
-
E-Commerce Store Solution 1:07:08
Chương 9 Structure Query Language (SQL) 16 bài · 2 giờ 59 phút
-
How is data stored in databases? 5:55
-
How do we read from a table? 6:31
-
How do we change information in a table? 2:57
-
How do we work with multiple tables? 6:03
-
How do we work with other data structures? 4:26
-
Note Regarding MySQL installation
-
MySQL Installation (Mac) 5:55
-
MySQL Installation (Windows) 4:31
-
(Optional) Create SQL Table
-
Customer Order Query (no MySQL) 36:06
-
Customer Order Query (MySQL) 41:51
-
Joining Tables
-
Joining Tables (no MySQL) 29:23
-
Joining Tables (MySQL) 35:13
-
Challenge: Remaining Invoice Balances
-
Customer Order Query
Chương 10 Visualization & Presentation 12 bài · 3 giờ 28 phút
-
What is business intelligence? 2:09
-
What is Tableau? 5:26
-
What types of information can be visualized? 17:56
-
Why are dashboards useful? 2:59
-
How do you present data? 14:37
-
Tableau Installation Instructions 3:34
-
Visualize Data in Tableau
-
Tableau Basics 1:04:10
-
Analyze Data in Tableau
-
Tableau Analytics 42:07
-
Tableau Case Study 1: Netflix Movies & Shows 33:08
-
Tableau Case Study 2: FIFA 2023 Players 21:45
Chương 11 Non-Technical Skills 4 bài · 20 phút
-
What frameworks are used to evaluate businesses? 7:09
-
How do I prioritize multiple projects? 1:20
-
What are KPIs within SaaS? 5:14
-
How do I work within a team? 5:58
Chương 12 Conclusion 1 bài · 1 phút
-
Course Conclusion 1:15
Requirment
-
No prior experience required, everything is taught from the basics
-
All software will be FREE to use
-
Classroom theory will be applied in guided worksheets and practical case studies
-
Contact me if you have financial difficulties - education is a right, not a priviledge
Outcomes
-
Excel: Mine data and generate actionable insights with Pivot Tables, Lookup Functions, Index/Match, and Graphs
-
Excel: Create machine learning model and make predictions with Analysis Toolpak
-
SQL: Understanding the data life cycle and how data moves from a pipeline into a data warehouse/lake
-
SQL: Query, clean, and prepare data for analysis and real-time reporting
-
Tableau: Create visualizations and dashboards to communicate data insights
-
Tableau: Storytelling technical information to executives and business stakeholders
0 Student
1 Course
0 review