Live Instructor-led program

Data Analytic and Business Intelligence + AI

Unleash the power of data! This immersive instructor-led program combines Data Analytics, Business Intelligence, and AI to transform raw data into actionable insights. Master tools like Power BI, Excel, SQL, and AI-powered solutions to elevate your decision-making capabilities across key industries including Finance, Retail, HR, and Hospitality. Whether you're a beginner or looking to upskill, this course prepares you for high-demand roles in data-driven fields.

₦120,000.00
₦100,000.00
Hero
Avatar

I enjoyed the practical step by step guide with positive outcomes. I am so happy I took the decision to enroll in this course. I can't wait to start the next module.

Emmanuel Umoh

Network Engineer

Avatar

I loved the fact that it is hands on and the instructors are always available and patient enough to ensure all queries are attended to. I am highly satisfied.

Ishola Abisoye

Chief Marketing Officer

Overview

The Data Analytics and Business Intelligence + AI program is designed to equip learners with the technical and analytical skills needed to thrive in today’s data-driven world. This instructor-led, hands-on training program focuses on providing practical knowledge and tools to extract, analyze, and visualize data for business insights.

Key Features of the Program:

  • Microsoft Power BI: Learn to create dynamic dashboards and interactive reports for real-time analytics and performance tracking.

  • Microsoft Excel: Master data modeling, pivot tables, and advanced formulas for data manipulation and forecasting.

  • SQL: Gain expertise in querying databases, managing structured data, and performing complex operations for business insights.

  • Business Math and Statistics: Develop the quantitative and statistical foundations to interpret data and make evidence-based decisions.

  • Generative AI Tools: Explore cutting-edge AI tools to streamline processes, generate insights, and automate workflows.

  • PowerPoint Design: Create visually engaging presentations that effectively communicate data-driven stories.

Business Domain Focus:

  • Finance: Learn how to analyze financial statements, create forecasts, and build profitability models.

  • Retail: Understand sales performance, inventory management, and customer segmentation.

  • HR: Track employee performance, analyze recruitment metrics, and assess training needs.

  • Hospitality: Manage booking data, optimize pricing strategies, and analyze customer satisfaction metrics.

Who Is This Program For?

  • Aspiring Data Analysts, Business Intelligence Developers, and AI enthusiasts.

  • Business professionals aiming to upskill for data-driven roles.

  • Entrepreneurs and managers looking to leverage data for strategic decisions.

  • Recent graduates and career changers seeking a competitive edge in analytics and AI.

Why Enroll? This program blends theory with practical application, ensuring you graduate job-ready with the ability to handle real-world datasets. You’ll leave with a professional portfolio, hands-on experience, and the confidence to drive impactful business decisions through data analytics and AI.

 

Course objectives

By the end of this course, you'll be able to:

  • Master data visualization and reporting using Microsoft Power BI.

  • Develop advanced data manipulation and analysis skills in Microsoft Excel.

  • Learn SQL for data extraction, querying, and database management.

  • Apply Business Math and Statistics to make data-driven decisions.

  • Utilize Generative AI tools to enhance productivity and automate insights.

  • Design compelling presentations using PowerPoint to communicate findings.

  • Apply analytics techniques to solve real-world problems in Finance, Retail, HR, and Hospitality.

Course curriculum

Data Analysis Fundamentals

Basic Data Transformation in Power Query

Intermediate Data Transformation in Power Query

Advanced Data Transformation in Power Query

Data modeling

Data Calculation using DAX

Create Retail Dashboards in Power BI

Create HR Dashboards in Power BI

Advanced Power BI concepts

Power BI administration

Introduction to Microsoft Excel

Working with Formulas, Functions and Tables in Excel

Working VLOOKUP and XLOOKUP

Basic Data Transformation in Excel using Power Query

Advanced Data Transformation in Excel Using Power Query

Data Modeling in Excel using Power Pivot

Data Calculation in Excel Using DAX

Create Sales Dashboard in Excel

Create Sales Report in Excel

Introduction to SQL

Database Modeling

Data Manipulation Language

Data Definition Language

Basic SQL Statements

Aggregate Functions in SQL

Joins in SQL

Data cleaning in SQL

Data Analysis and Reporting in SQL

Design Dashboards Background in PowerPoint

Working with AI Features in Power BI

Generative AI for Data Analysis

Prompt Engineering for Data Analysts

Basic Statistics for Data Analysis

Understanding Key Business Metrics

Business Math

Projects you'll create

Build projects you can showcase in your CV. Every project has a problem statement you're required to solve to give you the confidence you need to succeed in a any company. Projects are aligned with employer's requirements for a position in this field.

Product
Product
Product
Product
Product
Product
Product
Click to view image
Product
Product
Product
Product
Product
Product
Product

It's practical all through. No theory, no jagon, only practical.