Get in Touch

9999491895

Data Analytics Training Modules

SLA Consultants India is Training & Development Company and we provide Data Analyst /Business Analyst/Data
Analytics Practical Training for More Than 10+ Years with a Proven Track Record to Train for Data Analyst
/Business Analyst/Data Analytics-Fresher to experienced professionals. SLA Consultants Always Invites
Graduates, Post-Graduates, Pursuing Masters or Professional for Practical Training Classes with Real Time
Exposure.

Course Duration: 150 HRS with Highly Skilled Corporate Trainers for 5 Modules SLA Consultants India Data
Analytics/Business Analyst in Excel, Power Pivot, VBA/Macros, SQL, Tableau, Power BI, R-Program, Python
Training Delivery Method:

• Web / Desktop Base

• Instructor-Led Classroom Sessions,
• Presentations/Demonstration/Practical of Concepts.
• Handouts/Assignments/Real-time Exposure to Work on Clients

Please visit to our website to get more details:

http://www.slaconsultantsindia.com/institute-for-data-analytics-training-course.aspx

Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

Module 1 Excel & VBA/Macros Analytics

Section A – Basic & Advanced Excel
 Introduction to Excel,
 Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics,
Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

 Mathematical Functions:-
 Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs,
Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
 Text Functions:-
 Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper,
Text, Trim, Value
 Date & Time Function:-
 Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute,
Second, Now, Today, Time
 Logical Functions:-
 And, Or, If, Iferror, Not, Nested If
 Lookup & Reference Functions:-
 VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays
Concept In Lookup Formula’s

Section B – Analysis using MS Advanced Excel

 Lesson 1: Introduction to Business Analytics

 What is Analytics?
 Overview of different Analytics with Segment
 Customer Analytics
 Understand Business Analysis Key Concepts
 Performance Analytics
 Risk Analytics
 Lesson 2: Formatting, Auto Formatting & Data Manipulation
 Conditional Formatting
 Freezing Concept
 Data Validations
 Logical Functions
 And, If, Nested IF, Not, OR, True, False
 SUMPRODUCT, IFERROR, CONCATENATE, MOD, LEN, RIGHT, LEFT
 Vlookup/Hlookup, Index, Match, Offset
 Statistical and Mathematical Functions
Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

 Rank, Quartile, Percentile, Correl, Geomen

 Trace Precedents and Trace Dependents
 Round, Roundup, Round down, Max, Min, Large, Small
 Standard Deviation, Correlation, Mean, Median, Sum, Count, , Countifs , Sumif, Sumifs
 Lesson 3: Data Analysis & Visualization - Power Pivot
 Pivot Table
 Power Pivot
 What-if Analysis
 Data Table –One Variable and Two Variables
 Data Analysis Using Statistics
 Descriptive Statistics
 ANOVA
 Moving Average
 Testing Hypothesis
 Measuring Covariance and Correlation
 Distribution
 Regression
 Graphs & Charts
 Analysis Tool Pack
 Solver
 Histogram
 Pareto
 Water Fall etc.

 Lesson 4: What is Dashboards and Excel Dashboard?

 Overview of Chart types, Chart Formatting
 Active X Form Controls
 Principle of great dashboard design
 Selecting Correct Chart to display data
 Interactive Charts with Form Controls
 Combo box, Check Box, Scroll Bar and Radio Button
 Interactive Dashboard with Form Controls
 Form Controls for reports automation
 Data Models using Power Pivot

Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

Module 2- DASHBOARD & VBA / Macros Programming Objective

Dashboard Reports Allow User to Get High-Level Overview of the Business and Help Them Make Quick
Decisions. Dashboards are Often Called as Management Information System (MIS), Which Provides
Information that Organizations Require to Manage Themselves Efficiently and Effectively.

 To Define KPIs (Key performance Indicator), Customer Service Dashboards or Project Management
Dashboard (Gantt Chart)
 Dashboard Reports Based on Tables and Number or Charts/Graphs or Both.

 Introduction to Programming Introduction to logical thinking flowcharts & algorithms:

 Define Objective, Start & End Points; Identifying Solution & Breaking it Into Sequential Steps Writing a
Algorithm
 Step-by-Step Instructions, Flowcharts, Process Flow Diagrams. Excel Macros - an Introduction
 Complete Review of the VBA Language (Subs, Functions, Variables, Arrays, Loops, Logic...etc.)
 Excel Macro Language Review (VBA) Including Variables, Data Types, Constants, Arrays, Operators,
Expressions, Loops, Logic Decisions And Calling
 Overview Of Commanding Excel Using VBA Including A Discussion Of Objects, Properties And Methods
 The Power of Macros - What, When, How to use Macros.
 Introduction to Object Oriented Programming
 Objects, Its Functions, Methods and Properties Introduction to Events
 Details of Events, How & When to use of Events, Preparing to 'Macro' Visual Basic Editor (VBE) –
Developer Tab, Security
 Introduction to the VBE, Properties window, Project Explorer, Password Protection of Code How to use
the VBE - Features, Options, Intelligence Technology
 Debugging Mode, Bookmarks, Breakpoints, Watch Window, Immediate Window and Locals Window
Inbuilt VBE Help Feature - Tips and Tricks
 Form Controls vs. ActiveX Controls Getting into the Code
 Message Box and Input Box Working with Data in Excel through VBA
 Data Types, Constants and Variables
 Different type of data type; How and When to use Variables to Store Information.
 For-Next, For-Each, Do-While, Do until, Do Loop Decision-Making and Code Branching
 If-Then-Else, Select-Case, And/or Nested Conditions
 What is user’s Defined Functions?
 How to create & use them.
 Use of Arrays in VBA programming with one dimensional, two dimensional or multi-dimensional analysis

 Excel VBA Power Programming For VBA Macros

Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

 Working with Dynamic Ranges. Protecting Worksheets, Cells and Ranges. Working with Multiple Files.
Opening & Saving Files
 How to Analyze Data On Multi Worksheets And Build Summary Sheets
 How to Access The Windows File And Folder System To Open And Close Workbooks
 How to Protect Your Code Against Errors
 How to Use Excel And VBA To Create Basic Dash Boards
 How to Create Your Own Custom Business Worksheet Functions In VBA
 How to Create Basic Report Generation Tools Using Excel VBA, Microsoft Word And PowerPoint
 How to Use The Excel Visual Basic Macro Recorder To Record Excel Tasks In VBA And Then Interpret The
Code
 Overview of Using User forms To Create Business Wizards
 Working with User Forms & User Forms Events like List box, Combo box, Option Buttons, Check box,
Text box, Labels, Command button, Toggle button.
 How to create dynamic dashboard on user form with different controls
 How to link various user form with each other to create a complete interface between user and system
 Connection between Excel VBA & other platforms
 How to Establish Connection Between VBA and Internet Explorer to Open any Internet Website through
VBA
 How to Establish Connection Between Excel VBA and power presentation to create power point through
VBA
 How to Establish Connection Between Excel VBA and Access database to update the data in access
through VBA
 How to Establish Connection Between Excel VBA and outlooks through VBA
 How to Establish Connection Between Excel VBA and MS Word through VBA
 Testing and Debugging Your Code
 Effective Error Handling
 Automation Development Reports & Live Projects

Module 3 - SQL & Access

Access is a relational database management system (RDBMS) from Microsoft that combines the
relational Microsoft Jet Database Engine with a graphical user interface and software-development
tools. ... It can also import or link directly to data stored in other applications and databases.

 Introduction to SQL  Selecting rows

 SQL Course overview  Selecting columns
 Installing the test environment  Counting rows
 What is SQL?  Inserting data
 Editors and Platforms to learn SQL  Updating data
 Complete SQL in a Class  Deleting data
 Quick-start introduction  Import and Export data
 Using the basic SELECT statement
Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

 Fundamentals of SQL  Maintaining SQL Server Database

 Databases and tables  Backup Database
 SQL syntax overview  Restore Database
 Data Definition, Data Manipulation, Data  SQL Server Job Creation
Control, Transactional Control statements  How to create job in SQL Server Agent
 Creating tables  How to schedule job
 Deleting a table  Topics Covered as follows:
 Inserting rows into a table  Access environment and tools
 Deleting rows from a table  Database terminology and concept
 What is NULL?  Designing database in Access
 Controlling column behaviors with  Understanding RDBMS
constraints  Working with the Design side of Tables
 Changing a schema with ALTER  Create Query
 Filtering data with WHERE, LIKE, and IN  Join Tables That Have No Common Fields
 Removing duplicates with SELECT DISTINCT  Work with Subdatasheets
 Sorting with ORDER BY  Create Sub queries
 How Relationships Work in SQL  Working with the runtime of Tables
 Understanding joins  Data migration and importing
 Accessing related tables with JOIN  Working with the Design side of Queries
 Multiple related tables  Working with the runtime of Queries
 Explaining SQL Strings  Working with the Design side of Forms
 About SQL strings  Adding Controls to Forms
 Finding the length of a string  Creating Sub forms
 Selecting part of a string  Organizing Information with Tab Pages
 Removing spaces with TRIM  Displaying a Summary of Data in a Form
 Making strings uppercase and lowercase  Applying Conditional Formatting
 Numbers and SQL  Working with the runtime of Forms,
 About numeric types Managing Switchboard
 Finding the type of a value  Working with the Design side of Reports
 Integer division and remainders  Organize Report Information
 Rounding numbers  Format Reports Include Charts in a Report
 Add a Calculated Field to a Report
 SQL Functions and Clause
 Add a Sub report to an Existing Report
 The Aggregate functions MIN, MAX, AVG,
 Working with the runtime of Reports
SUM and COUNT, UPPER, LENGTH, LOWER
 Working with the Design side of Macros
 The GROUP BY and HAVING clauses
Grouping in a combination with joining  Creating a Macro Restricting Records Using
a Condition
 Triggers in SQL  Automating Data Entry Using a Macro
 Concept of Trigger  Working with the runtime of Macros
 Create Trigger for (Insert,Update,Delete)  How to create a functional specification
 Alter Trigger  Build a real-world business application
 What are Subselects and Views in SQL  Putting altogether and deployment
 Creating a simple subselect
 Searching within a result set
 Creating a view
 Creating a joined view
Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

Module 4 – SAS Base & Advanced

Module 4.1 – SAS Base
 INTRODUCTION TO SAS PROGRAMMING  STATEMENT OPTIONS
 Working in the SAS Environment  Global Statements
 Working with the Windows  Local Statements
 Enhance Editor  List Input
 Result Window  Modified Input
 Log Window  Column Input
 Explorer Window  Named Input
 Output Window  MANAGING DATA
 Program Editor Window  Exploring SAS data libraries using base SAS
 BASICS OF SAS LANGUAGE utility procedures
 SAS Libraries  Sorting observations in a SAS data set
 Data Sets  Conditionally execute SAS statements
 Cube  Use assignment statements in the DATA
 Data View step
 Referencing Files in Catalog  Modify variable attributes using options and
 Creating a SAS Program statements in the DATA step
 Components of SAS Program  Use SAS functions to manipulate character
 Characteristics of SAS Program data, numeric data, and SAS date values
 Layout of SAS Program  Use SAS functions to convert character data
 ACCESSING DATA to numeric and vice versa
 Use FORMATTED, LIST and COLUMN input  COMBINING SAS DATA SETS
to read raw data files  Concatenation
 Use INFILE statement options to control  One-One Merging
processing when reading raw data files  Match Merging
 Use various components of an INPUT  One-One Reading
statement to process raw data files  Updating or Setting
including column and line pointer controls,  CONDITIONAL STATEMENTS
and trailing @ controls  IF & IF THEN statement
 Combine SAS data sets using the DATA step  IF ELSE statement
 CREATING SAS DATA SETS  Where condition
 Create temporary and permanent SAS data  Like , Into Statements
