MOST

DEMANDING

SKILL

Data Analytics
& Bussiness Intelligence

Training Mode Interview Skills & Every Week Test

Classroom & Offline Preparation Mock Interview Test

Get Ready For Job in

5-6 Months
Course Highlights
04 Resume Based Projects
Complete concepts from Basics to Advance Level
Lifetime Assess for Materials
Everydayʼs Task
Every Week Test (Mock Interview Test)
- Microso Certification in Data Analyst
300+ Certification based Sample Questions
Resume Building
300+ Interview Questions & Answers
Interview Skills & Preparation
Multiple Mock Interviews

+91 81791 91999 www.nareshit.com

 Excel for Data Analytics
Basic Module
Introduction to Microso Excel Sum
Installing Excel: Windows / Mac Average
Getting Familiar With Excel Variance
Introduction to Tables Standard Deviation
Rows & Columns Correlation
Input data into cells IF
Introduction to Formulas Combining Data From Two Tables
Formula Behavior VLOOKUP
Built in Functions Index Match
Count

Advance Module
Pivot Tables
Introduction to Pivot tables
Pivot tables options & Formatting
Reports using Pivot Tables
Nested IF statements
VBA to automate tasks
Custom Functions

+91 81791 91999 www.nareshit.com

Statistics for Data Analytics
Descriptive Statistics
Data Measures of Central Tendency
Types of Data Mean Median Mode
Structured Data Measures of Spread
Continuous Range Variance
Discrete Count Standard Deviation
Discrete Categorical Bessel Correction
Nominal Measures of Shape
Ordinal Skewness Kurtosis
Time Series Percentiles
Unstructured Data Quartiles
Images & Videos Inter Quartile Range (IQR)
Text & Audio Outliers Correlation
Collection of Data Covariance Probability
Surveys
Probability Distributions
Design of Experiments
Discrete probability Distribution
Excel, CSV, Pdf, Textfile
Continuous Probability Distribution
Database (MySQL, MongoDB)
Uniform Distribution
Big Data – Hadoop, Spark
Normal Distribution
Cloud
Standard Normal Distribution
Population & Sample
Sampling Techniques Calculation of Probability using
Simple Random Sampling 68-95-99.7% Rule
Stratified Sampling Z – Score & Z tables
Systemic Sampling Standard Error
Cluster Sampling Central Limit Theorem
Biased Sampling Confidence Intervals

+91 81791 91999 www.nareshit.com

 Inferential Statistics
1 Sample test
Hypothesis Testing 1 Sample Z test
Formulation of Null & 1 Sample T test
Alternate Hypothesis 2 Sample test
Type-I error & Type-II error 2 sample independent test
P value 2 sample paired test
Le tail vs Right tail vs Two tail ANOVA Test
Chi-square Test

+91 81791 91999 www.nareshit.com

 Python
Basic Modules
Introduction to Python Loops
Installation of Python For Loops
Variables Nested for loops
Input While Loop
Output Nested While loops
Data types Loops Termination
int Float Complex Break Continue
Boolean String Functions
Syntax for Writing function
Data Structures
List Tuple Set Calling or Invoking function
Dictionary Inbuilt functions
User defined functions
Operators No Arguments
Arithmetic Operators
default arguments
Assignment Operators
positional arguments
Comparison Operators
keyword arguments
Logical Operators
arbitrary arguments
Membership Operators
Identity Operators
Operators Precedence
Condition Statements
If If-else if-elif-else
Nested if

+91 81791 91999 www.nareshit.com

 Advance Module
Advance Functions Errors
Lambda Map Compile-time Error
Filter Reduce Run-Time Error
Recursive Function Logical Error
Nesting of Functions Exception Handling
File handling Why exception handling?
Opening file try except block
Reading data from file Try with multi except
Writing data into file Finally block
Appending data into file Try-except-finally
Line count in File Try with finally

Python for Data Science

NumPy
Introduction to Numpy
Numpy Attributes
Array creation
Indexing & Slicing
Iteration over a array
Array Manipulation
Mathematical Operators
Relational Operators
Functions

+91 81791 91999 www.nareshit.com

 Pandas
Introduction to Pandas Basic insights of datasets
Series & Data Frame Summarizing Data
Create Data Frame Sorting
Column Selection, Addition Discretization
& Deletion Indexing and Selecting Data
Row Selection, Addition Filtering data
& Deletion GroupBy
Merging & Concatenation Exporting Data
Import of Data from Statistical Functions
various sources

Exploratory Data Analysis

Univariate Analysis Bivariate Analysis Multivariate Analysis

Matplotlib Seaborn
Histogram Pie Chart Bar Plot Regression Plot
Box plot Bar Chart Count Plot Pair Plot
Scatter Plot Subplots Box Plot Heatmap
Line Plot Line Plot Violin Plot
Scatter Plot

+91 81791 91999 www.nareshit.com

 Pandas
Introduction to Pandas Basic insights of datasets
Series & Data Frame Summarizing Data
Create Data Frame Sorting
Column Selection, Addition Discretization
& Deletion Indexing and Selecting Data
Row Selection, Addition Filtering data
& Deletion GroupBy
Merging & Concatenation Exporting Data
Import of Data from Statistical Functions
various sources

