Could I be a Data Analyst?

What it is really like

A lot of your time is spent in spreadsheets, databases, and visualisation tools, turning raw numbers into charts and tables that other people can actually understand. You'll write queries to pull data, clean it (which is often messier and more tedious than it sounds), then build dashboards or reports that show patterns. The satisfaction comes when someone says 'oh, I didn't realise that was happening' or when your analysis directly changes a decision.

The harder part is that data rarely tells a simple story on its own. You have to make judgment calls about what matters, what might be misleading, and what's actually worth reporting versus what's noise. You'll often find yourself explaining why something looks one way in one dataset and a different way in another, or pushing back when someone asks you to present data in a way that would be technically correct but misleading. You're frequently translating between technical and non-technical people, which takes patience.

The work involves a lot of back-and-forth. Someone asks a question, you dig into the data, you come back with an answer, they ask three follow-up questions, and you're back in the data again. Some days feel repetitive, especially routine reporting. Other days you're solving a puzzle nobody's asked about before, and that can feel genuinely interesting, though it also means there's often no clear right answer.

What you would actually be doing

• You're handed a request on Monday morning to refresh the monthly sales report by Wednesday, pulling data from three different systems and checking your numbers twice because a small error could affect someone's bonus calculation.
• Your analysis suggests the team's new strategy is working, but the numbers are only slightly better than before and you're unsure whether the improvement is real or just random variation, so you need to decide what to tell your manager and how confident to sound.
• You present findings to a room of people with different interests in the outcome, and someone immediately questions your methodology or suggests you've missed something, requiring you to defend your approach while staying open to genuine flaws.

Want to feel what it is actually like?

Step into a few real situations from this role, then get an honest, behaviour-based read on how you approached the work. No score, no pass or fail.

Your first exploration is free and takes about 15 minutes. No signup needed to start.

More in the Career Library

• How Do You Know If You'd Be Good at a Career You've Never Tried?
• How to Work Out What Job Actually Suits You