Scribd
Upload
59 views10 pages

Data Analysis and Visualization

The document outlines a comprehensive 120-hour training course on Data Analysis and Visualization, covering topics such as statistics, Excel, Python, SQL, Power BI, and Tableau. Each section includes specific skills and tools to be learned, culminating in a capstone project focused on creating a dashboard using SQL and Excel. The training aims to equip participants with the necessary skills for effective data analysis and visualization across various industries.

Uploaded by

younisomar768
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
59 views10 pages

Data Analysis and Visualization

The document outlines a comprehensive 120-hour training course on Data Analysis and Visualization, covering topics such as statistics, Excel, Python, SQL, Power BI, and Tableau. Each section includes specific skills and tools to be learned, culminating in a capstone project focused on creating a dashboard using SQL and Excel. The training aims to equip participants with the necessary skills for effective data analysis and visualization across various industries.

Uploaded by

younisomar768
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
You are on page 1/ 10

Data

Analysis and
Visualization
Comprehensive 120-Hour
Training
Introduction to Data Analysis (4h)
Introduction to Statistics (10 hours)
Excel for Data Analysis (14 hours)
Course Python for Data Analysis (20 hours)
Outline
SQL for Data Analysis (24 hours)
Power BI for Visualization (20 hours)
Tableau for Visualization (20 hours)
Capstone Project (8 hours)
Introduction to Data
Analysis (4h)

• What is Data Analysis?


• Structured vs. Unstructured Data

• Data Analysis Process: Collect, Clean,


Analyze, Visualize
• Applications in Industries
Introduction to
Statistics (10h)

• Descriptive Statistics
• Measures of Central
Tendency and Dispersion

• Data Visualization:
Histograms, Boxplots
• Probability: Normal, Binomial,
Poisson
• Hypothesis Testing: T-tests,
Chi-Square, ANOVA

• Confidence Intervals
Excel for Data
Analysis (14h)

• Data Cleaning: Remove Duplicates,


Validation
• Functions: AVERAGE, STDEV, IF,
VLOOKUP
• Charts & Graphs
• Pivot Tables & Pivot Charts
• Power Query Basics
Python for Data
Analysis (20h)

• Python Basics: Variables, Loops,


Functions
• Pandas and NumPy

• DataFrames and Series


• Data Cleaning and Aggregation
• Visualizations with Matplotlib &
Seaborn
• Intro to Machine Learning (Linear
Regression)
SQL for Data Analysis (24h)

• Basics: SELECT, WHERE, ORDER BY


• Aggregation: COUNT, SUM, AVG, GROUP BY

• Joins: INNER, LEFT, RIGHT, FULL


• Subqueries and CTEs
• Window Functions: RANK, DENSE_RANK

• Performance Tuning
• Stored Procedures
Power BI for
Visualization (20h)
• Power BI Interface Overview
• Connecting to Excel, SQL

• Power Query for Cleaning


• Data Modeling & DAX Basics
• Creating Dashboards & Reports

• Publishing and Sharing Insights


Tableau for Visualization
(20h)

• Tableau Interface Overview


• Connecting Data Sources

• Dimensions, Measures, Filters


• Building Visualizations: Maps, Charts
• Calculated Fields, Parameters

• Dashboards and Storytelling


• Tableau Public & Sharing
Capstone Use case: Sales Analytics or HR
Project (8h) Dashboard

Data Source: SQL + Excel

Tools: SQL + Python + Power BI or


Tableau

Deliverables: Dashboard, Insights,


Presentation

You might also like