Course Overview

This practical training program is designed to help participants develop strong 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 with real-world datasets and learn how to create professional reports and interactive dashboards to support 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

• Use DAX basics for calculations and KPIs

• Publish and share reports professionally

Course Topics

Day 1 – Excel Fundamentals & Data Preparation

• Introduction to Data Analysis

• Understanding data types and data sources

• Excel interface and shortcuts

• Data entry and formatting best practices

• Cleaning and organizing datasets

• Sorting and filtering

• Conditional formatting

• Data validation techniques

Day 2 – Excel Formulas & Data Analysis

• Basic formulas and calculations

• IF statements and logical functions

• COUNTIF / SUMIF / AVERAGEIF

• VLOOKUP / XLOOKUP

• INDEX & MATCH

• Text, date, and time functions

• Introduction to PivotTables

• PivotCharts and data summarization

Day 3 – Excel Dashboards & Introduction to Power BI

• Dashboard design principles

• Creating interactive Excel dashboards

• Using slicers and dynamic charts

• Introduction to Business Intelligence

• Power BI overview and interface

• Connecting to data sources

• Importing Excel and CSV files

Day 4 – Power Query & Data Modeling

• Data transformation with Power Query

• Cleaning and shaping data

• Combining multiple datasets

• Understanding ETL concepts

• Creating relationships between tables

• Data modeling basics

• Introduction to DAX formulas

• Calculated columns and measures

Day 5 – Power BI Dashboards & Reporting

• Creating visualizations and charts

• Interactive reports and dashboards

• Filters and slicers

• KPI creation and performance tracking

• Dashboard storytelling techniques

• Publishing reports to Power BI Service

• Sharing and exporting reports

• Final practical project and presentation

Who Should Attend?

• Office employees

• Administrative professionals

• Business analysts

• Finance professionals

• HR personnel

• Sales & marketing staff

• University students & fresh graduates

• Anyone interested in data analysis and reporting

Schedule and Duration

• Duration: 5 Days

• Time: 2:30 PM – 7:00 PM

• Language: English

• Total Hours: 22.5 Training Hours

• Certificate Format: mselect

• Format: Virtual or Classroom (Optional)

• Fee Per Person: $230

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

Certificate

Participants who successfully complete the training will receive a Certificate of Completion.

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