Next Meeting: Tue, Sep 10 2013
HASSUG & H-BI Monthly Meeting - September 10, 2013
Event Type: In-Person
Online Meeting URL: None
The general schedule for each meeting will be:
11:30-11:40 – Announcements
11:40-12:40 – General presentation (What DBAs Need to Know About Managing SSAS Databases)
12:40-1:00 – Lunch\Networking – Raffle #1
1:00-2:00 – BI themed presentation (Building an Effective Data Warehouse Architecture)
2:00-2:30 – Recap Announcements – Raffle #2 - Networking
UTC : Tue, Sep 10 2013 16:30 - 19:30
Event Time : Tue, Sep 10 2013 11:30 - 14:30 Central Daylight Time
Your Local Time: Tue, Sep 10 2013 16:30 - 19:30
2000 W. Sam Houston Pkwy S. #350
Building an Effective Data Warehouse Architecture
James Serra, PDW TSP Microsoft
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’s the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What’s the difference between the Kimball and Inmon methodologies? Does the new Tabular Model in SQL Server 2012 change things? What’s 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? Join this session for the answers to all these questions. You’ll leave with information that will amaze your boss and lead to a big raise… – or at least lead you down the correct path to adding business value to your organization!
James Serra is an independent consultant serving as Business Intelligence, Data Warehouse, and Master Data Management Architect, and has more than 25 years of IT experience. He started as a software developer and then served as a DBA for 12 years, working extensively the past seven years with BI using the SQL Server BI stack (SSIS, SSAS, and SSRS). James is a SQL Server MVP and is a noted speaker, blogger, and contributing writer for SQL Server Pro magazine.
What DBAs Need to Know About Managing SSAS Databases
Ron is a BI professional who is currently leading the Houston BI User Group of the Houston Area SQL Server User Group (HASSUG).