Module 1: STATISTICS FUNDAMENTALS
Module 1 Introduction to Statistics
Module 2 Descriptive Statistics
Module 3 Probability Concepts
Module 4 Discrete and Continuous Distributions
Module 5 Sampling and Sampling Distributions
Module 6 Hypothesis Testing
Module 7 Confidence Intervals
Module 8 Correlation and Regression Analysis
Module 9 ANOVA and Chi-Square Tests
Module 10 Advanced Statistical Methods
Measures the dispersion or spread of data points around the mean
lecture 2 Assignment
Module 2: Excel for Data Analysis
Introduction to Excel for Data Analysis
Data Validation
Data modeling
EXCEL ALL FUNCTIONS
Pivot Tables
Comprehensive Guide to Power Query in Excel
Working with Big Data in Excel
Power-Query
Introduction to DAX Functions and Usage
Conditional Formatting
Comprehensive Guide to Excel Text Functions
Module 3: Power BI for Data Analysis
Module 1 Introduction to Power BI
Module 2 Data Preparation and Transformation
Module 3 Building Data Models
Module 4 Introduction to DAX
Module 5 Advanced DAX Functions
Module 6 Creating Visualizations
Module 7 Interactive Dashboards
Module 8 Publishing and Sharing Reports
Module 9 Power BI Integration and Automation
Module 4: Introduction to Tableau
Module 5: SQL for Data Analysis
module 1 MySQL Training Key Concepts
module 2 Advanced MySQL Integration and Data Visualization
module 3 Real-world Data Analysis Projects
Module 6: Python For Data Analysis
Getting Started with Python
Variables , Strings , Arithmetic Operations, Comparison Operations , Identity Operations , Assignment Operations , Membership operations , List
• If statement • Data structure • TUPLE • SET • DICTIONARY • loop
• Functions • Error handling • Basics of File Handling in Python • Modules and Libraries
Seaborn
Advanced Seaborn Techniques
Matplotlib
Advanced Matplotlib Techniques
NumPy
Introduction to Data Visualization
INTRODUCTION TO PLOTLY
Pandas
Module 7: Web Scraping for Data Analysis
MODULE 1 Comprehensive Guide to Web Scraping with Python
MODULE 2 Comprehensive Guide to Web Automation and Data Extraction
MODULE 3 Mastering Dynamic Web Scraping and Data Management
Module 8: Machine Learning
Workshop
Apply your acquired knowledge and skills to a real-world data analysis project.
Work independently or in a team to solve a data-driven problem, from data acquisition to analysis and presentation of findings.
Develop a portfolio-worthy project that showcases your data analysis expertise.