Data

Clean a messy dataset and turn it into insights a manager can act on. Tests data handling, analytical thinking, and business communication.

Choose the right chart for a specific audience and cadence, and defend the choice. Tests metric selection, visual design, and executive communication.

Write, debug, and optimise SQL queries for real analytical work. Tests GROUP BY logic, window functions, joins, and query performance.

Interpret and communicate statistics honestly. Tests descriptive stats, hypothesis testing, and the ability to spot misleading analysis.

Build robust models in the most-used analytics tool in business. Tests pivot tables, what-if analysis, and simulation techniques.

Use pandas, numpy, and the Python data ecosystem for analysis and automation. Tests data wrangling, merging, and report generation.

Understand what to measure and why. Tests metric definition, root-cause analysis, and building metrics frameworks that drive decisions.

Turn data into narratives that move stakeholders to act. Tests executive communication, slide design, and handling conflicting data.

Design reliable data flows from source to warehouse. Tests pipeline design, schema evolution, and real-time streaming architecture.

Apply practical, applied machine learning thinking. Tests algorithm selection, model evaluation, and bias detection.

Design interactive, self-service analytics interfaces. Tests information hierarchy, filter design, and real-time monitoring.

Ensure data is trustworthy, compliant, and well-documented. Tests data dictionaries, quality checks, and privacy compliance.