There are no items in your cart
Add More
Add More
Item Details | Price |
---|
A Live Projects-Only Course That Makes You Better A Better Analyst
Duration: 8 Weeks
Maximum Cohort Size: 20
100% Live Classes (Online)
Recording Availability: 1 year
Timing: Sat & Sun -> 11 AM - 1 PM (EST) / 8 AM - 10 AM (PST)
Instructor: Avan Vora
Most analysts know SQL, Python, or Power BI - but still struggle when the problem is vague, the data is messy and stakeholders expect clear answers.
That’s the gap this course fills.
In this live, hands-on accelerator (limited to <20 participants), you'll work on end-to-end, real-world projects - starting from an ambiguous project email and ending with an executive-ready presentation, just like in a real job. We focus on depth over breadth, simulating the problem-solving process at top companies. This isn't just about learning tools; it's about learning how to think, solve and influence - skills that matter more than ever in the age of AI.
About Me
Hi, I'm Avan. I've spent over 10+ years driving data-driven impact at top organizations. As a Data Analytics Consultant at McKinsey & Company (US) and a Senior Analytics Manager at Wayfair (US), I've lived the challenges of translating complex data into actionable business strategies after starting my career in 2014 right after an MS from Georgia Tech. Since then, I've successfully helped professionals from the US, Canada, and India elevate their skills and careers.
Who Is This For?
If you know basic SQL and want to get better at applying data skills to real business problems, this course is for you - regardless of job title.
Typical Backgrounds:
Business Analysts, Data Analysts, Product Managers, MBA students, and early-career professionals (0–5 years)
Companies Where Our Alumni Work:
Uber, Paypal, Freshworks, Chargebee, BrowserStack, Avalara, Everstage
Alumni From Top Institutions:
UT Dallas, Singapore Management University, Indian School of Business, BITS Pilani, MICA, IIFT
What You’ll Learn:
You will:
Live Cohorts for US & India Time Zones
I run two live cohorts - one aligned with US time zones, another with India. Sessions are interactive, mentorship-driven, and designed to simulate real work.
Want to See More?
Check out the demo session, project previews, and FAQs below.
Have questions? Feel free to WhatsApp me at +91 9372646902.
Past Cohort Stats
Avg. Rating
said this course provided excellent value for money
said their problem-solving, communication and storytelling skills improved significantly after the course
said they would consider doing another course with us
said they would recommend this program to others
Hi, I'm Avan Vora. I'm a former Senior Analytics Manager with 10 years of experience in Analytics & Data Science across the US and India.
After earning my Masters from Georgia Tech in 2012 in the US, I began as a Data Analyst, consulted with McKinsey and eventually led analytics teams at Wayfair and BrowserStack. I spent a decade in the US and returned to India in 2021.
Over the past decade, I have worked closely with Product Managers, business leaders and non-technical teams to turn data into business decisions. In the past year, I have mentored 250+ professionals and one thing became clear: what most courses teach is far from what real-world analytics work demands. This course is my way of bridging that gap.
I find it fulfilling to help people realize their full potential and I hope to impact many more lives!
To directly connect with me, drop a message on +91 9372646902
Day | Topic |
SQL Revision | |
1 | - Course Outline - Basic SQL Revision (Aggregate functions, Joins) Core Skills:Technical |
2 | - Advanced SQL Revision (including CTEs, subqueries & Window functions) Core Skills:Technical |
Project 1 | |
3 | Email from the VP of Growth (Preview) - Deconstructing the email - Figuring out next steps Understanding & gathering requirements - Meeting 1: VP (Growth) / Analytics - Asking the right questions from the data - What does a good problem statement look like & how to clearly define one? Core Skills: Business Acumen, Problem-solving & Communication |
4 | Breaking down a problem - Building a hypothesis/issue tree - Structured Thinking - Meeting 2: Data Engineering / Analytics - Converting business questions into data questions - Data Requirements - Importing data into MySQL - Understanding table relationships Core Skills: Business Acumen, Problem-solving, Domain Expertise |
5 | Data Cleaning (SQL) - Handling null values - Outlier detection - Identifying & handling duplicates - Data standardization Data Manipulation (SQL) - Temporary tables - Multiple table joins - Creating a master table Core Skills: Technical |
6 | Analysis (SQL) - Trend Analysis - Drill down technique - Choosing the right metrics Core Skills: Problem-solving, Technical |
7 | Analysis (continued) - Cohort Analysis (Advanced SQL) - Marketing strategy analysis - Data interpretation - Getting everything together - Building a story Dashboard (PowerBI) - Connect PowerBI to MySQL - Organizing information - Picking the right charts - Revenue Attribution & Impact Analysis Core Skills: Problem-solving, Technical |
8 | Storytelling (Presentation) - Designing an impactful presentation - Converting insights into recommendations - Proposing a project plan Resume - Showcasing the project on a resume Core Skills: Communication |
Project 2 | |
9 | Email from the VP of Marketing (Preview) - Deconstructing the email Understanding & gathering requirements - Breaking down the problem - Meeting 1: Analytics / Marketing Team - Marketing funnel - Total Addressable Market (TAM) & Targeting Core Skills: Business Acumen, Problem-solving & Communication |
10 | Analysis (Advanced SQL) - Understanding our customer - Choosing the right metrics - Understanding percentiles - Choosing metrics for segmentation - Building master table for analysis - Building a segmentation model Core Skills: Problem-solving, Technical, Domain Expertise |
11 | Dashboard (PowerBI) - Visualizing KPIs for customer segments - Choosing the right charts Storytelling (Presentation) - Getting everything together - Building a story - Marketing strategy recommendations - Proposing a project plan Resume - Showcasing the project on a resume Core Skills: Problem-solving, Communication |
Project 3 | |
12 | Email from the Manager, Service Operations (Preview) - Deconstructing the email Understanding & gathering requirements - Breaking Down The Problem - Meeting 1: Analytics / Operations Team - Initital hypotheses Core Skills: Business Acumen, Problem-solving & Communication |
13 | Analysis (Advanced SQL) - Exploratory data analysis - What impacts service experience? - Identifying opportunities - Choosing the right metrics - Designing the metrics Core Skills: Problem-solving, Technical, Domain Expertise |
14 | Dashboard (PowerBI) - Visualizing customer experience KPIs - Drill-through functions - Choosing the right charts Storytelling (Presentation) - Getting everything together - Building a story - Service strategy recommendations - Proposing a project plan Resume - Showcasing the project on a resume Core Skills: Problem-solving, Communication |
Student Presentations | |
15 | Present a project of your choice and get feedback on presentation and communication just as you would in a real job. Get insights from past experience of presenting to senior leadership. Core Skills: Communication |
Networking & Job Tips | |
16 | - Resume - Networking Core Skills: Communication, Networking |
Avan has been an exceptional analytics leader at Wayfair. He continuously identified and addressed key opportunities to improve post-order customer experience, while effectively analyzing and driving actionable insights from the large and complex data set (e.g. survey results, contact data, order/customer data, repeat rate). In addition, he built an extremely strong analytics team from scratch, while raising the hiring bar for broader organization and offering a hands-on coaching to lead his team’s ongoing success. Furthermore, he established an exceptional partnership with various cross-functional partners as an SME in Voice of the Customer and data analytics. I have been so fortunate to have worked with and learned from such an exceptional analytics and people leader over the last 3+ years.
Youngeun Kim (Director of Product) via Linkedin
It was an absolute delight to have Avan on my team. His pod handled our trickiest analyses and consistently delivered error-free work and actionable recommendations, even adding insights that I didn't think to ask about. I could send Avan ambiguous requests and rely on him to frame them, own the analysis, and work with both technical and business partners to see the project through. He continually gets rave reviews from both direct reports and stakeholders.
Kellie McDougal (Associate Director) via Linkedin
Strongly recommended.
If you are in a strategic role, Avan will transform you into someone who can:
1. Craft a shared understanding with data-driven narratives
2. Build concrete executive buy-ins and become their go-to-person
3. Earn genuine respect with well established thought leadership
Arun Kumar Ahuja (Senior PM) via Linkedin