Winter Consulting 2024 | Course Dashboard | Consulting & Analytics Club, IIT Guwahati

Consulting and Analytics Club:
Dear Learners,
Get ready to embark on an exciting journey into Consulting, Economics, and Product and Business Analytics! Start with the Week 1 tab for daily tasks. Each week includes 5 days of Learning, followed by 2 days for quizzes and assignments. Check the Schedule tab for the course timelines. Leaderboard rankings will be updated weekly. Join the discord server for all the updates and discussions. Happy learning.

CAPSTONE PROJECT RELEASED !!

Swipe to view full content

WEEK 1	WHAT'S IN THERE	TASK 1	TASK 2	TASK 3
Day 1	Hey there, excited to start learning? Welcome to Winter Consulting 2024! We'll kick off this exciting journey with some basic concepts of Economics.	What is Consulting? Microeconomics vs Macroeconomics Microeconomics vs Macroeconomics (Video)	Top Down vs Bottom Up Approach Supply and Demand (Video) Law of Supply and Demand	Supply and Demand detailed (Video) What is Behavioural Economics
Day 2	Today, we'll learn about Behavioural Economics, Price Elasticity, Market sizing and Market Structures.	What is Price Elasticity? Elasticity of Supply (Video) Elasticity of Demand (Video)	Defining TAM, SAM, SOM Explaining TAM, SAM & SOM (Video)	Guesstimates Market Competition: Monopolies vs Oligopolies
Day 3	With a solid understanding of fundamental economic principles, we'll now transition to Unit economics and learn about the correlation between Money and Finance.	Introduction to Unit Economics Guide to Unit Economics	Unit Economics 101 (Video) Example of Unit Economics Calculation	Money and Finance (Video)
Day 4	Tody we'll delve into concepts of Economic Growth and explore renowned Growth Models	Understanding Growth and Productivity (Video) GDP vs GNP (Video)	How is Economic Growth measured Solow Growth Model of Economics (Video)	Harrod Domar Model (Video) Economic Growth in Short run and Long run (Video)
Day 5	We'll end this week by learning some basics concepts of Financial Markets and the related Economics behind them. Don't forget to submit Assignment 1 after completing Week 1!	How does the Stock Market works? Role of Financial Markets in Economics	Bonds vs Stocks Annuity vs. Perpetuity	Difference Between Annuity and Perpetuity Helping Students Crack Annuity, Perpetuity, Bond, and Stock Valuation Formulas

Swipe to view full content

WEEK 2	WHAT'S IN THERE	TASK 1	TASK 2	TASK 3
Day 1	Today, we'll learn about some Basic excel fuctions	Basic Excel Functions	LOOKUP function Data Validation	Conditional Formating - 1 Conditional Formating - 2
Day 2	Advanced excel functions used in Modelling and Data Analysis	Index Matching using CSE	Pivot Tables	Interactive Dashboards
Day 3	Introduction to Financial Modelling and grasping the concept of Time Value of Money.	What is Financial Modeling? How to Build a Basic Financial Model in Excel	Intro to Time Value Of Money (Read) Intro to Time Value of Money (Video)	Time Value Of Money Explained
Day 4	Some Financial Modelling Techniques and their implementation using Excel.	How to Read Company Financial Statements (Video) Understanding Comapny's Financial Statement (If you prefer reading)	DCF Modelling (Hindi) DCF Modelling (English)	Financial Modelling Case Study
Day 5	"Today, we explore Statistical Analysis and Probability and its role in Data Science.	What is Statistical Analysis? Complete Statistics for Data Science	Probability for Data Science	Probability: A thought experiment Binomial Distribution for predicting outcomes

Swipe to view full content

