OKCSQL | Oklahoma City SQL Server Users Group

November – Dimensional Modeling -Kimball BI

We are excited to invite you to the next meeting of the Oklahoma City SQL Server Users Group!OLYMPUS DIGITAL CAMERA

Allen Smith is our in-person speaker. Below are the details:

Allen is a Microsoft Certified Technology Specialist with certification in Business Intelligence Development and Maintenance. His IT specialties include database administration, business intelligence and medical imaging services.  He has designed and developed business solutions with the IBM Cognos and Microsoft SQL Server Business Intelligence platforms since 1999 and is also a VP for the OKCSQL Users Group.
More at Allen’s – Blog  or @CognitiveBI

The title for the talk is: Intro to Dimensional Modeling (aka Kimball Method) and will cover:

In this session we discuss the use of the Star Schema in data warehousing and compare it to relational modeling.  Typically used for OLAP cubes, these are also efficient for tabular modeling or DMR reporting.  We discuss dimensional analysis starting with business questions.  After that we discuss dimensional design, including the use of a Bus Matrix.  If time allows, we will review Slow Changing Dimensions and Conforming Dimensions.

When: Monday, Nov. 10th

Time: 6:00 p.m.- 8:00 p.m.

Food and Drinks will be provided by GDH

Location:  Dell – Lobby A
3501 SW 15th OKC, OK 73120
Be sure to check in with security when you arrive
Directions link: Click Here
Our Website/MailingList: http://okcsql.org
Twitter:  @OKCSQL

Other News:

Interested in learning about other local technology groups? Check out Techlahoma’s User Groups page at http://us.techlahoma.org/groups for a list of many local technology groups.

Sponsors:

We would like to thank GDH Consulting for sponsoring food, and Dell for sponsoring location. 
We would also like to thank our other prize sponsors Oreilly , McGraw Hill , Wrox, and Plural Sight.

10 Nov 2014

  • SQL Pass Chapter



    Subscribe

    * indicates required
  • Our Sponsors

  • Prize Sponsors

  • %d bloggers like this: