vba macros Institute in Delhi | Adobe vba macros training in Delhi | vba macros training in delhi | vba macro in gurgaon
Big Data Analytics with Hadoop

Big Data Analytics with Hadoop

About The Course

As the need for big data analytics gains prominence world over; there is a subsequent growth in demand for Hadoop skill to process big data.
Program Objective
This course aims to take you through all the Big Data and Hadoop analytics concepts through step by step, well structured modules. It is our objective at Analytic square that by the end of this program you should be able to –
1. Have a basic understanding of Hadoop Distributed File System as well as MapReduce framework
2. Create a Hadoop cluster
3. Work with Sqoop and Flume on Data Loading Techniques
4. Learn to program in YARN, MapReduce and even write them
5. Do data analytics
6. Work on your own Big Data Analytics project implementing Hadoop
Who Should Join
If you are interested in big data and want to become a proficient Hadoop Developer this course is just right for you. You can benefit from this course if you are a –
1. Software professionals
2. ETL developers
3. Project Managers
4. Analytics Professionals
5. Testing experts
6. Students with knowledge of Core Java

Course Module

    What-IF Analysis

  •  Formula based Conditional Formatting
  •  3-D Data Consolidation

    Data Lookup

  •  INDEX() and 2 MATCH()

    Data Lookup

  •  VLOOKUP() – a practical perspective
  •  VLOOKUP() with MATCH()

    Logical Statements

  •  IF(), Nested IFs, AND(), OR()
  •  ISNUMBER(), ISTEXT(), ISBLANK(), ISERROR()

    Data Cleaning – I

  •  LEFT(), RIGHT(), MID()
  •  LEN
  •  UPPER(), PROPER(), LOWER()
  •  TRIM(), VALUE()
  •  CONCATENATE(), & Data Cleaning – II
  •  Find & Replace (using wildcard character – Asterisk * )
  •  Go To (Special)
  •  Text-to-Columns (incl. advanced tricks)
  •  Remove Duplicates Working with Dates
  •  Date correction techniques
  •  DAY(), MONTH(), YEAR()
  •  EDATE(), EOMONTH()
  •  TODAY()

    MIS reporting

  •  Automatic row-wise Subtotal
  •  Conditional Formatting (Blanks, Errors, Cell Values, Duplicates)
  •  File Password Select Dashboard Techniques
  •  Activate-Deactivate Gridlines
  •  Data Validation (list)
  •  Cell-Range Naming
  •  Grouping
  •  Hyper linking
  •  Hide-Unhide Columns & Rows

    Data Analytics

  •  Sort & Filter
  •  Using SUBTOTAL() with filtered data
  •  SUMIFS(), COUNTIFS()
  •  Pivot Table for multi-variable analysis
  •  Computations %, Sum, Max, Min, Average, Count
  •  Grouping (Clustering)
  •  Generating multiple reports

    Warm-up

  •  Essential shortcuts
  •  AutoFill options
  •  Paste Special (Value, Transpose)
  •  Absolute & Relative referencing ($)
  •  ROUND()

    Macros

  •  Data Tables, Goal Seek
  •  Form Controls – Spin Button & Scroll Bar

    Special Charts (with Videos)

  •  Concept; Macros Recorder
  •  Record & Run

    Special Charts (with Videos)

  •  Thermometer chart
  •  Two-axis chart
  •  Trend line chart
  •  Exploded Pie-chart

    MIS reporting

  •  Formula based Conditional Formatting
  •  3-D Data Consolidation
  •  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
  •  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
  •  Working with User Forms & User Forms events
    User form Controls
  •  Data Validation & Input restrictions Effective Coding
  •  Testing and Debugging your code
  •  Effective Error Handling
  •  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
  •  How and when to use the inbuilt help features, Object browser Common terminology
  •  Terms like ‘Keywords’, ‘Compile’, ‘Debug’ etc.Recording a Macro
  •  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
  •  Debugging mode, Breakpoints, Bookmarks, Watch window, Immediate window and Locals window Inbuilt VBE Help feature – Tips and Tricks.

Big Data Analytics With Hadoop Course Training


Certification

The most important thing to be considered before enrolling for any course is to make sure it is a certified one or not. A certified course helps improve the skill value of the learner thereby giving them access to better jobs. And this course comes provides the learners with acceptable industry certification for all the training received.

Experienced Faculty

All the faculty responsible for imparting knowledge are expert CAs and FCAs with more than ten years of experience under their built. They provide learners with complete practical training.

Assistance for Placement

Once 70% of the training is completed, our dedicated placement teams start arranging interviews for the learners to help them get placed in a good position.

Lab Facility

Practical Training is always the best sort of training, and that is why we have a high-end lab facility to help the learners gain corporate level exposure with a series of technical tests to assess their progress.

FAQ'S

Workshops

Learners are given them to take part in real-time projects and case studies to better prepare them for the corporate world.

Constant Admin Support

The Admin team is always just a call away, and they take care of all the needs that a learner might have.

No Data Found

Search Courses

  • Related Courses Lists
  • former student testimonial

    Full support by the Singh Institute for job placement in any stream of the career. Wonderful institute in whole delhi.

    Rahul Kumar

    Certified Accounts Professional

    I had done eaccounting course from singh institute. My course was completed on time . Now i am working in Vasant vihar IDBC pvt ltd investment company

    anita verma

    Certified Accounts Professional

    Placed Partner