WEEK 3	WHAT'S IN THERE	TASK 1	TASK 2	TASK 3
Day 1	Today, we explore essential frameworks and tools used in consulting, including Issue trees and the MECE approach, along with SWOT and PESTLE analysis.	What is Issue Tree? MECE Approach MECE Approach (Video)	SWOT Analysis How to Perform a SWOT Analysis SWOT Analysis Example	PESTEL Analysis PESTEL Analysis (Video) PESTEL Analysis Example
Day 2	Today, we'll dive into some advanced frameworks like Porter Five forces, Value chain analysis and BCG Growth Share matrix.	Porter's Five Forces Porter's Five Forces (Video) Porter's Five Forces Example	Value Chain Analysis Value Chain Analysis (Video) Value Chain Analysis Example	BCG Growth Share MAtrix BCG Growth Share Matrix (Video) BCG Growth Share Matrix Example
Day 3	Next, we'll focus on standard techniques used by consultants to structure ideas and solutions, such as Balanced Scorecard analysis, 3Cs, and 4Ps framework.	Balanced Scorecard Approach Balanced Scorecard Examples Balanced Scorecard (Blog)	3Cs Framework 3Cs Framework (Blog))	4Ps Framework 4Ps Framework (Blog)
Day 4	Today, we'll engage with real-world case-solving scenarios, starting with Profitability, Pricing, and Market Entry cases.	Profitability Case Profitability Case (Blog) Profitability Case (Practice)	Pricing Strategy Case Pricing Case (Example) Pricing Case (Practice)	Market Entry Case Market Entry Case (Example)
Day 5	We'll conclude this week with cases on Growth and M&A, and explore the allied career path of Private Equity.. Ensure that you submit the week 3 quiz and assignment on time!	Growth Strategy Case Growth Strategy Case (Practice)	Mergers & Acquisitions Case Mergers & Acquisitions Case (Blog)	What is Private Equity? Private Equity (Additional Resource)

Swipe to view full content

WEEK 4	WHAT'S IN THERE	TASK 1	TASK 2	TASK 3
Day 1	Today, we'll dive into product management covering basic essentials,followed by OKR,KPI and creating user personas.	Profitability Life Cycle What is Product Management Project vs Program vs Product Management	Systems Thinking What are OKRs? How to develop KPIs	Understanding User Personas How to create User Personas? Market Segmentation and Personas
Day 2	Today we"ll explore on how to conduct user interviews, identify customer journey maps, pain points and understand the MVP concept.	Effective User Interviews Customer Empathy Map	Customer Journey Map Customer Pain Points	Minimum Viable Product ICE Scoring Model
Day 3	Next,we'll understand about the problem framing canvas,validationand product roadmapping.	Problem Framing Canvas Mind Mapping	Product Hypotheses : Generation and Validation. Planning Hypothesis in Product Management	Creating a Product Roadmap Types of Product Roadmaps
Day 4	Today,we'll learn about the growth loops,user acquistion and retention and some important metrics,product led growth.	Growth Loops vs. AARRR Funnels: Which One Is Right for Your Business? Acquisition, Engagement, Retention: How to Drive SaaS Growth	Customer Experience Metrics and KPIs Customer Retention and Cohort Analysis.	Leveraging Network Effects For Business Growth Understanding Product-Led Growth
Day 5	We"ll conclude this week with NSM AND OMTM metrics,A/B and multivariate Testing and user story mapping.	North Star Framework What is One Metric That Matters and how to find your OMTM?	A/B Testing in Product Management A/B Testing vs. Multivariate Testing for Design Optimization	User Story Mapping and Use Cases in Product Management User Journey & How it improves Agile process

Swipe to view full content

WEEK 5	WHAT'S IN THERE	TASK 1	TASK 2	TASK 3
Day 1	Welcome to the final week of this course. Today, we'll learn about what is SQL, It's role in a Product Manager's life and some basic SQL queries.	What is SQL? Download Postgre SQL (for Mac) Download Postgre SQL (for Windows)	Type of Database SQL for Product Managers	SQL Basics
Day 2	Today we'll learn about Joins and Subquery in SQL.	Joins in SQL (Part 1) If you prefer reading over videos	Joins in SQL (Part 2) If you prefer reading over videos	Subquery in SQL If you prefer reading over videos
Day 3	Today we'll learn how to use WITH clause in SQL, and learn about some WINDOW functions.	SQL WITH clause If you prefer reading over videos	WINDOW function in SQL	Window function in SQL (Part 2)
Day 4	Today we'll explore about REGEX in SQL and try to make faster SQL queries. You can also dive it into advanced SQL concepts like Recursion.	Regular Expression (REGEX) in SQL	How to make SQL queries faster?	Recursive SQL (Optional)
Day 5	Today we'll learn Tableau, a visual analytics platform transforming the way we use data to solve problems.	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

