What You Need to Know Before
You Start

Starts 8 June 2025 02:16

Ends 8 June 2025

00 days
00 hours
00 minutes
00 seconds
course image

Business Analyst Bootcamp: Excel, Stats, SQL, Tableau

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

4052 Courses


23 hours 32 minutes

Optional upgrade avallable

Not Specified

Progress at your own speed

Paid Course

Optional upgrade avallable

Overview

30+ Data Analysis, Business Intelligence, and Decision Making Exercises for Agile Business Analytics What you'll learn:

Excel:

Mine data and generate actionable insights with Pivot Tables, Lookup Functions, Index/Match, and GraphsExcel:

Create machine learning model and make predictions with Analysis ToolpakSQL:

Understanding the data life cycle and how data moves from a pipeline into a data warehouse/lakeSQL:

Query, clean, and prepare data for analysis and real-time reportingTableau:

Create visualizations and dashboards to communicate data insightsTableau:

Storytelling technical information to executives and business stakeholders 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 learnedAre you ready to dive into the world of Business Analytics? Let's get started!Shoutout to Mike Yang for dev reviews

Syllabus

  • Introduction to Business Analytics
  • Overview of Business Analytics and Intelligence
    Role of a Business Analyst
    Course objectives and structure
  • Excel for Business Analytics
  • Introduction to Excel for data analysis
    Data manipulation and cleaning
    Formulas, functions, and pivot tables
    Data visualization with charts and graphs
    Practical examples in Excel
  • Statistics for Business Analysis
  • Descriptive statistics
    Probability and distributions
    Inferential statistics
    Hypothesis testing
    Practical applications of statistical analysis
  • SQL for Business Analysts
  • Introduction to SQL and databases
    Writing basic SQL queries
    Advanced SQL topics: joins, subqueries, and functions
    Data aggregation and grouping
    Practical examples using SQL
  • Data Visualization with Tableau
  • Introduction to Tableau interface
    Connecting to data sources and data preparation
    Building basic and advanced visualizations
    Dashboards and storytelling with data
    Practical examples in Tableau
  • Integrating Tools for Business Insights
  • Combining Excel, SQL, and Tableau in analytics
    Automating workflows and repetitive tasks
    Real-world analytics projects and case studies
  • Capstone Project
  • Real-world business problem
    Using acquired skills in Excel, SQL, and Tableau
    Project presentation and peer review
  • Conclusion and Next Steps
  • Final thoughts and takeaways
    Career opportunities and continuing education
    Resources for further learning in business analytics

Taught by

Leo Zhu


Subjects

Business