Data Analytics with SQL and Power BI
Take a messy spreadsheet and turn it into an answer somebody will act on. Study at your own pace.
- Any time
- 8 weeks
- Online
- Beginner
One payment, in full, when you enrol. There are no instalments.
You enrol yourself. There is no application to wait on.
- 3
- 5
- 4h 5m
- 1
Written for beginners.
Taught online, at your own pace: you start when you enrol and set your own rhythm.
Most analysis work is not modelling; it is finding out what is wrong with the data, fixing it honestly, asking the right question of it, and saying what you found in a way a manager can act on. That is what this course is about.
3 outcomes, each one assessed.
Each outcome is judged on the work you hand in, and the result is recorded on your learning record.
Clean a dataset without losing what matters
Find the duplicates, the gaps and the inconsistent categories, and deal with them.
- Prepare business dataCompetent
Answer a business question in SQL
Joins and aggregates that answer what was asked, checked before they are sent.
- Answer questions with SQLCompetent
Build a report somebody reads
A dashboard that says what changed and what to do, not one with every column on it.
- Report findings in a dashboardCompetent
Levels run introduced, developing, competent and advanced, on Meridian Institute of Technology's own competency framework.
What you will be taught
3 modules · 5 lessons · 4h 5m of taught material
- 01
Before you analyse anything
- What is wrong with this spreadsheet
- Cleaning honestly
- 02
Asking the data
- Joins, and what they do to your row count
- Sense-checking an answer
- 03
Saying what you found
- A dashboard with a point of view
What you hand in
Each piece is reviewed by the academy's assessors, and the result is recorded on your learning record.
Final project: an analysis and its dashboard
Clean the supplied dataset, answer the question, and build the report.
What counts as complete, and what you receive
Finish the lessons, hand in the work, and the programme is complete.
100%of the required lessons
100%of the required work handed in and approved
Certificate in Data Analytics
Issued by Meridian Institute of Technology when your assessed work is approved for every skill this programme promises. It lists each one and how it was judged, and anyone you give its code to can check it against the record on Alethris.
Take your place
There is no application to wait on.
- 1Enrol.
- 2Pay the fee in full.
- 3Your workspace opens straight away.
- ₦180,000
- Full refund within 30 days of paying, and none after that
- 365 days from joining