NSDP Naujawan Skills Development Program home
LoginApply Now
Home
Laptop SchemeAsaan Karobar Card
Jobs & InternshipsHow to Apply
Home/Articles/In-demand skills/Data analysis for beginners: spreadsheets, SQL and Python

In-demand skills

Data analysis for beginners: spreadsheets, SQL and Python

Every organisation collects data and needs people who can turn it into answers. Start with spreadsheets, then add SQL and Python.

NSDP Editorial Team1 Nov 20261 min read
A bar chart with a rising trend line
In this article
  1. Start with spreadsheets
  2. Learn SQL
  3. Add Python
  4. Communicate the results
  5. Projects to build

Banks, telecoms, hospitals, retailers and government offices all collect data. People who can clean it, analyse it and explain it clearly are needed in almost every sector.

Start with spreadsheets

Excel or Google Sheets are where most data work begins. Learn:

  • Sorting, filtering and removing duplicates.
  • Formulas such as SUMIFS, COUNTIFS and XLOOKUP.
  • Pivot tables to summarise thousands of rows.
  • Charts that make one point clearly.

Practice: take a month of your household or shop expenses and build a summary by category.

Learn SQL

SQL is the language used to ask questions of databases. Learn SELECT, WHERE, GROUP BY and JOIN. With these four ideas you can answer most business questions.

Add Python

Python, with the pandas library, handles data too large or messy for a spreadsheet. Learn to load a file, clean columns, group and summarise, and draw a chart.

Communicate the results

An analysis is only useful if people understand it. For every project, write three sentences: the question, what the data shows, and what you recommend.

Projects to build

  1. Analyse public data on a topic you care about, such as weather or cricket scores.
  2. Build a sales dashboard from a sample dataset.
  3. Compare prices of a product across months and explain the trend.

NSDP's data courses are listed on the courses page, with the monthly fee and length of each.

Data analysisExcelPython

Questions and answers

Do I need strong maths for data analysis?+

Basic maths such as percentages and averages is enough to start. You learn the statistics you need as you go.

In this article

  1. Start with spreadsheets
  2. Learn SQL
  3. Add Python
  4. Communicate the results
  5. Projects to build

Study with NSDP

Three ways to learn, one monthly fee

  • Self-paced online: PKR 1,000 a month
  • Live Zoom classes: PKR 2,000 a month
  • On-campus classes: PKR 3,500 a month

24-hour refund policy. Certificates are issued by NSDP.

Apply now

Categories

  • In-demand skills
  • Careers & freelancing
  • Admissions & programme
  • Study tips
NSDP in your city

Read next

A chat with an AI assistant summarising a report

In-demand skills

Using AI tools at work: practical skills for beginners

AI assistants can draft, summarise and analyse, but they also make mistakes. Learn where they help, where they do not, and how to check their work.

1 Nov 20261 min read

Overlapping colour circles and a colour palette

In-demand skills

Graphic design: from the basics to your first portfolio

Design is a skill you can learn step by step: layout, type, colour, the right software, and a portfolio that shows how you think.

1 Nov 20261 min read

A marketing funnel from reach to sales

In-demand skills

Digital marketing skills employers and clients look for

Social media, search, paid ads, content and analytics: what each skill involves, how to practise it, and how to show results.

1 Nov 20261 min read

Admissions are open

Ready to learn a skill with NSDP?

Self-paced, live Zoom and on-campus courses for all of Pakistan and overseas Pakistanis, with a monthly fee and a 24-hour refund policy.

Apply nowBrowse courses
NSDP logo

Your future starts with one application

آج ہی درخواست دیں، کل کا ہنر سیکھیں

Apply nowExplore courses
NSDP logoNSDP logo

Naujawan Skills Development Program

Recognised by the Speaker’s Office, Punjab Assembly

For students across Pakistan and overseas · پورے پاکستان اور بیرونِ ملک کے لیے

In affiliation with the Office of the Speaker, Provincial Assembly of the Punjab

Inaugurated by the Governor of Punjab, NSDP equips learners across Pakistan and overseas with in-demand digital skills, laptops and business support so they can learn, earn and build a career.

Learn

  • Self-paced online courses
  • Live Zoom classes
  • On-campus classes
  • Find a campus
  • Free demo sessions
  • Get your certificate
  • How NSDP ranks courses

Schemes & admission

  • Laptop Scheme
  • Asaan Karobar Card
  • Schemes transparency
  • Scholarships
  • How to apply
  • Apply now

Earn with NSDP

  • Become an instructor
  • Campus affiliation
  • Affiliate partner
  • Jobs & internships
  • Hire NSDP graduates

About

  • About us
  • NSDP across Pakistan
  • NSDP Skills Network (soon)
  • Success stories
  • Outcomes
  • Share your story
  • Student Ambassadors
  • Alumni directory
  • Events & news
  • Articles & guides
  • Courses by city
  • Help centre
  • FAQs
  • Contact us

Contact us

  • UAN Helpline0304-111-0985
  • WhatsApp0320-8797409
  • Emailsupport.department@nsdp.pk

Now on Google PlayDownload the NSDP Student app

Watch lessons, join live classes, take quizzes and get notified about new batches. Free on Google Play; the iPhone app is coming soon.

GET IT ONGoogle PlayComing soon on theApp Store
NSDP logo

© 2026 Naujawan Skills Development Program. All rights reserved.Recognised by the Office of the Speaker, Provincial Assembly of the Punjab · Inaugurated by the Governor of Punjab · For learners across Pakistan and overseas

Cancellation policyPrivacy policyTermsJobs & InternshipsFAQsContact