Business Analysis Foundations: Excel, Statistics, SQL, and Tableau (Single Course)
About Course
Welcome to the ultimate course on Business Analysis, designed to help you thrive in today’s data-driven business world. Whether you’re a student, professional, or entrepreneur, this course will equip you with the skills to make smarter, data-informed decisions.
Key points:
Excel & Google Sheets: Master the use of spreadsheets, including powerful functions and the Analysis ToolPak for advanced data analysis.
Statistics: Learn descriptive and inferential statistics to interpret data effectively and apply them to real-world business scenarios.
SQL: Discover how to manage databases and use SQL to extract and manipulate data efficiently.
Tableau: Gain experience with data visualization using Tableau, learning how to create impactful, visually engaging reports and dashboards.
Machine Learning & Data Pipelines: Explore AI-driven insights and build data pipelines to streamline analysis.
With over 30 practical examples, hands-on tutorials, and real-world case studies, this course is constantly updated with the latest industry trends. By the end, you’ll have a solid grasp of Business Analytics tools and techniques, empowering you to drive better business outcomes through data.
Let’s dive into Business Analytics and unlock new opportunities together!
What Will You Learn?
- Become proficient in Statistics, SQL, Tableau, and problem-solving. Enhance your resume with sought-after data skills. Gather, organize, analyze, and visualize data effectively. Use data insights to drive better business decisions. Present metrics, KPIs, reports, and dashboards clearly. Perform both quantitative and qualitative business analysis. Analyze trends, market conditions, and competitor positioning. Understand core concepts of database theory. Create, design, and manipulate databases using SQL. Write custom queries to extract data from databases. Build professional data visualizations in Tableau. Integrate SQL and Tableau to visualize data directly from the source. Tackle real-world business analysis tasks with SQL and Tableau.
Course Content
Introduction
content
Data Pipeline
content
-
What is big data?
-
What are data pipelines?
-
How is data collected?
-
What kinds of data are there?
-
How is data stored?
Spreadsheets & Descriptive Statistics
content
-
What are spreadsheets?
-
What are spreadsheet functions?
-
What are descriptive statiistics?
-
What is a normal distribution?
-
How do we filter and organize information?
-
How do we characterize data point relationships?
-
Exotic Excursions (Excel Intro)
-
Exotic Excursions Solution
-
Global Travellers (Graphing)
-
Global Travellers Solution
-
Histogram (Graphing)
-
Histogram Solution
-
Stationary Sales (Functions, Statistics)
-
Stationary Sales Solution
-
Company Roles (Pivot Table)
-
Company Roles Solution
-
Tutoring Company (Pivot Table)
-
Tutoring Company Solution
-
Customer Orders (Vlookup / IndexMatch)
-
Customer Orders Solution
Probability
content
-
What are random variables and probability distributions?
-
How are statistics calculated for random variables?
-
What are probability distributions?
-
How do we make decisions based on expected value?
-
Bachelor Degrees (Gaussian Distribution)
-
Bachelor Degrees Solution
-
Shop Visitors (Poisson Distribution)
-
Shop Visitors Solution
-
Grocery Defects (Hypergeometric Distribution)
-
Grocery Defects Solution
-
Car Dealership (Expected Value)
-
Car Dealership Solution
-
Grade Calculator (Weighted Average)
-
Grade Calculator Solution
Inferential Statistics
content
-
What are random variables and probability distributions?
-
How are statistics calculated for random variables?
-
What are probability distributions?
-
How do we make decisions based on expected value?
-
Bachelor Degrees (Gaussian Distribution)
-
Bachelor Degrees Solution
-
Shop Visitors (Poisson Distribution)
-
Shop Visitors Solution
-
Grocery Defects (Hypergeometric Distribution)
-
Grocery Defects Solution
-
Car Dealership (Expected Value)
-
Car Dealership Solution
-
Grade Calculator (Weighted Average)
-
Grade Calculator Solution
Machine Learning 1
content
-
What is machine learning and artificial intelligence?
-
Why do we need to clean our data?
-
What is linear regression?
-
What are multiple linear regressions?
-
How do we compare models?
-
What are non-linear regressions?
-
Linear Regression
-
Linear Regression Solution
-
Outlier Removal
-
Outlier Removal Solution
-
Baby Height (Linear Regression)
-
Baby Height Solution
-
Multiple Regression
-
Multiple Regression Solution
-
Admissions Rates (Multiple Regression)
-
Admission Rates Solution
Machine Learning 2
content
-
What is classification?
-
What is clustering?
-
How do we make clusters?
-
How do we optimize clusteriing?
-
What is reinforcement learning?
-
What is model fit?
Time Series
content
-
How do we predict with time series?
-
Weekly Grades (Moving Average)
-
Weekly Grades Solution
-
Quarterly Sales (Time Series Decomposition)
-
Quarterly Sales Solution
-
5-Year Plan (Time Series)
-
5 Year Plan Solution
-
E-Commerce Store (Time Series Modelling)
-
E-Commerce Store Solution
Structure Query Language (SQL)
content
-
How is data stored in databases?
-
How do we read from a table?
-
How do we change information in a table?
-
How do we work with multiple tables?
-
How do we work with other data structures?
-
Note Regarding MySQL installation
-
MySQL Installation (Mac)
-
MySQL Installation (Windows)
-
(Optional) Create SQL Table
-
Customer Order Query (no MySQL)
-
Customer Order Query (MySQL)
-
Joining Tables
-
Joining Tables (no MySQL)
-
Joining Tables (MySQL)
-
Challenge: Remaining Invoice Balances
-
Customer Order Query
Visualization & Presentation
content
-
What is business intelligence?
-
What is Tableau?
-
What types of information can be visualized?
-
Why are dashboards useful?
-
How do you present data?
-
Tableau Installation Instructions
-
Visualize Data in Tableau
-
Tableau Basics
-
Analyze Data in Tableau
-
Tableau Analytics
-
Tableau Case Study 1: Netflix Movies & Shows
-
Tableau Case Study 2: FIFA 2023 Players
Non-Technical Skills
content
-
How do I prioritize multiple projects?
-
What are KPIs within SaaS?
-
How do I work within a team?
-
Conclusion