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
Looking for a Data Analysis course in Lagos covering Excel, SQL, and Power BI together? This 8-9 week programme at Corepoint Tech Academy takes you through the full data analysis workflow — cleaning and analysing data in Excel, querying it with SQL, and presenting it through Power BI dashboards — so you graduate able to handle a real analyst's workload, not just one tool in isolation.
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
Tools you'll use
Microsoft ExcelPower QuerySQLMicrosoft SQL ServerPower BIDAX
Projects you'll build
- Advanced Excel Sales & Performance Dashboard
- SQL Customer & Sales Analysis
- Power BI Business Intelligence Dashboard
- End-to-End Data Analysis Capstone Project
Prerequisites
- • Basic computer skills
- • Basic understanding of Microsoft Excel is helpful but not required
Frequently asked questions
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