Become a Certified Business Intelligence Expert With Power BI

Master Data Analytics and Data Visualization with over 15 hands-on projects using Microsoft Power BI, Excel, and Artificial Intelligence (AI). Live in Nigeria and work remotely for companies abroad as a Data Analyst, including opportunities for Visa Sponsorship.

Time before the price increases:

Chat with Us

Why You Should Take This Course

Business Intelligence with Power BI is one of the most in-demand skill sets in the world today.

The average salary of a data analyst in the US is ranging between $66k-$100k (N76,230,000-N115,500,000).

With this training, you will gain all the skills, knowledge, techniques, and tools—specifically in Power BI and Business Intelligence—that will make it incredibly easy for you to secure jobs in data analytics. Guaranteed..

Why Choose Ibadan Data School ?

Beginner Friendly Training

Experts-Led Training + Real Business Cases

Job Guaranteed or Get a 100% Refund

Remote Internship with 2 Big Foreign Companies

Professional Certificate of Completion

Job Alerts & Career Guidance

FREE Ultra-Fast Unlimited Internet (Starlink)

Become AI Powered Data Analyst

Skills You'll Learn

In this course, you'll discover the most effective methods to become a world-class Data Analyst by working with professional datasets from real companies, focusing on developing your Power BI and Business Intelligence skills and experience.

Introduction to Business Intelligence & Power BI Desktop

As students of Business Intelligence, you will be introduced to Power BI and its data transformation techniques.

Data Transformation in Power Query

What you’ll learn:

Removing duplicates and handling null values within the Power Query Editor.
Standardizing data formats (dates, numbers, text) for consistency.
Correcting data entry errors and resolving inconsistencies.
Splitting and merging columns as needed to shape your data.

Text Transformations in Power Query

What you’ll learn:

Introduction to Text transformation tools: Trim, Clean, Parse, Extract, etc…
Practice using these transformations on sample datasets within Power BI.

Basic DAX Functions What you’ll learn:

Introduction to Basic DAX aggregate functions: SUM, AVERAGE, MIN, MAX.
Practice using these DAX functions to create measures in sample datasets.

Real-World Project: Connecting and Exploring Sales Data

Background: A major retail company wants to begin its journey into business intelligence to better understand its sales performance. The first step is to connect to their primary sales database and perform an initial exploration to assess the data’s structure and quality. This foundational work is critical before any deep analysis or dashboard creation can begin.

Task Overview: As a BI Developer, your first task is to connect to the company’s sales dataset using Power BI. You will need to explore the data to understand its contents, identify the different tables provided (e.g., sales, products, customers), and document the key fields that will be used for future analysis.

Your Responsibilities:

Establish a successful connection to the provided sales data source (such as an Excel file or CSVs) within Power BI Desktop.
Navigate the Power BI interface to view the imported tables and their columns.
Identify the primary tables in the dataset (e.g., a sales transaction table, a product details table, a customer information table).
Review the columns within each table to understand what information they contain (e.g., OrderDate, ProductID, CustomerName, SaleAmount).
Make initial observations about the data, such as the date range of the sales and the types of products sold.
Identify key columns that will likely be used to create relationships between tables later (e.g., ProductID in the sales table and the product table).
Document your findings in a brief summary, outlining the tables, key columns, and your initial assessment of the dataset.

Data Transformation with Power Query Editor

What you’ll learn

Conditional Logic in Power Query:

Conditional Column: Basic usage and syntax to create columns based on if-then-else logic.
Creating more complex logic: Nesting conditional statements or adding multiple clauses to handle various scenarios.
Using the UI and M Language: Learn to create conditional logic both through the user-friendly interface and by understanding the underlying M code.
Advanced Data Profiling and Filtering

ACTIVITIES:

Understanding Data Profiling: Use Power Query’s data profiling tools (Column Quality, Distribution, and Profile) to understand your data’s structure and identify issues.
Applying Conditional Filters: Filter rows based on single or multiple criteria (equivalent to the logic of SUMIFS, COUNTIFS).
Grouping and Aggregation: Use the “Group By” feature to perform conditional aggregations like Sum, Count, and Average on specific categories of data.
Transforming Data based on Conditions: Apply transformations to a column based on the values in another column, achieving complex conditional outcomes.

Real-World Project: Cleaning and Preparing Netflix Inc. Data

