Introduction
○ MS office Versions(similarities and differences)
○ Interface(latest available version)
○ Row and Columns
○ Keyboard shortcuts for easy navigation
○ Data Entry(Fill series)
○ Find and Select
○ Clear Options
○ Ctrl+Enter
○ Formatting options(Font,Alignment,Clipboard(copy, paste special))

● Referencing, Named ranges,Uses,Arithemetic Functions
○ Mathematical calculations with Cell referencing(Absolute,Relative,Mixed)
○ Functions with Name Range
○ Arithmetic
functions(SUM,SUMIF,SUMIFS,COUNT,COUNTA,COUNTIFS,AVERAGE,AVERA
GEIFS,MAX,MAXIFS,MIN,MINIFS)

● Logical functions
○ Logical functions:IF,AND,OR,NESTED IFS,NOT,IFERROR
○ Usage of Mathematical and Logical functions nested together

● Referring data from different tables: Various types of Lookup, Nested IF
○ LOOKUP
○ VLOOKUP
○ NESTED VLOOKUP
○ HLOOKUP
○ INDEX
○ INDEX WITH MATCH FUNCTION
○ INDIRECT
○ OFFSET

● Advanced functions
○ Combination of Arithmatic
○ Logical
○ Lookup functions
○ Data Validation(with Dependent drop down)

● Date and Text Functions
○ Date Functions:DATE,DAY,MONTH,YEAR,YEARFRAC,DATEDIFF,EOMONTH
○ Text
Functions:TEXT,UPPER,LOWER,PROPER,LEFT,RIGHT,SEARCH,FIND,MID,TTC
, Flash Fill

● Data Handling::Data cleaning, Data type identification, Remove Duplicates, Formatting
and Filtering
○ Number Formatting(with shortcuts)
○ CTRL+T(Converting into an Excel Table)
○ Formatting Table
○ Remove Duplicate
○ SORT
○ Advanced Sort
○ FILTER
○ Advanced Filter

● Data Visualization: Conditional Formatting, Charts
○ Conditional formatting(icon sets/Highlighted colour sets/Data bars/custom
formatting)
○ Charts:Bar,Column,Lines,Scatter,Combo,Gantt,Waterfall,pie

● Data Summarization: Pivot Report and Charts
○ Pivot Reports:Insert,Interface,Crosstable Reports;Filter,Pivot Charts,
○ Slicers:Add,Connect to multiple reports and charts
○ Calculated field, Calculated item

● Data Summarization: Dashboard Creation, Tips and Tricks
○ Dashboard:Types,Getting reports and charts together, Use of Slicers.
○ Design and placement: Formatting of Tables,Charts,Sheets,Proper use of Colours
and Shapes

● Connecting to Data: Power Query, Pivot, Power Pivot within Excel
○ Power Query: Interface, Tabs
○ Connecting to data from other excel files, text files, other sources
○ Data Cleaning
○ Transforming
○ Loading Data into Excel Query

● Connecting to Data: Power Query, Pivot, Power Pivot within Excel
○ Using Loaded queries
○ Merge and Append
○ Insert Power Pivot
○ Similarities and Differences in Pivot and Power Pivot reporting
○ Getting data from databases, workbooks, webpages

● VBA and Macros
○ View Tab
○ Add Developer Tab
○ Record Macro:Name,Storage
○ Record Macro to Format table(Absolute Ref)
○ Format table of any size(Relative ref)
○ Play macro by button
○ shape
○ as command(in new tab)
○ Editing Macros
○ VBA:Introduction to the basics of working with VBA for Excel: Subs, Ranges,
Sheets
○ Comparing values and conditions
○ if statements and select cases
○ Repeat processes with For loops and Do While or Do Until Loops
○ Communicate with the end-user with message boxes and take user input with
input boxes, User Form

Introduction to Mysql
○ Introduction to Databases
○ Introduction to RDBMS
○ Explain RDBMS through normalization
○ Different types of RDBMS
○ Software Installation(MySQL Workbench)

● SQL Commands and Data Types
○ Types of SQL Commands (DDL,DML,DQL,DCL,TCL) and their applications
○ Data Types in SQL (Numeric, Char, Datetime)

● DQL & Operators
○ SELECT
○ LIMIT
○ DISTINCT
○ WHERE AND
○ OR
○ IN
○ NOT IN
○ BETWEEN
○ EXIST
○ ISNULL
○ IS NOT NULL
○ Wild Cards
○ ORDER BY

● Case When Then and Handling NULL Values
○ Usage of Case When then to solve logical problems and handling NULL Values
(IFNULL, COALESCE)

