Skip to main content
Ideal Workplace Solutions
NITA AccreditedIntermediatePhysical + Virtual10 daysDAEP03

Training on Data Analytics using Excel and Power BI

Master data analytics with Excel and Power BI. Learn to clean, transform, and visualize data effectively. Create stunning dashboards and extract valuable insights to drive informed decisions.

Next intake

20 Jul 2026 · Nakuru

View all dates

Duration

10 days

Live instruction

Delivery

Physical + Virtual

Cohort based

Level

Intermediate

Working professionals

Certification

NITA reimbursable

For Kenyan cohorts

Language

English

All materials

Overview

About this programme

Data analytics is the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision making. Companies need data analysts to sort through this data to help make decisions about their products, services or business strategies. Everything you need to get started in the world of data analytics is already on your computer in the wonderful application called Excel which has robust features. Microsoft Power BI is another tool from Microsoft that gathers and processes your data, analyzes and provides data-driven insights that enable managers, business analysts and key decision makers to make informed decisions in real-time.

Course Duration

10 Days

Who Should Attend

  • Data Analysts
  • Business Analysts
  • Financial Analysts
  • Project Managers
  • IT Professionals
  • Marketing Analysts
  • Anyone interested in enhancing their data analysis and visualization skills
Learning outcomes

What you'll walk away with

By the end of this course, participants will be able to

  • Understand the fundamentals of data analytics and its importance in decision-making.
  • Use advanced Excel functions and formulas for data analysis.
  • Prepare and clean data for analysis in Excel and Power BI.
  • Create and customize interactive dashboards in Power BI.
  • Analyze and interpret data to generate actionable insights.
  • Integrate data from various sources into Power BI.
  • Apply data visualization best practices to effectively communicate findings.
  • Automate data analysis tasks using Power Query and DAX in Power BI.
  • Develop and present data-driven reports to stakeholders.
  • Utilize Power BI service for sharing and collaborating on reports.
Course modules

What we cover, module by module

Module 1: Introduction to Data Analytics

  • Importance of data-driven decision making
  • Overview of data analytics concepts and applications
  • Introduction to Excel and Power BI
  • Setting up the analytics environment
  • Case Study: How dashboards improved business decision-making
  • Practical: Setting up Excel and Power BI workspace

Module 2: Data Preparation & Cleaning in Excel

  • Importing data from multiple sources
  • Data cleaning techniques
  • Removing duplicates and handling missing values
  • Using Excel functions for preparation
  • Case Study: Poor decisions caused by inaccurate data
  • Practical: Cleaning and preparing a raw dataset

Module 3: Advanced Excel Functions for Analysis

  • Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH
  • Text functions and data manipulation
  • Date and time functions
  • Conditional formatting and data validation
  • Case Study: Automating reports using advanced Excel formulas
  • Practical: Solving real-world data analysis tasks in Excel

Module 4: Data Visualization in Excel

  • Creating charts and graphs
  • Using PivotTables and PivotCharts
  • Customizing dashboards in Excel
  • Introduction to Power Query
  • Case Study: Executive reporting through Excel dashboards
  • Practical: Building an interactive Excel dashboard

Module 5: Introduction to Power BI

  • Overview of Power BI components
  • Connecting to data sources
  • Power BI Desktop interface and tools
  • Basic data transformation in Power BI
  • Case Study: Migrating reports from Excel to Power BI
  • Practical: Importing and transforming data in Power BI

Module 6: Advanced Data Modeling in Power BI

  • Data modeling principles
  • Creating relationships between tables
  • Introduction to DAX formulas
  • Calculated columns and measures
  • Case Study: Building a sales performance model
  • Practical: Creating a relational data model in Power BI

Module 7: Data Visualization in Power BI

  • Designing effective dashboards
  • Interactive visualizations
  • Using slicers, filters, and drill-through
  • Visualization best practices
  • Case Study: Operational dashboard for management reporting
  • Practical: Creating an executive Power BI dashboard

Module 8: Advanced Analytics with Power BI

  • Advanced DAX functions
  • Time intelligence functions
  • Dynamic reports and KPIs
  • Row-level security implementation
  • Case Study: Multi-branch reporting with secure access controls
  • Practical: Building advanced analytical dashboards

Module 9: Power BI Service & Collaboration

  • Publishing reports to Power BI Service
  • Sharing dashboards and reports
  • Workspaces and collaboration tools
  • Power BI Mobile overview
  • Case Study: Team collaboration using Power BI cloud tools
  • Practical: Publishing and sharing reports online

Module 10: Final Project & Presentation

  • Comprehensive real-world analytics project
  • Applying Excel and Power BI concepts
  • Presenting findings and recommendations
  • Review and Q&A session
  • Case Study: End-to-end business intelligence project
  • Practical: Final capstone presentation
Impact

Where the change lands

Organizational Impact

  • Enhances decision-making by turning raw data into actionable insights.

  • Increases operational efficiency through automated reporting and faster analysis.

  • Strengthens competitiveness by uncovering trends that improve profitability and reduce costs.

Personal Impact

  • Builds in-demand skills for leadership, business intelligence, and strategic roles.

  • Enables direct contribution to organizational success through data-driven recommendations.

  • Provides confidence to lead and champion data-focused initiatives.

Dates and locations

Upcoming intakes

Every intake is limited to a small cohort. Booking closes when a date fills or three weeks before the start, whichever comes first.

Full calendar
FAQs

Common questions.

Still not sure? Send us a note and a facilitator will get back to you within a business day.

The goal is to equip you with the skills to use Excel and Power BI for data analysis, visualization, and creating actionable insights for better business decisions.

Related programmes

You may also like.

Programmes in the same discipline that participants often pair with this course.

Browse the full catalogue
Hybrid5 days
Training Courses
Professional Certificate in Research Methods, Data Analysis, and Report Writing for Public Sector Organizations

Master research methods, data analysis, and report writing for the public sector. Gain the skills to conduct rigorous research, analyze data effectively, and communicate findings clearly.

Multiple citiesOpen enrolment
FromOn request
View course
Hybrid5 days
Training Courses
Training on AI Ethics and Governance

Gain practical skills in AI ethics, governance, and regulatory compliance for sustainable innovation.

Multiple citiesOpen enrolment
FromOn request
View course
Hybrid5 days
Training Courses
Training on AI Ethics, Governance & Responsible Implementation

Build skills in ethical AI and governance. This course equips professionals to implement AI responsibly while addressing bias, privacy, and accountability.

Multiple citiesOpen enrolment
FromOn request
View course

Course finder

Find the right course for you

Prefer to talk it through? Send us an enquiry and a facilitator will scope a fit within a business day.

For corporate teams

Training 10+ professionals?

We deliver Training on Data Analytics using Excel and Power BI in-house at your offices, at a venue we arrange, or fully virtual. Customise the curriculum against your KPIs, and get a bespoke price for the cohort size you need.

Request a corporate quoteDownload brochure