Skip to content
UdemyData AnalysisPaid courseAll LevelsCertificate

Business Analyst Bootcamp: Excel, Stats, SQL, Tableau (Udemy.com)

30+ Data Analysis, Business Intelligence, and Decision Making Exercises for Agile Business Analytics

Created by: Leo Zhu

Last updated July 2024

icon
What you will learn

  • 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

How it compares

Against the other 371 rated Udemy courses in Data Analysis on CourseDuck:

  • Rating4.5 out of 5higher than 49% of them
  • Reviews848#153 of 372 by number of reviews
  • Length23.5 hourslonger than 94% of them
  • Last updatedJuly 2024earlier than 64% of them

icon
Course Description

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:


  1. Introduction: Welcome to the course where you'll learn about how agile and AI-powered workflows enable the modern agile business analyst.

  2. Data Pipeline: You'll learn about big data and how data is collected, stored, and organized.

  3. Spreadsheets & Descriptive Statistics: You'll explore spreadsheets and descriptive statistics, understanding normal distributions and relationships between data points.

  4. Probability: You'll study random variables and probability distributions, calculating statistics and making decisions.

  5. Inferential Statistics: You'll dive into inferential statistics, learning about hypothesis testing and decision making based on expected value.

  6. Machine Learning 1: You'll be introduced to machine learning and artificial intelligence, including linear and non-linear regressions.

  7. Time Series: You'll forecast with time series and predict future events.

  8. Machine Learning 2: You'll learn about classification, clustering, and reinforcement learning.

  9. SQL: You'll understand databases, reading, changing and working with multiple tables.

  10. Visualization & Presentation: You'll study business intelligence, creating visualizations (Tableau) and presenting data effectively.

  11. Non-Technical Skills: You'll evaluate businesses and work within teams, prioritizing projects and understanding KPIs.

  12. 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

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Leo Zhu

Leo Zhu graduated from the University of Toronto with a master’s in Chemical Engineering, focused on using big data to build pharmaceutical models.

Leo has four years of experience mentoring pre-medical school students on the Medical College Admissions Test and continuously improving associated education technology products. Leo is a product manager at an e-commerce optimization company, and consults on optimizing SaaS/no-code integrations to improve startup operational efficiency at Zhu Consulting.

In his teaching, Leo focuses on peer-to-peer learning by fostering a supportive atmosphere to facilitate open-ended case studies as well as creating assignments to push his students’ business sense and decision making.

icon
More Data Analysis courses

Free

$79.99

$12.99

$74.99

$69.99

Free

icon
Reviews

4.5

848 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Abhishek Pagade on 7/20/2025

should have a proper project which include all the skills like Excel , SQL and tableau which will gives us an real life example how business Analyst woks . Still a pretty good course and get so many things to learn .

By Sukumar Jena on 5/8/2025

The information provided was wholesome, and many used cases are covered, theories well explained.. I wish the sessions videos could have been shortened to cut the time, however if we have enough time to go over do not hurt, because who knows those questions could be our questions. Overall, I am taking few important learnings. There are assignments which needed Excel to complete, and if we do not complete, the progress wont complete. Also the assignments are kept before the topic is covered, making a challenge to complete. and when you skip them, you cannot take it later resulting in incomplete course, therefore I am removing 1 star for that.

By Marianne van Genugten on 1/13/2025

Leo is a very good teacher. He is nice to listen to: he has a good volume, articulation and pace. This course has a good build-up and in his tutorials are very helpful with a pace that is also suitable for newbies.

By Arpit Singh on 8/19/2024

This course is an excellent starting point for anyone looking to build a career in business analytics. The content is well-structured, providing a solid foundation in the key concepts and tools needed in the field. What I particularly appreciated was the practical approach, with hands-on assignments in each section that allowed me to apply what I learned immediately. This made the learning experience both engaging and impactful.

By Shreyas Ashok Panchal on 5/25/2024

Couldn't be expecting more!! I was not confident before starting with the course but now as i write the review after completion of course in 14 days, I feel pretty confident with all the skills regarding excel, stats, sql and tableau. Thanks Leo, you are so co-operative with all the students, and yes see the last linkedin message. I am waiting for sql file fr as I couldn't find it over udemy .

By Atcharee Nimmansethakul on 3/26/2024

This course is efficient for new users who want to learn content related to business analysis. Furthermore, this course provides an example for learners to understand better. Learners will know a wide area of business analysis and what it can do in the real business world.

By Ulumbi Dyamo on 9/26/2023

I gained an improved understanding of various data analysis techniques.I think this course has persuaded me to explore a bit more on analytics. All in all, it was wonderful, the lecturer was straight-foward, provided feedback and made it easy to understand.

By Tania Garcia on 9/5/2023

I took this course as part of an MBA program and gave me the basis to understand business analytics. The algebra-theory behind some concepts was sometimes difficult to understand but the practical exercises helped to clarify the concepts. I think the course provides good insights and basis to understand the importance and uses of business analytics in different situations.

By Corina Ysabel Valderrama Laura on 7/30/2023

Very interesting! In a world where data is the most valuable resource that exists, it is necessary to acquire new skills to be able to clean data, analyze it, and generate insights for better decision-making. This course allowed me to learn new tools and update my skills in data processing. I recommend it 100%.

By Paola Duarte on 6/27/2023

The course provides good knowledge about business analysis, the statistical formulas are a bit complex but the teacher explains them through some examples that help to clarify the concepts.

Showing all 10 reviews on CourseDuck

Read all 848 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100