The best preparation for building an end-to-end, analytical warehouse solution with real-time insights.

Decision Tech for Business Growth

Relevant and rigorous training

Our administrator and developer course provides students with a comprehensive understanding of the procedures and techniques necessary to rapidly load data, build dashboards, and produce immediate insights using Incorta.

Experience Builds Confidence

Hands-on, project-base learning

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

Super Heros Welcome

Audience prerequisites

Designed to serve the learning goals of data warehouse administrators, database developers, and application programmers, this course requires experience with structured data, relational database systems, SQL, and shell scripting. Although not required, we recommend that students have familiarity with a modern programming language such as Python.

Data Warriors, Champions, and Visionaries

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

    Details and Downloads

    • Virtual Meeting Details --> Updated for Session 04

    • Verify SSH Access

    • BYOL and Software Requirements

    • Verify Access to the Incorta Training Instance

    • Student User Account and Tenant

    • Student Downloads

    • Administrator Student Downloads

    • Video: Session 01

    • Video: Session 02

    • Video: Session 03

    • Video: Session 04
  • 2

    Architecture Fundamentals

    • Guided Walkthrough of the Incorta Architecture

    • 4.3 LAB: US States Analysis
  • 3

    Hands-on Incorta Build Case Study

    • 4.3 LAB: Thrive Beverage Company, a Case Study
  • 4

    Schema Workshop

    • Employees ERD

    • Table Counts: Create a Reality Check Dashboard

    • Check #1: Count of employees by department

    • Check #2: Count of Emp Salaries and Average Salary

    • Check #3: Min, Avg, Max, Count of Salary Rows by Gender

    • Check #4: Average Dept Salary and Distinct Employee Count

    • Check #5: Count of emp titles by title

    • Check #6: Count of emp by department and title
  • 5

    The Complete Incorta Interface

    • Content

    • Scheduler

    • Business Schema

    • Schema

    • Data

    • Security
  • 6

    Building Schemas and Loading Data

    • Data Sources and Data Files

    • Schemas

    • Keys, Measures, and Dimensions

    • Schema Wizard

    • Adding Tables

    • Creating Joins

    • Loading Data
  • 7

    Creating Calculations and Formulae

    • Formula Columns

    • Formula Builder
  • 8

    Building Data-Driven Insights

    • Dashboard Creation

    • Insight Types

    • Measures

    • Dimensions

    • Settings

    • Data Filters

    • Bookmarks
  • 9

    Filters, Prompts, and Variables

    • Filters

    • Prompts

    • Presentation Variables

    • Session Variables
  • 10

    Hierarchies

    • Hierarchies
  • 11

    Tables Aliases, Base Tables, and Advanced Joins

    • Table Alias

    • Base Table

    • Advanced Joins
  • 12

    Data Loading Strategies

    • Full

    • Staging
  • 13

    Incorta Data and Object Security

    • Data Security

    • Data Encryption

    • Data Security

    • Row Level Security
  • 14

    Incorta Administration

    • Cluster Typologies

    • Installation and Configuration

    • Cluster Management Console

    • Tenant Management Tools

    • Command Line Interface

    • Audit Trails

    • Performance Tuning and Monitoring
  • 15

    Certification Exam

    • Instructions

    • Certification Exam