Overview

The Data Analytics Training Program at Analyze Infotech is designed to provide comprehensive knowledge of statistical analysis, business intelligence tools, programming, and data visualization. This industry-focused program equips students with practical skills required to analyze real-world datasets and make data-driven decisions.

Module 1: Introduction to Data Analytics

• Overview and Importance of Data Analytics
• Types of Analytics: Descriptive, Diagnostic, Predictive, Prescriptive
• Data Types and Structures
• Measures of Central Tendency and Dispersion
• Central Limit Theorem & Confidence Intervals
• Data Visualization for Decision Making

Module 2: Business Statistics

• Probability and Distributions
• Sampling & Hypothesis Testing
• Correlation & Regression Analysis
• ANOVA and Chi-Square Test
• Data Cleaning & Missing Value Imputation

Module 3: Excel for Data Analysis

• Excel Basics & Logical Functions
• Pivot Tables & Pivot Charts
• Data Cleaning & Table Management
• Lookup Functions (VLOOKUP, HLOOKUP)
• Advanced Charts & Conditional Formatting

Module 4: SQL for Data Analytics

• Writing SQL SELECT Queries
• Aggregate Functions & Joins
• Subqueries & SET Operators
• DML & DDL Operations
• Schema & User Access Management

Module 5: Python for Data Analytics

• Python Basics & File Handling
• Data Handling with Pandas
• Data Visualization (Matplotlib & Seaborn)
• Statistical Analysis using Scipy & Statsmodels
• GroupBy, Merging & Aggregation

Module 6: Tableau

• Data Connectivity & Data Blending
• Creating Reports & Dashboards
• Advanced Visualizations & Calculated Fields
• Publishing Dashboards on Tableau Server

Module 7: Power BI

• Power BI Concepts & Components
• Creating Interactive Reports
• Dashboard Management & Publishing
• Power BI Desktop & Mobile Usage

Live Projects & Internship

Students will work on real-world datasets and industry case studies to gain practical exposure. Certificate will be provided upon successful completion of training and internship.