Data and Information - Introduction to the Data , Differentiating between Data and Information, Structure Data, Semi Structured Data , Unstructured Data. Types of Analysis - Introduction to Data Analysis, Descriptive Data Analysis , Diagnostics Data Analysis, Predictive Data Analysis , Prescriptive Data Analysis , Decision Making.

Framework and Data Processing Methods - Overview of end to end process,V-Lookup (Merging two data) , Handling Missing Value , Data Formatting , Quartile (handling outlier), Feature Engineering. Tools and Technologies - Overview of Spreadsheet , SQL and Tableau

Covid Dataset

Operation Of Spreadsheet - Advantages and use of Spreadsheet , Overview of the operation of Spreadsheet, Sorting , Filtering , Conditional Formatting , Handling Duplicates etc. Function of Spreadsheet - Overview of the functions : Sumif, countif, IF, Count , Charts etc.

Introduction to the Business problem - Introduction to the company with the available dataset, Business problem explanation , Description of the Data points. Data Processing : Merging Data - V-Lookup Function , Syntax , Errors of V-lokup , Drawback. Data Processing : Missing Values - Introduction to the Missing values, Missing Value representation , Imputation Method , Average, Standard Deviation , Median.

Data Processing: Handling Outliers - Introduction to Outliers , Quartile Function, Candlestick Chart , Finding Outliers. Data Processing : Data Formatting - Data Representation, Formatting of data point. Data Processing: Feature Engineering - Introduction to Feature Engineering and its impact on analysis

Data Analysis Methods - Introduction to the type of data , Univariate Method ,Bivariate Method ,Multivariate Method. Univariate Methods and Analysis - Continuous Value : Trim mean , Density plot, Frequency table. Categorical value : Pivot Table.

Bivariate Methods and Analysis - Continuous to Continuous Method, Categorical to Categorical Method, Categorical to Continuous Method, Scatter Plot , Correlation.

Framework of Storytelling - Storytelling for Business Problem.

Step by Step analysis of the Business Problem - Data processing , Univariate Analysis, Bivariate Analysis.

Analysis of World Economic Data .

Introduction to Database - Database Definition , Database type , RDBMS Database. Introduction to SQL - Introduction to SQL , Database creation, Table creation , Create,Update, Delete , Alter.

Retrieving and Filtering the Data - Select and From keyword , Where Clause. Aggregation Operation - SUM,MIN,MAX,AVG ,COUNT.

Group by operation - Group by clause, having clause ,Order by Clause ,IN, BETWEEN, LIKE .

Introduction to Join - Different types of Join : Inner Join, Outer Join , Cross Join, Left Join, Right Join. Its applications.

Supermarket Data Analysis.

Introduction to Data Visualisation - Different ways for Data Visualisation, Types Of Data Visualisation, What is Data Visualisation? Importance Of Data Visualisation. Introduction to Tableau - Automatically Generated Fields, Dimension & measure, Tableau Navigation, Data Joins and Union, Connect with Data, Tableau Installation, What is Tableau, Data Types. Tableau Visualisations - Histogram, Bar Chart, Area Chart, Adding customization, Let’s create the First plot, Understanding the Basics of Plotting, Types of charts, Line Chart