Data Analysis Diploma

Diplomas

Data Analysis Diploma

Become a Certified Social Media Designer
70 Hours of practical application

Course Detailes

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 Versions:

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 Data Analysts and Business Analysts
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

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

Master Essential Tools: Learn Excel, Power BI, Power Query, and DAX for advanced data analysis.
Hands-on Projects: Build a portfolio with real-world case studies and data analysis projects.
Advanced Data Transformation: Gain expertise in cleaning and transforming data for accurate insights.
Proven Data Visualization: Create interactive reports and dashboards for effective data presentation.
Boost Career Prospects: Gain in-demand skills for roles like Data Analyst and Business Analyst.
Statistical Analysis: Understand regression, hypothesis testing, and other statistical techniques.
Automation & Customization: Learn to automate data processes and create custom solutions.
Job Readiness: Develop practical skills to make data-driven decisions in any industry

Module1: 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
- 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 2: 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

Experienced in data analysis, Excel, Power BI, and data transformation techniques.
Passionate about teaching complex concepts with practical applications, ensuring students understand how to leverage data for decision-making

Mr. Mahmoud Serag

Experienced in data analysis, Excel, Power BI, and data transformation techniques.
Passionate about teaching complex concepts with practical applications, ensuring students understand how to leverage data for decision-making

EBS Courses graduates

EBS Training features

Book your seat with 50% off

Or request a call with our experts

Certified Diploma

First Name

Last Name

Preferred Booking Date

Delivery Methods

Phone Number

E-Mail Address

Login / Register

Submissions

My Cart

Outsourcing Solutions

Outsourcing services

Payroll Calculation

Payroll Audit

Personnel

Accounting &Finance Solutions

Accounting Audit

Tax

CFO Outsource

Human Resources Solutions

HR Consulting

Recruitment

HR Audit

HR Outsource

Legal Solution

Work permits

Diplomas

Human Resources Diploma ( Expert )

Junior HR Diploma ( beginner )

Digital Marketing Diploma

Graphic Design Diploma