T TestsWorld
← All crash courses
5-day Crash Course

Crack your Data Analyst aptitude & job tests in 5 days

For campus placement tests, off-campus drives, company online tests and recruiter screening rounds. A book you read like a real one: each day is a chapter with worked examples, diagrams, key-fact boxes and a quick question every few pages, then practice and a timed quiz.

🏆 The only course of its kind

The only crash course made to crack the online screening test of a recruitment drive. Recruiters run their screening rounds on TestsWorld, and this course is written from that same test blueprint — the same sections, the same timing, the same question styles — so you prepare for the round that decides your shortlist, not just "general aptitude".

109
book pages
66
diagrams & charts
186
worked examples
250
practice questions
Data Analyst · Crash Course
5-DAY PLAN
TestsWorld
The Crash Course
Data Analyst
Aptitude, technical & screening tests for freshers
109 pages 66 diagrams 250 questions
Day 1free to
read

Use it for any fresher Data Analyst test

🎓
Campus placements

The aptitude, reasoning and subject rounds most companies use when they hire from colleges.

🏢
Off-campus & company online tests

Timed online assessments with sections, cut-offs and negative-marking rules — learn how to pace them.

📨
Recruiter screening rounds

Screening tests sent by recruiters, including the ones on TestsWorld, follow the same section pattern.

🗣️
The interview after

Concepts explained in plain words, so you can also answer "why" when the interviewer asks.

📖 Reads like a book
Turn pages on phone or laptop, pick up where you stopped.
🖍 Your own revision notes
Highlight lines and add notes; they collect on one page.
✍️ Learn by doing
Step-by-step examples, "try it now" questions and timed mocks.

What's inside

Day 1 · 22 pages · ~90 min
Excel for Data Analysts: Formulas, Lookups, Conditional Sums, Pivot Tables and Charts
Free preview
  • ✔ Write formulas with the right cell references and predict their results
  • ✔ Use VLOOKUP, XLOOKUP and INDEX-MATCH and explain when each one fails
  • ✔ Answer business questions with IF, COUNTIFS, SUMIFS and AVERAGEIFS
  • ✔ Build a pivot table and pick the right chart for the story
📊 16 diagrams ✍️ 49 worked examples 📝 40 practice Qs ⏱ 10-Q quiz
Day 2 · 22 pages · ~90 min
SQL for Analysis: Filtering, GROUP BY, Joins, Window Functions and CTEs
🔒
  • ✔ Filter rows correctly with WHERE, IN, BETWEEN, LIKE and NULL checks
  • ✔ Summarise data with aggregates, GROUP BY and HAVING
  • ✔ Combine tables with INNER, LEFT and self joins without double counting
  • ✔ Use window functions and CTEs for rankings, running totals and growth
📊 13 diagrams ✍️ 34 worked examples 📝 40 practice Qs ⏱ 10-Q quiz
Day 3 · 22 pages · ~90 min
Statistics for Analysts: Averages, Spread, Distributions, Sampling & A/B Tests
🔒
  • ✔ Choose between mean, median and mode and defend the choice
  • ✔ Measure spread with range, IQR, variance and standard deviation, and spot outliers
  • ✔ Read distributions and use the normal 68-95-99.7 rule, z-scores and percentiles
  • ✔ Explain correlation vs causation, sampling, confidence intervals and run a basic A/B test
📊 13 diagrams ✍️ 38 worked examples 📝 40 practice Qs ⏱ 10-Q quiz
Day 4 · 21 pages · ~90 min
Python for Data: pandas, Cleaning and Charts
🔒
  • ✔ Load, inspect and select data in pandas with loc, iloc and boolean filters
  • ✔ Clean messy columns: types, text, dates, missing values and duplicates
  • ✔ Summarise and combine tables with groupby, pivot_table, merge and concat
  • ✔ Choose and draw the right chart, and follow a repeatable data cleaning checklist
📊 11 diagrams ✍️ 32 worked examples 📝 40 practice Qs ⏱ 10-Q quiz
Day 5 · 22 pages · ~90 min
Dashboards, Storytelling & the Interview Round
🔒
  • ✔ Define and calculate the KPIs that businesses track every week
  • ✔ Choose the right chart and lay out a clean, honest dashboard
  • ✔ Explain Power BI and Tableau building blocks: data model, DAX measures, dimensions, measures and LOD
  • ✔ Solve case-study questions with a metric tree and answer common interview questions with confidence
📊 13 diagrams ✍️ 33 worked examples 📝 40 practice Qs ⏱ 10-Q quiz
Full mock
60-minute test in the real format

Same sections and timing as the screening test, with a topic-by-topic result.

🔒 Included in the course

Get the full course

1. Choose your course
2. Applying for more than one kind of job?
⭐ More courses, better price
Total
₹499
90 days' access · UPI, cards, net banking

The pay link is also emailed to you as an invoice. Access opens automatically within minutes of payment, any time of day. Payments are processed by ZingLabs, the company that runs TestsWorld.