Skillnaija Start free

DATA & TECH

Data Analysis Foundations

Excel, SQL, Power BI, dashboards.

  • 13 lessons
  • ~4 hours
  • Beginner-friendly
  • Project + certificate

Free account required to open the lessons. Any price is shown before you pay.

What you'll learn

  • Excel
  • SQL
  • Power BI
  • Storytelling with data
  • Excel formulas, lookups and pivot tables
  • Cleaning messy data
  • SQL aggregation
  • Power Query, data models and DAX measures
  • Presenting insights to decision-makers

By the end you will be able to

  • Structure spreadsheets that do not break, with lookups, pivot tables and clean data conventions.
  • Write SQL to select, filter, aggregate and join data from a real database.
  • Build a Power BI dashboard from raw data with measures, filters and a clear story.
  • Turn analysis into a one-page recommendation that a manager acts on.

About this course

Go from spreadsheets to confident SQL and Power BI dashboards. Build a real sales dashboard for a small Lagos business.

For many years, Nigerian businesses often just “managed.” We'd open shop, sell market, make a small profit, and thank God. But things have changed. Competition is plenty, customers are smarter, and the economy is not smiling. The businesses truly shining today are not just managing; they are measuring and know their numbers.

Who it's for

For people who want the most transferable office skill of the decade: graduates in any discipline, accountants and admin staff drowning in spreadsheets, business owners who want to see their numbers, and anyone aiming at analyst roles in banks, fintech, telcos, FMCG and consulting. It starts from spreadsheets and assumes no coding.

Pay, demand and the market in Nigeria

Data analyst is one of the most advertised entry-level tech roles in Nigeria, and unlike software engineering it is open to graduates of any discipline. In 2026 entry-level analysts earn ₦150,000 to ₦350,000 a month at Nigerian companies, ₦400,000 to ₦900,000 with two or three years' experience, and $1,500 to $4,000 a month in remote roles for foreign companies. Freelance dashboard projects for SMEs pay ₦50,000 to ₦300,000 each. Excel and SQL are asked for in almost every listing; Power BI or Tableau in most.

Tools and what it costs to start

Google Sheets or Excel, a free SQL environment (the course uses a browser-based one, no installation), and Power BI Desktop (free, Windows) — or the free tier of a cloud alternative if you are on a Mac or a phone. A laptop is needed for Power BI; the spreadsheet and SQL lessons work on a phone in a pinch.

The lessons 13 lessons, ending in a graded project

  1. 1Why data matters in Nigerian businesses8 min
  2. 2Spreadsheets that don't break14 min
  3. 3Excel totals that answer real questions: SUM and SUMIFS13 min
  4. 4Excel labels and lookups: IF, XLOOKUP and locked cells16 min
  5. 5Cleaning messy Nigerian data16 min
  6. 6Pivot tables and charts that answer questions16 min
  7. 7SQL: your first SELECT12 min
  8. 8Joining tables without tears16 min
  9. 9SQL that answers business questions16 min
  10. 10Your first Power BI dashboard22 min
  11. 11Power BI: models, Power Query and your first measures17 min
  12. 12From numbers to decisions: telling the story16 min
  13. 13Project: SME sales dashboard60 min
  14. Project: Sales Dashboard for a Local BusinessGraded

THE PROJECT AND YOUR CERTIFICATE

Sales Dashboard for a Local Business

A link to your Google Sheet/Excel file (uploaded to Google Drive) containing the raw data, analysis, and dashboard, along with your written summary of findings and recommendations.

A sales dashboard for a small business, built from a provided dataset or your own: the cleaned data, the analysis, the dashboard and a written summary of findings and recommendations. It is graded on correctness, on whether the dashboard answers a business question, and on the quality of the recommendation.

Certificates on Skillnaija are earned, not issued for attendance: you submit this project, an examiner grades the real work against a published rubric (you need 65% to pass), and passing issues a certificate anyone can verify. If you don't pass yet, you get written feedback and can try again.

  • Data Collection & Organization (Is the data relevant, clean, and well-structured?)25%
  • Analysis & Insights (Are the insights meaningful and supported by the data?)30%
  • Dashboard Design & Visualization (Is the dashboard clear, easy to understand, and visually effective?)25%
  • Recommendations (Are the recommendations actionable and data-driven?)20%

See the full project brief, rubric and free workbook →

Frequently asked questions

Is Data Analysis Foundations free?

Most Skillnaija courses can be started free with a free account: your first two courses are free to start, then one new course each month. Some courses are paid; the course page in the app shows whether Data Analysis Foundations is one, and its price, before you pay. You can also buy any course on its own for twelve months, or open every course with the All-Access Pass. Certificates are never sold: you earn one by passing the course's project.

How long does Data Analysis Foundations take to complete?

8 weeks · ~5 hrs/week. There are 13 lessons, about 4 hours of material in total. You learn at your own pace and your progress is saved.

Do I need any experience to start Data Analysis Foundations?

Beginner-friendly. You can start from scratch — no prior experience is assumed.

What will I learn in Data Analysis Foundations?

You will build practical skills in Excel, SQL, Power BI, Storytelling with data, Excel formulas, lookups and pivot tables, Cleaning messy data, SQL aggregation, Power Query, data models and DAX measures, Presenting insights to decision-makers. Every lesson is written in plain English, with examples drawn from how the work is actually done and paid for, in Nigeria and beyond.

Do I get a certificate for Data Analysis Foundations?

Yes, but it has to be earned. You complete the course project — Sales Dashboard for a Local Business and submit it for grading. Passing the project issues a verifiable certificate; finishing the lessons alone does not.

Do I need maths or coding to become a data analyst?

Secondary-school maths is enough. SQL is a query language, not programming in the usual sense, and the course teaches it from the first SELECT. Python comes later, in the Data Science & Machine Learning course, if you want to go further.

Which data analysis course is best for beginners in Nigeria?

One that uses Nigerian data and ends with a real project, because employers ask to see a dashboard, not a certificate of attendance. This course does both and is free; pair it with Excel, Google Sheets & Dashboards if you want more spreadsheet depth.

Can I get a remote data analyst job from Nigeria?

Yes, and many do — usually after a year or two of local experience and a portfolio of two or three dashboards. The Get Your First Remote Job course covers the application side.

Ready to start Data Analysis Foundations?

It is self-paced, and it ends with something you can show an employer.

Start learning free