Exploratory Data Analysis

Univariate Analysis Bivariate Analysis Multivariate Analysis

Matplotlib Seaborn
Histogram Pie Chart Bar Plot Scatter Plot
Box plot Bar Chart Count Plot Regression Plot
Scatter Plot Subplots Box Plot Pair Plot
Line Plot Line Plot Heatmap
Violin Plot

+91 81791 91999 www.nareshit.com

 Data Cleaning
Dealing wrong Data Dealing Missing Values
Dealing wrong data types Handling Outliers
Treating the duplicates Drop unnecessary columns

SQL for Data Analytics

Basic Modules
Introduction to Databases Data Manipulation Language
Databases vs Spreadsheets Data Control Language
DBMS vs RDBMS Transaction Control Language
Introduction to SQL SQL Commands
SQL vsNoSQL Create Insert
Installation of MySQL Alter, Modify, Rename, Update
Data Types in SQL Delete, Truncate, Drop
Keys Grant, Revoke
Primary Key Commit, Rollback
Foreign Key SELECT
Constraints SQL Clause
Unique NOT NULL Where Distinct Orderby
Check Default Group By Having Limit
Auto Increment Operators
CRUD Operations Comparison Operators
Create Retrieve Logical Operators
Update Delete Membership Operators
SQL Languages Identity Operators
Data Definition Language Wild cards
Data Query Language Aggregation functions

+91 81791 91999 www.nareshit.com

 Advance Modules
SQL Joins SQL Functions
Inner Join & Outer Join String functions
Le Join & Right Join Numeric functions
Self & Cross Join Window Functions
Natural join User Defined functions
Normalization Sub queries
Normal Forms (1NF, 2NF & 3 NF) Common Table Expressions (CTE)
ER Diagrams Views
De-Normalization Stored procedures

Power BI for Data Analytics

Basic Modules
Introduction to Power BI Exploring Live Connections to
Introduction to Power BI Data Sources
Connecting Directly to My SQL
Traditional BI vs. Power BI
Connecting Power BI in Excel
Power BI vs. Tableau vs. QlikView
Installation of PowerBI Desktop
Connect & Working with
Power BI Desktop
Basic Components of Power BI
Data model and importance
of Data Modeling
Connectivity Modes
Various Data Sources
Supported in Power BI Desktop

+91 81791 91999 www.nareshit.com

Power BI Desktop and
Advanced filters
Data Transformation
Top N filters
Loading Data in Power BI Desktop
Filters on Measures
Views in Power BI Desktop
Saving Work file
Transform, Clean, Shape, and
Data Visualization & Dashboard
Model Data
Visualization Charts in Power BI
Manage Data & Editing
Custom Visuals
Relationship
Page Layout and Formatting
Measures
Bookmarks and Selection Pane
Calculated Fields
Grouping and Binnig
Calculated Columns
KPI Visuals
Calculated Measures
Creating a Dashboard
Calculated Tables
Configuring a Dashboard
Conditional Columns
Share a Dashboard, Report &
POWER BI Filters:
Workspace
Slicer Basic filters

Advance Modules
Data Analysis Expression (DAX)
Introduction to DAX
Data Types in DAX
DAX Calculation Types
Steps to Create Calculated Columns
Measures in DAX
DAX Syntax
DAX Functions
DAX Operators
DAX Tables and Filtering

+91 81791 91999 www.nareshit.com

 Tableau for Data Analytics
Basic Modules
Introduction to Tableau Basic Charts:
Tableau Architecture Bar Chart
Various Tableau Products Line Chart
Installation of Tableau Desktop Pie Chart
Features of Tableau Desktop Sorting Filtering
Tableau Desktop User Interface Grouping Sets
Introduction to Tableau Built-in Functions (Number, String
Connect to data from File & Database Date, Logical and Aggregate)
Types of Connections Operators and Syntax Conventions
Joins and Unions Table Calculations
Visual Analytics

Advance Modules
Types of Calculations Funnel Chart
Trend lines Bump Chart
Reference lines Word Cloud
Forecasting Donut Chart
Advance Plots Dashboard
Box and Whisker's Plot Introduction to Dashboards
Bullet Chart The Dashboard Interface
Bar in Bar Chart Dashboard Objects
Gantt Chart Building a Dashboard
Waterfall Chart Dashboard Layouts and Formatting
Pareto Chart Interactive Dashboards with actions
Control Chart

+91 81791 91999 www.nareshit.com

Head Office :
2nd Floor, Durga Bhavani Plaza, Ameerpet,
Hyderabad, 500016.

Ameerpet Branch :
Ground Floor, Manjeera square,opp Prime Hospital,
Ameerpet, Hyd.

KPHB Branch :
2nd Floor, Sreeramoju Complex, K P H B Phase 1,
Hyderabad, 500072.

USA :
5007 Arbor View Pkwy NW Acworth, GA, 30101

www.nareshit.com Call / Whatsapp : +91 8179191999