Business Analyst

Almost every analyst, product and data role uses SQL to answer questions directly from company data.

Start with

• · Learn SELECT, WHERE, GROUP BY and JOIN on a practice dataset
• · Answer ten real questions about a public dataset

Finance, consulting and business roles rely on spreadsheets daily for analysis and communication.

Start with

• · Learn lookups, pivot tables and charts
• · Rebuild a simple budget or financial statement

Analysts are judged on how clearly they communicate findings, not just on the analysis itself.

Start with

• · Learn when to use bar, line and scatter charts
• · Build a one-page dashboard

Consulting case interviews and analyst roles test this directly.

Start with

• · Practise issue trees on everyday problems
• · Do two case interviews per week with a partner

Essays, research reports, policy memos and scholarship applications all depend on strong writing.

Start with

• · Write a one-page memo each week
• · Enter an essay competition

Interviews, pitches, Model UN and leadership roles all reward clear spoken communication.

Start with

• · Join a debate or Model UN club
• · Present a project in under five minutes

Every consulting, product and operations role involves running projects.

Start with

• · Plan your applications as a project with milestones
• · Learn basic agile practices