Building an Effective Data Warehouse Architecture Presentation

I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals Virtual Chapter.  Info about watching the presentation online is here, and the abstract for my session is below.  I hope you can make it!

Building an Effective Data Warehouse Architecture

You’re a DBA and your boss asks you to determine if a data warehouse would help the company.  So many questions pop into your head: Why use a data warehouse?  What is the best methodology to use when creating a data warehouse?  Should I use a normalized or dimensional approach?  What is the difference between the Kimball and Inmon methodologies?  Does the new Tabular model in SQL Server 2012 change things?  What is the difference between a data warehouse and a data mart?  Is there any hardware I can purchase that is optimized for a data warehouse?  What if I have a ton of data? During this session James will help you to answer these questions so your response to your boss will provoke amazement and lead to a big raise.  Or at least help to lead you down the correct path!

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication. Bookmark the permalink.

2 Responses to Building an Effective Data Warehouse Architecture Presentation

  1. Sam says:

    Your presentation today on Building an Effective Data Warehouse Architecture was very good. This is something that we plan on tackling in the next year or two (hopefully, been on the agenda for a while) and I will definitely plan to revisit this presentation at that time.

Leave a Reply

Your email address will not be published. Required fields are marked *