WHY ASPIRE ?

We are the Information Technology training division of Aspire Techsoft Pvt Ltd, an IT company founded in 2011.We are ranked among the software training institutes in the india. We are specialized in ERP, SAP, SAS, JAVA, Data Warehousing,Hadoop etc.

Kothrud Branch (Head Office)
  • Address: Malhar Building, Plot No 2, H. A. Colony,
    Paud Phata, Eardawana, Pune 38.
  • Phone:7058-198-728 / 7058-733-423
  • Email:info@aspireit.net
Dange Chowk Branch
  • Address: Office No 108, 1st Floor, ABC Nirman Complex,
    Opp Macdonald, 16 No Stop, Near Dange Chowk, Pimpri Chinchwad, Pune - 33.
  • Phone:8856-033-664
  • Email:aspiretech.erpsolution@gmail.com

Enrol for free Demo!

Enquiry
course-leftside-review

Reviews


Amrut Desai

  • 2018-02-16

Excellent!!! Staff & guidance


shamal jagdhane

  • 2018-02-16

This is good institute.as per my point of view all lecture are good& understandable.


Sumit Kale

  • 2018-02-08

Best training institute in Pune. Clear my doubts. Thank you aspire.


Data Science

  • Need for Data Scientists

  • Foundation of Data Science

  • What is Business Intelligence

  • What is Data Analysis

  • What is Data Mining

  • What is Machine Learning

  • Analytics vs Data Science

  • Value Chain

  • Types of Analytics

  • Lifecycle Probability

  • Analytics Project Lifecycle

  • Basis of Data Categorization

  • Types of Data

  • Forms of Data & Sources

  • Data Quality & Changes

  • Data Quality Issues

  • Data Quality Story

  • What is Data Architecture

  • Components of Data Architecture

  • OLTP vs OLAP

  • How is Data Stored?

  • What is Big Data?

  • 5 Vs of Big Data

  • Big Data Architecture

  • Big Data Technologies

  • Big Data Challenge

  • Big Data Requirements

  • Big Data Distributed Computing & Complexity

  • Hadoop

  • Map Reduce Framework

  • Hadoop Ecosystem

  • Introduction to R

  • Business Analytics

  • Analytics concepts

  • The importance of R in analytics

  • R Language community and eco-system

  • Usage of R in industry

  • Installing R and other packages

  • Perform basic R operations using command line

  • Usage of IDE R Studio and various GUI

  • Various phases of Data Cleaning

  • Functions used in Inspection

  • Data Cleaning Techniques

  • Uses of functions involveds

  • Use-cases for Data Cleaning using R

  • Import data from spreadsheets and text files into R

  • Importing data from statistical formats

  • Packages installation for database import

  • Connecting to RDBMS from R using ODBC and basic SQL queries in R

  • Web Scraping

  • Other concepts on Data Import Techniques

  • What is EDA?

  • Why do we need EDA?

  • Goals of EDA

  • Types of EDA

  • Implementing of EDA

  • Boxplots, cor() in R

  • EDA functions

  • Multiple packages in R for data analysis

  • Some fancy plots

  • Use-cases for EDA using R

  • Story telling with Data

  • Principle tenets

  • Elements of Data Visualization

  • Infographics vs Data Visualization

  • Data Visualization & Graphical functions in R

  • Plotting Graphs

  • Customizing Graphical Parameters to improvise the plots

  • Various GUIs

  • Spatial Analysis

  • Other Visualization concepts

  • Big Data and Hadoop Introduction

  • What is Big Data and Hadoop?

  • Challenges of Big Data

  • Traditional approach Vs Hadoop

  • Hadoop Architecture

  • Distributed Model

  • Block structure File System

  • Technologies supporting Big Data

  • Replication

  • Fault Tolerance

  • Why Hadoop?

  • Hadoop Eco-System

  • Use cases of Hadoop

  • Fundamental Design Principles of Hadoop

  • Comparison of Hadoop Vs RDBMS

  • Map Reduce Concepts

  • What is Map Reduce?

  • Why Map Reduce?

  • Map Reduce in real world.

  • Map Reduce Flow

  • What is Mapper?

  • What is Reducer?

  • What is Shuffling?

  • Word Count Problem

  • Hands-On Exercise

  • Distributed Word Count Flow & Solution

  • Log Processing and Map Reduce

  • Hands-On Exercise

  • Getting Started with Python

  • Python Overview

  • About Interpreted Languages

  • Advantages/Disadvantages of Python pydoc.

  • Starting Python

  • Interpreter PATH

  • Using the Interpreter

  • Running a Python Script

  • Python Scripts on UNIX/Windows

  • Python Editors and IDEs.

  • Using Variables

  • Keywords

  • Built-in Functions

  • StringsDifferent Literals

  • Math Operators and Expressions

  • Writing to the Screen

  • String Formatting

  • Command Line Parameters and Flow Control.

  • Sequences and File Operations

  • Lists

  • Tuples

  • Indexing and Slicing

  • Iterating through a Sequence

  • Functions for all Sequences

  • Using Enumerate()

  • Operators and Keywords for Sequences

  • The xrange() function

  • List Comprehensions

  • Generator Expressions

  • Dictionaries and Sets.

  • Functions

  • Function Parameters

  • Global Variables

  • Variable Scope and Returning Values. Sorting

  • Alternate Keys

  • Lambda Functions

  • Sorting Dictionaries

  • Sorting Lists in Place

  • Errors and Exception Handling

  • Handling Multiple Exceptions

  • The Standard Exception Hierarchy

  • Using Modules

  • The Import Statement

  • Module Search Path

  • Package Installation Ways.

  • PIG and HIVE Basics

  • Streaming Feature in Hadoop

  • Map Reduce Job Run using Python

  • Writing a PIG UDF in Python

  • Writing a HIVE UDF in Python

  • Pydoop and MRjob Basics.

  • Accessing the SAS System

  • Navigating through the SAS windows including the editor, log, and output

  • Windows

  • Creating and executing SAS programs in batch and interactive mode

  • Understanding errors in the SAS log

  • Exploring program output

  • Understanding SAS data set and library structure

  • Creating DATA and PROC steps

  • Understanding SAS syntax and SAS naming conventions

  • Working with temporary and permanent SAS data sets

  • Using the REPORT Procedure

  • Creating reports in a WYSIWYG interactive environment without code

  • Creating reports in a batch environment with code and NOWD

  • Using COLUMN, DEFINE, and COMPUTE statements for structure

  • Using ODS to generate HTML, RTF and XML reports.

  • Using Report options such as WIDTH=, FORMAT=, DISPLAY, GROUP,

  • HEADLINE and HEADSKIP

  • Summarizing and sorting reports

  • Adding titles, footnotes and labels to reports

  • Using the PRINT procedure

  • Selecting report columns with the VAR statement

  • Grouping reports with the BY statement

  • Summing report columns with the SUM statement

  • Producing frequency tables using the FREQ procedure

  • Producing vertical and horizontal bar charts with the GCHART procedure

  • VBAR and HBAR statements

  • Understanding chart variables

  • Using RUN-group processing for multiple graphs in the same session

  • Understanding options to tailor graphs, such as DISCRETE, SUMVAR=, and TYPE=

  • Reading data sets with the SET statement

  • Restricting data set size by selecting variables with DROP= and KEEP=

  • Options Learning Hub

  • Using IF-THEN/ELSE logic processing

  • Understanding the difference between sub setting IF and WHERE clause

  • Processing

  • To restrict observations

  • Reading raw data using list, column and pointer input

  • Naming variables

  • Understanding how to read any type of data using SAS in formats

  • Using INFILE and INPUT statements to read raw data

  • Examining the structure of a SAS data set and its variables' attributes using the CONTENTS procedure

  • Creating new variables using SAS functions and assignment statements

  • Social Media Final Project

  • Hadoop Project

  • Objective

  • Problem Definition

  • Solution

  • Discuss data sets and specifications of the project.

Download PDF

Benefits of Aspire Techsoft training

ASAP methodology

24 HOURS LAB

MATERIAL SOFT COPY& HARD COPY

100% PLACEMENT ASSISTANCE

RESUME PREPARATION

SOFT SKILLS& HR TIPS

aspire-review-default-image

Amrut Desai

  • 2018-02-16

Excellent!!! Staff & guidance

aspire-review-default-image

shamal jagdhane

  • 2018-02-16

This is good institute.as per my point of view all lecture are good& understandable.

aspire-review-default-image

Sumit Kale

  • 2018-02-08

Best training institute in Pune. Clear my doubts. Thank you aspire.

Did Aspire convinced you ? Add Your Review

Your Ratings



course_footer

Courses We Offer

ADD NEW SKILLS TO YOUR PROFILE

Also Find Us At


Explore Smarty