Hadoop is the poster child for Big Data

Hadoop is the poster child for Big Data, so much so that the open source data platform has become practically synonymous with the wildly popular term for storing and analyzing huge sets of information. It is written in Java and allows storing and process big data in a distributed environment across clusters of computers using simple programming models.

In short, Hadoop allows storage of very large amount of data in any form simply by additions of more servers to a Hadoop cluster; it can handle both structured and unstructured data at very high volumes with an unprecedented price/performance ratio.

"Hadoop is the first step in putting all of your data in one place-the analytics you utilize from there is where you'll find answers. And questions." (Libero,2014)

ATI's offers Hadoop courses that train you to write and run jobs in Hadoop using map/reduce. We also make our students well versed with HDFS. HDFS provides a very high bandwidth by storing chunks of files scattered throughout the Hadoop cluster. Adding Hadoop training to our list of courses, we aim to build an all-rounder for a data/business analyst.

Duration: 32 Hours COURSE DETAILS:

    Introduction to Apache HADOOP & Big Data
    HADOOP Architecture/Components
    Introduction to VM
    Setting up environment- JAVA, WinSCP, Putty, SSH
    HDFS Commands
    Data Sets
    Map Reduce
    HADOOP Distributions

Advance Analytics for Mis

Duration: 32 Hours

Learn how to make your data look good using data visualization and forecasting using time series. Master the art of finding find patterns in large amounts of text using text analytics. Our advanced analytics course takes you a step ahead!

Module 1: Text Analytics

    Problems with unstructured data
    Terminology in text analytics: Corpus, TDM, parsing, stemming, stopwords, chunking, etc.
    Classification and tagging
    In class project: document classifier and sentiment analysis

Module 2: Automation in time Series

    Time series decomposition
    Common techniques like moving averages, smoothing etc.
    In class project to automate forecasting

Module 3: Machine Learning

    What is machine learning?
    Tree based learning
    Common learners: KNN, random forests, GBM etc
    In class project

Module 4: Data Visualization

    Landscape of visualization
    Thinking visually
    How to choose appropriate visuals
    Story boarding
    In class project

Analytics course introduces

Duration: 48 Hours

The Analytics course introduces participants to fundamental concepts of statistics, and guides them all the way to building predictive models using multiple linear and logistic regressions. All the topics are explained with the help of hands-on practice with live case studies and data, enabling a deeper understanding of the underlying concepts of analytics.

Module 1: Introduction to Analytics

    Need for analytics
    Analytics use in different industries
    Challenges in adoption of analytics

Module 2: Descriptive Statistics

    Understanding different outputs
    Tabular & Graphical Method
    Summary statistics

Module 3: Statistical Testing

    Hypothesis Testing
    Z-Test, T-Test, Chi-Square test, ANOVA
    Parametric & Non-Parametric test

Module 4: Regression & Correlation

    How to do regression
    Types of regression – logistic and linear
    Case Studies

Module 5: Modeling Techniques

    Concepts of Segmentation
    Usage of Segmentation
    Cluster Analysis
    Factor Analysis

SQL is a database used to access a excel database

Duration: 16 Hours

SQL is a database computer language used to access a database. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, etc.

Module 1: introduction to SQL

    What is SQL?
    Why and where is SQL used?
    Why should one learn SQL?
    Database fundamentals.
    What is a database?
    What are the different features in a database (for example; primary key, foreign key and candidate key)

Module 2: Basic Relational Database Management Concepts

    How to access one table from the other?
    What are the different relationships possible between two tables?
    How to use SQL commands in Access?
    1NF, 2NF..BCN
    Model a normalized database

Module 3: Introduction to the concept of Tables

    How to create a table?
    How to import data from excel , text files?
    How to check the tables for consistency?
    How /Where/Why use the SELECT function?
    How/Where/Why use the INSERT / UPDATE / DELETE function?

