" rel="stylesheet">
Skip Main Navigation
Page Content
This event has ended

[SOLD OUT] SQL Saturday Workshop - Dimensional Modeling with Jason Horner

SoCal SQL Saturday

Friday, April 25, 2014 from 8:30 AM to 5:00 PM (PDT)

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
General Admission Sold Out Ended $99.00 $6.44

Who's Going

Loading your connections...

Share [SOLD OUT] SQL Saturday Workshop - Dimensional Modeling with Jason Horner

Event Details


Dimensional modeling is arguably one of the most important
fundamentals of business intelligence it is still relevant even as new
technologies like PowerPivot and SSAS tabular are coming into to
Vogue. Correctly modeling your organization's data not only protects
the most important asset your company has but ensures that your data
mart or data warehouse will be responsive and able to accommodate
emerging requirements.

The workshop is split into three main modules:

  • Dimensional modeling fundamentals
  • Advance Dimensional modeling design patterns
  • Group modeling exercises

Dimensional modeling fundamentals will introduce the basic terminology
and concepts in the Kimball methodology we will also provide a 15,000
foot overview of data warehouse architecture including the typical
components and roles

Case Study module we will review some example Dimensional models and
point out the good bad and ugly

Group Project The final module will be a group project the class will
be split into teams and given a small to medium size dimensional model
to implement. Once this is complete the groups will present their
findings in a short 5-10 minute presentation highlighting some of the
challenges and design tradeoffs with the reasons they were made.

Ready to go from Zero to Dimensional Modeling Hero? This full day
workshop will get your there.


Dimensional Modeling Fundamentals 2.5 -3hrs

The need for Dimensional modeling
Components of a Data Warehouse
Exploring the Star Schema

Just the facts

Measures meters and KPI's oh my
Types of fact tables
Special fact tables
Factless Facts

Dimensions to delight and excite

Date and Time
Handling change
Snow flaking
Advanced design patterns
Behavior study groups

Let's Get Physical

Data Types
Disk layout

Db Objects

Inline TVF's

Case Studies 1hr

Sales Order Management
Order Fulfillment
Human Resources

Group modeling exercises 2-3hrs

About the Trainer:

Jason Is a Microsoft Certified Master SQL Server and holds MCSE's in both Data Platform and Business Intelligence.

Working with Sql Server as a DBA / Application Developer since version 6.5, He made the transition to delivering BI solutions in 2002 and began working with Spatial Data in 2008. Jason speaks frequently on a diverse range of topics from PowerShell to Dimensional Modeling at the local Colorado user Groups, SQL Saturday's and other regional and national conferences including the Rocky Mountain Oracle User Group(RMOUG) Training Days and PASS Business Analytics Conference(BACON).

Jason Horner

LinkedIn: http://www.linkedin.com/in/jasonhorner
Twitter: @jasonhorner


Have questions about [SOLD OUT] SQL Saturday Workshop - Dimensional Modeling with Jason Horner? Contact SoCal SQL Saturday

When & Where

QuickStart Intelligence
16815 Von Karman Ave
Suite 100
Irvine, CA 92606

Friday, April 25, 2014 from 8:30 AM to 5:00 PM (PDT)

  Add to my calendar
[SOLD OUT] SQL Saturday Workshop - Dimensional Modeling with Jason Horner
Irvine, CA Events Seminar Science & Tech

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.