Data Analysis in Excel

1. Understanding Excel Interface
• Installation and Microsoft Terms and Conditions
• Basic Excel Shortcuts
• Data Visualisation in Excel
• Conditional Formatting, VLOOKUP, HLOOKUP, Pivot Table
• Dashboard Presentation in Excel

Installation of required software

1. Installation of Anaconda Navigator
2. Introduction to Jupyter Notebook
3. Installation of required software

Introduction to Python and Setup

1. Python
• Installation
• Variable
• Operator
• Looping Statement
• Conditional Statement
• Pass Statement
• Function
• File Handling
• Basics of working with data in Python
• Unique ways to collect data
• Data Visualisation In Python

Introduction to SQL

1. Introduction to SQL
2. Various Constraints in SQL
3. Star Schema
4. Database Creation and Modification in MySQL workbench
5. Queries in SQL
6. Combining Tables
7. Advanced Filtering
8. SQL Transactions, Variables and Procedures
9. WHERE, BETWEEN, IN, OR, NOT
10. LIKE, ORDER BY, GROUP BY, JOINs
11. Subqueries

Introduction to Statistics

1. Introduction to Statistics
2. Descriptive statistics

Inferential Statistics

1. Categorical & Numerical Inferential Statistics
2. Categorical & Categorical Inferential Statistics
3. Numerical & Numerical Inferential Statistics

Introduction to Data Visualization

1. Introduction to Data Visualization
2. Charts and Plots
3. Visualization using Python

Advanced Data Visualization

1. Visualization using Power BI part 1
2. Visualization using Power BI part 2

Understanding Data

1. Understanding data
2. General statistical analysis

Uni-variate and Bi-variate Analysis

1. Uni-variate data analysis
2. Bi-variate data analysis
3. Multivariate analysis

Project Preparation

1. Project on Data Analytics
2. Live Project