Advanced Data Analysis Course (SQL, Power BI & Python) in Kubwa, Abuja
Move beyond spreadsheets. This course teaches the tools data analysts use every day: SQL for pulling data from databases, Power BI for interactive dashboards, and an optional Python track for automation and deeper analysis.
About this course
Move beyond spreadsheets. This course teaches the tools data analysts use every day: SQL for pulling data from databases, Power BI for interactive dashboards, and an optional Python track for automation and deeper analysis.
You work through real business questions from start to finish, from querying the data to presenting a dashboard that decision-makers can use.
What you'll learn
- Write SQL queries in PostgreSQL to filter, join and aggregate data
- Clean and model data in Power BI using Power Query
- Build interactive Power BI dashboards and reports
- Use Python and pandas to clean and analyse data (optional track)
- Turn analysis into clear, practical recommendations
Course outline
1 SQL with PostgreSQL
- SELECT, WHERE and ORDER BY
- Joining tables
- GROUP BY and aggregate functions
2 Power BI
- Power Query and data transformation
- Data modelling and relationships
- DAX measures basics
3 Dashboards and storytelling
- Visual design principles
- Interactive filters and drill-through
- Publishing and sharing reports
4 Python for data (optional)
- Python basics for analysts
- Cleaning and analysis with pandas
- Charts with matplotlib
5 Capstone project
- End-to-end analysis project
- Portfolio-ready dashboard
- Presenting your insights
Who this course is for
- Graduates of our beginner data analysis course
- Excel users ready to move on to SQL and BI tools
- Professionals moving into data analyst roles
Tools you'll use
Requirements
Comfortable with Excel formulas and PivotTables, or completion of Data Analysis (Beginner to Intermediate).
Frequently asked questions
Is Python required?
No. The Python track is optional. You can complete the course with SQL and Power BI alone.
Will I have a project to show employers?
Yes. The course ends with a capstone dashboard you can share with employers.
How much does the Advanced Data Analysis Course (SQL, Power BI & Python) cost?
Send us a message on WhatsApp and we'll reply with the current fee for the Advanced Data Analysis Course (SQL, Power BI & Python), the available class times and the next start date.
Can I take this course online?
Yes. We offer both in-person classes at our Kubwa centre and live online classes, so you can choose what suits your schedule and location.
Will I get a certificate?
We issue certificates for most of our courses. Ask us when you enrol and we will confirm the certificate for this course.
Ready to start Advanced Data Analysis Course (SQL, Power BI & Python)?
Message us on WhatsApp and we'll send you the current fee, class times and the next start date.