Apologies, but enrollment is now full.

Add yourself to the wait list:

Data Warriors, Champions, and Visionaries — Join Us!

Relevant and rigorous training for Incorta developers

Designed to serve the learning goals of both database and data warehouse developers already familiar with Incorta, this course dives deeper into how developers can unleash no-limits analytics within their organization using Incorta 4.5.

Audience Prerequisites

Hands-on, project-base learning to build confidence and skills

This course is ideal for folks who have previously achieved Incorta certification. You should be already familiar with Incorta schema design and dashboard development. Additional experience with structured data, relational database systems, SQL, Python, machine learning, and shell scripting is helpful.

When and Where

When
Wednesday, October 2nd, 9:00 a.m. to 5:00 p.m.

Where
Rosewood Sand Hill, 2825 Sand Hill Rd., Menlo Park, CA

To learn more about the location, visit:
Rosewood Sand Hill

Curriculum

Course modules

  • 1

    Details and Downloads

    • Oct 2 Pre-Summit Event Details

    • BYOL and Software Requirements

    • Student Workspace

    • Architecture Diagram

    • Keep Alive

  • 2

    Demystifying Variables and Filters

    • Formula Builder (New)

    • System Variables

    • Session Variables

    • Presentation Variables

    • Filters Overview

    • Prompts

    • Insight Filters

    • Measure Filters

    • LAB: Session Variables

    • Lab-1- Solution

    • LAB: Presentation Variables

    • Lab-2-Solution

    • Runtime Security Filters (Table)

    • LAB: Runtime Security Filters

  • 3

    No-ETL Schema Design

    • Formula Columns in Schema Design

    • Simulating Join Types

    • Table Alias

    • Incorta Table

    • LAB: Cohort Analysis with Incorta Table

    • Materialized Views

  • 4

    Schema Workshop

    • Create the Schema

    • Sanity Check

    • Check #1: Count of Employees and Average Salary

    • Check #2: Count of Employees by Department and Title

    • Check #3: Average Department Salary and Distinct Employee Count

    • Check #4: Average Salary by Department Name and Title

  • 5

    Advanced Data Loading Strategies

    • Loading Data

    • Incremental Schema Loads

    • Snapshots

    • LAB: Dense Snapshot

    • LAB: Sparse Snapshot

    • Slow Changing Dimensions

    • LAB: SCD Type II

    • Data Integration from Multiple sources

    • Additional PySpark resources

    • Data Hub = PostgreSQL Protocol for SQL

    • Dashboards for labs

  • 6

    The Path From Reports to AI

    • Incorta Maturity Model

    • About Apache Kafka

    • Incorta Apache Kafka Connector

    • LAB: Streaming Ingest with Apache Kafka and JSON

    • Machine Learning and Predictive Analytics with Apache Spark

    • LAB: Predicting Airfares

    • Python

    • Avro

  • 7

    Certification Exam

    • What's Next

CONNECT, LEARN, SHARE, INSPIRE

Oct 2, one day before the Incorta Summit 2019

  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds