PROSPECTUS

Certified
DATA ANALYST
Course In
Collaboration
With
IBM
ABOUT US
ExcelR is an Ed-Tech Firm headquarter
in Houston, USA. We have been the
industry leaders since the past 8 years
and have provided the best to the
students by collaborating with the best
companies and organizations. We are
the Training partners for 150+ corporate
companies and 70+
Universities & colleges.

ACCOLADES
SOME OF THE MAJOR COMPANIES
THAT HIRE OUR STUDENTS
SOME OF THE MAJOR COMPANIES
THAT HIRE OUR STUDENTS
OUR CORPORATE TIE UPS
COURSE CURRICULUM

1 Business statistics
2 Excel: Basics to Advanced
3 My SQL
4 Tableau
5 Power BI
6 SAS
7 R Basics
8 Python Basics
MODULE 1
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
Probability Distribution
Normal Distribution
SND

Inferential Statistics
Sampling Funnel Central Limit Theorem
Confidence interval
Introduction to Hypothesis Testing
Anova and Chisquare
Data cleaning and Insights
Data Cleaning
Imputation Techniques
Scatter Diagram and Correlation Analysis
MODULE 2
EXCEL: BASICS TO ADVANCED
Intorduction to Excel:Quantum of Excel and Basics
Workbook
Types of workbooks and their uses
Common uses of Excel
Cell
Row
Column
Range/Array
Name box
Formatting of cells
Ribbon
Formula bar Status bar
Basic operators

Intorduction to Functions:Commonly used Excel Functions

What is syntax
arguments
Navigations using keyboard
shortcuts
Sum
Average
Maximum- Minimum
Product
CountBlank
CountA
CountIF
If,Now,Today
Cut,Copy,Paste,Paste Special

Anchoring data:Referencing,Named ranges and its uses

Absolute
Relative
Mixed referencing
Name Manager
Named ranges
Creating Tables
Create functions using named ranges AND/OR referencing
MODULE 2
EXCEL: BASICS TO ADVANCED
Referring data from different tables:
Various types of Lookup,Nested IF
Lookup
Vlookup
Nested Vlookup
Hlookup
Index
Index with Match function
If
If with combination of AND/OR
IFERROR
Referring data from different tables:
Advanced functions
RANK
RAND
RANDBETWEEN
INDIRECT with ADDRESS & MATCH
OFFSET

Data Handling:
Data cleaning,Data type identification,Data restrictions
LEN
LEFT
RIGHT
MID
CONCATENATE
CONCAT
FIND
SUBSTITUTE
TEXT
TRIM
SECOND
MINUTE
HOUR
DAY
WEEK
MODULE 2
EXCEL: BASICS TO ADVANCED
MONTH
QUARTER
YEAR
WORKDAYINTL
ISNUMBER
ISNA
ISNONTEXT
ISEVEN
ISODD
ISFORMULA
ISERROR
Data validation
Depended drop down
Protecting cell
Array
range
sheet
Workbook

Data Handling:Formatting and Filtering

Conditional formatting
Sort
Advanced Sort
Filtering

Data Summerization:
Advanced functions,Charts
Sum
Average
Max-Min with IF and IF'S
CountIF'S
Various types of Charts

Data Summerization:Pivots,Preparing the Dashboard

Pivot table
Slicers
Pivot charts
MODULE 2
EXCEL: BASICS TO ADVANCED
Calculated field
Calculated item
ADD/REMOVE/CHANGE data into the pivot table
Refreshing pivot data
Dashboard creation
Power query,power pivot
Cleaning data
Extracting data from multiple sources
Transforming data
Imputation techniques
Getting data from CSV files
Databases
Workbooks
Webpages

Power query,power pivot,Use case discussion:

Data Preparation,Project Summarization
Consolidating data from multiple sources
merging data from different workbooks/worksheets
relationships
Use Data handling steps taught in the previous session
Use Data summarization techniques
Populate output in Excel
Combining multiple functions

Intro to Automation:Macros(Recorded /VBA)

How VBA works
Record a sample macro
VBA
If constructs,Select construct,
User defined functions
Input box, message box
Procedures
Automatic macros
Methods to cleanup the codes
MODULE 3
MY SQL
Introduction to Databases:
Software Installation
Introduction to RDBMS
Explain RDBMS through normalization
Different types of RDBMS

Types of SQL Commands:

Data Types in SQL
DDL
DML
DQL
DCL
TCL
Datatypes:
- int
- float
- char
- varchar
- date
- date&time
- UTC
DDL and DML and TCL commands
DDL:
- Create
- Drop
- Rename
- Alter
- Truncate
DML:
- Insert
- Update
- Delete
TCL:
- Commit
- Rollback
- Savepoint
MODULE 3
MY SQL
Database Constraints
Domain Constraint
Key Constraint
Referential Integrity
Constraint
Primary key
Foreign Key
Operators in SQL
AND
OR
WHERE
IN,NOT IN
BETWEEN
EXIST,NULL

Grouping Operations
Select query
Order by
Group by
Having Classes
Aggregating functions

Ranking functions,Analytical functions

Rank
Dense rank
Row number
Percentile rank
Lead and lag functions

Joining Tables
Inner,Left,Right
Cross
Self Joins
Full outer join
Interview Scenarios
MODULE 3
MY SQL
Views,Triggers
Simple views
Complex views
Different types of triggers

Introduction to subqueries,
different types of subqueries
Explaintion of subqueries with interview scenarios

Indexing,Sequence Objects
B.Tree Index
Hash Index
Unique index
Advantage of Index
Creation of Sequence on primary key column

Stored Procedures
Parameters in stored procedures
Exception handling in stored procedures
MODULE 4
TABLEAU

Intro to TableauTool
What is data
Types of Data
Visualization basics
Different visualizaion tools
Popularity of the tools
Licencing Cost
Different products of Tableau
Installation
Connecting to Static files
Mysql

Data Pane Window

Live Vs Extract
Data source window
Navigating to work sheet
Data pane
Analytics pane
Dimensions
Measures
Auto generated fields
Data visualization window explaination
Data source window operations

Groups,Sets,Parameters
Hierarchy
Grouping
Sets
Parameter with filters and Parameter with Sets
Usage of meausre names and Measure Values
MODULE 4
TABLEAU

Filters In Tableau
Dual axis
Blended axis
Dimension filters
Measure filters
,Date filters
Cascading Filters
Context filters
Data source filters
Extract filters

Calculated Fields
Quick table calculations
Introduction to calculated fields
String calculated fields
Number calculated fields
Date calculated fields
Logical calculated fields
ZN Function
Data Blending And Joins
Mixing up of all calculated fields
Conditional Formatting in Tableau
Data blending
Data joins
Unions
Relationships
Basic Charts and use cases
Introduction to Show me
Development of In built charts part1

Charts In Tableau
Development of inbuilt charts part2
Customized graphs
Animated Chart
MODULE 4
TABLEAU

Reference Lines,Bands,Distributions
Arbitary formatting
Explaination of Marks Card
Reference lines
Reference Bands
Reference Distribution

LOD's, Intro To Dashboard,Story

Forecasting
Introduction to Dashboard
Story board interfaces
LOD's

Creating A Dashboard
Creating of a Basic Dashboard with both Tiled
Floating layouts
Explaination of objects in the Dashboard interface
Action filters on Dashboards

Creating A Advanced Dashboard

Advanced level dashboard
Designing of Basic Story board

Tableau Public Server

Publishing Dashboards on Tableau public server
Exposure to the websites which consists of real time data
Interview cracking resources
Introduction to Tableau certification
MODULE 5
BASICS OF R

Introduction to R,Installation of Rstudio Data Types in R

Data types
Relational 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
Data visualization using ggplot2
Scatterplot
Histogram
Boxplot
MODULE 6
BASICS OF PYTHON

Anaconda Installation,Introduction To Python,

Data Types,Opearators
Variables
Data types
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
if
elif
Getting input from user
Identity Operators
MODULE 6
BASICS OF PYTHON
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
MODULE 7
POWERBI

Power BI Introduction
Introduction to Power BI Desktop
- Getting data
- Naming for Q&A
- Direct Query vs Import data

Modelling with Power BI

Introduction to Modelling
- Set up and Manager relationships
- Cardinality and cross filtering
- Creating hierarchy in the model
Introduction to Modelling
- Default summarization and sort by
- Creating calculated columns
- Creating measures and quick measures
Power BI Desktop Visualizations
Creating visuals
- Colour and conditional formatting
- Setting sort order
- Scatter and bubble charts and play axis
- Tool tips
- Slicers, timeline Slicers and sync Slicers
- Cross filtering and highlighting
Creating visuals
-Visual, Page and Report level filters
- Drill down/up
- Hierarchies
- Constant Lines
- Tables, Matrix and Table conditional formatting
- KPI’s, Cards and Gauges
- Map Visualizations
- Custom visuals
MODULE 7
POWERBI
Power BI Desktop Visualizations
Creating visuals
- Managing and Arranging
- Drill Through
- Custom Report themes
- Grouping and binning
- Bookmark and buttons

DAX Expressions
Introduction to Dax
- Important Dax used in Power BI along with its applications.
Introduction to Dax
- How to create calculated columns and measures in Power BI and
difference in its application
Introduction to Dax
- Scenarios with Questions on DAX & explanation.
Introduction to Dax
- Creating date dimension in Power BI using calendar functions
and its importance.

Publishing And Sharing

Sharing options
- Publish from Power BI Desktop
- Publish reports to Web
- Sharing reports and Dashboards
- Workspaces
- Apps
Sharing options
- Printing, PDF’s and exports
- Row level Security
- Exporting data from Visualizations Refreshing Datasets
- Understanding data refresh
- Gateways
COURSE DURATION

TOPIC DURATION
Business Statistics 8 Hrs
Excel Basic & Advance 26 Hrs
SQL 24 Hrs
Tableau 24 Hrs
R Basics 6 Hrs
Power BI 24 Hrs
Python Basics 10 Hrs
Total 122 hrs
* Free eLearning Modules: SAS
SALARY INSIGHT

Salary Insights: Data Analyst

Level Experience Package

Entry Level 0 Years 3.5-4.5L
Early Level 1-4 Years 4.5-8.5L
Mid-Level 5-9 Years 10-16L
High Level Above 10 Years 17-25L

Source:Naukri
KEY HIGHLIGHTS

Data Analyst
certification
from IBM

Placement
Preparation

Dedicated
Support
Team
100% PLACEMENT PREPARATION

Job Readiness
Once the assignment and project are completed, we have a
placement incubation cell that will help you with the following:

·Resume prep sessions and guidance

·Mock interviews of the student by Senior Data Analyst.
·Detailed Analysis of where the student has to improve (SWOT Analysis)

*Please note that only those participants that finish their

assignments and projects will be eligible for placement Preparation.
DEDICATED SUPPORT TEAM

Support Team

Support is the most important aspect when it comes to learning

technical courses. This is where we are so highly rated. We have
a dedicated assignments team that helps you in every step when
it comes to solving your doubts (No matter how
big or small the doubt is). Shoot those doubts
to us and we will help you solve them.
SUMMARY OF THE COURSE

1
Data Analyst
Certification 2
from IBM
3
4
CERTIFICATE
For further information on the program we offer
please visit our website or contact us at:
www.excelr.com
1800-212-2120
Follow us on :
https://www.facebook.com/ExcelR/
https://www.instagram/excelrsolutions/
https://twitter.com/ExcelrS
https://www.youtube.com/c/ExcelRSolutionsRaisingExcellence
https://www.linkedin.com/company/excelr-solutions/