● Basic Module
○ Introduction to Microsoft Excel
○ Installing Excel: Windows / Mac
○ Getting Familiar With Excel
○ Introduction to Tables
○ Input data into cells
○ Introduction to Formulas
○ Formula Behavior
○ Built in Functions
○ Combining Data From Two Tables
● Advance Module
○ Pivot Tables
○ Nested IF statements
○ VBA to automate tasks
○ Custom Functions

● Descriptive Statistics
○ Data
○ Types of Data
○ Collection of Data
○ Population & Sample
○ Sampling Techniques
○ Measures of Central Tendency
○ Measures of Spread
○ Measures of Shape
○ Percentiles
○ Quartiles
○ Inter Quartile Range (IQR)
○ Outliers
○ Correlation
○ Covariance
○ Probability
○ Probability Distributions
○ Calculation of Probability using
○ Standard Error
○ Central Limit Theorem
○ Confidence Intervals
● Inferential Statistics
○ Hypothesis Testing
○ Formulation of Null & Alternate Hypothesis
○ Type-I error & Type-II error
○ P value
○ Left tail vs Right tail vs Two tail
○ 1 Sample test (Z test & T test)
○ 2 Sample test (independent test & paired test)
○ ANOVA Test
○ Chi-square Test

● Basic Module
○ Introduction to Python
○ Installation of Python
○ Variables
○ Input
○ Output
○ Data types
○ Data Structures
○ Operators
○ Condition Statements
○ Loops
○ Functions
● Advance Module
○ Advance Functions
○ File handling
○ Errors
○ Exception Handling

● Numpy
○ Introduction to Numpy
○ Numpy Attributes
○ Array creation
○ Indexing & Slicing
○ Iteration over an array
○ Array Manipulation
○ Mathematical Operators
○ Relational Operators
○ Functions
● Pandas
○ Introduction to Pandas
○ Series & Data Frame
○ Create Data Frame
○ Column Selection, Addition & Deletion
○ Row Selection, Addition & Deletion
○ Merging & Concatenation
○ Import of Data from various sources
○ Basic insights of datasets
○ Summarizing Data
○ Sorting
○ Discretization
○ Indexing and Selecting Data
○ Filtering data
○ GroupBy
○ Exporting Data
○ Statistical Functions

● Univariate Analysis
● Bivariate Analysis
● Multivariate Analysis
● Matplotlib
○ Histogram
○ Box plot
○ Scatter Plot
○ Line Plot
○ Pie Chart
○ Bar Chart
○ Subplots
● Seaborn
○ Bar Plot
○ Count Plot
○ Box Plot
○ Line Plot
○ Scatter Plot
○ Regression Plot
○ Pair Plot
○ Heatmap
○ Violin Plot

● Dealing wrong Data
● Dealing wrong data types
● Treating the duplicates
● Dealing Missing Values
● Handling Outliers
● Drop unnecessary columns

● Basic Module
○ Introduction to Databases
○ Databases vs Spreadsheets
○ DBMS vs RDBMS
○ Introduction to SQL
○ SQL vs NoSQL
○ Installation of MySQL
○ Data Types in SQL
○ Keys – Primary Key & Foreign Key
○ Constraints
○ CRUD Operations
○ SQL Languages
○ SQL Commands
○ SELECT
○ SQL Clause
○ Operators
○ Wild cards
○ Aggregation functions
● Advance Module
○ SQL Joins
○ Normalization
○ De-Normalization
○ SQL Functions
○ Sub queries
○ Common Table Expressions (CTE)
○ Views
○ Stored procedures

● Basic Module
○ Introduction to Power BI
○ Connectivity Modes
○ Power BI Desktop and Data Transformation
○ Data Visualization & Dashboard
● Advance Module
○ Introduction to DAX
○ Data Types in DAX
○ DAX Calculation Types
○ Steps to Create Calculated Columns
○ Measures in DAX
○ DAX Syntax
○ DAX Functions
○ DAX Operators
○ DAX Tables and Filtering

● Basic Module
○ Introduction to Tableau
○ Connections
○ Visual Analytics
○ Basic Charts
○ Sorting
○ Filtering
○ Grouping
○ Sets
○ Built-in Functions (Number, String, Date, Logical and Aggregate)
○ Operators and Syntax Conventions
○ Table Calculations
● Advance Module
○ Types of Calculations
○ Trend lines
○ Reference lines
○ Forecasting
○ Advance Plots
○ Dashboard