Praneeta Gupta
AVP
9+ years
NAB Bank, Zomato, Deloitte, Uber
Analyst fellowship cohort
Data, Business & Product Analyst Fellowship
π Get Job/Internship Ready in Just 10 Days!
Live
2
months
Mentorship
Placement for
18M
50% OFF
27th cohort starts on
10th June
Cost
βΉ8,999/-βΉ17,998
!Price increase from 9th June 23:59
Price up in00h:00m:00s
Razorpay Secured100% Refund Guarantee4.7/5 Rated
β¨ Cohort Highlights
Hover or tap to reveal full list π
What Will You Learn?
Day 1 to 3
Introduction
- 1What's App Group Formation & Rule Setting
- 2Non-Tech Industry Overview & Essential Skills
- 3Resume Crafting & Narrative Development
- 4Aptitude & Puzzle-Solving Strategies Using AI
- 5Project Building Using AI Tools (Manus, Claude)
- 6LinkedIn & Naukri Profile Optimization.
- 7Tools Setup: SQL, Python, Excel, Looker Studio.
Day 4 to 5
Guesstimates
- 1Guesstimates Overview
- 2Discussion of Various Approaches to Solve Guesstimates
- 3The Universal Guesstimate Framework (Structure β Assumptions β Calculate β Sanity Check)
- 4Demonstrating Guesstimate Problems: Market sizes, populations, revenues
- 5Guesstimates 101: Practice and Preparation
- 6Three Mock Interviews: Guesstimate Round + Resume Round
Day 5 to 6
Business Case Problems
- 1Case Study Overview: What is a case study and why it matters
- 2Discussion of Various Approaches & Strategies to Solve Case Studies
- 3Profitability Framework: Revenue tree, cost structure, EBITDA analysis
- 4Market Entry Framework: TAM/SAM/SOM, 5 Forces, entry modes
- 5Merger & Acquisition Overview: Synergies, due diligence, valuation basics
- 6Three Mock Interviews: Profitability Case + Market Entry Case + Resume Round
Day 7 to 8
Business Case Problems
- 1Guesstimates Doubt Clarification Session
- 2Business Case Study (Doubt Practice): Solve real past cases
- 3Profitability, Market Entry, M&A Framework β Advanced Applications
- 4GTM (Go-To-Market) Strategy Framework
- 5Business Case Study 101: Practice and Preparation
- 6Three Mock Interviews: Full Case + GTM Case + Company-Specific Round
Day 9 to 10
Excel + Looker Studio β Data Visualization
- 1Excel Advanced: VLOOKUP, HLOOKUP, XLOOKUP, INDEXMATCH
- 2Statistical Formulas: SUMIF, SUMIFS, COUNTIF, AVERAGEIF
- 3Text & Date Functions: CONCATENATE, TEXT, DATEDIF, EDATE
- 4Looker Studio: Connect data sources, build dashboards
- 5Looker Studio: Interactive filters, scorecards, geo charts, time series
- 6Dashboard Design: Color theory, layout, storytelling with data
- 7Three Mock Interviews
Day 11 to 14
SQL β Database Mastery
- 1SQL Fundamentals: SELECT, WHERE, GROUP BY, ORDER BY, HAVING
- 2SQL All Functions: String, Date, Aggregate, Math functions
- 3Joins Mastery: INNER, LEFT, RIGHT, FULL OUTER, CROSS, SELF joins
- 4Window Functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, NTILE
- 5SQL Database Design: Normalization, ERD, Foreign Keys
- 6SQL Problem Practice: 50+ real interview
- 7Three Mock Interviews
Day 15 to 17
Python
- 1Introduction to Python: Setup, syntax, first program, variables, data types, operators, I/O
- 2Control Flow: if/else, for loops, while loops, list comprehension and data structures β lists, tuples, sets, dictionaries
- 3String Manipulation, Regular Expressions and Pandas (DataFrames, groupby, merge), NumPy
- 4Data Cleaning: Handling nulls, duplicates, outliers, type conversions
- 5Visualization: Matplotlib, Seaborn β bar charts, histograms, heatmaps
- 63 Mock Interviews: Python Technical, EDA Case, and Company-Specific
Day 18 to 19
Product
- 1Product Case Studies: Overview and structured approach
- 2KPI Questions: Defining metrics for success, North Star Metric
- 3Product Improvement Framework: Identify β Prioritize β Design β Measure
- 4RCA (Root Cause Analysis): Why a metric dropped β structured investigation
- 5GTM (Go-To-Market) Strategy: Product launch playbook
- 6RAC Framework: Responsible, Accountable, Consulted
- 7Three Mock Interview
Day 20 to 21
Product
- 1Agile & Scrum in Project Management: Sprints, standups, backlogs
- 2Product Lifecycle & Roadmaps: Prioritization with RICE, MoSCoW
- 3Wireframing & Prototyping: Balsamiq basics
- 4Writing PRDs & MRDs: Product Requirements Documents
- 5Mock Interviews: Product Case, KPI Round, and PM Company-Specific
- 6Company Prep: Unifyapps, AdvantageClub, Meesho PM interview formats
- 73 Mock Interview
Program Timeline
Detailed week-by-week schedule covering Live Sessions, Mentor Labs, and Placement Updates.
Day / Theme
Session 1
- β’(Live Content)
Session 2
- β’(Live Content)
Mentor Labs / Mocks
Mentor Mock Interviews
- β’(Tue / Thu / Fri)
Placement Update
Placement Update
- β’(Sat 10 PM)
Day 1β3 (Jul 1β3)
1β’ WhatsApp Group Formation & Rule Setting
- β’2β’ Non-Tech Industry Overview & Essential Skills
- β’3β’ Resume Crafting & Narrative Development
- β’4β’ Aptitude & Puzzle-Solving Strategies Using AI
5β’ Project Building Using AI Tools (Manus, Claude)
- β’6β’ LinkedIn & Naukri Profile Optimization
- β’7β’ Tools Setup: SQL, Python, Excel, Looker Studio
Mentor Labs / Mocks
Resume Round
- β’(Peer intro + narrative check)
Placement Update
Sat Jul 4
- β’Cohort kickoff + placement orientation
Day 4β5 (Jul 4β5)
1β’ Guesstimates Overview
- β’2β’ Discussion of Various Approaches to Solve Guesstimates
- β’3β’ The Universal Guesstimate Framework
- β’ (Structure β Assumptions β Calculate β Sanity Check)
4β’ Demonstrating Guesstimate Problems:
- β’ Market sizes, populations, revenues
- β’5β’ Guesstimates 101: Practice and Preparation
- β’6β’ Three Mock Interviews: Guesstimate Round + Resume Round
Mentor Labs / Mocks
Mock 1: Guesstimate Round
- β’Mock 2: Resume Round
- β’Mock 3: Guesstimate (advanced)
Placement Update
Sat Jul 11
- β’Placement Update #2
- β’(Internship openings shared)
Day 5β6 (Jul 5β6)
1β’ Case Study Overview: What is a case study and why it matters
- β’2β’ Discussion of Various Approaches & Strategies
- β’3β’ Profitability Framework: Revenue tree, cost structure, EBITDA analysis
4β’ Market Entry Framework: TAM/SAM/SOM, 5 Forces, entry modes
- β’5β’ M&A Overview: Synergies, due diligence, valuation basics
- β’6β’ Three Mock Interviews: Profitability Case + Market Entry Case + Resume Round
Mentor Labs / Mocks
Mock 1: Profitability Case
- β’Mock 2: Market Entry Case
- β’Mock 3: Resume Round
Placement Update
Sat Jul 11
- β’Placement Update #3
- β’(Consulting roles featured)
Day 7β8 (Jul 7β8) I
1β’ Guesstimates Doubt Clarification Session
- β’2β’ Business Case Study (Doubt Practice): Solve real past cases
- β’3β’ Profitability, Market Entry, M&A Framework β Advanced Applications
4β’ GTM (Go-To-Market) Strategy Framework
- β’5β’ Business Case Study 101: Practice and Preparation
- β’6β’ Three Mock Interviews: Full Case + GTM Case + Company-Specific Round
Mentor Labs / Mocks
Mock 1: Full Case Round
- β’Mock 2: GTM Case
- β’Mock 3: Company-Specific Round
Placement Update
Sat Jul 11
- β’Placement Update #4
- β’(BA/Consulting openings)
Day 9β10 (Jul 9β10)
1β’ Excel Advanced: VLOOKUP, HLOOKUP, XLOOKUP, INDEXβMATCH
- β’2β’ Statistical Formulas: SUMIF, SUMIFS, COUNTIF, AVERAGEIF
- β’3β’ Text & Date Functions: CONCATENATE, TEXT, DATEDIF, EDATE
4β’ Looker Studio: Connect data sources, build dashboards
- β’5β’ Interactive filters, scorecards, geo charts, time series
- β’6β’ Dashboard Design: Color theory, layout, storytelling with data
- β’7β’ Three Mock Interviews
Mentor Labs / Mocks
Mock 1: Excel Round
- β’Mock 2: Dashboard Case
- β’Mock 3: Visualization Presentation
Placement Update
Sat Jul 11
- β’Placement Update #5
- β’(DA roles, analytics internships)
Day 11β14 (Jul 11β14) SQL β Database Mastery
1β’ SQL Fundamentals: SELECT, WHERE, GROUP BY, ORDER BY, HAVING
- β’2β’ SQL All Functions: String, Date, Aggregate, Math functions
- β’3β’ Joins Mastery: INNER, LEFT, RIGHT, FULL OUTER, CROSS, SELF joins
- β’4β’ Window Functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, NTILE
5β’ SQL Database Design: Normalization, ERD, Foreign Keys
- β’6β’ SQL Problem Practice: 50+ real interview questions
- β’7β’ Three Mock Interviews
Mentor Labs / Mocks
Mock 1: SQL Technical Round
- β’Mock 2: Data Analyst Round
- β’Mock 3: Company-Specific
Placement Update
Sat Jul 18
- β’Placement Update #6
- β’(SQL/DA heavy roles)
Day 15β17 (Jul 15β17)
1β’ Introduction to Python: Setup, syntax, variables, data types, operators, I/O
- β’2β’ Control Flow: if/else, loops, list comprehension; Data Structures β lists, tuples, sets, dicts
- β’3β’ String Manipulation, Regular Expressions and Pandas (DataFrames, groupby, merge), NumPy
4β’ Data Cleaning: Handling nulls, duplicates, outliers, type conversions
- β’5β’ Visualization: Matplotlib, Seaborn β bar charts, histograms, heatmaps
- β’6β’ 3 Mock Interviews: Python Technical, EDA Case, and Company-Specific
Mentor Labs / Mocks
Mock 1: Python Technical
- β’Mock 2: EDA Case
- β’Mock 3: Company-Specific
Placement Update
Sat Jul 18
- β’Placement Update #7
- β’(Python/Data roles)
Day 18β19 (Jul 18β19)
1β’ Product Case Studies: Overview and structured approach
- β’2β’ KPI Questions: Defining metrics for success, North Star Metric
- β’3β’ Product Improvement Framework: Identify β Prioritize β Design β Measure
- β’4β’ RCA (Root Cause Analysis): Why a metric dropped β structured investigation
5β’ GTM (Go-To-Market) Strategy: Product launch playbook
- β’6β’ RAC Framework: Responsible, Accountable, Consulted
- β’7β’ Three Mock Interviews
Mentor Labs / Mocks
Mock 1: Product Case
- β’Mock 2: KPI Round
- β’Mock 3: Company-Specific PM Round
Placement Update
Sat Jul 25
- β’Placement Update #8
- β’(PM/APM internships)
Day 20β21 (Jul 20β21) I + FINAL
1β’ Agile & Scrum in Project Management: Sprints, standups, backlogs
- β’2β’ Product Lifecycle & Roadmaps: Prioritization with RICE, MoSCoW
- β’3β’ Wireframing & Prototyping: Balsamiq basics
- β’4β’ Writing PRDs & MRDs: Product Requirements Documents
5β’ Mock Interviews: Product Case, KPI Round, and PM Company-Specific
- β’6β’ Company Prep: Unifyapps, AdvantageClub, Meesho PM interview formats
- β’7β’ 3 Mock Interviews
Mentor Labs / Mocks
Mock 1: Product Case
- β’Mock 2: KPI Round
- β’Mock 3: PM Company-Specific
Placement Update
Sat Jul 25
- β’FINAL Placement Update ο
- β’+ Celebration & Next Steps
Verified Certification
Earn Your Industry-Recognized Certificate
Upon successful completion of the fellowship and the final capstone project, you will be awarded a verified CrackNonTech certificate to showcase your skills to top employers.
- Shareable on LinkedIn & Resumes
- Verified by Industry Leaders & Mentors
- Proof of Hands-on Project Experience
- Highlight your structured problem-solving skills
What Students are Saying?
Real stories from students who cracked top companies
Join 1500+ students who transformed their placement outcomes through structured prep and mentor-led support.
Placed
Hewlett Packard Enterprise
βThanks to CrackNonTech's guidance and support, I secured a prestigious internship at Hewlett Packard Enterprise!β
Before: Unstructured prep phase
After: Placed at Hewlett Packard Enterprise
Graduate
|Student
Malaika Singh
Marketing Analyst
Placed
Magicpin
βCrackNonTech played a crucial role in my internship journey. Before joining the fellowship, I was genuinely lost.β
Before: No interview strategy
After: Placed at Magicpin
Graduate
|Student
Kaashvi Gupta
GCO Intern
Placed
Siemens
βI cracked my very first on-campus interview and secured a 2-month summer internship at Siemens! CrackNontech prepared me well.β
Before: Nervous about interviews
After: Placed at Siemens
Graduate
|Student
Kaushal Kumar
Research and development Engineer
Placed
Honda Cars India Ltd
βcracknontech helped me refine not just answers, but mindset. The focused mentoring turned every interview into a success.β
Before: No mock interview exposure
After: Placed at Honda Cars India Ltd
Engineering Graduate
|Student
Sachin Kumar
Associate Consultant
Placed
PWC
βWith cracknontech, every mock interview felt like a real challenge. That intensity built my confidence and helped me secure my role.β
Before: Lacked confidence
After: Placed at PWC
Graduate
|Student
Aakarsh Dwivedi
Graduate Engineer Trainee
Placed
Godrej & Boyce Mfg. Co. Ltd
βcracknontech wasn't just prep β it was perspective. The personal guidance and sharp strategies helped me approach interviews differently.β
Before: Needed better strategies
After: Placed at Godrej & Boyce Mfg. Co. Ltd
Engineering Graduate
|Student
Aditya Kumar
Graduate Engineering Trainee
Placed
Technip Energies
βBefore cracknontech, interviews felt like guesswork. Their structured prep turned confusion into confidence helping me secure my dream role.β
Before: Interviews felt like guesswork
After: Placed at Technip Energies
Engineering Graduate
|Student
Shubh Sharma
Data engineer
Placed
Fractal Analytics
βCracknontech's focused prep and data-driven approach helped me crack Fractal. Their insights made me interview ready.β
Before: Needed data-driven approach
After: Placed at Fractal Analytics
Graduate
|Student
Rudra Jaisara
Consultant
Placed
PWC
βCracknontech's mock interviews pushed me beyond basic prep. Their sharp, real-world approach helped me crack my dream company.β
Before: Basic preparation level
After: Placed at PWC
Graduate
|Student
Aditi Tripathi
Analyst
Placed
Wells Fargo
βCracknontech sharpened my approach to interviews. Their honest feedback and practical tips helped me confidently crack Wells Fargo.β
Before: Low shortlist confidence
After: Placed at Wells Fargo
Graduate
|Student
Ayush Kumar
Product Development
Placed
Verizon
βCracknontech's expert mentorship and mock interview sessions were pivotal in securing my placement in Product Development at Verizon.β
Before: Looking for expert mentorship
After: Placed at Verizon
Graduate
|Student
Umesh Sahu
Growth & Strategy Role
Placed
Qurez
βCracknontech's personalized guidance and mock interviews helped me secure a placement at Qurez. The mentorship was invaluable.β
Before: Struggling with strategy roles
After: Placed at Qurez
Graduate
|Student
Nishant Kumar
Design Engineer
Placed
Structures
βThanks to Cracknontech's expert mentorship and mock interview practice, I secured my placement at Structures.β
Before: Needed design role specific prep
After: Placed at Structures
Engineering Graduate
|Student
Himanshu Pal
Data engineer
Placed
Swiss Re
βCrackNonTech helped me shift my mindset and build real interview skills. The practical prep and 1:1 feedback gave me an edge.β
Before: Tier-3 engineering student
After: Placed at Swiss Re
Engineering Graduate
|Student
Rahul Arora
Product Analyst
Placed
Collegedunia
βCrackNonTech's mentorship and mock interviews were game-changers. Their guidance helped me land a Product Analyst role at Collegedunia.β
Before: Confused about role transition
After: Placed at Collegedunia
Graduate
|Student
Verified reviews from our alumni placed at Swiss Re, Collegedunia, HPE, Honda Cars, Magicpin, Wells Fargo
Cohort Schedule
Live Sessions
Every Saturday, Sunday 09:00 PM - 11:00 PM IST
Mentor Labs
Every Tuesday 10:30 PM - 11:30 PM IST
Buddy Mock
Every Thursday 9:00 PM - 10:00 PM IST
Mock Interview With Mentor
Every Saturday or Sunday 12:00 PM - 2:00 PM IST
18 Months Placement Support
Clear the cut-off marks in your graduation project to get access to jobs at our partner companies.
Mock InterviewsResume ReviewsHiring Interviews
Your Future Job Title
Data Analyst
How Your Avg Cohort Looks Like
0%
3rd year students
0%
4th year students
0%
Graduated Students
Skills & AI Tools you will master
Excel
Claude AI
Guesstimates
Problem Solving
Case Study
Product Improvement
RCA
GTM
Mentors from top hiring teams
Hiring managers & industry experts guiding your prep
Learn directly from professionals who have cracked top companies.
15+ yrs
Combined mentoring experience
1500+
Students mentored to placements
1:1
Mock + feedback support
Sahil Kumar
PM @ FamPay
Product Manager
IIT Dhanbad Alumnus
Jitendra Kumar
Founder
Industry Expert
CrackNonTech
Exclusive Job Portal
Your shortcut to the right opportunity.
Cracknontech's job portal brings curated internships and full-time roles from trusted companiesβupdated weekly and ready to apply.
300+
Internships Added Weekly
500+
Full-time Jobs
100%
Free for CrackNonTech Students
Only
Verified Opportunities
Curated for Non-Tech Roles
Every listing is filtered and verified for Data, Business, Product, and consulting-aligned roles.
Direct Company Partnerships
Our team tracks opportunities from top employers and aggregates them in one clean feed.
Priority Application Support
Get application guidance, resume support, and interview tips before applying.
All JobsInternshipFull-timeRemote
L
Data Analyst Internship at Lumos Labs
Lumos Labs
BangaloreInternship2 days ago
View details
S
Shiprocket is Hiring β Data Analyst
Shiprocket
GurgaonFull-time1 day ago
View details
B
BCG Vantage is Hiring Analyst
BCG Vantage
GurugramFull-time3 hours ago
View details
12 new jobs added today
2,500+ Active Users
Join Our WhatsApp Community!
Join for daily job updates, interview tips, career advice, and exclusive resources to boost your career!
We don't spam π
Cohort starts on10th June
Time Commitment8-10 hours / week
Cost
βΉ8,999βΉ17,998