LINK	DEADLINE	INSTRUCTIONS
Capstone Project	22 Jan, 2025 11:59 PM	Slide Limit: 15 pages Submission Link

Originally developed by Advaith Krishna A for Consulting & Analytics Club, IIT Guwahati

Managed by Poorvi Panjwani, Priya Gawshinde, Kevin Kuriakose, Dhruv Mishra for Consulting & Analytics Club, IIT Guwahati

Week 5 Quiz update	Quiz 5 is now live! Deadline: 5 Jan 2025, 11:59 PM
Week 5 Assignment update	Assignment 3 is now live! Deadline: 6 Jan, 9:00 AM

02.12.2024	Week 1 Release
07.12.2024	Assignment 1 and Quiz 1 Release
09.12.2024	Week 2 Release
14.12.2024	Assignment 2 and Quiz 2 Release
16.12.2024	Week 3 Release
21.12.2024	Assignment 3 and Quiz 3 Release
23.12.2024	Week 4 Release
28.12.2024	Assignment 4 and Quiz 4 Release
30.12.2024	Week 5 Release
04.01.2025	Assignment 5 and Quiz 5 Release
08.01.2025	Final Project Release
20.01.2025	Certificates + Badges

1	HARDIK GURUDEV	[email protected]	58.38
2	Tanisha Patel	[email protected]	57.83
3	Chakarwardhan Singh	[email protected]	57.83
4	Karan Lalwani	[email protected]	57.38
5	Samarth Sharma	[email protected]	57.38
6	Anikashri K	[email protected]	57.38
7	Saurav Kumar	[email protected]	57.38
8	Tamanna Gupta	[email protected]	57.34
9	Satyam Sinha	[email protected]	57.34
10	Aviral Jain	[email protected]	57.34
11	Pranav Mohan Lal	[email protected]	57.34
12	Srivatsan JS	[email protected]	57.30
13	Deepanshi Varshney	[email protected]	57.13
14	Dushyant Kumar	[email protected]	56.88
15	Ishant Verma	[email protected]	56.88
16	Shaurya Anand	[email protected]	56.81
17	Shrehan Raj Singh	[email protected]	56.80
18	Khushivardhan Singh Rao	[email protected]	56.75
19	Anuoshka Singh	[email protected]	56.75
20	Sai Shashank Reddy Puchala	[email protected]	56.75
21	Priyal Khandelwal	[email protected]	56.75
22	Yash Garg	[email protected]	56.71
23	Krushna Shete	[email protected]	56.67
24	Rachit Nema	[email protected]	56.63
25	Aryan Kumar	[email protected]	56.50
26	Sheikh Mirajuddin	[email protected]	56.50
27	Vedika Thakur	[email protected]	56.46
28	Paras Kulkarni	[email protected]	56.46
29	Priti Sand	[email protected]	56.461
30	Amey Jawale	[email protected]	56.38
31	Kshitiz Gupta	[email protected]	56.30
32	Siddhant Paul	[email protected]	56.30
33	Srijan Kumar	[email protected]	56.21
34	Ayush Kumar Sahoo	[email protected]	56.21
35	Vijay Prabhas	[email protected]	56.21
36	Saksham Jha	[email protected]	56.09
37	Sai Kiran Bollineni	[email protected]	56.00
38	Shubham Singh	[email protected]	55.96
39	Shriya Mishra	[email protected]	55.88
40	Pratikcha choudhary	[email protected]	55.83
41	S Sanjayram Tharun	[email protected]	55.83
42	Rishabh Singha	[email protected]	55.83
43	Shashank Prabhat	[email protected]	55.83
44	Abhishek Kumar	[email protected]	55.83
45	Dhruvinkumar Patel	[email protected]	55.83
46	Priyanshu Raj Singh	[email protected]	55.83
47	Rohan Sah	[email protected]	55.83
48	Amey Taksali	[email protected]	55.83
49	Kashmira Matale	[email protected]	55.80
50	Prayas Gupta	[email protected]	55.76

Week 1

Week 2

Week 3

Week 4

Week 5

Assessments