sets  Loops ( Do, While )
 Create and manipulate SAS date values  WRITING DATA TO EXTERNAL FILES
 Control which observations and variables in  File Statement
a SAS data set are processed and output  Put Statement
 DATA STEP PROCESSING  GENERATING REPORTS
 Program Data Vector (PDV)  Generate list reports using the PRINT and
 Execution Phase and Compilation Phase REPORT procedures
 Get Started with Output Delivery System  Enhance reports through the use of labels,
(ODS) SAS formats, and user-defined formats

Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

 Generate summary reports and frequency  Proc Transpose

tables using base SAS procedures  Proc Print
 DEBUGGING AND HANDLING ERRORS  Proc Contents
 Identify and resolve programming logic  Proc Formats, Proc Compare
errors  Proc Append, Proc Tabulate
 Checking for Errors, Warnings, Un-  Proc Report
Initialization, missing values  Proc Import, Proc Export
 Recognize and correct syntax errors  Proc Freq
 Examine and resolve data errors  Proc Means
 PROCEDURES
 Proc Sort
Module 4.2 –SAS Advanced
 ADVANCE SAS TRAINING SYLLABUS  Inserting data into Tables
 Introduction to SAS Macro Language  Alter & update the tables
Elements  Construct sub queries within a PROC SQL
 Introduction to Macro Variables step
 Automatic Macro Variables  SQL pass through Facility
 User define Macro Variables  Connecting to DBMS
 How Macro processing will undergo inside  Natural Joins
the SAS system  Inner Joins
 Macro Statements  Outer Joins
 Macro Functions  Access Dictionary Tables using the SQL
 Autocall Macros procedure
 SAS MACROS  Work with indexes using the macro
interface/creating macro variables with SQL,
 SAS Libraries
defining integrity constraints
 Introduction to SAS Macro Language
Elements  MACRO PROCESSING
 Introduction to Macro Variables  Creating and using user-defined and
 Automatic Macro Variables automatic macro variables within the SAS
 User define Macro Variables Macro Language
 How Macro processing will undergo inside  Automating programs by defining and
the SAS system calling macros using the SAS Macro
 Macro Statements Language
 Macro Functions  Various system options available for macro
 Autocall Macros debugging
 Displaying values of user-defined and
 ACCESSING DATA USING SQL automatic macro variables in SAS log
 Introduction to Proc SQL  Understand the use and implantation of
 Generate detail reports by working with a
macro functions
single table or joining tables using PROC SQL
 Generate summary reports by working with
a single table or joining tables using PROC
SQL

Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

Module 5 –Tableau / MS Power BI

 Module 5 a) Tableau OR  Module 5 b) MS Power BI

 Module 1 - Getting Started with Tableau  A Quick Introduction

 Overview Of Tableau  What is MSPBI and its scope
 Tableau Architecture  Learn the common work flow in MSPBI
 Installation And Configuration Of Tableau 10  Building blocks of MSPBI and its relations
 Module 2 - Connecting to The Data  Quick demo how to create a business
dashboard in MSPBI
 Managing Metadata  MSPBI components
 Managing Extracts  Old vs. new technologies
 Data Sources  Power BI Desktop/Service/Mobile
 Cross-Database Joins  Getting Business Data
 Data Aggregation And Data Ports  Get data in shape for use with MSPBI
 Tableau Charts  Combining two or more data sets (source
data) for reporting
 Bar Charts and Stacked Bars Data Blending  Tackling messy data in MSPBI
 Tree Maps and Scatter Plots  Clean and transform data
 Individual Axes, Blended Axes, Dual Axes  Modelling in Power BI
and Combinational Chart
 Module 3 - Visual Analytics  How to connect many different data sources
 Drill Down and Hierarchies  Manage data source (database) relationships
 Sorting, Filtering and Grouping  Unique keys
 Trend and Reference Lines  Calculated columns and more
 Forecasting and Clustering  Custom calculations to evaluate time-based
