Data Analysis for Beginners: Excel, SQL and Dashboards Explained

Businesses today collect huge amounts of data: sales records, customer behaviour, website visits, survey answers. But data on its own is useless until someone turns it into clear answers. That person is the data analyst, and it is one of the most accessible tech careers for beginners.

What does a data analyst actually do?

A typical analyst's work follows a simple loop:

1. Ask the question. For example: why did sales drop last month?
2. Collect the data from spreadsheets, databases or tools.
3. Clean the data, fixing duplicates, missing values and errors.
4. Analyse it, using formulas, queries and summaries to find patterns.
5. Visualise the results in charts and dashboards.
6. Tell the story, explaining what the numbers mean and what to do next.

The last step is the most valuable. A great analyst does not just produce charts; they help people decide.

Skill 1: Excel

Excel is where most analysts start, and many still use it daily. Focus on:

• Cleaning data: removing duplicates, fixing text and dates.
• Formulas: SUM, IF, VLOOKUP or XLOOKUP, and COUNTIF.
• Pivot tables to summarise large datasets quickly.
• Basic charts to show trends and comparisons.

Skill 2: SQL

SQL is the language used to ask questions of databases. When data is too large for a spreadsheet, you use SQL. Beginners should learn how to:

• Select and filter data with SELECT and WHERE.
• Sort and group results with ORDER BY and GROUP BY.
• Combine tables with JOIN.
• Calculate totals and averages with aggregate functions.

SQL is readable and logical, and most people find the basics learnable in a few weeks of practice.

Skill 3: Data visualisation and dashboards

Dashboards turn analysis into something anyone can understand at a glance. Tools such as Power BI, Tableau and Google Looker Studio let you build interactive charts. The key skills are choosing the right chart, keeping layouts clean and highlighting what matters.

Skill 4: Communication and business thinking

Technical skill gets you started. Communication gets you promoted. Learn to explain findings in simple language, to link numbers to business goals and to say clearly what the data does and does not prove.

How our 12-week Data Analysis programme is structured

Our Data Analysis programme follows this same path. You work with Excel and SQL for analysis and learn data visualisation and dashboards, with practical projects along the way. It is designed for beginners, and you can start now and pay later.

Practice projects for your portfolio

• Sales analysis: clean a sales dataset and build a dashboard showing the best products and months.
• Customer survey: analyse survey results and present three clear recommendations.
• Personal finance tracker: design a dashboard that shows spending patterns.
• Public data project: choose a public dataset on a topic you care about and tell a story with it.

For each one, write a short summary: the question, the method, the finding and the recommendation.

Jobs you can aim for

Common entry points include Data Analyst, Business Analyst and Reporting Specialist. Analysts work in banks, telecoms, retail, logistics, healthcare, media and start-ups, as well as in freelance roles. Data skills also pair well with AI and Automation, because automated workflows depend on clean, well-understood data.

Common beginner mistakes

• Jumping into advanced tools before mastering Excel basics.
• Making charts that look impressive but answer nothing.
• Working only with clean, perfect datasets instead of messy real ones.
• Not explaining your findings in plain language.

Want to start? Explore the Data Analysis programme, or read our beginner guide to starting a tech career first.