Module 4: Database Functions

    How/Where/Why use "GROUP BY" option?
    How/Where/Why use "COUNT" option?
    How/Where/Why use "WHERE" option?
    Mathematical Functions: AVG, SUM, MIN, MAX, FIRST, LAST
    Scalar Functions: UCASE, LCASE, MID, LEN, NOW, ROUND, FORMAT
    Primary Key Constraint â ALTER
    In Class project using Functions

The R Project for Statistical Computing

R is a free software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows and MacOS.

Duration: 16 Hours

The R tool is an open sourced framework which grew as a result of a strong push by Google. Today, R is poised to overtake SAS as the most widely used tool in statistical analyses and with over 20,000 packages currently available, it has near limitless potential for business application.

Module 1: Basic R tool programming

    R environment and Windows system
    R Objects, Data permanency and removing objects
    R Help and search with Functions
    R commands and Case sensitivity
    Data Import and Export
    R Studio Installation
    Simple Manipulations : Numbers and Vectors
    Writing your own functions

Module 2: Advanced Applications of R

    Data Manipulation: merging, sorting, filtering, de-duping
    User defined functions
    Visualizations: histogram, bar plot, box plot, mosaic plots, geographic plots, etc
    TM package
    Word cloud Package

Module 3: Hands on

    In Class Project
    Students do independent research
    Build your first sentiment analysis algorithm
    Combine solutions of students to showcase a final project

Managing Databases with Excel

Topic Covered

    Database Management Tools
        Arranging Data
        Filtering Data
        Conditional Formatting
        Watch Window
        Group and Summarize Data
        Subtotal Data
        Removing Duplicates
        Custom Views
        Excel Workspace
        Page Break Preview
    Functions & Formulas
        Financial Functions and Data Tables
        Database functions
        Reference Functions
        Other classes covering functions
    What-If Analysis Tools
        Goal Seek
        Other classes covering IF Statements
        Planning & Recording
        Viewing and Editing VBA Code
    Collaboration Tools
        Tracking changes
        Sharing and Merging Workbooks

Advanced Excel Training

Topic Covered

    Advanced Formulas
        Viewing available Excel functions
        Basic text functions
        Basic “IF” conditional formulas
        Nesting “IF” statements
        Concatenate and “IF” statements with concatenate
        Using name ranges in formulas
        Other classes covering Formulas and Functions
    Customizing Data Views
        Lookups and Lookup functions
        Transposing data
        Pivot Tables
        Filtering PivotTables
        PivotTable Charts
        Other classes covering Navigation and Views
    Advanced Chart Techniques
        Multiple series charts
        Moving charts in a spreadsheet
        Layout, title & labels
        Adding picture backgrounds
        Other classes covering Excel charts
    Page Formatting Techniques
        Custom views
        Creating a default view
        Filters and grouping
        Embedding and linking
        Editing and embedded object
        Editing a linked object
        Linking as an icon
    Additional Tools in Advanced Excel
        Protecting worksheets
        Locking cells
        Protecting a workbook

Intermediate Excel

Topic Covered

    Formulas & Functions
        Typing formulas and functions
        Cell references and reference formulas
        The Functions Library
        Average, date, and time functions
        If statements
        Other classes covering Formulas & Functions
    Moving and Copying Data in Excel
        Cut, copy, and paste data
        The Fill Handle
        Absolute and relative references
        AutoFill and custom Lists
    Working with Multiple Worksheets
        Renaming worksheets
        Color coding tabs
        Moving and copying worksheets
        3D references
    Formatting Cells and Appearance
        Formatting text and numbers in cells
        Merging cells
        Wrapping text within a cell
        Custom number formats
        Conditional formatting
        Copying formatting
        Other classes covering Excel formatting
    Viewing Worksheets
        Showing formulas and references
        Tracing precedents and dependents
        Grouping rows and columns
        Cell comments
        Headers and footers
        Other classes covering Navigation and Views
        Creating and defining a chart
        Positioning, rotating, and resizing charts
        WordArt in charts
        Editing charts in Excel
        Changing types
        Formatting a data series
        Multiple series charts
        Other classes covering Excel charts

