by Mahendra Singh · Data Analytics Mentor
Learn Data Skills.
Crack Interviews.
Build Your Career.
Practice with real interview questions, hands-on labs, and expert resources — all in one place.
Tableau · Excel Real Interview PrepCompany &
scenario-based Hands-on PracticeSQL Labs · Projects
· Mock Interviews Track ProgressQuizzes · Badges
· Leaderboard Career GuidanceResume Tips
· Interview Strategies Get HiredBuild Skills
· Grow Your Career
Certification DumpPractice exams for top certifications
90 Day's AI LearningBecome an AI engineer in 12 weeks
Data Analyst RoadmapStep-by-step skill path on roadmap.sh
Live 1:1 with Mahendra SinghMock interview · career · resume — ₹250
12 fresh interview questions, every day
3 each from SQL, Power BI, Tableau and Excel — one Easy, one Medium, one Hard. New set every midnight. Tick them off to keep your streak.
Everything a data analyst interview covers
Pick a skill and start practicing real questions today.
Interview Preparation Journey
A clear path from your first lesson to your offer letter.
Learn
Go through topic-wise concepts and real questions.
Practice
Answer questions and quizzes at your own pace.
Hands-on
Run real SQL queries in the Practice Lab.
Mock Interview
Simulate a real interview and get feedback.
Track Progress
See your readiness score improve over time.
Get Hired
Walk into interviews prepared and confident.
Featured Interview Questions
A few real questions from the question bank — with full answers inside.
🚀 Practice Lab
Run real SQL queries against a live database, LeetCode-style — or paste your resume for an AI mock interview.
See where you stand
Every lesson you explore counts. The leaderboard ranks learners by topics explored and daily streak — sign in free and climb it.
- 🌐Public profile with your progress and certificates
- 🔥Daily streak — build and protect your longest run
- 📊Readiness score across SQL, Power BI, Tableau & Excel
- 🏆Top learners board, refreshed live
Pick a topic
How to give your introduction
The first 90 seconds decide the interview mood. Learn the exact formula with sample answers.
8 lessons →02📊Project explanation
How to explain your project so the panel is actually impressed — with a full sample walkthrough.
Framework + sample →03⚡Power BI questions
Scenario-based Power BI questions asked in real interviews — DAX, data modeling, performance.
18 full answers →04📈Tableau questions
Filters, LOD, blending, live vs extract, Tableau Server — the full developer question bank.
140+ questions →05🧮Excel questions
Pivot tables, XLOOKUP, Power Query and everything Excel an analyst must know.
80+ questions →06🗄️SQL questions
Real query-writing questions with copy-ready solutions — the round most people fail.
26 full answers →07🏢Company-wise questions
Real questions from TCS, Deloitte, Goldman Sachs, EATON, Virtusa & more — with answers.
10 companies →08📄Resume & Naukri profile
ATS-friendly resume rules and Naukri optimization to get more interview calls.
2 guides →09💼Business Analyst
BA interview guide — BRD vs FRD, elicitation, Agile, JIRA, scenario questions.
10+ questions & PDFs →10🏗️Data Warehousing
OLTP vs OLAP, star schema, ETL, SCD — the concepts behind every analytics job.
8 concepts →11🤖Data Science & AI
Python, statistics, machine learning and Generative AI questions — your next career level.
35+ questions →12🚀Practice Lab
Paste your resume for an AI mock interview, or run real SQL queries against a live database — LeetCode-style, Easy/Medium/Hard.
Mock interview + SQL sandbox →Why CrackAnalytics
Built by Mahendra Singh. Trusted by thousands.
450+ real questions
SQL, Power BI, Tableau, Excel, Data Science & AI — with full answers, not one-liners.
Company-wise questions
Real questions asked at TCS, Deloitte, Goldman Sachs, EATON, Virtusa & more.
Practice Lab
Run real SQL queries in a live sandbox, or take an AI mock interview.
Resume Builder ↗
Build a role-wise, ATS-friendly resume on Resumiq: live score, job-description match and Dexa AI help. Free.
Progress tracking
A readiness score and streak that reflect your real activity.
Free resource library
Guides, cheat sheets and a blog covering the whole data analyst path.
Three steps to interview-ready
No payment, no setup — start in under a minute.
Pick your skill
Choose a track and open real interview questions with full answers — grouped Easy, Medium and Hard.
Practise in the browser
Write real SQL in the Practice Lab, take quizzes and flashcards, or try an AI mock interview on your resume.
SELECT dept, AVG(salary) FROM employees GROUP BY dept HAVING AVG(salary) > 50000;
Build your streak
Sign in free to save progress, keep a daily streak, earn certificates and climb the leaderboard.
Loved by aspiring data analysts
Real reviews from students who prepared on CrackAnalytics.
Common questions
Everything about the free site and 1:1 sessions.
Is CrackAnalytics really free?
Yes — completely. All 450+ questions with answers, quizzes, flashcards, the Practice Lab, study plan, resource hub and resume builder are free for everyone. The only paid thing on the site is an optional live 1:1 session with Mahendra.
What are the 1:1 sessions and how much do they cost?
There are three types of 1-hour live sessions on Google Meet, each ₹250:
- Mock Interview — a real data analyst interview (SQL, Power BI, Tableau, Excel, projects, HR) with structured feedback at the end.
- Career Guidance — your skills, career path, projects, job search and switching strategy.
- Resume Discussion — a line-by-line review of your resume and Naukri/LinkedIn profile for data analyst roles.
What time slots are available?
All times are IST, 1 hour each.
- Monday – Friday: 9:00 – 10:00 AM
- Saturday & Sunday: 11 AM – 12 PM, 12 – 1 PM, 1 – 2 PM and 2 – 3 PM
Each slot is for one person only, so once a slot is booked it disappears from the form.
When is my booking confirmed?
Only after your ₹250 payment is successful. Filling the form alone does not reserve the slot. Once payment goes through you'll see a confirmation on screen with your payment ID, and the Google Meet link is sent to your email / WhatsApp before the session.
What should I keep ready for the session?
A laptop with a stable internet connection, working camera and mic, and a quiet place. For a resume discussion, share your resume link (Google Drive / PDF) in the form. For a mock interview, mention the role and tools you're preparing for so the questions match your target job.
What if the session is cancelled or rescheduled?
If Mahendra has to cancel or reschedule your session, or it can't happen because of any circumstance from our side, you can choose a new slot or get a full refund of ₹250.
Can I get a refund if I cancel or miss the session?
No. If you cancel your booking, don't join the call, or join too late for the session to happen, the ₹250 is non-refundable — the slot was reserved only for you. Read the full refund policy.
What payment methods are accepted?
Payments are handled securely by Razorpay — UPI, credit/debit cards, netbanking and wallets are all supported.
Need personal help? Book a 1-hour session.
The whole site is free. When you want a real person to interview you, plan your career or fix your resume — book a live Google Meet call. ₹250 per hour.
Booking confirmed!
Save your payment ID. The Google Meet link will reach your email / WhatsApp before the session. Please join on time.
Tell us what you are trying to learn
Stuck on a topic, found a mistake in an answer, or want a company's questions added? Send a message — Mahendra reads every one.
Start building your daily practice habit.
15 minutes a day. 12 fresh questions. Steady improvement across SQL, Power BI, Tableau & Excel.
Start today's Daily Quest → 100% free · No sign-up needed to start