2015 Sunday Training

Higher Education Data Warehousing Conference 2015

Hosted by Illinois State University, April 19-22, 2015

Sunday All-Day Training Session 8:30am – 5:00pm

Fee: $500 (includes breakfast & lunch)

(Participants should arrive in Bloomington-Normal by Saturday evening.)


Course descriptions:


Training #1: Intermediate/Advanced Data Modeling – Steve Hoberman

Dimensional Data Modeling for Analytic Applications Workshop

This workshop, which will contain higher education real world examples, will prepare you for analyzing and designing reporting- and query-friendly business applications. The day is organized around the five steps for building a Star Schema:

  1.    Elicit Business Questions
  2.    Complete the Grain Matrix
  3.    Build the Dimensional Conceptual Data Model (CDM)
  4.    Build the Dimensional Logical Data Model (LDM)
  5.    Build the Dimensional Physical Data Model (PDM)

For eliciting business questions, we will reference the International Institute of Business Analysis (IIBA) Body of Knowledge (BABOK), and tailor several of the techniques, such as interviewing and prototyping, for data modeling requirements. We will cover the two important ingredients to every business question, and explore different techniques for arriving at a set of business questions.

The Grain Matrix is an essential spreadsheet for capturing the common measures across business questions, and for scoping analytics applications. This matrix works really well with agile practices, as the Grain Matrix allows for program level analysis and then agile deliverers projects quickly and iteratively.

The dimensional CDM helps with scoping a particular project and in capturing high level terminology, especially key measures. We will learn about the Axis Technique, which is a much more user-friendly diagramming style than traditional entity/relationship modeling.

The dimensional LDM captures the business solution for the analytics application. We will cover key terminology such as dimension, meter, conformity, factless facts, bridge tables, and behavioral structures. We will cover drilling up, down, and across. We will end this section with some thought-provoking quotes on both modeling and architecture.

The dimensional PDM captures the technical solution. We will explain the difference between a star schema and snowflake, and cover key terminology such as degenerate, junk and mini dimensions. We will cover all four types of slowly changing dimensions.

We will use many higher-ed examples throughout the day, and complete a higher-ed case study at the end of the day to reinforce all of the dimensional techniques.


About Steve Hoberman:


Steve Hoberman taught his first data modeling class in 1992 and has trained more than 10,000 people since then, spanning every continent except Africa and Antarctica. Steve is known for his entertaining and interactive teaching style (watch out for flying candy!), and organizations around the globe have brought Steve in to teach his Data Modeling Master Class, which is recognized as the most comprehensive data modeling course in the industry. Steve is the author of seven books on data modeling, including the bestseller Data Modeling Made Simple. His latest book, Data Modeling for MongoDB, presents a streamlined approach to data modeling for NoSQL solutions.  As a data modeling consultant, he frequently validates data models using the Data Model Scorecard® approach. He is the founder of the Design Challenges group, Conference Chair of the Data Modeling Zone conference, recipient of the 2012 Data Administration Management Association (DAMA) International Professional Achievement Award, and highest rated presenter at Enterprise Data World 2014. To receive Steve’s monthly Design Challenges, visit his website at www.stevehoberman.com. Steve can be reached at me@stevehoberman.com, @DataMdlRockStar on Twitter, or through Steve Hoberman on LinkedIn



Training #2: How to Create and Maintain a Healthy Organization (based on Patrick Lencioni’s book, The Advantage) – Rick Van Arnam, Principal, The Table Group


Presentation and facilitation of a healthy organizational model as described in Patrick Lencioni’s The Advantage utilizing the The Table Group’s signature approach -practical (not theoretical), relevant (not touchy feely) and fast (not slow or boring).  The session will cover the Four Disciplines:

  1. Build a Cohesive Team
  2. Create Clarity
  3. Over-communicate Clarity
  4. Reinforce Clarity

In addition, participants will be guided through exercises and discussion focused on the behaviors of a cohesive team, trust, conflict styles and norms, how to achieve commitment, embracing accountability.  Finally, a practical discussion of how to apply these techniques in your own teams and next steps will close out the day.

A participant guide and a copy of Lencioni’s, The Advantage are included.


About Rick Van Arnam: 


As a Principal Consultant, Rick has been working with teams and leaders on matters of leadership, team and organizational effectiveness for nearly twenty years. His client work focuses on the connection between effective relationships, cohesive teams and producing results. Recognized for his ability to connect with others and break down complex issues, Rick has a unique way of helping clients improve their organizations by creating healthy environments where desired results are realized.

Currently, Rick works with CEOs and executive teams in quickly and effectively applying the concepts captured in all of Pat Lencioni’s books. His clients span a broad spectrum of industries ranging from technology, consumer brands, health care and the government.

Rick has a diverse leadership background in the military, corporate, and higher education segments. A veteran of deployments to Panama (1989) and Afghanistan (2003 & 2010), he has used Patrick’s concepts in senior leadership roles spanning data network sales to full-spectrum Military Intelligence Operations in Afghanistan.

Prior to joining The Table Group in 2012 and since 9/11, Rick balanced challenging Army National Guard demands with his work as an organizational effectiveness consultant and work in higher education leading teams in both development and student affairs. In 2014, he retired at the rank of Colonel in the United States Army where he served for thirty years on Active Duty and in the National Guard and Reserves including a final assignment as Commander of the 124th RTI (Regional Training Institute) Regiment. He earned an MBA from the University of Michigan’s Ross School of Business with a focus on marketing and strategy.



Register for the Pre-Conference Training by selecting from the two offerings under “Sunday Training Sessions” when prompted on the online registration form.