EncartaLabs

Vertica Advanced Analytics

( Duration: 2 Days )

The HP Vertica Advanced Analytics training course provides you with an in-depth introduction and hands-on experience with HP Vertica Analytics tools and concepts. The course provides a comprehensive understanding of general c analytic functions (including SQL analytics, as well as a comprehensive introduction to the HP Vertica-interpolation, event series joins, and pattern matching). This course event-based windowing, gap combines lectures with hands-on laboratory exercises performed in a live HP Vertica database cluster.

Attending HP Vertica Essentials course or equivalent experience with the HP Vertica Analytics platform; Intermediate knowledge of SQL.

Data Analysts, Business Analysts, Application Developers, and Database Administrators.

COURSE AGENDA

1

Introductions

  • Class Introductions
2

Introduction to SQL Analytics

  • Analytic Basics, The Analytic OVER Clause, Named Windows, Minimizing Sort Operations
3

Event Based Windows

  • Event Based Windows, Use Cases, Sessionization
4

Place

  • Place Basics, Geospacial Basics, Place Functions, Spatial Joins
5

Pulse

  • Pulse Basics, Sentiment Analysis Function, Pulse Dictionaries
6

Time Series

  • Time Series, Time Slice, Interpolation, Gap Filling, Treatment of Nulls
7

Event Series Joins

  • Event Series Joins, INTERPOLATE keyword
8

Pattern Matching

  • Pattern Matching, Funnel Analysis, Pattern

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top