ADVANCED EXCEL

Introduction to excel

Referencing, Uses, Named Ranges, Arithmetic Functions, Logical Functions, Referring Data from Different tables, Advanced Functions, Data Handling, Data Visualization, Data Summarization, Connecting to Data, VBA and Macros.

MYSQL

Introduction to MySQL

SQL Commands and Data Types, Case When Then and Handling NULL Values, Group Operations & Aggregate Functions, Constrains & Joins, DDL, DML & TCL Commands, Indexes, Views & Stored Procedure, Function, Constructs, Union, Intersect & Sub-query, Exception Handling Triggers.

TABLEAU

Introduction to tableau

Basic Charts & Formatting, Filters, Calculations, Data Combining Techniques, Custom Charts, Analytics & Dashboard.

POWER BI

Power BI Introduction and Installation

The Power BI User interface, Sample dashboard with Animation Visual, Power BI artificial intelligence Visual, Power BI Visualization, Power Query Editor, Modelling with Power BI, Power Query Editor Filter Data, Customize the data in Power BI, Dax Expressions, Custom Visual, Power BI Service.

BUSINESS STATISTICS

Data Types, Measure of Central Tendency, Measures of Dispersion, Skewness & Kurtosis, Box Plot, Random, Variable, Probability, Probability Distribution, Sampling Funnel, Central Limit Theorem, Confidence Interval, Introduction to Hypothesis Testing, Anova and Chi-Square Test, Data Cleaning, Scatter Diagram & Correlation Analysis.

PYTHON

Intro to Python, Variables, Data Types, Data Structures, Loops, Functions, Pandas, Numpy, Matplotlib, Seabom.

R PROGRAMMING.

Intro to R, Data Types, Data Structures, Decision Making Statements, Loops, Dplyr Package, Visualizations.