Data Analysis Skills for Any Job: Excel, SQL and Reports

Last reviewed: 27 September 2026.

You don't need to become a data scientist to have useful data analysis skills. In most offices in Pakistan, whether a bank branch, a pharma sales team, a school, an NGO or an e-commerce startup, the people who get noticed are not the ones who know the most tools. They're the ones who can look at a messy spreadsheet, find what matters, and explain it to their boss in a few clear lines.

This guide covers the practical data skills that help in almost any job, how to turn numbers into a one-page story that leads to a decision, and how to show these skills when you apply.

The data analysis skills that matter most (for non-analysts)

1. Spreadsheet basics done well

Excel or Google Sheets is still the main data tool in most Pakistani workplaces. Being solid at the basics is more valuable than knowing a little of many tools:

• Clean data: remove duplicates, fix inconsistent spellings ("Lhr", "Lahore", "lahore"), split and join columns.
• Core formulas: SUM, AVERAGE, COUNTIF/SUMIF, IF, and lookups (XLOOKUP or VLOOKUP).
• Pivot tables to summarise data by region, month or product.
• Simple charts: bar, line, and occasionally a table with conditional formatting.

Microsoft's own Excel help and training and Google's Sheets help are free and reliable.

2. Asking a clear question

Before you touch the data, write down the question in one sentence: "Which three branches had the biggest drop in sales this quarter, and why?" Most bad analysis comes from starting without a question.

3. Checking whether the numbers make sense

Do totals match the source? Are there missing months? Does one strange value distort the average? A quick sense-check prevents embarrassing mistakes in front of management.

4. Explaining the result simply

This is where most people fall short, and where you can stand out. More on this below.

The one-page data story

Bosses usually don't want fifteen slides. They want to know what happened, why it matters, and what to do next. A one-page summary does exactly that. Here's a structure that works:

1. Headline (one sentence): the main finding. "Sales in the South region fell 18% in Q2, mostly because of stock shortages in two products." (Use your real numbers.)
2. One chart: the single chart that best shows the finding. Label it clearly. Remove anything that doesn't help.
3. Three supporting points: short bullets with the key evidence.
4. What we don't know: name the missing data or uncertainty honestly. "We don't have stock data for March, so the April figure may be understated."
5. Recommendation: one or two specific next steps, with who should do them.

Naming what's missing is a sign of trust, not weakness. Managers remember people who tell them the limits of the data before someone else points them out.

Chart tips that make a big difference

• Use bar charts for comparing categories, line charts for trends over time.
• Avoid 3D charts and pie charts with many slices.
• Write the takeaway as the chart title: "South region sales fell after April" rather than "Sales by region".
• Highlight the one bar or line that matters in a stronger colour; make the rest grey.

A worked example from an ordinary job

Imagine Sana, an admin officer at a private school in Rawalpindi. Her principal complains that fee collection "feels slow this year". Sana doesn't have any analytics tools, just the fee register in Excel. She writes her question: "Are fees being paid later this year than last year, and for which classes?" She cleans the data (fixing class names written three different ways), adds a column for days late, and builds a pivot table by class and month.

Her one-page summary says: late payments rose mainly in two senior classes after a fee increase; most other classes are on time; she doesn't have data on sibling discounts, which may affect the picture. Her recommendation: send a polite reminder and offer an instalment option to parents in those two classes, then check again in six weeks. The principal acts on it the same day.

No coding, no dashboard, no data science. Just a clear question, clean data, one chart and an honest recommendation. That's the skill employers value, and it's exactly the kind of story to tell in an interview.

Where to practise (with real data)

You can build skill and proof using public data:

• The Pakistan Bureau of Statistics publishes data on prices, labour and more.
• The World Bank's Pakistan data page has long-term indicators.
• Your own life: track your monthly spending or your job applications and analyse them.
• At work: with permission, analyse a real (anonymised) dataset your team uses.

Pick one question, create one one-page story, and you have a portfolio piece.

Do you need Power BI, SQL or Python?

It depends on where you want to go:

• Staying in your current field but being "the data person": strong spreadsheets and one-page stories are usually enough. A dashboard tool like Power BI or Looker Studio is a useful next step.
• Moving towards analyst roles: add SQL (for getting data from databases) and a dashboard tool. The Google Data Analytics Certificate is one structured option; see our guide to Google Career Certificates.
• Aiming for data science: then Python, statistics and machine learning become necessary. That's a longer path.

Whatever you choose, the ability to explain results clearly remains the skill that gets you promoted.

Using AI tools with data (carefully)

AI assistants can help write formulas, suggest chart types or summarise findings. They can also make mistakes with numbers. Always check calculations against the data, and never paste confidential company or customer data into tools your employer hasn't approved. See AI skills for jobs.

How to list data analysis skills on your resume

• On your CV, describe a result: "Built a monthly sales summary in Excel that cut reporting time from two days to three hours."
• Add one or two one-page data stories to your portfolio (using public or anonymised data).
• In interviews, be ready to walk through one example: question, data, finding, recommendation, and what was missing.

Common mistakes

• Showing every chart you made instead of the one that matters.
• No clear question or recommendation.
• Hiding data problems until someone else finds them.
• Learning many tools superficially instead of mastering spreadsheets first.

Frequently asked questions

Should I use Excel or Google Sheets?

Use whichever your workplace uses. The skills (cleaning, formulas, pivot tables, charts) transfer easily between them.

Is Excel still worth learning in 2026?

Yes. It remains one of the most widely used tools in Pakistani offices and appears in many job ads.

How long does it take to get good at this?

With regular practice on real questions, most people see big improvement in a few weeks. Mastery comes from using it at work.

What if my job doesn't involve data?

Almost every job has some numbers: sales, attendance, costs, customer complaints. Start there.

What are basic data analysis skills?

Cleaning a messy sheet, sorting and filtering, a handful of formulas (SUMIFS, COUNTIFS, XLOOKUP or VLOOKUP), pivot tables, one clear chart, and two or three lines that explain what the numbers mean. SQL is the next step if your job pulls data from databases.

Try this this week

Pick one small question from your work or daily life. Answer it with a spreadsheet and write a one-page story: headline, one chart, three points, what's missing, and a recommendation. Show it to one person and ask if the message is clear. That page is proof you can take to your next interview.