• Introduction to Data Analytics

  • What is Data Analytics?

  • Importance and Applications of Data Analytics

  • Overview of the Data Analytics Process

• Basic Statistics Concepts (Mean, Median, Mode, Variance, Standard Deviation)
• Probability Theory & Distributions (Normal, Binomial, Poisson)
• Hypothesis Testing & Confidence Intervals
• Correlation & Regression Analysis

•  Excel: Basics to Advanced
  ● 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
  ● Logical functions
  ○ LOOKUP
  ○ VLOOKUP
  ○ NESTED VLOOKUP
  ○ HLOOKUP
  ○ INDEX
  ○ Arithmetic
  functions(SUM,SUMIF,SUMIFS,COUNT,COUNTA,COUNTIFS,AVERAGE,AVERAGE
  IFS,MAX,MAXIFS,MIN,MINIFS)
  ○ 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
  ○ 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.
  ○ Power Query: Interface, Tabs
  ○ Data Cleaning
  ○ Transforming
  ○ Design and placement: Formatting of Tables,Charts,Sheets,Proper use of Colours
  and Shapes
  ● Connecting to Data: Power Query, Pivot, Power Pivot within Excel
  ○ Connecting to data from other excel files, text files, other sources
  ○ 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

● 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,elseif Getting 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

Power Bi Training
● Power BI Introduction and Installation
○ Understanding Power BI Background
○ Formatting and Setting prerequisits
○ Installation of Power BI and check list for perfect installation
○ 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

            OR 

● Tableau Training
● 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 ?

• Two – Hands-on Industry Projects
• Resume Building & Portfolio Development
• Data Analytics Case Studies & Best Practices
• Mock Interviews & Placement Assistance