Syllabus of Data Analytics Course in Pune
Module 1: Foundations of Data Analysis
- Static Analysis
- Counting, Probability, and Probability Distributions
- Sampling Distributions
- Estimation and Hypothesis Testing
Module 2: Exploratory Data Analysis
- Scatter Diagram
- ANOVA and Chi-square
- Data Cleaning
- Correlation and Regression
- Imputation Techniques
Module 3: Data Analytics Overview
- Importance of Data Analytics
- Descriptive Analytics
- Diagnostic Analytics
- Predictive Analytics
- Prescriptive Analytics
- Benefits of Data Analytics
Module 4: Data Visualization
- Graphical Techniques
- Data Types, Measure Of central tendency, Measures of Dispersion
- Skewness & Kurtosis
- Box Plot
- Data Visualization Tools
Module 5: Basic Excel for Data Analysis
- The CONCATENATE Function
- Absolute Cell References
- Data Validation
- Conditional Formatting
- Using the IF Function
- Pivot Tables
- Charts
- Difference between Tables and Ranges
- Create Table
- Removing Unwanted Characters from Text
Module 6: Advanced Excel for Data Analysis
- Date Formats
- Conditional Formatting
- Filtering
- Lookup Functions
- Sorting
- Pivoting
Module 7: Structured Query Language (SQL)
- SQL SELECT Statement
- Usage of Single-Row Functions
- Invoke Conversion Functions
- Conditional Expressions
- Aggregate Data Using the Group Functions
- Display Data From Multiple Tables Using Joins
- Use Sub-queries to Solve Queries
- The SET Operators
- Data Manipulation Statements
- Use of DDL Statements to Create and Manage Tables
- Management of Schema Objects
- Manipulate Large Data Sets
- Data Management in Different Time Zones
- Retrieve Data Using Sub-queries
- Regular Expression Support
Module 8: Data Visualization Tools- Power BI
- Introduction to Power BI
- Power BI Desktop
- Data Source Connection
- Data Transforming
- Modeling using Power BI
- Data Visualization
- Reports and Dashboards
- Publishing and Sharing Reports
Module 9: Data Visualization Tools- Tableau
- Tableau Basic Reports
- Tableau Charts
- Tableau Advanced Reports
- Calculations & Filters
- Tableau Dashboards
- Server
Module 10: Python for Data Analysis
- Basics of Python
- Program Flow / Data Flow
- Functions
- File Handling
- Exception Handling
- OOP Concepts
- Comprehension in Python
- Thread and DateTime
- Advanced data Structure/collections
- GUI programming with Python
- API access with Python