Scribd
Upload
3 views3 pages

Data Analysis For Data Science Training Program

The Data Analysis for Data Science Training Course is a 20-hour program aimed at university students and fresh graduates, focusing on SQL and Power BI. Participants will learn data analysis fundamentals, SQL database management, data preparation, and visualization techniques, culminating in a final project. The course fee is 2000, with a 50% discount for E-JUST students and alumni.

Uploaded by

Mostafa Nageh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views3 pages

Data Analysis For Data Science Training Program

The Data Analysis for Data Science Training Course is a 20-hour program aimed at university students and fresh graduates, focusing on SQL and Power BI. Participants will learn data analysis fundamentals, SQL database management, data preparation, and visualization techniques, culminating in a final project. The course fee is 2000, with a 50% discount for E-JUST students and alumni.

Uploaded by

Mostafa Nageh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Data Analysis for Data Science Training Course (20 Hours)

Using Power BI & SQL

Total Duration: 20 Hours


Level: Beginner to Intermediate
Mode: Classroom / Lab-based
Audience:
 University students & fresh graduates
 Anyone seeking to start a career in Data Science through Data Analysis

#Audiences: 20 - 25
Fee: 2000 (50% discount for E-JUST students and Alumina’s)

Objectives
By the end of this training, participants will be able to:
 Understand the fundamentals of Data Analysis and its role in Data Science
 Work with databases using SQL
 Import, clean, and analyze data efficiently
 Build professional dashboards using Power BI
 Extract meaningful insights to support decision-making

Structure (20 Hours Total)

Module 1: Introduction to Data Analysis & Data Science (2 Hours)


Topics
 What is Data Analysis?
 Data Analyst vs Data Scientist
 Data Lifecycle
 Types of Data (Structured / Unstructured)
 Business Understanding & Problem Framing
 Real-life Use Cases of Data Analysis

Module 2: SQL Fundamentals for Data Analysis (6 Hours)


Topics
 Introduction to Databases & DBMS
 Tables, Rows, Columns, Primary Keys
 Writing Basic Queries:
o SELECT
o WHERE
o ORDER BY
 SQL Filtering:
o BETWEEN
o IN
o LIKE
 Aggregate Functions:
o COUNT
o SUM
o AVG
o MIN / MAX
 GROUP BY & HAVING
 JOINs:
o INNER JOIN
o LEFT, RIGHT, FULL OUTER JOIN
 Analytical SQL Queries on Real Datasets
 Hands-on SQL Practice

Module 3: Data Preparation & Cleaning


(Using SQL + Power BI) – 4 Hours
Topics
 Data Quality & Common Data Issues
 Handling:
o Missing Values
o Duplicates
o Incorrect Data Types
 Data Transformation Techniques
 Creating Calculated Columns
 Data Validation Rules
 Preparing Clean & Reliable Datasets for Analysis

Module 4: Power BI Fundamentals & Data Visualization (6 Hours)


Topics
 Power BI Interface Overview
 Connecting to Data Sources
 Power Query for Data Transformation
 Data Modeling Fundamentals
 Relationships Between Tables
 DAX Fundamentals:
o Calculated Columns
o Measures
o Basic Time Intelligence
 Creating Visualizations:
o Bar Charts
o Line Charts
o Cards
o Tables
o Slicers
 Designing Interactive Dashboards
 Business Storytelling with Data

Module 5: Final Project – End-to-End Data Analysis Case Study (2 Hours)


Topics
 Real Business Dataset
 Data Cleaning & Preparation
 Data Analysis Using SQL
 Dashboard Development in Power BI
 Insights & Business Recommendations
 Final Project Presentation

Certification
Participants who complete all modules and successfully pass the final project will receive:
Certificate of Data Analysis for Data Science – 20 Training Hours

You might also like