Data Analytics

DATA ANALYSIS (EXCEL + SQL + POWER BI)

A practical data analytics course focused on DATA ANALYSIS (EXCEL + SQL + POWER BI), hands-on class exercises, and job-ready digital skills.

Duration
12 Weeks
Days/Week
3 days per week
Classes
Physical
Fee
₦0
Course Overview

What this course covers

This course helps learners build practical knowledge in DATA ANALYSIS (EXCEL + SQL + POWER BI). The program combines guided teaching, applied exercises, project work, and mentorship so students can understand the tools, practice real workflows, and develop confidence for work, business, freelancing, or further study in data analytics.

Course Outline

  • Excel cleanup, formulas, pivot tables, and dashboards
  • SQL querying, joins, aggregation, and data extraction
  • Power Query transformations and data modeling
  • DAX measures, KPIs, and Power BI visuals
  • Dashboard storytelling and business reporting
  • End-to-end business analytics project

Learning Outcomes

  • Clean and analyze data across Excel, SQL, and Power BI.
  • Write SQL queries for reporting and business analysis.
  • Create Power BI dashboards with useful KPIs.
  • Explain insights clearly to business users.
  • Deliver a complete analytics report from raw data to dashboard.

Prerequisites

  • Student should have access to a personal computer.

Why Choose It

  • A complete path for business data analysis and dashboard reporting.
  • Uses tools commonly requested in analyst job descriptions.
  • Builds confidence moving from raw data to executive reports.
  • Useful for office workers, analysts, entrepreneurs, and graduates.

Ready to start data analysis (excel + sql + power bi)?

Contact Mayorkay Technologies Services for enrollment, class schedule, and group training arrangements.

Contact Us