● Group Operations & Aggregate Functions
○ Group By
○ Having Clause
○ COUNT
○ SUM
○ AVG
○ MIN
○ MAX
○ COUNT String Functions
○ Date & Time Function

● Constraints
○ NOT NULL
○ UNIQUE
○ CHECK
○ DEFAULT
○ Primary key
○ Foreign Key (Both at column level and table level)

● Joins
○ Inner
○ Left
○ Right
○ Cross
○ Self Joins
○ Full outer join

● DDL
○ Create
○ Drop
○ Alter
○ Rename
○ Truncate
○ Modify
○ Comment

● DML & TCL Commands
○ DML
■ Insert
■ Update & Delete
○ TCL
■ Commit
■ Rollback
■ Savepoint
■ Data Partitioning
● Indexes and Views
○ Indexes (Different Type of Indexes)
○ Views in SQL

● Stored Procedures
○ Procedure with IN Parameter
○ Procedure with OUT parameter
○ Procedure with INOUT parameter

● Function, Constructs
○ User Define Function
○ Window Functions
○ Rank
○ Dense Rank
○ Lead
○ Lag
○ Row_number

● Union, Intersect, Sub-query
○ Union, Union all
○ Intersect
○ Sub Queries, Multiple Query

● Exception Handling
○ Handling Exceptions in a query
○ CONTINUE Handler
○ EXIT handler

● Triggers
○ Triggers - Before | After DML Statement

Introduction to Tableau
○ What is Tableau ?
○ What is Data Visulaization ?
○ Tableau Products
○ Tableau Desktop Variations
○ Tableau File Extensions
○ Data Types, Dimensions, Measures, Aggregation concept
○ Tableau Desktop Installation
○ Data Source Overview
○ Live Vs Extract

● Basic Charts & Formatting
○ Overview of worksheet sections
○ Shelves
○ Bar Chart, Stacked Bar Chart
○ Discrete & Continuous Line Charts
○ Symbol Map & Filled Map
○ Text Table, Highlight Table
○ Formatting: Remove grid lines, hiding the axes, conversion of numbers to
thousands, millions, Shading, Row divider, Column divider
○ Marks Card

● Filters
○ What are Filters ?
○ Types of Filters
○ Extract, Data Source, Context, Dimension, Measure, Quick Filters
○ Order of operation of filters
○ Cascading
○ Apply to Worksheets

● Calculations
○ Need for calculations
○ Types: Basic, LOD's, Table
○ Examples of Basic Calculations: Aggregate functions, Logical functions, String
functions, Tablea calculation functions, numerical functions, Date functions
○ LOD's: Examples
○ Table Calculations: Examples

● Data Combining Techniques
○ What is Data Combining Techniques ?
○ Types
○ Joins, Relationships, Blending & Union

● Custom Charts
○ Dual Axis
○ Combined Axis
○ Donut Chart
○ Lollipop Chart
○ KPI Cards (Simple)
○ KPI Cards (With Shape)

● Groups, Bins, Hierarchies, Sets, Parameters
○ What are Groups ? Purpose
○ What are Bins ? Purpose
○ What are Hierarchies ? Purpose
○ What are Sets ? Purpose
○ What are Parameters ? Purpose and examples

● Analytics & Dashboard
○ Reference Lines
○ Trend Line
○ Overview of Dashboard: Tiled Vs Floating
○ All Objects overview, Layout overview
○ Dashboard creation with formatting

● Dashboard Actions & Tableau Public
○ Actions: Filter, Highlight, URL, Sheet, Parameter, Set
○ How to save the workbook to Tableau Public website ?

Power BI Introduction and Installation
○ Understanding Power BI Background
○ Installation of Power BI and check list for perfect installation
○ Formatting and Setting prerequisits
○ Understanding the difference between Power BI desktop & Power Query

● The Power BI user interface, including types of data sources and visualizations
○ Getting familiar with the interface BI Query & Desktop
○ Understanding type of Visualisation
○ Loading data from multiple sources
○ Data type and the type of default chart on drag drop.
○ Geo location Map integration

● Sample dashboard with Animation Visual
○ Finanical sample data in Power BI
○ Preparing sample dashboard as get started
○ Map visual Types and usages in different variation
○ Understanding scatter Plot chart with Play axis and the parameters

● Power BI artificial intelligence Visual
○ Understanding the use of AI in power BI
○ AI analysis in power bi using chart
○ Q&A chat bot and the use in real life
○ Hirarchy tree

● Power BI Visualization
○ Understanding Column Chart
○ Understanding Line Chart
○ Implementation of Conditional formating
○ Implementation of Formating techniques

● Power Query Editor
○ Loading data from folder
○ Understanding Power Query in detail
○ Promote header, Split to limiter, Add columns, append, merge queries etc

