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 step-by-step interactive project-based labs, students will master Incorta key concepts, terminology and topics for on the job success.

Prerequisites

This course is ideal for students who have previously achieved Incorta Essentials 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 Developers Virtual

    • Course Prerequisites
  • 2

    Welcome and Software Requirements

    • Welcome!

    • Software Requirements
  • 3

    Your Course Workspace

    • Accessing Your On-Demand VM and the Incorta Analytics Interface

    • Lab Troubleshooting

    • How to Follow Along (2 min)

    • Join our Community!
  • 4

    Incorta Architecture

    • Architecture Diagram (28 min)
  • 5

    Demystifying Variables and Filters

    • Filters Overview (2 min)

    • Dashboard Runtime Filters (13 min)

    • Insight Filters (18 min)

    • Dynamic Grouping and Measures (3 min)

    • Applied Filters (5 min)

    • Prompts (4 min)

    • Filter Options (5 min)

    • Presentation Variables (7 min)

    • Global Variables (9 min)

    • Runtime Security Filters (4 min)

    • Session Variables (10 min)

    • System Variables (3 min)
  • 6

    LAB: Session Variables and Applied Filters

    • Introduction

    • Create Internal Session Variables

    • Create an Applied Filter

    • Create Filter Options

    • Create a Filter Expression Session Variable

    • Create an Applied Filter That Uses the Filter Expression
  • 7

    LAB: Presentation Variables and Insight Filters

    • Introduction

    • Applying Presentation Variables for Dynamic Date Ranges

    • Applying Presentation Variables for Dynamic Group By & Aggregation
  • 8

    LAB: Runtime Security Filters

    • Introduction

    • Create the sch_RLS Physical Schema

    • Create an Internal Session Variable

    • Create a Regular Runtime Security Filter

    • Create the RLS Dashboard

    • Create a Formula Runtime Security Filter

    • Modify the RLS Dashboard
  • 9

    No-ETL Schema Design

    • Formula Columns in Schema Design (21 min)

    • Simulating Join Types

    • LAB: Incorta Joins (12 min)

    • Table Alias (8 min)

    • Incorta Analyzer Table (4 min)

    • Materialized Views
  • 10

    LAB: Schema Workshop

    • Create the Schema (12 min)

    • Validity Check Dashboard (10 min)

    • Check #1: Count of Employees and Average Salary (3 min)

    • Check #2: Count of Employees by Department and Title (8 min)

    • Check #3: Average Department Salary and Distinct Employee Count (5 min)

    • Check #4: Average Salary by Department Name and Title (5 min)
  • 11

    Advanced Data Loading Strategies

    • Loading Data (15 min)

    • Incremental Schema Loads (3 min)

    • Snapshots

    • Download these Dashboards for labs

    • LAB: Dense Snapshot (11 min)

    • LAB: Sparse Snapshot (7 min)

    • Slow Changing Dimensions

    • LAB: SCD Type II (18 min)

    • Data Integration from Multiple Sources (5 min)

    • Additional PySpark resources
  • 12

    Submit Labs and Workshop Assignments

    • Submit Your Demystifying Variables and Filters Lab

    • Submit Your Workshop Dashboard (7 min)
  • 13

    Certification Exam

    • Instructions

    • Certification Exam
  • 14

    Wrap Up

    • Pay it forward!

    • What's Next?