functions
 Analysis with Cubes and MDX  Build calculated tables based on DAX formulas
and expressions
 Module 4 - Developing First Bar Chart OR  Creating and viewing visuals easier with
optimized models
 Connecting Tableau to Data File  Discover hierarchal drill-down tools for date
fields
 Navigating Tableau  Data Visualization
 Calculated Fields  Create and customize visualization in MSPBI
and its power
 Adding Colors, Labels and Formatting  Use combination charts
 Module 5 - Time Series, Maps and  Create and format slicers with it
Aggregation
 Data Extracts and Time Series  Map visualizations and its utilization
 Understanding Granularity, Aggregation and  Use tables and matrixes
Level of Details
 Default Location in Maps  Long live bubbles
 Custom Geo Coding  scatter charts in action

Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

 Symbol Map and Filled Map  Advanced funnel and waterfall charts
 Module 6 - First Dashboard  Drive fast dashboard insights with gauges and
numbers
 Into Section  Color your visualization world with colors
 Joining Data In Tableau  shapes and scales
 Working With Maps and Hierarchies  Adding personal touch
 Scatter Plot and Applying Filters in Different  logo etc. to reports and dashboards
Sheets
 Creating First Dashboard  Display and present your dashboard in a way
you want with summarize data
 Module 7 - Blending Data and Dual Axis  Control how your report elements overlap
Charts with each other
 Duplicate Values  Learn to drill into hierarchies
 Multiple Fields  Manage how levels are shared (Z-order in
reports)
 Data Blending  How to use R visuals in MSPBI
 Dual Axis Chart  Data Exploring & Sharing
 Building Calculated Fields  Quick insights in Power BI Service
 Module 8 - Table Calculation and  Create and configure a dashboard
Storytelling
 Downloading Dataset and Connection  Share dashboard with your organization
 Mapping  Display and edit visuals- tiles
 Building Table Calculation For Gender  full screen
 Bins and Distributions for Age  Get more space on your dashboard
 Tree Map Chart  Install and configure a personal gateway
 Advanced Dashboard  Excel and MSPBI
 Storyline and Storytelling  Import and excel table into Power BI
 Module 9 - Data Preparation  Import excel files with data models and power
view sheets
 Data Format  Connect One Drive for business to MSPBI
 Data Interpreter OR  Excel data in Power BI summary
 Multiple Columns And Pivot  DAX (Data Analysis Expression) Application
 Metadata Grid  DAX and its basic building blocks
 Advanced Data Preparation  Create calculated columns (fields) and
measures in MSPBI using DAX formulas
 Breadth of functions available in DAX
 User variables in DAX
 Create expressions across multiple tables with
relational functions;
 Filter and evaluate tables using advanced
table functions

Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

Module 6 – R-Programming/Python

 Module 6 a) R-Programming OR  Module 6 b) Python

 Module 1- Introduction to Business  Module 1 - Introduction to Python

Analytics
 Introduction to Business Analytics  Python Overview
 Types of Analytics  Advantages and Disadvantages
 Case study on Walmart, Signet Bank  Installation and Configuration
 Data Science and its importance  Interpreted Languages
 Module 2- Introduction to R  Module 2 - Programming with Python
 Introduction to R  Python Script
 Installing R  Standalone Scripts Under Unix And
