Data Analyst Fundamentals
SQL, data cleaning, statistics and BI judgement — the toolkit behind every analyst job description.
Measures whether you can turn raw data into decisions: writing correct SQL (joins, aggregation, NULLs and window functions), cleaning and reshaping messy data, applying core statistics without common traps, choosing honest visualisations and defining metrics a business can act on.
What it measures
SQL Querying
Aggregation, HAVING, joins, NULLs, DISTINCT and window functions.
Data Cleaning
Duplicates, missing values, dates, outliers and join grain.
Statistics
Central tendency, spread, significance and correlation.
Visualisation & BI
Chart choice, honest axes and dashboards.
Analytical Thinking
Metric definitions, percentages and paradoxes.
Who it's for
- Aspiring data and business analysts
- MBA and commerce graduates moving into analytics
- Professionals who build reports in Excel, SQL or Power BI
How the test works
- 20 questions drawn at random from a larger bank, balanced across every skill area above.
- Answer options are shuffled for each candidate, and the timer keeps running once you start.
- Your answers save automatically. If your connection drops, reopen your link to continue.
- Score 70% or more to earn a verifiable ARISE certificate. You get 2 attempts.
Try a sample question
Which SQL clause sorts the result set?
FAQ