14
Live Sessions
90 mins
Session Length
Applied Learning
Level
Professionals
Suitable For
Live Online
Delivery
UK Time
Time Zone
LEARNING OBJECTIVE
By the end of this course, you will be able to
Build an interactive Power BI dashboard from a structured dataset, complete with slicers, visuals and calculated measures.
Configure pandas and SQL pipelines to clean, filter, aggregate and reshape a real business dataset, not a pre-cleaned sample.
Automate data quality checks that catch bad rows before they reach a stakeholder's dashboard.
Integrate Python analysis output directly into a Power BI report so the two tools work as one pipeline, not two disconnected steps.
Present a dashboard walkthrough that answers a real business question, the deliverable a hiring manager actually wants to see.
TARGET LEARNER
Who this course is for
Career starters and graduates targeting data analyst or business intelligence roles who want a portfolio of real dashboards not just certification screenshots.
Professionals already working with data in Excel or basic tools who want to move to Python, pandas, SQL, and Power BI the toolkit data-driven organisations actually pay for.
Anyone seeking a promotion or role change into analytics who needs to demonstrate real analytical output, not just awareness of the tools.
If you see yourself in one of these, this course is built for you.
Prerequisites
What you need
No prior data analysis or Power BI experience is required.
Basic Python knowledge — variables and functions — is needed before joining.
A laptop with Python, Jupyter Notebook, and Power BI Desktop installed is required.
Power BI Desktop is free to download from the Microsoft website.
Basic SQL awareness is helpful but not essential and is briefly covered in the course.
COURSE OVERVIEW
What this course is about
Data Analysis with Python and Power BI is a structured, instructor-led programme for professionals who want to turn business data into clear, interactive analysis. The course covers pandas, SQL, and Power BI in depth, combining real business datasets with dashboard building throughout every session.
The programme runs across 14 one-and-a-half-hour live sessions over 7 weeks, progressing through data fundamentals, and pandas for data manipulation before finishing with SQL for data analysis, data visualisation, Power BI and DAX, and a capstone dashboard project. Every topic is applied to a real business dataset, not a pre-cleaned sample.
Basic Python knowledge is assumed throughout the course, with no prior Power BI experience required. A dataset is cleaned, analysed, and visualised from session one so learners are building toward a real dashboard throughout, not isolated exercises.
What the course covers:
Data Fundamentals: the end-to-end data analysis workflow.
Python for Data: pandas for cleaning, filtering, and reshaping data.
SQL: querying and aggregating business data.
Visualisation: matplotlib and Power BI, including DAX measures.
Capstone: an interactive Power BI dashboard built from a structured dataset.
CIRRICULUM
7 Modules. 14 live Sessions. Hundreds of small wins.
The curriculum starts with data fundamentals and pandas, then moves through SQL and data visualisation before finishing with Power BI, DAX, and a capstone dashboard project.
01
Data Fundamentals
Learn the analytical process how analysts approach data, distinguish data types, and structure a question before touching any tool and apply that thinking framework to a real business dataset you’ll analyse throughout the course.
02
pandas and Data Manipulation
Learn data manipulation with pandas filtering, grouping, joining, reshaping, and handling missing values and apply them to clean and transform real business datasets into analysis-ready form.
03
SQL for Data Analysis
Learn SQL for data analysis SELECT, aggregations, JOINs, subqueries, and window functions and apply them to extract business insights from a relational database using queries you’ll add to your portfolio.
04
Data Visualisation with matplotlib
Learn data visualisation with matplotlib and seaborn charts, histograms, scatter plots, and heatmaps and apply them to create visual narratives from your cleaned dataset that communicate insight to a non-technical audience.
05
Power BI Introduction
Learn Power BI fundamentals connecting data sources, building a data model, creating visuals, and publishing a report and apply them to build your first interactive dashboard from the dataset you’ve been working with.
06
Advanced Power BI and DAX
Learn advanced Power BI and DAX calculated columns, measures, time intelligence, and drill-through and apply them to build an executive-grade dashboard that answers complex multi-dimensional business questions.
07
Capstone Dashboard Project
Learn how to structure, finalise, and present a complete analytics project combining Python, SQL, and Power BI and apply all course learning to deliver and present a capstone dashboard to the cohort and mentor.
Course Types
We offer three structured learning paths based on your goals:
Crash Course (Fast-Track)
Quick, intensive courses designed to teach specific skills efficiently. Ideal for those upskilling fast or preparing for certifications.
DeepDive Program (Full Mastery)
Comprehensive, step-by-step learning for full mastery. For beginners and professionals seeking long-term, deep expertise.
MentorConnect (One-on-One)
Personalised mentorship with real-world guidance. Best for those who thrive with direct, expert-to-learner coaching.
Learning Approaches
We recognize that everyone learns differently, so we offer flexible learning formats to fit your needs:
One-on-One Training
Personalized, instructor-led coaching tailored to your learning speed.
Best for career-specific coaching or specialized training needs.
Small Batch Classes (2-5 learners)
Interactive, discussion-based learning in small groups.
Encourages collaboration, teamwork, and peer-to-peer engagement.
FAQ
1
Who is this course designed for?
This course is designed for career starters, business professionals, and anyone who works with data and wants to move beyond Excel. It is equally suited to those preparing for the Microsoft Power BI Data Analyst Associate (PL-300) pathway.
2
What prior experience do I need?
Basic Python knowledge variables and functions is recommended. Basic SQL awareness is helpful but not required. No prior data analysis or Power BI experience is needed.
3
What will I be able to do by the end?
You will be able to clean and manipulate real datasets with pandas, write SQL queries for data extraction, create compelling visualisations with matplotlib and seaborn, build interactive Power BI dashboards, and present data insights clearly to a non-technical audience.
4
How are the sessions structured?
Seven modules, 1.5 hours per session, 14 sessions over seven weeks. All sessions use real business datasets throughout.
5
What is EngagePro?
After each session you receive reference material covering pandas operations, visualisation techniques, and DAX formula guides. Each task involves analysing a real dataset and producing either a written insight or a Power BI visual. Dr Amara Osei reviews all submissions with data quality and insight quality scores.
6
What tools do I need?
A laptop with Python, Jupyter Notebook, and Power BI Desktop installed. All are free to download.
7
Will I receive a certificate?
Yes the ITLearnner Data Analysis with Python and Power BI Certificate on completion, with full alignment to the Microsoft PL-300 exam pathway for those who wish to pursue formal certification.
8
Will I be able to use Power BI after this course without a Microsoft licence?
Power BI Desktop is free to download and use for personal analysis and learning. Power BI Service, which enables sharing and collaboration, requires a Microsoft 365 licence, though a free trial is available. The course covers both tools so you understand the full workflow from data preparation to published dashboard.
9
What kinds of datasets will I work with during the course?
You will work with real-world datasets drawn from business, finance, and operations contexts. The course uses datasets that reflect the types of problems analysts encounter in actual roles (sales performance, operational efficiency, customer behaviour) so the analysis skills you develop are immediately applicable in a professional setting.
10
Does this course lead to any industry certifications?
The course provides strong preparation for the Microsoft Power BI Data Analyst Associate certification (PL-300) and complements Python data science certifications. ITLearnner provides guidance on which certifications to pursue next based on your career goals, whether you are heading towards a data analyst, business intelligence, or data engineering role.
Join Us Today
Welcome to ITLearnner, your gateway to a world of online education! We make it simple to register for our courses, helping you navigate through various categories to find the perfect match for your learning goals.
When signing up, we'll ask where you learned about us and if you have any references, making the process smooth and tailored to your needs.
Join us today and unlock your potential in the digital realm!