Business Analytics 101: Become A Business Analyst

Name: Business Analytics 101: Become A Business Analyst
Rating: 4.0 (131 reviews)

Learn the basics of business analytics and build your career as a business analyst.

Created byJustin Butlion

Last updated 6/2025

English

English [Auto],

What you'll learn

Learn about the role of the business analyst
Start learning SQL
Start learning Excel and Tableau
Start looking for a job as a business analyst
Go to job interviews with confidence
Understand basic data structures

Course content

8 sections • 22 lectures • 1h 57m total length

Introduction2:28
In this video I provide an overview of the course.

What is a business analyst?5:14
In this lecture I'm going to answer a key question, What is a business analyst?
You will learn the fundamental role of this position in the organization and how critical it is for optimization of the business.
The Role of a Business Analyst8:53
In this lecture you'll learn why I compare business analysts to ninjas.
You'll also learn about the many hats that a business analyst wears and why you'll need to develop a spectrum of skills and knowledge to perform your role.

Excel #1 - Building a data set in Excel7:13
Create a quick Joe's Coffee sales table in Excel for September, with columns like id, product name, and amount, to illustrate how Excel builds data sets for analysis and reporting.
Excel #2 - Functions9:43
Explore advanced Excel techniques for business analysis, including filtering data, using functions, creating tables, and building aggregations and nested groupings for daily sales insights.
Tableau #1 - Introduction6:57
Connect to diverse data sources in Tableau and build visuals using dimensions, measures, and pivot tables. Explore running totals with table calculations and switch to bar charts for clear comparisons.
Tableau #2 - Functions, Filters and more7:36
Learners use Tableau to build profit over time visuals, use functions and calculated fields to create ratios, and filter by state to identify profitable versus non-profitable areas.

How to Find a Job as a Business Analyst7:11
Find business analyst roles by searching LinkedIn by city, reviewing company pages for required skills, and applying. Explore remote jobs on Modoc and engage in groups to identify hiring firms.
How to Prepare for a Business Analyst Job Interview #17:12
Discover practical prep for a business analyst interview by analyzing the job listing, researching the company, and highlighting skills in SAS, Tableau, Excel, and data-driven decision making.
How to Prepare for a Business Analyst Job Interview #26:50
learn to research a target company using its website and LinkedIn, build a network, and analyze team structure, offices, funding, and operations to prepare for a business analyst interview.
How to Prepare for a Business Analyst Job Interview #3 - Interview Questions9:19

How to find outliers in a dataset using Tableau & Excel5:56
Outliers can ruin an analysis if you miss them. In this video I cover the concept of an outlier and teach you how you can find outliers using Tableau or Excel.
How I Think About Business Intelligence For Startups (Tinder Example)11:13
In this video I cover how I like to think about business intelligence for a startup. I go through my process step-by-step and teach you how you can use the same approach for your own startup.

Requirements

No prior experience is needed.

Description

The goal of this course is to give you all the knowledge, tips and resources you need to start your career as a business analyst.

The field of business analytics is growing like crazy. Ambitious, and technical students can quickly develop the skills and knowledge needed to help businesses use data to grow and become more optimized.

In my course you'll learn the following:

What exactly does a business analyst do?
What skills and knowledge is needed to do this business analyst job professionally?
What your salary should be as a business analyst
What tools will I need to know in order to do my job?
What are some of the important topics which I need to know as a business analyst?
How can I find a job as a business analyst?
How should I prepare for an interview as a business analyst?
I want to learn SQL, Google Analytics, Mixpanel and SalesForce, where do I get started?
Tips on how to accelerate your career as a business analyst

Take your first step towards a new career with this course. Let's get started!

Why you should learn from me?

I've been working as a data and analytics specialist for a number of years. During my time as the Director of Business Performance at Yotpo I interviewed over 80 business analysts while building my team.

During this time I've hired, trained and directly managed both senior and junior analysts and know first hand what it takes to perform as a business analyst.

Since leaving Yotpo I've worked with over 25 companies as a freelancer, specializing in analytics, data infrastructure and operations.

Enjoy the course.

Who this course is for:

Individuals that are interested in starting a career as a business analyst.
Junior analysts that want to climb the corporate ladder quicker.
Entrepreneurs that want to become more data-driven.
Developers / marketers / ops specialists that want to learn how to become more analytical.

Business Analytics 101: Become A Business Analyst

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

The Roles of a Business Analyst in the Organization2 lectures • 14min

Important Topics For Business Analysts2 lectures • 21min

Tools of the Trade4 lectures • 31min

How to Get Hired as a Business Analyst4 lectures • 31min

Bonus Videos2 lectures • 17min

Further Learning6 lectures • 1min

What's next?1 lecture • 1min

Requirements

Description

Who this course is for: