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
Full Stack Data Analysis

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.

About the Course

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 should enrol?

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

Course curriculum

Tools and software

Microsoft ExcelPower QuerySQLMicrosoft SQL ServerPower BIDAX

Practical projects

Build practical experience and a portfolio of completed projects through realistic exercises.

  • 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

Advanced Excel for Data Analysis
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
Power BI for Business Intelligence
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
Product Analysis
Data Analysis
Beginner 6 weeks

Product Analysis

Use product metrics, funnels, cohorts, and experiments to understand user behavior and guide product decisions.

View course