● Modelling with Power BI
○ Loading multiple data from different format
○ Understanding modelling (How to create relationship)
○ Connection type, Data cardinality, Filter direction
○ Making dashboard using new loaded data

● Power Query Editor Filter Data
○ Power Query Custom Column & Conditional Column
○ Manage Parameter
○ Introduction to Filter and types of filter
○ Trend analysis, Future forecast

● Customize the data in Power BI
○ Understanding Tool tip with information
○ Use and understanding of Drill Down
○ Visual interaction and customisation of visual interaction
○ Drill through function and usage
○ Button triggers
○ Bookmark and different use and implementation
○ Navigation buttons

● Dax Expressions
○ Introduction to DAX
○ Table Dax, Calculated column, DAX measure and difference
○ Eg:- Calendar, Calendar auto, Summarize, Group by etc
○ Calculated Column
○ Related, Lookup value, switch, Datedif,Rankx,Date functions
○ Dax Measure and Quick Measure
○ Remove filters, Keep filters, All, Allselected, Time Intelligence Functions,Rolling
average,YoY, Running total

● Custom Visual
○ Custom visual and understanding the use of custom
○ Loading custom visual, Pinning visual
○ Loading to template for future use
○ Publishinhg Power Bi

● Power BI Service
○ Introduction to app.powerbi.com
○ Schedule refresh
○ Data flow and use power bi from online
○ Download data as live in power point and more

Business Statistics
● Descriptive Statistics
○ Data Types, Measure Of central tendency, Measures of Dispersion
○ Graphical Techniques, Skewness & Kurtosis, Box Plot

● Probability and Normal Distribution
○ Random Variable, Probability, Probility Distribution, Normal Distribution, SND,
Expected Value

● Inferential Statistics
○ Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
○ Introduction to Hypothesis Testing
○ Hypothesis Testing (2 proportion test, 2 t sample t test)
○ Anova and Chisquare

● Data cleaning and Insights
○ Data Cleaning(Invalid cells,Blanks,Outliers,Null values)
○ Imputation Techniques(Mean and Median)
○ Scatter Diagram
○ Correlation Analysis

Fundamentals Of R
Introduction to R,Installation of Rstudio,Data Types in R
○ Data types(Numeric,Char,Logical,Complex,Vector,List,Matrix,Factor,Array,Dataframe),R
elational operators,Logical operators

Decision making statements,Loops,Functions
○ If,Ifelse,For loop,While loop,Repeat,Functions

Built in Functions in R,Joins,dplyr and ggplot2
○ Merging dataframes,Analyzing Iris Dataset using apply functions,dplyr
package(Filter,Sel,Arrange),Data visualization using
ggplot2,Scatterplot,Histogram,Boxplot

Fundamentals Of Python
Anaconda Installation,Introduction to python,Data types,Opearators
○ Variables,data types(integer,Boolean,Float,List,tuple,string),Opearators in python

● Data types Contd,Slicing the data,Inbuilt functions in python
○ Dictionaries,Sequence methods,Concatenate,Repetition,len,min,max
functions,Index position,Addition and deletion of elements,Reverse,Sorting

● Sets,Set Theory,Regular Expressions,Decision making statements
○ Sets,re module(findall,search,split,match),if,elifGetting input from user,Identity
Operators

● Loops,Functions,Lambda functions,Modules
○ For,While loops,Functions,Lambda functions,Math module,Calender module,Date
& time module

●Pandas,Numpy,Matplotlib,Seaborn
○ Data frame creation using different methods,Using Pandas anlysis on
Universities,Salary data sets,Visualization using Matplotlib and Seaborn,Numpy
introduction

Introduction to ChatGPT and AI
● What is ChatGPT?
● The history of ChatGPT
● Applications of ChatGPT
● ChatGPT vs other chatbot platforms
● Industries using ChatGPT
● The benefits and limitations of ChatGPT
● Future developments in ChatGPT technology
● Ethical considerations related to ChatGPT and AI
Types of AI and Chatgpt architecture
● What is AI?
● Types of AI
● What is Machine Learning?
● Neural Networks
● Deep Learning
● Natural Language Processing (NLP)
● Computer Vision
● Robotics and AI
ChatGPT Functionalities and Applications
● How does ChatGPT work?
● ChatGPT Functionalities
● Drafting emails and professional communication
● Automating content creation
● Resume and Cover letter creation
● Research and information gathering
● Brainstorming ideas and creative problem solving
● Best Practices for Using ChatGPT
ChatGPT Prompt Engineering
● What is Prompt Engineering?
● Types of Prompts
● Crafting Effective Prompts
● Using ChatGPT to generate prompt