Scope the request first.
Scoping a request: who, what decision, what done looks like
Learn · Practice · Apply PROFESSIONAL CERTIFICATE · 10 WEEKS
Turn a messy export
into a number a manager trusts.
Data Analyst Certificate
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.
YOUR NEXT COHORTA fresh start. A focused ten weeks.
—DAYS
:—HRS
:—MIN
Not sure this course is right for you? Find your training path ↗
Or try a sample exercise—no sign-up✓ Beginner-friendly foundations✓ Practice-led learning
Training for remote work. A certificate does not guarantee employment.
PICTURE YOUR NEXT CHAPTERYou reach for a spreadsheet when a number sounds wrong. Learn the job where that instinct gets paid.See the work you’ll practise
10 weeksA structured learning journey
45+ hoursCore course training
Learn + practiceLessons, quizzes & assignments
Assessed skillsKnowledge & practical tasks
THE SKILL BEHIND THE OPPORTUNITYDon’t just know what to say.
Don’t just know what to say.
Know what to do next.
Ten-week certificate course in junior data analysis for remote teams: cleaning, pivot tables, SQL, charts, Looker Studio and Power BI dashboards and the weekly report, taught on Google Sheets, Excel and a SQL sandbox with a two-week practicum.
Never edit the raw export.
Cleaning with a log: raw, staging, final
Learn · Practice · ApplyTitle the chart with the finding.
Lookups and joins in Sheets and Excel
Learn · Practice · ApplyYOUR PRACTICAL TOOLKIT
Google Sheets and Excel · SQL · Looker Studio · Power BI Desktop · Python in Colab, gently · Slack, Notion and the request queue
LESS IMAGINING. MORE UNDERSTANDING.Picture yourself
Picture yourself
doing the work.
Move from tidy sheets to cleaned data, SQL you can explain, and a weekly report a director reads on a phone. Select a moment below to look inside the practice.
01A request lands.Three things are settled before the dataset is opened.↗
Friday request queue · Bluewick Studio, a fictional marketing agency
THE REQUEST
YOUR NEXT MOVE
Confirm the decision it serves and what done looks like: leads, deals won, cost per lead.
A number without a decision behind it is a report nobody uses.
02The export is a mess.Blanks, zeros and nulls are three different things.↗
Friday request queue · Bluewick Studio, a fictional marketing agency
THE CLEAN
YOUR NEXT MOVE
Copy to staging, fix each class of problem, and write every change in the cleaning log.
Never edit the raw export.
03Two numbers disagree.Pull the same number two ways to prove it.↗
Friday request queue · Bluewick Studio, a fictional marketing agency
THE CHECK
YOUR NEXT MOVE
Trace the gap to its cause before anyone sees either number.
A total that does not reconcile is not finished.
04Report a bad week.Plainly, without softening it and without panic.↗
Friday request queue · Bluewick Studio, a fictional marketing agency
THE SUMMARY
YOUR NEXT MOVE
Two paragraphs: what happened, what it means, what we suggest checking.
Honest reporting is the whole product.
Based on the Academy’s course content and signed-in Playground. Previewing these steps does not create an attempt or save a score.
Try the no-sign-up exercise ↗What will you learn in data analyst training?
SchoolRegistry Academy’s Data Analyst course is a ten-week online programme for beginners and career changers in Nigeria. First, students learn to scope a request, clean an export with a log, and summarise with averages, rates, pivot tables and trends in Google Sheets and Excel. Second, students practise SQL in a sandbox, charts whose title is the finding, and dashboards in Looker Studio and Power BI, on Bluewick Studio, a fictional US marketing agency whose numbers stay consistent all course. Third, tutor-reviewed assignments, a two-week practicum on the Bluewick analyst desk and a capstone create evidence of applied analytical judgment. The October 2026 cohort follows a daily study plan with one live class a week. Certification requires the published completion rules, full tuition coverage and an 80% overall result. The course does not promise employment or income, and it is not a Microsoft or Google certification.
How the Academy supports your progress
AI study support
Ask academic questions in the lesson player. The assistant uses lesson context but does not answer assignments or grade your work.
Practical task boards
Manage personal work and participate in assigned team tasks with columns, dependencies, comments and history.
Feedback and revision
Use tutor feedback, explain your changes and resubmit while the original and revised evidence remain available for review.
Your assessed portfolio is private by default. Sharing is optional and revocable. Available learning-media formats depend on the lesson; caption and low-bandwidth processing is still being completed across the library.
DESIGNED AROUND DOINGA course you
A course you
participate in.
Not just watch.
Build a habit of learning, applying, and improving. Each part of the week gives the next one a purpose.
Explore your ten weeks ↗THROUGH THE WEEK
Learn in focused sessions.
Work through self-paced lessons and check your understanding with module quizzes.
THROUGHOUT THE WEEK
Put the lesson to work.
Apply what you’ve learned through assignments and track-specific practical exercises.
ONCE A WEEK
Practice. Get feedback. Improve.
Join your track’s live session and submit your weekly assignment on the cohort schedule.
YOUR LEARNING ROADMAPTen weeks.
Ten weeks.
A stronger
skill set.
From the foundations to your final practical assessment, each stage builds on the last.
A clear standard at every step.
Module quizzes check understanding before you move forward. The final assessment includes written and practical work, then two practicum weeks on the job simulator.
01WEEK 1What a data analyst actually does+
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.
- What a remote data analyst does all day, and for whom
- The request: who asked, what decision it serves, what "done" looks like
- Sanity checks: does this number make sense before anyone sees it
- Formulas that analysts use every day: SUM, AVERAGE, COUNTIF, SUMIF, IF
02WEEK 2Cleaning data without breaking it+
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.
- Blanks, zeros and nulls are three different things
- Duplicates: finding them, deciding which row wins
- VLOOKUP, XLOOKUP and INDEX MATCH: joining two sheets without breaking either
- Raw, staging, final: never edit the export
03WEEK 3Summarising: averages, rates, pivots and trends+
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.
- Sum, average, median and mode, and when each one lies
- Rows, columns, values, filters: building the four common views
- Moving averages and why one bad week is not a trend
- Percent of total, percent change and percentage points: three different things
04WEEK 4SQL: reading the database behind the CRM+
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.
- SELECT, FROM, WHERE: reading a table
- GROUP BY and aggregate functions: sums by client, counts by month
- LEFT JOIN and the rows that disappear when you get it wrong
- Pulling the same number two ways to prove it
05WEEK 5Charts and dashboards+
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.
- Axes, scales and the chart that exaggerated a dip
- Title as the finding, not the topic
- Looker Studio: connecting a sheet, building the first page
- Who can see what: sharing a dashboard without leaking a client's numbers
06WEEK 6The weekly report and the honest summary+
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.
- The two-paragraph summary: what happened, what it means, what we suggest checking
- Bad news: how to report a falling number without softening it or panicking anyone
- Correlation is not cause: the claim you do not make
- Questions you will get and the honest answers: "are you sure", "why", "what should we do"
07WEEK 7Data you must protect, and requests you must push back on+
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.
- Personal data in your spreadsheets: what counts and why it matters
- Access: what you are given, what you ask for, what you never share
- Errors you found in someone else's number: how to raise it
- Requests you should push back on: the misleading chart, the cherry-picked range
08WEEK 8Working with requesters, and the capstone+
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.
- The intake template: turning "can you pull the numbers" into a request
- Documentation a colleague can follow: the data dictionary
- Three honest projects: what a junior analyst portfolio contains
- The capstone brief: what you will build in the practicum
09WEEK 9Practicum, part one+
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.
10WEEK 10Practicum, part two+
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.
TAKE A CLOSER LOOK
Your next step, on your terms.
Keep the curriculum, fees, start date, and study checklist in one handy course guide.
A SMALL TASTE OF THE TRAININGA moment of judgment.
A moment of judgment.
What would you do?
Start with good judgment. Try this illustrative exercise and see the reasoning behind a useful response.
SAMPLE EXERCISE No sign-up. No score saved.
PRACTICAL JUDGMENT01 / 01
Kofi, head of marketing, messages: can you pull the lead numbers for the client review?
Choose your next response.
sr / SCHOOLREGISTRY ACADEMYCERTIFICATE OF ACHIEVEMENTEarned through
Earned through
demonstrated skill.
Data Analyst Certificate
KNOWLEDGE
COMMUNICATION
EXECUTIONSR
ACADEMY
COMMUNICATION
EXECUTIONSR
ACADEMY
SAMPLE DESIGN · NOT AN ISSUED CREDENTIAL
MORE THAN COURSE COMPLETIONA certificate.
A certificate.
And the work behind it.
The SchoolRegistry Academy certificate is assessed through knowledge and practical tasks—not simply time spent watching lessons.
- A written assessment of your understanding
- Track-specific practical assessment
- Applied work that demonstrates your skills
- A unique certificate ID and verification page
Issued by SchoolRegistry Academy. This is not a third-party accreditation or a guarantee of employment.
MAKE AN INFORMED CHOICEIs this your
Is this your
next step?
A good fit if you…
- You already reach for a spreadsheet when someone says a number that sounds wrong, and you want to be the person whose numbers are trusted.
- You can ask a requester what decision the number serves before you start pulling data, instead of guessing and producing a report nobody uses.
- You are willing to learn SQL properly, ten queries at a time in a sandbox, rather than staying inside the one tool you know.
Plan for the practicalities.
A computer, headset, reliable internet, and a quiet place to practice will help you participate. Check the live-session schedule before enrolling.
Future US-client work may involve afternoon or evening hours in Nigeria.
GIVE YOUR LEARNING A DIRECTIONSkills with a
Skills with a
role in mind.
Roles this training prepares you to pursue. Start with the work you want to do, then build the skills to demonstrate it.
Junior Data Analyst
Answer requests from sales, marketing, support and finance with cleaned data and clear charts.
YOUR TRAINING CONNECTION
Scoping, cleaning, pivots, SQL and the weekly report.
Reporting Analyst
Own a recurring dashboard and the summary that goes with it, and keep it honest when the source changes.
YOUR TRAINING CONNECTION
Looker Studio and Power BI dashboards with reconciled totals.
Operations or Marketing Analyst
Sit inside one team and turn its questions into numbers that drive a decision.
YOUR TRAINING CONNECTION
Funnel, cost per lead, variance against plan.
Employers may require experience with a specific BI tool or a vendor certification such as Microsoft PL-300. This is a foundation for junior analysis; it is not data engineering or data science. Employment is not guaranteed; role titles and hiring requirements vary by employer.
THE SKILL IS ONLY PART OF YOUR STORY
Explore enrollment ↗Learn how to show what you can do.
The shared Career Readiness course covers your LinkedIn profile, résumé, interview practice, and getting paid as an international remote contractor. Describe practice honestly as training—not employment.
A vendor credential to add later, and the course shows you the path
The SchoolRegistry Academy certificate proves you did the work: the ten weeks, a supervised practicum and a capstone with zero critical errors, verifiable by any employer on our public verification page.
Many US postings for reporting analysts ask for Power BI, and Microsoft issues the PL-300 Power BI Data Analyst Associate certification for it. By Week 5 you will have built the Bluewick dashboard in Power BI Desktop, and Week 8 explains what the exam tests and how to prepare for it with your own work.
Together they answer the two questions a hiring manager asks: can you do the work (our certificate, assessed), and does the software vendor recognise your product knowledge (PL-300). One proves the skill; the other proves the tool.
PL-300 is issued and governed by Microsoft, not by SchoolRegistry Academy, and the exam carries a fee set by Microsoft; the learning material is free. We prepare you and show you the process, Microsoft awards the credential.
Talent should have
more than one way forward.
Need help with your course fee? Apply for a Founder's Scholarship before enrolling. You can also invite a family member, employer, or supporter to sponsor all or part of your training.
Scholarship awards depend on review and available budget. Sponsorship does not guarantee admission, certification, or employment.
INVEST IN A SKILL YOU CAN USEYour next chapter
Your next chapter
starts with
one clear step.
Choose your payment option. Get a clear view of the commitment before making your decision.
One track. The complete program.
- Ten-week structured curriculum: eight taught weeks and two practicum weeks
- Self-paced lessons and module quizzes
- One live practice session a week
- Weekly assignments and final assessment
- Certificate when requirements are met
DATA ANALYST CERTIFICATE10-week program
Pay in full or choose two installments at checkout.
₦250,000
Full course fee · or ₦125,000 × 2 installments
- Total course fee
- ₦250,000
- Format
- Online + live practice
- Cohort start
- Oct 12, 2026 · 11 AM WAT
Choose your payment plan securely at checkout.
Questions? Book a free advising call ↗Choose an available time with the Academy team. All times are WAT.
BEFORE YOU DECIDEGood questions.
Good questions.
Straight answers.
Do I need maths or a statistics background?+
No. The course covers sum, average, median, mode, rates, percent change and percentage points from the ground up, and it is strict about when each one lies. What you need is care with numbers, the habit of checking a total against its source, and the discipline to ask what decision a request serves.
Which tools does the course use?+
Google Sheets and Excel for cleaning, formulas and pivot tables; a SQL sandbox holding Bluewick's tables; Looker Studio and Power BI Desktop for dashboards; and an optional pair of lessons in Python on Google Colab. All of them run on free tiers or trials.
Is this a coding course?+
No. SQL is taught as reading a database, ten queries at a time, and the Python lessons are optional. The job the course prepares you for is the junior or reporting analyst on a remote team, not a data engineer or scientist.
Who will I be working for in the exercises?+
Bluewick Studio, a fictional US marketing agency with nine clients and six people who send you requests. Their numbers are one dataset that stays consistent from Week 1 to the capstone, so the pivot you build in Week 3 must match the query you write in Week 4 and the dashboard you publish in Week 5.
Is there a certificate at the end?+
Yes. A SchoolRegistry Academy certificate with a unique ID and a public verification page is issued when the published completion rules are met, including the final assessment and the practicum with zero critical errors.
When does the cohort begin?+
October 12, 2026 at 11:00 AM WAT (Nigeria). Each track has one live class a week; the day is confirmed in your enrollment information.
Is a job guaranteed?+
No. The Academy develops and assesses skills. Employment depends on your performance, employer requirements, and available roles.
What does the fee include?+
₦250,000 covers this track. You can pay in full or in two ₦125,000 installments, with the balance due three weeks later. Review the handbook and checkout terms before paying.
A little clarity.
A more confident decision.
Talk through this course, your experience and how to get started. Choose a time from the Academy team’s shared availability.
See available advising times ↗Four more ways to move forward.
A certificate should be
easy to check.
Employers and partners can confirm the current status of a shared SchoolRegistry Academy certificate using its 12-character ID.
Verify a certificate ↗Related career guides
Use these existing SchoolRegistry guides to compare the wider career decision before you enroll.
BUILD THE SKILL. PRACTICE THE WORK.Your next opportunity
Explore your enrollment ↗
Your next opportunity
deserves preparation.
Explore your enrollment ↗Data Analyst Certificate · SchoolRegistry Academy