Background: Netflix Inc. aims to optimize its content recommendation algorithm and improve customer satisfaction by ensuring that its content library data is clean, accurate, and ready for analysis. The company has observed inconsistencies in its data, such as missing values, duplicate records, and incorrect classifications, which may affect the performance of its BI reports and recommendation systems.
Task Overview: As a BI Developer at Netflix, you are tasked with using Power Query Editor in Power BI to clean and prepare the company’s dataset for analysis. The dataset includes information about movies and TV shows, such as titles, genres, release dates, ratings, and other attributes.
1. Use Power Query’s data profiling tools to determine which columns have missing data.
2. Decide on and apply appropriate strategies to handle null values, such as removing rows, replacing values, or filling them in.
3. Identify and remove any duplicate records in the dataset to ensure each content entry is unique.
4. Check for and correct inconsistencies in data formats, ensuring dates are in a standard date format and ratings are numeric.
5. Standardize categorical data, such as genre and country names, to maintain consistency (e.g., “United States” vs. “U.S.A.”).
6. Split delimited columns, such as “cast” or “listed_in,” into multiple rows or columns for easier analysis.
7. Verify data integrity by checking for logical consistencies, such as ensuring release dates are valid, and document the applied cleaning steps.

Real-World Project: Building a Retail Sales Data Model

What you’ll learn

Introduction to Data Modeling: Understand the importance of a well-structured data model in Power BI.
Creating Relationships: Learn to create and manage relationships between different tables (e.g., sales, products, customers) in the Model View.
Understanding Star Schema: Be introduced to best practices in data modeling, including fact and dimension tables, to build an efficient star schema.
Introduction to DAX: Explore the basics of DAX (Data Analysis Expressions) for creating simple calculations.
Creating Calculated Columns: Learn how to use DAX to add new columns to your tables based on existing data.
Creating Basic Measures: Understand the difference between a calculated column and a measure, and learn to write basic measures to aggregate data (e.g., Total Sales).

Real-World Project: Sales Analysis Using Lookup Functions.

Background: A retail company has its data stored in separate tables: one for sales transactions, one for customer information, and another for product details. To perform meaningful analysis, this data must be structured into a proper data model. Without a model, creating reports would be inefficient and complex calculations would be impossible.

Task Overview: As a BI Developer, your task is to use Power BI’s Model View to build a robust and efficient data model. You will connect the separate data tables by establishing relationships between them, forming a classic star schema. Finally, you will create some basic DAX calculations to verify the model works as expected.

Your Responsibilities:

Load the Sales, Customer, and Product datasets into Power BI.

Navigate to the Model View to examine the tables.

Identify the key columns (e.g., ProductID, CustomerID) that will be used to link the tables.

Create relationships between the fact table (Sales) and the dimension tables (Customers, Products) to build a star schema.

Ensure the relationships have the correct cardinality (e.g., one-to-many) and cross-filter direction.

Use basic DAX to create a new calculated column, such as “Total Revenue” (Quantity * Unit Price), in the sales table.

Create two simple measures: one to calculate the “Sum of Total Revenue” and another to count the “Total Number of Transactions.”

Briefly test the model by creating a simple table visual that shows Total Revenue by Product Category to ensure the relationships and measures are working correctly.

Real-World Project: Analyzing Bike Sales Data with DAX and Visuals

What you’ll learn
- Mastering the CALCULATE function, the most important function in DAX.
- Writing Time Intelligence functions to analyze trends over time (YTD, MTD, Same Period Last Year).
- Using DAX iterators (SUMX, AVERAGEX) for row-by-row calculations.
VISUALIZATION
- Creating a variety of visuals like bar charts, line graphs, maps, and matrices.
- Using filters, slicers, and cross-filtering to create interactive reports.
- Configuring visuals with formatting options to enhance clarity and impact.

Real-World Project: Analyzing, Bike Sales Data

Background: A leading bike retailer wants to move beyond basic reporting to perform deeper, more dynamic analysis of its sales data. The company needs to understand sales trends, customer behavior, and product performance using sophisticated calculations and interactive visuals. Your task is to leverage DAX for analysis and Power BI for visualization to deliver these insights.
Your Responsibilities:
Use DAX time intelligence functions to analyze sales trends over time, identifying peak periods and year-over-year growth.
Write DAX measures to evaluate the performance of different bike types in terms of sales volume and revenue generated.
Create calculated columns and measures in DAX to segment customers based on demographics such as age, gender, and region.
Build an interactive Power BI report that visually represents the key findings from your DAX analysis.
Include key performance indicators (KPIs) calculated with DAX, such as total sales, average order value, and top-selling bike types.
Implement slicers and filters in the Power BI report that allow users to drill down into specific time periods, regions, or customer segments.
Use a variety of Power BI visualizations, such as bar charts, line graphs, and maps, to present the data from your DAX measures clearly and effectively.
Use the insights from your analysis to recommend which bike types should be prioritized in marketing and inventory based on sales performance and customer demand.

