Course Intro
Lillian will demonstrate the entire business analysis process from 0 to 1 by solving a case study, which is a common interview format for business analyst interviews in tech. Regardless of your background, whether it’s in marketing, project management, operations, engineering, this course helps develop your “data analytics skills” and “business sense” to solve any hard business problems at work.
Learning Points
Business Analytics、Data Analysis、Storytelling
Learning Materials
Raw Dataset, Useful Templates
Total Duration of Videos
About 3 hours 25 minutes
Viewing Restrictions
Unlimited Time and Access
Charge Type
One-time Charge (Course Project)
Course Outline
Ch 1 Problem Solving Framework
Ch 2 Logical Thinking: Structuring the Business Problem
Ch 3 Analytical Thinking / Asking the Right Data Questions
Ch 4 Data Analytics: Data Wrangling, Visualization, Extracting Insights
4.1 How to Organize and Prepare for Data Analysis Using Google Slides and Google Sheets
4.2 Data Analysis Example: Analyzing Total Demand
4.3 Data Analysis Example: Analyzing Top Performing Stores
4.4 Data Analysis Example: Analyzing Worst Performing Store
4.5 Data Analysis Example: Analyzing Order Frequency
4.6 Data Analysis Example: Analyzing Average Order Size
Ch 5 Developing Business Recommendations
5.1 The Key to Creating a Business Strategy
5.2 Turning Insights into Business Recommendations (step-by-step Part 1)
5.3 Turning Insights into Business Recommendations (step-by-step Part 2)
Ch 6 Building a Business Presentation
6.1 Building a Winning Business Presentation – Storytelling
6.2 Structuring a Business Presentation
6.3 Formatting: Visual Thinking, Writing Headline, Communications Flow
6.4 Driving Impact: Integrate Your Business Logic Thinking into Your Presentation
6.5 How to Write and Present Data, Insights, and Business Recommendations (Formulas + Templates)
6.6 The Most Important Slide: How to Write a Concise Executive Summary
6.7 Final Presentation Tip/Submitting your Case Study
Ch 7 Preparing for a Business Analyst Role
7.1 What does a Business Analyst actually do? What are the 3 core skills?
7.2 Common Career Background/Relevant Work Experiences
Ch 8 Business Analyst Job and Interview Tips
8.1 How to find business analyst roles & tips for applying/How to prepare and write your resume?
8.2 What to expect during your business analyst interviews?
Sales Page:_https://us.ppacademy.cc/project/36651D9F89DA6B24908490D70EE5B2C5/about
