Swipe to view full content
| WEEK 1 | WHAT'S IN THERE | TASK 1 | TASK 2 | TASK 3 |
|---|---|---|---|---|
| Day 1 |
"Hey everyone — excited to start learning? Welcome to Winter Consulting 2025! We’ll kick off this journey by walking through a sample consulting case to help you understand what a real case study looks like. After that, we’ll dive into how you can structure and create similar business analyses with clarity and impact." | What is Consulting? Understanding a Business Case First Principles Thinking |
Market Research Issue Tree MECE Approach |
SWOT Analysis Performing SWOT Analysis Example of SWOT Analysis |
| Day 2 |
Gaining a solid understanding of a business’s core, along with the ability to analyse its supply chain and value chain. | 3Cs Framework 3Cs Blog 4Ps Framework |
Supply Chain Supply Chain Theory Supply Chain Example |
Value Chain AnalysisValue Chain Analysis - VideoValue Chain Analysis - Example |
| Day 3 |
Key problem-solving frameworks that you can use while cracking a case — forming the backbone of a consultant’s essential toolkit. | PESTEL Analysis PESTEL Analysis - Video PESTEL Analysis - Example |
Porter's Five Forces Porter's Five Forces - Video Porter's Five Forces - Example |
TAM, SAM, SOM TAM, SAM, SOM - Video Guesstimates |
| Day 4 |
Deep-diving into core case frameworks: Profitability, essential matrices, and other foundational tools. | BCG Matrix BCG Matrix - Video BCG Matrix - Example |
Balanced Scorecard Balanced Scorecard - Example Balanced Scorecard - Blog |
Case Solving Profitability Cases Profitability Case - Practice |
| Day 5 |
Exploring other major case types you’ll encounter in interviews, including Market Entry, Growth Strategy, and M&A. Don't forget to submit Assignment 1 after completing Week 1! |
Growth Strategy Case Growth Strategy Case - Practice |
M&A Case M&A Case - Blog |
Market Entry Case Market Entry Case - Blog |
Swipe to view full content
Swipe to view full content
| WEEK 3 | WHAT'S IN THERE | TASK 1 | TASK 2 | TASK 3 |
|---|---|---|---|---|
| Day 1 |
Welcome to Week 3 of the course! This week, we’ll dive into SQL—what it is, why it matters, and how it plays a crucial role in a Product Manager’s day-to-day work. You’ll also get hands-on with basic SQL queries that every PM should know to make data-driven decisions. | What is SQL? Download Postgre SQL (for Mac) Download Postgre SQL (for Windows) |
Type of Database SQL for Product Managers |
Joins in SQL (Part 1) If you prefer reading over videos |
| Day 2 |
Today, we’ll learn about SQL Joins and Subqueries, along with an introduction to SQL WITH clauses. | Joins in SQL (Part 2) If you prefer reading over videos |
Subquery in SQL If you prefer reading over videos |
SQL WITH clause If you prefer reading over videos |
| Day 3 |
Today, we’ll explore Window Functions and REGEX in SQL, and learn techniques to write faster and more efficient SQL queries. You can also dive into advanced SQL concepts like Recursion. After that, we’ll begin our discussion on basic Excel functions. | WINDOW function in SQL Window function in SQL (Part 2) |
Regular Expression (REGEX) in SQL How to make SQL queries faster? Recursive SQL (Optional) |
Basic Excel Functions |
| Day 4 |
Today, we’ll discuss advanced Excel functions used in modeling and data analysis. | LOOKUP function Data Validation |
Conditional Formating - 1 Conditional Formating - 2 |
Index Matching using CSE Pivot Tables Interactive Dashboards |
| Day 5 |
We’ll conclude this week by learning Tableau—a powerful visual analytics platform that’s transforming how we use data to explore insights and solve real-world problems. Don't forget to submit Assignment 3 after completing Week 3! |
How to Install Tableau and Create First Visualization How to use Calculated Fields and Bins in Tableau |
How to Create Visualisations in Tableau How to use Joins in Tableau |
Full Beginner Project in Tableau Figma to tableau |
Swipe to view full content
| WEEK 4 | WHAT'S IN THERE | TASK 1 | TASK 2 | TASK 3 |
|---|
| LINK | DEADLINE | INSTRUCTIONS |
|---|---|---|
| Week-2 Assignment | 15 Dec, 2025 11:59 PM |