Data Analysis
Intermediate 5 weeks
Advanced Excel for Data Analysis
Master advanced Excel techniques for data cleaning, analysis, dashboard development, reporting and business decision-making.
View course Back to catalog
Data Analysis
Full Stack Data Analysis
Master Advanced Excel, SQL and Power BI to clean, analyse, transform and communicate real-world business data.
Register for This Course
Level
Beginner to Intermediate
Duration
8-9 weeks
Delivery
Physical & Live Online
Category
Data Analysis
Course overview
A practical, career-focused data analysis programme designed to take learners from spreadsheet-based analysis to professional business intelligence. Students learn Advanced Excel, SQL and Power BI through real-world datasets, practical exercises and portfolio projects.
Who it's for: Beginners, graduates, career switchers and professionals who want to develop practical data analysis and business intelligence skills.
What you will learn
- Use Advanced Excel to clean, analyse and automate business data
- Build advanced Excel formulas, PivotTables and interactive dashboards
- Write SQL queries to retrieve, filter, join and aggregate data
- Work with relational databases and perform advanced SQL analysis
- Clean and transform data using Power Query
- Build interactive Power BI dashboards and reports
- Create calculated columns and measures using DAX
- Apply data modelling principles in Power BI
- Communicate data-driven insights to non-technical stakeholders
- Build professional portfolio projects using real-world datasets
Curriculum
Prerequisites
- • Basic computer skills
- • Basic understanding of Microsoft Excel is helpful but not required
Related courses
Data Analysis
Beginner to Intermediate 6 weeks
Power BI for Business Intelligence
Transform raw business data into interactive dashboards, meaningful KPIs and actionable insights with Power BI.
View course