A ten-week certificate course in junior data analysis: reading a request properly, cleaning the export without touching the raw file, pivot tables that reconcile to the invoice total, SQL you can explain out loud, charts whose title is the finding, and dashboards in Looker Studio and Power BI. Taught on Google Sheets, Excel and a SQL sandbox, with one fictional marketing agency, Bluewick Studio, whose nine clients and six requesters stay consistent all course.
Start: October 12, 2026 · 11 AM WAT (Nigeria).
Fee: ₦200,000 for this track, or two ₦100,000 installments with the balance due three weeks later.
Format: Ten weeks: eight of lessons, assignments and one live class a week, then two practicum weeks of timed shifts on the track's job simulator. Your track’s live-session day and time are confirmed at enrolment.
The request and the decision it serves; metric, dimension and KPI; Bluewick Studio and the people who will ask you for numbers; the one-page report; precision and sanity checks; the spreadsheet habits that keep a sheet readable.
Text, numbers, dates and booleans; blanks, zeros and nulls; duplicates and which row wins; dates across time zones; lookups; data validation; the cleaning log; raw, staging, final.
When the average lies; rates and ratios; the outlier that is a typo; pivot tables and the four common views; totals that must reconcile; month over month and the seasonal trap; cohorts; benchmarks and where the number came from.
Tables, rows and keys; SELECT, FROM, WHERE; GROUP BY and HAVING; dates; JOIN and the rows that disappear on a bad LEFT JOIN; pulling the same number two ways; a query someone else can read; the query library.
Bar, line, table; when a pie chart is wrong; axes and the chart that exaggerated a dip; title as the finding; colour and accessibility; Looker Studio and Power BI; sharing without leaking a client's numbers.
Sales, marketing, support and finance questions; variance against plan; the two-paragraph summary; bad news without softening it; correlation is not cause; presenting to a director who reads on a phone; the questions you will get.
Personal data in your spreadsheets; the US state privacy overview and the NDPA; access and what you never share; health and payment data; repeatable cleaning and Python in Colab; raising an error in someone else's number; the misleading chart you refuse to make.
The intake template; estimating effort; the data dictionary; handing over a dashboard; working with engineers; the junior analyst portfolio; the take-home task; interview questions answered with your own work; remote analyst work from Nigeria; the capstone brief.
Timed shifts on the Bluewick analyst desk: requests arrive from Imani, Kofi and Anjali, exports come with problems, the Friday freeze is real, and every number you send is checked against the source.
More shifts including a downtime drill, a bad week you must report honestly, a request you must refuse as asked, and a tutor-marked capstone. Passing needs zero critical errors.
Plan for a computer, headset, reliable internet, a quiet practice space, and time for assignments. Review the student handbook for assessment, access, and policy details before payment.
Issued by SchoolRegistry Academy when the track’s assessment requirements are met. It is not third-party accreditation and does not promise job placement.
Questions: hello@schoolregistry.ng
Use Print → Save as PDF for a PDF copy. Course guide · September 2026.