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

    • BYOL and Software Requirements

    • Verify Access to the Incorta Training Instance

    • Virtual Meeting Details

    • Student Tenant

    • Student Downloads

    • Administrator Student Downloads

    • Video: Session 01

    • Video: Session 02

    • Video: Session 03
  • 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

    The Complete Incorta Interface

    • Content

    • Scheduler

    • Business Schema

    • Schema

    • Data

    • Security
  • 5

    Building Schemas and Loading Data

    • Data Sources and Data Files

    • Schema Wizard

    • Schemas

    • Keys, Measures, and Dimensions

    • Adding Tables

    • Creating Joins

    • Loading Data
  • 6

    Creating Calculations and Formulae

    • Formula Columns

    • Formula Builder
  • 7

    Developing and Designing Data-Driven Insights

    • Dashboard Creation

    • Insight Types

    • Measures

    • Dimensions

    • Settings

    • Data Filters

    • Bookmarks
  • 8

    Filters, Prompts, and Variables

    • Filters

    • Prompts

    • Presentation Variables

    • Tenant Session Variables
  • 9

    Hierarchies

    • Hierarchies
  • 10

    Tables Aliases, Base Tables, and Advanced Joins

    • Table Alias
  • 11

    Schema Workshop

    • Employees ERD

    • Create Joins

    • Table Counts: Create a Reality Check Dashboard

    • Count of employees by department

    • Count of emp titles by title

    • Count of Emp Salaries and Average Salary

    • Min, Avg, Max, Count of Salary Rows by Gender

    • Average Dept Salary and Distinct Employee Count
  • 12

    Certification Exam

    • community.incorta.com

    • Instructions

    • Certification Exam