Windows
 Installing R Studio  Using Variables and Operators
 Workspace Setup  Command Line Parameters
 R Packages  Understanding Expressions
 Module 3- R Programming  Module 3 - Flow Control
 R Programming  If And Else If Statement
 if statements  The While and Loop Statement
 for statements  Continue Statement
 while statements  Break Statement
 repeat statements  Range () Function
 break and next statements  Using Lists
 switch statement  Module 4 - Sequence Data
 scan statement  List Operations and Methods
 Executing the commands in a File  Sets
 Module 4 - R Data Structure  Dictionaries
 Data structures  Tuples
 Vector  Strings
 Matrix  Module 5 - Functions
 Array  Defining Functions
 Data frame OR  Parameters and Variables
 List  Using Global Statement
 Factors  Keyword Arguments
 Module 5 - Apply Functions  Keyword Only Parameters
 DPLYR & apply Function  The Return Statement
 Import Data File  Varargs Parameters
 DPLYP – Selection  Docstrings
 DPLYP – Filter
 DPLYP – Arrange
 DPLYP – Mutate
 DPLYP – Summarize

Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

 Module 6 - Apply Functions  Module 6 - Errors and Exception Handling

 Data visualization in R  Dealing Syntax Errors
 Bar chart, Dot plot  Exception Handling
 Scatter plot, Pie chart  Cleaning Up
 Histogram and Box plot  Module 7 - Modules
 Heat Maps  Creating Modules
 World Cloud  The From and Import Statement
 Module 7 - Apply Functions  Package
 Introduction to statistics  Dir Function
 Type of Data  Module Name
 Distance Measures (Similarity, dissimilarity,  Module 8 - Importing and Exporting Data
correlation)
 Euclidean space.  Importing Data From Different Sources
 Manhattan  Connecting To Databse
 Minkowski  Viewing Data Objects And Sets
 Cosine similarity  Exporting Data To Other Formats
 Mahalanobis distance  Module 9 - Data Manipulation and Data
Analysis
 Pearson's correlation coefficient  Cleansing Data With Python
 Probability Distributions  Data Manipulation
 Module 8 - Hypothesis Testing I  Python Tools And In-Built Functions
 Hypothesis Testing  Formatting And Normalizing Data
 Introduction  User Defined Functions
 Hypothesis Testing - T Test, Anova  Data Analysis Using Statistics And Graphical
Representation

 Module 9 - Hypothesis Testing II  Module 10 - Data Structures and Regular

Expressions
 Hypothesis Testing about population  List, Tuples, Dictionaries And Set
 Chi Square Test  Re Objects
 F distribution and F ratio  Pattern Matching
 Module 10 - Regression Analysis OR  Subexpressions
 Regression  Parsing Data
 Linear Regression Models  Complex Substitutions
 Non Linear Regression Models  Module 11 - Live Practice Sessions
 Module 11 – Classification  Projects and Assignments
 Classification  Live Training
 Decision Tree
 Logistic Regression
 Bayesian
 Support Vector Machines
 Module 12 – Clustering
 Clustering
 K-means Clustering and Case Study
Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301
 Get in Touch
9999491895

 DBSCAN Clustering and Case study

 Hierarchical Clustering

 Module 13 – Association
 Association
 Apriori Algorithm
 Candidate Generation
 Visualization on Associated Rules
 Summary

Please Find The Data Analytics Training Course Fee & Details.
Course Module Course Duration 30th April 19 1st May 19
SAS Basic + Advanced / Tableau / 25-30 (Hours) 12,500/- 15,500/-
Power BI / R / Python - Any One

Data Analytics ( M 1 – 6 ) 150 (Hours) 35,000/- Offer 40,000/-

Excel+VBA/Macros+SQL+SAS+(Tableau
/Power BI)+(R Program/Python)
Note: GST Applicable on all Course Module

Payment Details
Banking
Bank Name - ICICI Bank, F-11, Preet Vihar, New Delhi - 110092
A/C Name - Structured Learning Assistance Consultants India Private Limited
A/C NO - 003705018870
IFSC - ICIC0000037
Or
Paytm No – 9654382464

Regards,
Sla Consultants India
9999491895|7836028222|7836023222| 011-47519207
[email protected]

Head Office - SLA Consultants India, 82-83, 3rd Floor, Vijay Block, Metro Pillar No. 52, Laxmi Nagar, New Delhi – 110092
Branch office - 3rd Floor, Gourav Plaza, Metro Pillar No. 50, DLF Phase - 2 Sikanderpur, Gurgaon – 122002
Branch office (Noida) – 1st Floor, E-49, Sector3 (Near Sector 16 Metro Station), Noida – 201301