Data Analysis Professional Course (Start: 05-07-2025)

محتوى الدورة

Excel Outlines (12 Hr)

Interface overview and shortcuts
Data entry and basic formatting
Essential formulas (SUM, AVERAGE, COUNT)
Using AutoFill and quick calculations
Sorting, filtering, and freezing panes
Data validation (drop-down lists)
Conditional formatting techniques
Logical functions (IF, AND, OR)
Lookup functions (VLOOKUP, XLOOKUP)
Text and date functions
Named ranges
Creating and customizing charts
PivotTables and PivotCharts basics
Using slicers and timelines
Simple data analysis tools (Goal Seek, What-If Analysis)
Introduction to Power Pivot
Creating data models and relationships
Building PivotTables from multiple tables
Final project: Analyze a dataset and build a report

Power Bi Outlines (15 Hr)

Introduction to Self-Service BI
Connecting to multiple data sources and building data models
Cleaning, shaping, and combining data using Power Query Editor
Creating visualizations, charts, and custom visuals
Using DAX for calculated measures and conditional columns
Creating hierarchies, applying filters, and slicers
Building and managing dashboards for business reporting
Developing a complete interactive Report from raw data
Best practices for visualization, publishing, and sharing

SQL Outlines (12 Hr)

Entity-Relationship Modeling and ERD concepts
Understanding Relationships in RDBMS
SQL Syntax, Data Types, and Basic Operations (SELECT, INSERT, UPDATE, DELETE)
Creating and Managing SQL Views
Mastering SQL Joins (Inner, Outer, Cross, Full, Self, Delete, Update)
Working with SQL Keys (Primary, Foreign)
Implementing Indexes for performance
Using Wildcards for flexible querying
Applying Aggregated Functions (SUM, COUNT, AVG, etc..)
Writing and Optimizing Subqueries for complex data retrieval
Designing a complete database solution
Implementing queries, views, and reports based on business requirements

Python Outlines (21 Hr)

Introduction to Python and setup (Jupyter / VS Code)
Variables, data types, operators
Basic input/output
Writing first Python scripts
Lists, Tuples, Dictionaries, Sets
Conditional statements (if/else)
Loops (for, while)
Basic error handling (try-except)
Defining and calling functions
Parameters and return values
Reading from and writing to text/CSV files
Introduction to basic modules (os, sys)
Introduction to web scraping concepts
Using requests library to fetch web pages
Parsing HTML with Beautiful Soup
Extracting text and tables from websites
Introduction to Numpy arrays and operations
Pandas Series and DataFrame basics
Reading/writing CSV files
Filtering, sorting, and aggregating data
Creating basic charts with Matplotlib
Advanced plotting with Seaborn
Interactive visualizations with Plotly
Web scraping to collect data
Data cleaning and manipulation with Pandas/Numpy
Visualizing insights with Matplotlib/Seaborn/Plotly

تقييمات ومراجعات الطلاب

لا يوجد تقييم حتى الآن

محتوى الدورة

Excel Outlines (12 Hr)

Interface overview and shortcuts

Data entry and basic formatting

Essential formulas (SUM, AVERAGE, COUNT)

Using AutoFill and quick calculations

Sorting, filtering, and freezing panes

Data validation (drop-down lists)

Conditional formatting techniques

Logical functions (IF, AND, OR)

Lookup functions (VLOOKUP, XLOOKUP)

Text and date functions

Named ranges

Creating and customizing charts

PivotTables and PivotCharts basics

Using slicers and timelines

Simple data analysis tools (Goal Seek, What-If Analysis)

Introduction to Power Pivot

Creating data models and relationships

Building PivotTables from multiple tables

Final project: Analyze a dataset and build a report

Power Bi Outlines (15 Hr)

Introduction to Self-Service BI

Connecting to multiple data sources and building data models

Cleaning, shaping, and combining data using Power Query Editor

Creating visualizations, charts, and custom visuals

Using DAX for calculated measures and conditional columns

Creating hierarchies, applying filters, and slicers

Building and managing dashboards for business reporting

Developing a complete interactive Report from raw data

Best practices for visualization, publishing, and sharing

SQL Outlines (12 Hr)

Entity-Relationship Modeling and ERD concepts

Understanding Relationships in RDBMS

SQL Syntax, Data Types, and Basic Operations (SELECT, INSERT, UPDATE, DELETE)

Creating and Managing SQL Views

Mastering SQL Joins (Inner, Outer, Cross, Full, Self, Delete, Update)

Working with SQL Keys (Primary, Foreign)

Implementing Indexes for performance

Using Wildcards for flexible querying

Applying Aggregated Functions (SUM, COUNT, AVG, etc..)

Writing and Optimizing Subqueries for complex data retrieval

Designing a complete database solution

Implementing queries, views, and reports based on business requirements

Python Outlines (21 Hr)

Introduction to Python and setup (Jupyter / VS Code)

Variables, data types, operators

Basic input/output

Writing first Python scripts

Lists, Tuples, Dictionaries, Sets

Conditional statements (if/else)

Loops (for, while)

Basic error handling (try-except)

Defining and calling functions

Parameters and return values

Reading from and writing to text/CSV files

Introduction to basic modules (os, sys)

Introduction to web scraping concepts

Using requests library to fetch web pages

Parsing HTML with Beautiful Soup

Extracting text and tables from websites

Introduction to Numpy arrays and operations

Pandas Series and DataFrame basics

Reading/writing CSV files

Filtering, sorting, and aggregating data

Creating basic charts with Matplotlib

Advanced plotting with Seaborn

Interactive visualizations with Plotly

Web scraping to collect data

Data cleaning and manipulation with Pandas/Numpy

Visualizing insights with Matplotlib/Seaborn/Plotly

تقييمات ومراجعات الطلاب

Related Courses

IELTS Test Preparation Course (Start: 15-07-2025)

Excel from Beginner to Professional (Start: 07-07-2025)

Data Analysis Professional Course (Start: 08-08-2025)