Blank

Data Analysis with Excel and Power BI

Normal

Fee $200

Course Date

Sunday, 25 October 2026

Course Overview

This practical training program is designed to help participants develop essential data analysis and reporting skills using Microsoft Excel and Power BI. The course focuses on transforming raw data into meaningful insights through data cleaning, analysis, visualization, dashboards, and reporting techniques commonly used in business environments.

Participants will gain hands-on experience working with real-world datasets and learn how to create professional reports and interactive dashboards that support effective decision-making.

Learning Outcomes

By the end of this training, participants will be able to:

  • Understand data analysis fundamentals and workflows

  • Organize, clean, and prepare datasets efficiently

  • Use Excel formulas and functions for data analysis

  • Analyze data using PivotTables and PivotCharts

  • Create interactive dashboards in Excel

  • Import, transform, and model data in Power BI

  • Create visual reports and dashboards

  • Apply basic DAX calculations and KPIs

  • Publish and share reports professionally

Course Topics
​

Day 1 – Excel Data Preparation and Analysis Introduction to Data Analysis

  • Introduction to Data Analysis

  • Understanding data types and data sources

  • Excel interface and productivity shortcuts

  • Data entry and formatting best practices

  • Cleaning and organizing datasets

  • Sorting and filtering techniques

  • Conditional formatting

  • Data validation

  • Essential formulas and calculations

  • IF statements and logical functions

  • COUNTIF, SUMIF, and AVERAGEIF

  • VLOOKUP/XLOOKUP

  • Text, date, and time functions

Day 2 – Advanced Excel Analysis and Dashboards Basic formulas and calculations

  • Introduction to PivotTables

  • PivotCharts and data summarization

  • Data analysis using PivotTables

  • Dashboard design principles

  • Creating interactive Excel dashboards

  • Using slicers and dynamic charts

  • Introduction to Business Intelligence (BI)

  • Power BI overview and interface

  • Connecting to data sources

  • Importing Excel and CSV files

Day 3 – Power BI Reporting and Dashboards Dashboard design principles

  • Data transformation with Power Query

  • Cleaning and shaping data

  • Combining multiple datasets

  • Understanding ETL concepts

  • Creating relationships between tables

  • Data modeling fundamentals

  • Introduction to DAX formulas

  • Calculated columns and measures

  • Creating visualizations and charts

  • Interactive reports and dashboards

  • Filters and slicers

  • KPI creation and performance tracking

  • Publishing and sharing reports

  • Final practical exercise and project presentation

Who Should Attend?

  • Office employees

  • Administrative professionals

  • Business analysts

  • Finance professionals

  • HR personnel

  • Sales and marketing staff

  • University students and fresh graduates

  • Anyone interested in data analysis and reporting

Schedule and Duration

  • Duration: 5 Days

  • Time: 05:00 PM – 7:00 PM

  • Language: English

  • Certificate Format: mselect

  • Format: mselect Certificate of Completion

  • Fee Per Person: $200

Training Methodology

  • Instructor-led sessions

  • Hands-on practical exercises

  • Real business case studies

  • Interactive discussions

  • Final practical assignment

Requirements

  • Basic computer knowledge

  • Basic Microsoft Excel understanding

  • Laptop for practical sessions

Certification & Completion Requirements

Certificate of Completion

Participants who successfully complete the training will receive an mselect Certificate of Completion, subject to meeting the following requirements:

  • Minimum 80% attendance: Participants must attend at least 80% of the total training hours.

  • Successful completion of assessments: Participants must complete and pass the required course assessments.

  • Active participation: Participants are expected to actively participate in the practical exercises, discussions, case studies, and other learning activities throughout the course.

  • Course completion: Participants must complete all required learning and assessment activities within the scheduled training period.

A certificate will be issued only to participants who meet the required attendance and assessment criteria.

Payment

Must be made 7 working days before the start of the course. Payment can be made in cash, by bank transfer or through exchange offices.

How do I register?

You can register by emailing training@mselect.com with the following details:

  • Full Name:

  • Position/Title (If applicable):

  • Email Address:

  • Phone number:

  • Name of the course:

For more information, contact 0771 842 2380

​register now