Skip Main Navigation
Eventbrite
Browse Events
Organize
Help
Log InSign Up
Menu
Page Content
This event has ended.

Actions Panel

Jun 07

Dimensional Modeling Design Patterns Beyond the Basics with Jason Horner

By Team SQL Saturday Columbus (Andy, David, Jonathan, Peter, and Todd)

When and where

Date and time

Fri, June 7, 2019, 8:30 AM – 4:00 PM EDT

Location

Otterbein University, Roush Hall 27 South Grove Street Westerville, OH 43081

Map and directions

How to get there

Refund Policy

Contact the organizer to request a refund.

Description

Dimensional modeling is arguably one of the most important fundamentals of business intelligence. It is still relevant even as new technologies like Power BI and SSAS Tabular Models are becoming standard. 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 capable of accommodating emerging requirements. This session provides a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally, we will cover physical design choices. This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.


Bio:

Hi, my name is Jason I'm a practice lead at Attunix. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Data Bricks, HDInsight, and Azure SQL Database. I'm fluent in several languages including SQL, C#, Python, and PowerShell. I'm a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years. In my off hours I like to snowboard, karaoke, ride roller coasters and play arcade games

Tags

  • United States Events
  • Ohio Events
  • Things to do in Westerville, OH
  • Westerville Classes
  • Westerville Science & Tech Classes
Event ended

Dimensional Modeling Design Patterns Beyond the Basics with Jason Horner


Follow this organizer to stay informed on future events

Team SQL Saturday Columbus (Andy, David, Jonathan, Peter, and Todd)

Event creator

Events you might like

  • Beyond - The Basics of Hair Extensions

    Beyond - The Basics of Hair Extensions
    Beyond - The Basics of Hair Extensions

    Sun, Aug 6, 9:00 AM
    Muse Hair Studio • Powell, OH
    $1,500
  • 3D Modeling Fundamentals

    3D Modeling Fundamentals
    3D Modeling Fundamentals

    Mon, Jan 30, 4:00 PM
    Terra Gallery • Dublin, OH
    $160
  • Beyond The Read Author Event

    Beyond The Read Author Event
    Beyond The Read Author Event

    Sat, Jul 22, 12:00 PM
    2886 Airport Dr • Columbus, OH
    $20 - $75
  • JASON LEECH + HONEYCOMB at The Summit Music Hall - Friday February 10

    JASON LEECH + HONEYCOMB at The Summit Music Hall - Friday February 10
    JASON LEECH + HONEYCOMB at The Summit Music Hall - Friday February 10

    Fri, Feb 10, 9:00 PM
    The Summit Music Hall • Columbus, OH
    $15
  • Galentine's or Valentine's Heart Beach Resin Design (or other Beach Design)

    Galentine's or Valentine's Heart Beach Resin Design (or other Beach Design)
    Galentine's or Valentine's Heart Beach Resin Design (or other Beach Design)

    Thu, Feb 9, 6:30 PM
    Mimi's Cafe • Columbus, OH
    $39 - $74.99
  • Color Theory Basics

    Color Theory Basics
    Color Theory Basics

    Sun, Feb 5, 1:00 PM
    Daylight Artist Collective • Westerville, OH
    $45
  • Witchy 101	 Basics	$5 at the door

    Witchy 101 Basics $5 at the door
    Witchy 101 Basics $5 at the door

    Wed, Feb 1, 6:00 PM
    Samantha's Alley • Newark, OH
    $5
  • Spring Floral Design Class @ Brewdog Canal

    Spring Floral Design Class @ Brewdog Canal
    Spring Floral Design Class @ Brewdog Canal

    Mon, Mar 6, 6:00 PM
    BrewDog Canal Winchester (Dogtap Columbus) • Canal Winchester, OH
    $65
  • Summer Floral Design Class @ Brewdog Canal

    Summer Floral Design Class @ Brewdog Canal
    Summer Floral Design Class @ Brewdog Canal

    Mon, Jun 5, 6:00 PM
    BrewDog Canal Winchester (Dogtap Columbus) • Canal Winchester, OH
    $65
  • Designer Warehouse Sale @ Crimson Design Group

    Designer Warehouse Sale @ Crimson Design Group
    Designer Warehouse Sale @ Crimson Design Group

    Fri, Feb 3, 11:00 AM
    825 Grandview Ave • Columbus, OH
    Free

Site Navigation

Use Eventbrite

  • How it Works
  • Pricing
  • Eventbrite Boost
  • Eventbrite Mobile Ticket App
  • Eventbrite Check-In App
  • Eventbrite App Marketplace
  • Event Registration Software
  • Content Standards
  • FAQs
  • Sitemap

Plan events

  • Sell Tickets Online
  • Event Planning
  • Sell Concert Tickets Online
  • Event Payment System
  • Solutions for Professional Services
  • Event Management Software
  • Community Engagement
  • Virtual Events Platform
  • QR Codes for Event Check-In
  • Post your event online

Find events

  • Browse Westerville Events
  • Get the Eventbrite App

Connect with us

  • Report This Event
  • Help Center
  • Terms
  • Privacy
  • CA Privacy Notice
  • Accessibility
  • Community Guidelines
Eventbrite + Ticketfly

© 2023 Eventbrite