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
24th 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?
Week 0
Induction
- 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.
Week 1
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
Week 2
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
Week 3
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
Week 4
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
Week 5
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
Week 6
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
Week 7
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
Week 8
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.
Week / Theme
Wednesday 9–10:30 PM
- •(Live Session)
Sunday 9–10:30 PM
- •(Live Session)
Mentor Labs / Mocks
Mentor Mock Interviews
- •(Tue / Thu / Fri)
Placement Update
Placement Update
- •(Sat 10 PM)
Week 0 (Jun 8–14)
Wed Jun 10
- •Non-Tech Industry Overview (BA, DA, PA, Consultant)
- •Resume Crafting & Personal Narrative
Sun Jun 14
- •Aptitude & Puzzle-Solving Using AI
- •Project Building (Manus, Claude)
- •LinkedIn Optimization + Tools Setup
Mentor Labs / Mocks
Resume Round
- •(Peer intro + narrative check)
Placement Update
Sat Jun 14
- •Cohort kickoff + placement orientation
Week 1 (Jun 15–21)
Wed Jun 18
- •Guesstimates Overview
- •Universal Framework:
- • Structure → Assumptions → Calculate → Sanity Check
Sun Jun 22
- •Guesstimate Problem Practice:
- • Market sizes, populations, revenues
- •Live Q&A + Drill
Mentor Labs / Mocks
Mock 1: Guesstimate Round
- •Mock 2: Resume Round
- •Mock 3: Guesstimate (advanced)
Placement Update
Sat Jun 21
- •Placement Update #2
- •(Internship openings shared)
Week 2 (Jun 22–28)
Wed Jun 25
- •Case Study Overview & Why It Matters
- •Profitability Framework:
- • Revenue tree, cost structure, EBITDA
Sun Jun 29
- •Market Entry Framework:
- • TAM/SAM/SOM, 5 Forces, entry modes
- •M&A Overview: Synergies, due diligence, valuation
Mentor Labs / Mocks
Mock 1: Profitability Case
- •Mock 2: Market Entry Case
- •Mock 3: Resume Round
Placement Update
Sat Jun 28
- •Placement Update #3
- •(Consulting roles featured)
Week 3 (Jun 29– Jul 5) I
Wed Jul 2
- •Guesstimate Doubt Clarification
- •Advanced Applications:
- • Profitability + Market Entry + M&A
Sun Jul 6
- •GTM (Go-To-Market) Strategy Framework
- •Real Past Case Practice
- •Full Case Walkthrough
Mentor Labs / Mocks
Mock 1: Full Case Round
- •Mock 2: GTM Case
- •Mock 3: Company-Specific Round
Placement Update
Sat Jul 5
- •Placement Update #4
- •(BA/Consulting openings)
Week 4 (Jul 6–12)
Wed Jul 9
- •Advanced Excel: VLOOKUP, XLOOKUP, INDEX-MATCH
- •Statistical Formulas: SUMIF, COUNTIF, AVERAGEIF
- •Logic & Text/Date Functions
Sun Jul 13
- •Pivot Tables: Multi-level grouping, slicers
- •Looker Studio: Dashboards, filters, scorecards
- •Dashboard Design: Color, layout, storytelling
Mentor Labs / Mocks
Mock 1: Excel Round
- •Mock 2: Dashboard Case
- •Mock 3: Visualization Presentation
Placement Update
Sat Jul 12
- •Placement Update #5
- •(DA roles, analytics internships)
Week 5 (Jul 13–19)
Wed Jul 16
- •SQL Fundamentals: SELECT, WHERE, GROUP BY,
- • ORDER BY, HAVING
- •All SQL Functions: String, Date, Aggregate, Math
Sun Jul 20
- •Joins Mastery: INNER, LEFT, RIGHT, FULL OUTER,
- • CROSS, SELF
- •Subqueries & CTEs
Mentor Labs / Mocks
Mock 1: SQL Technical Round
- •Mock 2: Data Analyst Round
- •Mock 3: Company-Specific
Placement Update
Sat Jul 19
- •Placement Update #6
- •(SQL/DA heavy roles)
Week 6 (Jul 20–26)
Wed Jul 23
- •Python Intro: Syntax, Variables, Operators, I/O
- •Control Flow, Data Structures (lists, dicts, sets)
- •String Manipulation & Regular Expressions
Sun Jul 27
- •Pandas & NumPy (DataFrames, groupby, merge)
- •Data Cleaning: nulls, duplicates, outliers
- •Visualization: Matplotlib, Seaborn
Mentor Labs / Mocks
Mock 1: Python Technical
- •Mock 2: EDA Case
- •Mock 3: Company-Specific
Placement Update
Sat Jul 26
- •Placement Update #7
- •(Python/Data roles)
Week 7 (Jul 27– Aug 2)
Wed Jul 30
- •Product Case Studies Overview
- •KPI Questions & North Star Metric
- •Product Improvement Framework:
- • Identify → Prioritize → Design → Measure
Sun Aug 3
- •RCA (Root Cause Analysis):
- • Why a metric dropped — structured investigation
- •GTM Product Launch Playbook
- •RAC Framework
Mentor Labs / Mocks
Mock 1: Product Case
- •Mock 2: KPI Round
- •Mock 3: Company-Specific PM Round
Placement Update
Sat Aug 2
- •Placement Update #8
- •(PM/APM internships)
Week 8 (Aug 3–9) I + FINAL
Wed Aug 6
- •Agile & Scrum: Sprints, standups, backlogs
- •Product Lifecycle & Roadmaps (RICE, MoSCoW)
- •Wireframing & Prototyping: Figma, Balsamiq
Sun Aug 10
- •Writing PRDs & MRDs
- •Company-Specific Prep:
- • Unifyapps, AdvantageClub, Meesho PM formats
- •Final Q&A + Wrap-up
Mentor Labs / Mocks
Mock 1: Product Case
- •Mock 2: KPI Round
- •Mock 3: PM Company-Specific
Placement Update
Sat Aug 9
- •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 Commitment12-14 hours / week
Cost
₹8,999₹17,998