Menu

Data Analysis Diploma

Become a Certified Data Analysis

14 Sessions
70 Hours of practical application
Get 20% OFF Now
ELEGANT Business Solution ISO Cer
ELEGANT Business Solution SHRM Cer
ELEGANT Business Solution ISO Cer2
  • 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?

    • Aspiring graphic designers
    • Professionals looking to enhance their data analysis skills
    • Entrepreneurs who want to leverage data for business decisions
    • 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!

  • Module 01

    Data Analysis Using Excel

    • Classic Excel Dashboard
      • Introducing Pivot Tables & PivotChart
        • Inserting Pivot Table
        • Customize Pivot Table
        • Pivot table options
        • Pivot Table Layout and Formats
        • Inserting Slicers
        • Inserting timeline
        • Sorting & Grouping
        • Adding New Data
        • Calculations
        • Manipulating Values
        • Classic Excel Dashboard
    • Analyzing & Visualizing Data with PivotChart
      • Pivot Chart types and Pivot Chart Options
      • Manual Legend
      • Dynamic Labels
      • Color Formatting with Themes
      • Formatting Objects
      • Hide Sheets / Gridlines / Headers / Formula Bar
      • Changing themes
      • Utilize right charts
    • Extract, Transform, and Load (ETL) Data Using Power Query
      • Introducing to Power Query
      • Connecting to Excel Workbook Files
      • Connecting to CSV & TEXT Files & Folders
      • Connecting to Access Files
      • Data Types
      • Transforming Data Using Power Query
        • Power Query Overview
        • Manage columns & rows
        • Change Type Using Locale
        • Table level operations
        • Column level operations
        • Text Transformation options
        • Number Transformation options
        • Date & Time Transformation options
        • Merge and append queries
      • Loading Data to the Excel Data Model
      • Working with Multiple Queries
      • Custom Columns with M Calculations
    • Working with Data Model in Power Pivot
      • Power Pivot Capabilities
      • Importing Data into Power Pivot
      • Understand Data Model Concept
      • Create & Manage Relationships in Data Model
    • Working with DAX
      • Understand Data Analysis Expression - DAX
      • DAX Terminologies
      • Create Calculated Column
      • Create Measure
      • Row Context
      • Filter Context
      • Implicit Measure
      • Explicit Measure
    • Working with Advanced DAX Measures
      • Aggregation Functions
      • Date & Time Functions
      • Filter Functions
      • Information Functions
      • Logical Functions
      • Relationship Functions
      • Text Functions
      • Building a Calendar table
      • Time Intelligence in DAX
    • Visualizing Data in Excel Using Power Query, Pivot Tables & Pivot Charts
      • Create Dynamics Excel Reports
        • Inserting Power Pivot Pivot Table
        • Create interactive Excel Dashboard
      • Creating KPIs

  • Module 02

    Data Analysis Using Power BI

    • Get Started with Power BI Desktop
      • Introduction Power BI
      • The 7 pillars for Mastering Power BI
      • Installing Power BI Desktop
      • Create Report & Dashboard
    • Clean, Transform, and Load Data in Power BI
    • Loading Data to Power BI
    • Uploading & Updating PBIX Reports
    • Transforming Data Using Power Query in Power BI
    • Modeling with Power BI
    • Mange Data Model in Power BI
    • Setup and Manage Relationships
    • Create Calculated Column
    • Create Measure & Quick Measure
    • Perform DAX Functions in Power BI
    • Building a Calendar table
    • Time Intelligence in DAX
    • Data Visualizations in Power BI
    • Creating Reports & Dashboard
    • Report Filtering
    • Drill-down & Drill-Through
    • Hierarchies
    • Formatting Visualizations
    • Color & Conditional Formatting
    • Understanding Data Refresh
    • Bookmarks & Buttons & Q & A
    • Publishing and Sharing

Mr. Yasser Shahin

Mr. Mahmoud Serag

Book your seat in the

Data Analysis Diploma

Book your seat with 50% off

EBS Courses graduates

6
7
8
9
10
11
12
13
14
15
16
17

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

Facebook Linkedin Youtube X-twitter Instagram Whatsapp
Main Links
Solutions
Training Programs
Facebook Linkedin Youtube X-twitter Instagram Whatsapp
All Rights Reserved For Elegant Business Solution ©2025

Powered By: SSalama Designs

Thank You For Booking

Data Analysis Diploma

We will contact you soon as possible..