Diplomas

Data Analysis Diploma

Become a Certified Data Analysis

14 Sessions

70 Hours of practical application

Training
Offline Or Live stream
Level
Beginner - Intermediate
Investment
Limited offer

Course Details

Overview

The Data Analysis Diploma provides comprehensive training to develop expertise in data analysis using industry-standard tools like Excel and Power BI.
Through hands-on learning, participants will gain the skills to organize, transform, and visualize data, enabling informed decision-making and impactful reporting.
Duration

14 sessions, 5 hours each, totaling 70 hours.
Location

EBS Training Academy, Nasr City.
Course Version

Online – Twice weekly, 6:30 PM – 9:30 PM (Cairo Time).
In-Person – Fridays & Saturdays, 9:00 AM – 3:00 PM or 3:00 PM – 8:00 PM (Cairo Time).
Who should Join?

1- Aspiring graphic designers
2- Professionals looking to enhance their data analysis skills
3- Entrepreneurs who want to leverage data for business decisions
4- Anyone interested in gaining expertise in Excel, Power BI, and DAX for data-driven insights
Certificate

Earn a certificate upon course completion, attesting to your proficiency.

Join us to advance your career with Data Analysis Diploma!

01

Master Essential Tools

Learn Excel, Power BI, Power Query, and DAX for advanced data analysis.
02

Hands-on Projects

Build a portfolio with real-world case studies and data analysis projects.
03

Advanced Data Transformation

Gain expertise in cleaning and transforming data for accurate insights.
04

Proven Data Visualization

Create interactive reports and dashboards for effective data presentation.
05

Boost Career Prospects

Gain in-demand skills for roles like Data Analyst and Business Analyst.
06

Statistical Analysis

Understand regression, hypothesis testing, and other statistical techniques.
07

Automation & Customization

Learn to automate data processes and create custom solutions.
08

Job Readiness

Develop practical skills to make data-driven decisions in any industry

Empower your career with the tools, knowledge, and support you need to excel in Designing!

Unit (1): Data Analysis Using Excel

Classic Excel Dashboard

Introduction to Pivot Tables and Pivot Charts

Inserting Pivot Table
Customizing Pivot Table
Pivot Table Options
Pivot Table Layout and Formatting
Inserting Slicers
Inserting Timeline
Sorting and Grouping
Adding New Data
Calculations
Handling Values

Data Analysis and Visualization Using Pivot Charts

Pivot Chart Types and Options
Manually Adjusting the Legend
Dynamic Labels
Color Formatting Using Themes
Object Formatting
Hiding Sheets / Gridlines / Headers / Formula Bar
Changing Themes
Choosing Appropriate Charts

Extract, Transform, and Load (ETL) Using Power Query

Introduction to Power Query
Connecting to Excel Files
Connecting to CSV & TEXT Files and Folders
Connecting to Access Files
Data Types
Transforming Data Using Power Query

Power Query Overview

Managing Columns and Rows
Changing Type Using Locale Settings
Table-Level Operations
Column-Level Operations
Text Transformation Options
Number Transformation Options
Transforming Dates and Times
Merging and Appending Queries
Loading Data into Excel Data Model
Working with Multiple Queries
Creating Custom Columns Using M Calculations

Working with Data Model in Power Pivot

Power Pivot Capabilities
Importing Data to Power Pivot
Understanding the Concept of Data Model
Creating and Managing Relationships in the Data Model

Working with DAX (Data Analysis Expressions)

Understanding DAX and Its Basic Terminology
Creating Calculated Columns
Creating Measures
Row Context
Filter Context
Implicit and Explicit Measures

Using Advanced DAX

Aggregation Functions
Date & Time Functions
Filter Functions
Information Functions
Logical Functions
Relationship Functions
Text Functions
Creating a Calendar Table
Time Analysis Using DAX

Displaying Data in Excel Using Power Query, Pivot Tables, and Pivot Charts

Creating Dynamic Excel Reports
Inserting Pivot Tables Using Power Pivot
Creating Interactive Dashboards in Excel
Creating Key Performance Indicators (KPIs)

Unit (2): Data Analysis Using Power BI

Getting Started with Power BI Desktop

Introduction to Power BI
The Seven Pillars of Mastering Power BI
Installing Power BI Desktop
Creating Reports and Dashboards

Cleaning, Transforming, and Loading Data in Power BI

Loading Data into Power BI
Uploading and Refreshing PBIX Reports
Transforming Data Using Power Query in Power BI

Data Modeling in Power BI

Managing Data Models in Power BI
Setting Up and Managing Relationships
Creating Calculated Columns
Creating Measures and Quick Measures
Implementing DAX Functions in Power BI
Creating a Calendar Table
Time Analysis Using DAX

Data Visualization in Power BI

Creating Reports and Dashboards
Filtering Reports
Data Navigation (Drill-down & Drill-Through)
Creating Hierarchies
Visual Formatting
Color Formatting and Conditional Formatting
Understanding Data Refresh
Using Bookmarks, Buttons, and Q&A Feature

Publishing and Sharing Reports

Publishing Reports and Sharing

Mr. Yasser Shahin

Mr. Mahmoud Serag

Book your seat in the

Data Analysis Diploma

EBS Courses graduates

EBS Training features

01

EBS Certification

Become a certified Manager with specialized AI skills
02

Full Curriculum

Gain in-depth knowledge across all critical functions.
03

Expert Instructors

Learn from our experts & professionals with real-world experience
04

Join a Community

Be part of a supportive network of like-minded professionals.
05

Real-World Projects

Build a portfolio with hands-on experience.
06

AI-Powered Tools

Use advanced tools to streamline your work.
07

Exclusive Resources

Access premium tools and templates.
08

Time-Saving Techniques

Learn efficient methods for quick results.

Request a call with our experts

Certified Diploma

First Name

Last Name

Preferred Booking Date

Delivery Methods

Phone Number

E-Mail Address