Advanced Visualization and Dashboard Design

ACTIVITIES

Designing user-friendly and effective dashboard layouts.
Implementing data storytelling principles to guide users through insights.

Advanced Visuals and Interactivity

ACTIVITIES

Using advanced visuals like decomposition trees, key influencers, and smart narratives.
Configuring bookmarks, buttons, and page navigation for a custom app-like experience.

Dashboard Finalization

ACTIVITIES

Applying themes and formatting templates for a consistent look and feel.
Optimizing report performance for fast loading and interaction.

Real-World Project: Creating an Interactive Executive Dashboard

Background: Choprite, a retail chain with multiple locations, needs a high-level dashboard for its executive team. The data has already been cleaned and modeled, but the management team requires a user-friendly, interactive report to track key performance indicators (KPIs) and make strategic decisions quickly. They need to see the big picture but also have the ability to drill down into specific areas without getting lost in complex tables.

Your Responsibilities:

Design a one-page summary dashboard that presents the most critical KPIs, such as total sales, profit margin, and customer count.

Create an intuitive layout with clear navigation, allowing executives to easily switch between different views like Sales, Profit, and Customer Analysis.

Use bookmarks and buttons to create an app-like experience, guiding the user through a data story.

Implement advanced visuals like decomposition trees or smart narratives to provide automated insights into what drives performance.

Build detailed drill-down pages that can be accessed from the main dashboard, showing performance by region, store, and product category.

Apply a consistent and professional theme, ensuring the dashboard is visually appealing and easy to read.

Optimize the final dashboard for performance and publish it to the Power BI service for executive access.

\Power BI Service, Collaboration, and AI Integration

ACTIVITIES

Publishing reports from Power BI Desktop to the Power BI Service.
Creating and managing workspaces for different teams and projects.

Collaboration & Data Management

ACTIVITIES

Sharing reports and dashboards with colleagues and stakeholders.
Setting up scheduled data refreshes to ensure data is always up-to-date.
Configuring a gateway to connect to on-premise data sources.

AI Integration

ACTIVITIES

Using AI-powered visuals like Q&A to ask natural language questions of your data.
Leveraging the Key Influencers visual to identify drivers behind your metrics.
Exploring the Smart Narrative visual to get automated, text-based summaries of your data.

Real-World Project: Publishing and Sharing a Final Shopping Trends Report

Background: A retail analytics firm has finalized its comprehensive Power BI report on consumer shopping trends. The report is complete within Power BI Desktop, but now it needs to be made accessible to stakeholders and management. The goal is to publish the report, ensure the data remains current, and share it securely with the intended audience for review and decision-making.

Your Responsibilities:

Publish the finalized Shopping Trends report from Power BI Desktop to a designated workspace in the Power BI Service.

Create a new workspace specifically for the marketing analytics team to house this report and future projects.

Share the report with key stakeholders, configuring their access levels (e.g., view-only vs. build permissions).

Set up a scheduled refresh for the dataset to ensure the report’s data is updated automatically every morning.

Create a dashboard in the Power BI Service that pins key visuals from the report, providing an at-a-glance summary for executives.

Use the Q&A feature on the dashboard to ask a natural language question, such as “total sales by payment method,” to demonstrate its AI capabilities.

Package the report and dashboard into a Power BI App for easy distribution and a professional, polished presentation to the end-users.

Learn Generative AI Tools for Data Analytics

Discover how to integrate generative AI into your Power BI workflows to enhance your ability to derive actionable insights and make more informed decisions.

Capstone and 20+ Data Analysis Projects

You will execute numerous mini-projects and 3 Capstone Projects focused on Power BI to prepare you for job opportunities in the data field.

Job Preparation Guide

We will help you prepare for technical and HR interviews for Data Analyst roles, focusing on Power BI skills.

Bonus 1: A Mentorship Session with a Top Data Analyst

In this segment, you will have a Ask-Me-Anything session with a top data analyst to guide you further.

Bonus 2: How To Make $1,000 Monthly Working Remotely As a Data Analyst

In this segment, a top freelancer will share with you a blueprint that guarantees you to make at least $1,000 Monthly working Remotely As A Data Analyst… Even if you know nothing about remote work.