Topic Covered in Basic Excel

Navigating to accomplish tasks
        Using the Ribbon, Office Button, and menus (depending on software version)
        Cells, columns, and rows
        Keyboard shortcuts
        Freezing and splitting panes
        Hiding columns and rows
        Other classes covering Excel navigation
Entering basic data into Excel
        Formatting dates and times
        Spell check
        Undo and redo buttons
        Creating and modifying tables
        Sorting and filtering tables
Creating basic Excel formulas
        Subtraction, division, multiplication
        Cell references
        Other classes covering Excel formulas
Using functions
        Manually typing functions
        AutoSum and AutoCalculate
        Other classes covering Excel functions
 Moving and copying data
        Cut, copy & paste
        Fill handle
        Smart Tags
Working with worksheets
        Renaming and coloring tabs
        Moving, copying, and inserting worksheets
Basic Excel Formatting
        Adjusting width and alignment
        Formatting text in cells
        Formatting numbers
        Other classes covering Excel Formatting

VBA, Macros & Reporting Introduction to logical thinking, flowcharts & algorithms

Microsoft Visual Basic for Applications (VBA, Macros) when used with Microsoft Excel can build powerful automated business tools & Solutions through which the impossible can be made possible . You can automate the repetitive task , Create the Global Templates, Analytical Dashboards and many more. We are the Pioneer in providing excel macro training.
  VBA Course:
  Introduction To Programming Introduction to logical thinking, flowcharts & algorithms
• Define objective, start & end points; Identifying solution & breaking it into sequential steps Writing an algorithm
• Step-by-step instructions, process flow diagrams/flowcharts.Excel Macros – an introduction
• The Power of Macros - What can be done with Macros and When to use Macros Introduction to object oriented programming
• Objects, their functions, methods and properties Introduction to Events
• What are events, how & when to use them Preparing to ‘Macro’ Visual Basic Editor (VBE) – Developer Tab, Security
• Introduction to the VBE, Project Explorer, Properties window, Password protection of code How to use the VBE – Features, Options, Intellisense technology
• Debugging mode, Breakpoints, Bookmarks, Watch window, Immediate window and Locals window Inbuilt VBE Help feature – Tips and Tricks.
• How and when to use the inbuilt help features, Object browser Common terminology
• Terms like ‘Keywords’, ‘Compile’, ‘Debug’ etc.Recording a Macro
• If and when to use Macro recorder along with the code More On Excel Macros - I Structure of an Excel workbook from VBA point of view -Common Objects
• MS Excel Objects like Applications, Workbook, work sheets, etc. Where to write the code? Variables and Constants
• What are variables and constants?
• Type of variables; How and when to use variables to store information.
• Typical Variable naming conventions
• When to use Variables or constants More on Excel Macros - II Loops
• For-Next, For-Each, Do-While, Do-Until Decision-making and Code Branching
• If-Then-Else, Select-Case, And/Or conditions User defined functions (UDF)
• What are user defined functions. How to create & use them.Form Controls vs. ActiveX Controls Getting into the Code MsgBox and Input Box Working with Data in Excel
• Data types in Excel worksheets, like Dates, Texts, Nulls etc. Working with workbooks, worksheets, ranges, cells etc.
• Using offset and other cell navigation methods. Working with Arrays Power Data Processing Working with Data in Excel
• Working with dynamic ranges. Protecting worksheets, cells and ranges. Working with multiple files. Opening & Saving files Introduction to User Forms
• Working with User Forms & User Forms events
• User form Controls
• Data Validation & Input restrictions Effective Coding
• Testing and Debugging your code
• Effective Error Handling

Introduction to VBA & Excel Macros MIS & Data Analyst Training

We will learn how to make a Dynamic Dashboard using Microsoft Excel. you know, the company run by the richest man in the world. Excel, along with the other members of Microsoft Office 2003, includes the VBA language (at no extra charge). In a nutshell, VBA is the tool that people use to develop programs that control Excel.

Visit Below Link For More Details: