Introduction to Modeling 101*

Sandhill Academy's Introduction to Modeling 101 offers an introduction to the concepts, procedures, and industry significance of data modeling. This overview is suitable for novices, active data modelers needing better grounding in the fundamentals, IT staffers and programmers exploring data modeling for the first time, and database administrators seeking a fuller understanding of how their data is initially defined. Introduction to Modeling 101 courses include:

Data Modeling Concepts

Data Modeling Concepts provides for a basic understanding of data modeling procedures, how data models are developed, and introduces the notation used to define and record those data models. Course presentations and classroom exercises introduce analysts, developers, and DBAs to the fundamentals of data modeling using ERwin-based methods and concepts.

Dimensional Modeling Concepts and Fundamentals

Dimensional Modeling Concepts and Fundamentals starts with a brief overview of dimensional modeling concepts to level set the knowledge on the theory of Dimensional Modeling and reviews what are facts and dimensions.   The students then learn to describe, design and build dimensional models and model marts using Star Schemas’ or Snowflake Dimensional Modeling Techniques.  Students also learn how to define the three classic types of time variants and how they are traditionally positioned. Part of the class also focuses on  normalization / de-normalization as part of the design process, and assess their impact on the key structures.  This class is filled with hand on lab exercises and upon completion the student will know how to do dimensional modeling in eerwin®.  Dimensional Modeling Fundamentals is available as an instructor-led training class, held on-site at client locations

Process Modeling Concepts

Process Modeling Concepts leveraging Casewise Modeler, delivers basic introduction to process modeling, explaining what models represent, showing how models are defined, and demonstrating the notation used to create process diagrams. Course presentations and classroom exercises help business analysts and IT staffers understand the role of process modeling in process management and process change projects.