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, the only Unified Data Analytics Platform with Direct Data Mapping.

Experience Builds Confidence

Hands-on, project-based learning

Through instructor-led discussion and interactive project-based labs, students will master Incorta key concepts, terminology and topics for on the job success.

Superheroes Wanted!

Audience prerequisites

This course is ideal for students 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.

Decision Tech for Business Growth

Professional certification for stardom

Incorta Certification establishes your leadership credentials and validates your expertise.

You can achieve Incorta certification by completing this course and by passing a certification exam. With a few clicks, you can easily add your digital certificate to your LinkedIn profiles.

Curriculum

Course modules

  • 1

    About Foundations Virtual

    • Course Prerequisites
  • 2

    Welcome! Zoom, BYOL, and Software Requirements

    • Welcome

    • BYOL and Software Requirements

    • Session 01

    • Session 02

    • Session 03

    • Session 04
  • 3

    Your On Demand, Cloud VM

    • Ready, Set, and Go!
  • 4

    Incorta Architecture

    • Architecture Diagram
  • 5

    Demystifying Variables and Filters

    • Filters Overview

    • Prompts

    • Presentation Variables

    • System Variables

    • Session Variables

    • LAB: Session Variables

    • LAB: Presentation Variables

    • Runtime Security Filters (Table)

    • LAB: Runtime Security Filters - Part 1

    • LAB: Runtime Security Filters - Part 2

    • LAB: Runtime Security Filters - Part 3
  • 6

    No-ETL Schema Design

    • Formula Columns in Schema Design

    • Simulating Join Types

    • LAB: Incorta Joins

    • Table Alias

    • Incorta Table

    • Materialized Views

    • Incorta over Incorta
  • 7

    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
  • 8

    Advanced Data Loading Strategies

    • Loading Data

    • Incremental Schema Loads

    • Snapshots

    • Download these Dashboards for labs

    • LAB: Dense Snapshot

    • LAB: Sparse Snapshot

    • Slow Changing Dimensions

    • LAB: SCD Type II

    • Data Integration from Multiple sources

    • Additional PySpark resources
  • 9

    The Path From Dashboards 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

    • Avro
  • 10

    Submit Labs and Workshop Assignments

    • Submit Your Demystifying Variables and Filters Lab

    • Submit Your Workshop Dashboard
  • 11

    Certification Exam

    • Instructions

    • Certification Exam
  • 12

    Wrap Up

    • Pay it forward!

    • What's Next?

Your Instructor

John will be your guide.

Principal Technical Instructor

John Nadasky

For over 25 years, John has been an Information Technology professional, mostly as an Oracle database administrator specializing in performance analysis. At NetApp, he specialized in enterprise storage. While expanding his industry and product knowledge, John became a technical instructor. For the past eight years, he conducted virtual and in-person training mostly focusing on NetApp’s storage, performance and analytics products.

John is a graduate from Pace University in New York with a bachelor’s degree in business administration and master’s degree in information systems. Before becoming a part time online adjunct professor with Southern New Hampshire University, John was an adjunct professor with the University of Phoenix. For nearly twenty years, John has been an online IT professor.

Originally from New Jersey, John lives just outside Raleigh, North Carolina, with his wife, three sons, and two Labrador retrievers. When not working, John enjoys spending time with family and friends, taking walks with his dogs, and watching movies and football.