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	hardik.20225034@mnnit.ac.in	58.38
2	Tanisha Patel	tanishapatel2807@gmail.com	57.83
3	Chakarwardhan Singh	17corechaks@gmail.com	57.83
4	Karan Lalwani	kglalwani_b22@et.vjti.ac.in	57.38
5	Samarth Sharma	samarth.sharma1103@gmail.com	57.38
6	Anikashri K	anikashri08@gmail.com	57.38
7	Saurav Kumar	sauravkumar070304@gmail.com	57.38
8	Tamanna Gupta	gargtamanna2sep@gmail.com	57.34
9	Satyam Sinha	sinha2satyam2004@gmail.com	57.34
10	Aviral Jain	aviral.jain.mec23@itbhu.ac.in	57.34
11	Pranav Mohan Lal	pranavlal21@gmail.com	57.34
12	Srivatsan JS	srivatsan.js.2004@gmail.com	57.30
13	Deepanshi Varshney	deepanshivarshney2@gmail.com	57.13
14	Dushyant Kumar	dushyant.kumar.met23@itbhu.ac.in	56.88
15	Ishant Verma	ishantv69@gmail.com	56.88
16	Shaurya Anand	shauryaanand2803@gmail.com	56.81
17	Shrehan Raj Singh	shrehanofficial@gmail.com	56.80
18	Khushivardhan Singh Rao	khushivardhansinghrao@gmail.com	56.75
19	Anuoshka Singh	anuoshkasingh23@gmail.com	56.75
20	Sai Shashank Reddy Puchala	saishashankreddypuchala@gmail.com	56.75
21	Priyal Khandelwal	khandelwalpn@rknec.edu	56.75
22	Yash Garg	gyash0644@gmail.com	56.71
23	Krushna Shete	krushnashete1999@gmail.com	56.67
24	Rachit Nema	rachitnema04@gmail.com	56.63
25	Aryan Kumar	aryan_k@mt.iitr.ac.in	56.50
26	Sheikh Mirajuddin	mirajuddinsheikh6@gmail.com	56.50
27	Vedika Thakur	thakurvedika05@gmail.com	56.46
28	Paras Kulkarni	kulkarniparas42@gmail.com	56.46
29	Priti Sand	u23me091@med.svnit.ac.in	56.461
30	Amey Jawale	aajawale_b22@el.vjti.ac.in	56.38
31	Kshitiz Gupta	guptakshitiz2005@gmail.com	56.30
32	Siddhant Paul	sidpaul.trinity@gmail.com	56.30
33	Srijan Kumar	22f1001865@ds.study.iitm.ac.in	56.21
34	Ayush Kumar Sahoo	ayushgudu04@gmail.com	56.21
35	Vijay Prabhas	vijayprabhas885@gmail.com	56.21
36	Saksham Jha	sakshamjha3027@gmail.com	56.09
37	Sai Kiran Bollineni	21je0246@iitism.ac.in	56.00
38	Shubham Singh	shubham.singh.cd.che23@itbhu.ac.in	55.96
39	Shriya Mishra	reachshriya24@gmail.com	55.88
40	Pratikcha choudhary	pratikshachoudhary349@gmail.com	55.83
41	S Sanjayram Tharun	sirisanjayram@gmail.com	55.83
42	Rishabh Singha	rishabhsingha@gmail.com	55.83
43	Shashank Prabhat	shashankprabhat442@gmail.com	55.83
44	Abhishek Kumar	abhishekkumar.idl@gmail.com	55.83
45	Dhruvinkumar Patel	dhruvinkumar.patel@mitwpu.edu.in	55.83
46	Priyanshu Raj Singh	priyanshurs@iitg.ac.in	55.83
47	Rohan Sah	sahrohan183@gmail.com	55.83
48	Amey Taksali	amey.taksali@gmail.com	55.83
49	Kashmira Matale	matalekashmira@gmail.com	55.80
50	Prayas Gupta	prayasgupta1234@gmail.com	55.76

Week 1

Week 2

Week 3

Week 4

Week 5

Assessments