Data Warriors, Champions, and Visionaries — Join Us!
Relevant and rigorous training for Incorta developers
 
        Experience Builds Confidence
Hands-on, project-based learning
 
        Superheroes Wanted!
Audience prerequisites
 
        Decision Tech for Business Growth
Professional certification for stardom
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
- 
            
            1About Foundations Virtual- 
                    
                      
                    
                    
                    Course Prerequisites 
 
- 
                    
                      
                    
                    
                    
- 
            
            2Welcome! Zoom, BYOL, and Software Requirements- 
                    
                      
                    
                    
                    Welcome 
- 
                    
                      
                    
                    
                    BYOL and Software Requirements 
- 
                    
                      
                    
                    
                    Session 01 
- 
                    
                      
                    
                    
                    Session 02 
- 
                    
                      
                    
                    
                    Session 03 
- 
                    
                      
                    
                    
                    Session 04 
 
- 
                    
                      
                    
                    
                    
- 
            
            3Your On Demand VM- 
                    
                      
                    
                    
                    Ready, Set, and Go! 
 
- 
                    
                      
                    
                    
                    
- 
            
            4Incorta Architecture- 
                    
                      
                    
                    
                    Architecture Diagram 
 
- 
                    
                      
                    
                    
                    
- 
            
            5Demystifying Variables and Filters- 
                    
                      
                    
                    
                    Filters Overview 
- 
                    
                      
                    
                    
                    Prompts 
- 
                    
                      
                    
                    
                    Presentation Variables 
- 
                    
                      
                    
                    
                    System Variables 
- 
                    
                      
                    
                    
                    Session Variables 
- 
                    
                      
                    
                    
                    LAB: Session Variables and Applied Filters 
- 
                    
                      
                    
                    
                    LAB: Presentation Variables and Insight Filters 
- 
                    
                      
                    
                    
                    Runtime Security Filters 
- 
                    
                      
                    
                    
                    LAB: Runtime Security Filters - Part 1 
- 
                    
                      
                    
                    
                    LAB: Runtime Security Filters - Part 2 
- 
                    
                      
                    
                    
                    LAB: Runtime Security Filters - Part 3 
 
- 
                    
                      
                    
                    
                    
- 
            
            6No-ETL Schema Design- 
                    
                      
                    
                    
                    Formula Columns in Schema Design 
- 
                    
                      
                    
                    
                    Simulating Join Types 
- 
                    
                      
                    
                    
                    LAB: Incorta Joins 
- 
                    
                      
                    
                    
                    Table Alias 
- 
                    
                      
                    
                    
                    Incorta Table 
- 
                    
                      
                    
                    
                    Materialized Views 
- 
                    
                      
                    
                    
                    Incorta over Incorta 
 
- 
                    
                      
                    
                    
                    
- 
            
            7Schema 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 
 
- 
                    
                      
                    
                    
                    
- 
            
            8Advanced 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 
 
- 
                    
                      
                    
                    
                    
- 
            
            9The 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 
 
- 
                    
                      
                    
                    
                    
- 
            
            10Submit Labs and Workshop Assignments- 
                    
                      
                    
                    
                    Submit Your Demystifying Variables and Filters Lab 
- 
                    
                      
                    
                    
                    Submit Your Workshop Dashboard 
 
- 
                    
                      
                    
                    
                    
- 
            
            11Certification Exam- 
                    
                      
                    
                    
                    Instructions 
- 
                    
                      
                    
                    
                    Certification Exam 
 
- 
                    
                      
                    
                    
                    
- 
            
            12Wrap Up- 
                    
                      
                    
                    
                    Pay it forward! 
- 
                    
                      
                    
                    
                    What's Next? 
 
- 
                    
                      
                    
                    
                    
Your Instructor
John will be your guide.
 
              Principal Technical Instructor
John Nadasky
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.