Bonus 3: A Step-by-Step Guide On How To Relocate to the UK from Nigeria with a Skilled Worker Visa & Tech Nation Visa.

The Skilled Worker visa allows qualifying individuals to come to the UK to work for an approved sponsor in an eligible role. We will give you a Guide on How To Apply for Skilled Worker Visa and Tech Nation Visa.

Bonus 4: FREE Workspace with Utra Fast Unlimited Internet Wifi (Starlink)

Click Here To Register Now

Training Details

No need to quit your job or school, you can enhance your professional and earning potential with our weekday, weekend and online sessions.

Sessions

Weekdays Session: 6 Weeks - (Monday, Wednesday & Friday) 2PM - 5PM

Start Date: 14th July 2025

Venue

4, Obe Street, Beside BOVAS Filling Station, Bodija, Ibadan, Oyo State, Nigeria

Training Fee

Early Birds*: Pay N60,000 Instead of standard fee of ~~N100,000~~

Frequently Asked Questions

1. What is the essence of Data Analytics?

In today’s world, where decisions are increasingly driven by data, everything from market research and sales to expenses and logistics depends heavily on accurate information. However, this data can often feel overwhelming and difficult to interpret. It takes time and effort to figure out what’s relevant and what the numbers truly mean. Data Analysts are trained to uncover valuable insights from raw information, which requires a solid grasp of core Data Analytics principles like data cleaning, analysis, and visualization. The Data Analytics Course at Ibadan Data School in Nigeria is designed to thoroughly teach these essential skills, helping learners gain the knowledge they need to succeed in the field.

01. Can I make payment in Installment?

Yes, we’re happy to offer flexible payment plans. If you’d like to discuss available options, feel free to contact our team on WhatsApp at 07030163486. We’ll be glad to assist you.

02. What Are The Requirements for Taking This Course?

No prior experience in Data Analysis is needed to join the course. However, you should be comfortable using a computer. Our teaching approach is beginner-friendly — we start with the basics and gradually build your skills until you gain expert-level proficiency.

03. Who Are The Key Skills That I Will Learn In This Training?

Developing strong communication and presentation skills for sharing data insights effectively.
Understanding how data is used in both daily life and business environments.
Learning techniques for gathering and exploring data from various sources.
Organizing data properly to prepare it for analysis.
Defining business or analytical problems clearly and applying problem-solving strategies.
Following a step-by-step approach to perform thorough and accurate data analysis.

04. Who Is This Training For?

This training is designed for individuals who want to gain practical Excel skills for data analysis and visualization.
It is ideal for:

Professionals looking to enhance their data analysis and visualization abilities.
Aspiring Data Analysts seeking to build a strong foundation in the field.
Business owners who want to better understand and interpret their business data.
Business consultants and coaches who need data-driven insights to support their clients

05. Why Should I Choose Ibadan Data School Over Other Training Centres?

People choose Ibadan Data School because our training stands out in several key ways:

Expert Instructors: Our trainers and mentors include professionals currently working with leading global tech companies like Google and Facebook.
Project-Based Learning: Students build confidence and hands-on experience by working on real-life projects.
Job Opportunities: We actively connect our students with top employers both within and outside Nigeria.
Free Career Support: Enjoy free access to career guidance, mentorship, and ongoing support.
Community Access: Join our exclusive support and job placement community at no cost.
Globally Recognized Certification: Our certificates are widely accepted and respected around the world.
Flexible Learning Options: Choose from in-class, online, or weekend sessions to suit your schedule.
Flexible Payment Plans: We offer convenient payment options to make learning more accessible.

06. Do I Need To Have My Own Computer Before I Enroll For This Training?

Yes, we recommend that you come with your own laptop, as it will make it easier for you to practice what you’re learning. However, if needed, we do provide laptops that can be used within our premises during the training.

07. What Type of Jobs Would I Qualify For If I Take This Course?

As a leading Business Intelligence tool, Microsoft Power BI, often used alongside Excel, is one of the most powerful and widely-used data analysis platforms in the world. Hundreds of roles for Data Analysts are available on job websites and other platforms specifically seeking Power BI skills. In this course, we will show you exactly how to find and qualify for these high-demand jobs.

08. When Does Your Next Data Analysis Training Start?

Our I.T classes run on a rolling basis, so you don’t have to wait for a specific term like September or January to get started. Simply call us on 07030163486, and we’ll provide you with all the information you need.

Click Here To Register