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 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: 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 5: 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 6: 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.