DATA ANALYSIS COURSE MODULE
Module 1: Introduction to Data Analysis
1
Introduction to data analysis and its importance
2
Types of data analysis and their applications
3
Overview of the tools: Excel, SQL, Power BI, and Tableau
Module 2: Excel for Data Analysis
- Excel interface and navigation
- Data entry and formatting
- Formulas and functions for basic calculations
- Statistical functions (SUMIFS, AVERAGEIFS, etc.)
- Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH)
Data Validation & Formatting
Data validation and conditional formatting
Pivot Tables & Charts
Creating Pivot Tables for data summarization
Building Pivot Charts for Visual Analysis
Slicers & Filters
Slicers and filters in PivotTables
Module 3: SQL for Data Analysis
1
SQL Syntax
Basics of SQL syntax
2
SELECT & Filtering
SELECT statements and filtering data
3
Sorting & Grouping
Sorting and grouping data
4
JOIN Operations
INNER JOIN, LEFT JOIN, RIGHT JOIN
- Subqueries for advanced filtering
- UNION and UNION ALL
- GROUP BY and aggregate functions (COUNT, SUM, AVG, etc.)
- Window functions for advanced analysis
Module 4: Power BI for Visualization
Power BI Components
Overview of Power BI components
Data Import & Transform
Importing data into Power BI
Transforming and cleaning data in Power BI
Visualizations & Dashboards
Creating visualizations in Power BI
Designing interactive dashboards
Drill-down and cross-filtering in reports
- Introduction to DAX functions
- Creating calculated columns and measures
- Time intelligence functions
Module 5: Tableau for Data Analysis
1
Tableau Interface
Overview of Tableau interface
2
Data Connections
Connecting to data sources
3
Visualizations
Building basic visualizations
4
Mapping & Analysis
Mapping and geographic analysis
5
Calculated Fields
Tableau calculated fields
6
Parameters & Sets
Parameters and sets in Tableau
7
Interactive Dashboards
Creating interactive dashboards
8
Storytelling
Storytelling with Tableau
9
Visualization Tips
Tips for effective Tableau visualization
Module 6: Capstone Project
Data Ethics
Overview of data ethics
Best Practices
Best practices in data analysis
Avoiding Pitfalls
Avoiding common pitfalls