Part 1:

• Introduction to Data Analytics

• Component of Data Analytics

• Tools need to be a Data analyst

• Scope of a Data Analyst

• Why Data Analyst

• Cell formatting: Copy, Cut and Paste

• Formatting Shortcut

• Text function (Join and Split)

• Freezing Panes

Part 2:

• Cell referencing (Relative vs absolute)

• Self-Finance handle in Excel

• Conditional formatting

• Data Structure: Shorting and Filtering

• Customizing header and footer

• Using Print area and print related tutorial

Part 1:

• Logical Function (Filter, IF, And, OR)

• Carefulness of VLOOKUP, HLOOKUP

• Using SUMIF, COINTIF, SUMIFS, COUNTIFS, COUNTA, INDEX & MATCH function

• MAXIFS, MINIFS, AVERAGEIFS

Part 2:

• What if analysis

• Inserting calculated filed and calculated items

• Shorting and filtering technique with pivot table

• Slicer in Pivot table (creating, changing and formatting)

• Dynamic pivot table using slicer

Part 1:

• Understand table structure

• Understand various relationships

• Understand primary key and foreign key

Part 2:

• Using Measure in power pivot

• Data Analysis with Power pivot

• Dax in power pivot

Part 1:

• What is power query

• Understand the table structure

Part 2:

• Creating data model

• Data analysis with PowerPivot Business Dashboard

Part 1:

• Using power query | Power Pivot| Web scrapping data | Dax

SQL for Data Modeling and visualization

Part 1:

• Understand SQL and Data Models

• Basic SQL syntax and Structure

• SELECT statement: Receiving data from table

• Filtering Data with WHERE clause

• Usage Of GROUP BY

• Shorting Data with Order by clause

Part 2:

• Introduction to SQL in Data Analytics

• SQL queries for Data Extraction

• Working with INNER, LEFT, RIGHT, FULL JOINS

• Usage of CASE statement

• Hands of Activity: Business case analysis using SQL

Part 1:

• Overview of Power BI and its ecosystem

• Installing and setting Up Power BI Desktop

• Power BI interface basics: Panes, ribbons, views

• Overview of data sources compatible with power bi

• Hands on activity connecting to simple dataset and importing data

Part 2:

• Introduction to Power Query editor

• Data transformation basic: filtering, merging and appending tables

• Data cleaning technique

• Data modeling, Basic data scrapping

• Data Shaping pivoting and unpivoting

• Using Power query to clean and transform raw data

Part 1:

• AI in Data Analytics and its importance

• AI feature in Excel

Part 2:

• AI feature in Power Bi

• Understand AI feature in Power BI: Section introduction, Anomaly detection, smart Narrative, Smart Q & A generate, Decompression Tree, AI based key influences