PASS Community Summit 2009: Pre-Conference Sessions (BI Platform Architecture, Development and Administration)
Return to Session Listings
Building a Microsoft Data Warehousing Platform
Brian Knight (Pragmatic Works)
In this session, you''ll learn from author and SQL Server MVP Brian Knight how to build a data warehouse for your company and support it with the Microsoft platform. Well start with how to design and data model a data warehouse including the system preparation. Then, well quickly jump into loading the data warehouse with SSIS. After SSIS, you''re ready to roll the data up and provide slice and dice reporting with SSAS. Brian walks through cube development and enrichment with things like key performance indicators, which are essential for your future dashboards. Lastly, Brian covers how to report against the data warehouse with SSRS including a primer in how to write MDX queries against the SSAS cube. Make sure you bring your own optional laptop as you''ll be able to follow Brian in the session as he designs, loads and reports against the data warehouse with you.
Watch 24 Hours of PASS Session Recording
Q&A with Brian
Q: Your seminar walks through building a data warehouse from beginning to end using the Microsoft data warehousing platform. What are your favorite features of the Microsoft platform?
A: Nothing beats the look in users’ eyes when they see the data presented by SQL Server Analysis Services (SSAS) in a spreadsheet. It really empowers executives and staff to make quicker and better decisions. My favorite feature, though, is data mining because the ROI is so clear and it positions IT to be a profit center instead of a cost center. For example, a data mining solution can be directly responsible for reducing fraud or the primary reason marketing mails out half the brochures but receives 90% of the results...
Read the rest of Brian's conversation with PASS here.
About the Speaker
Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was recently on the Board of Directors of the Professional Association for SQL Server (PASS). Brian does regular webcasts at Jumpstart TV and is the author of 9 SQL Server books including: Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and co-author Professional SQL Server DTS, Professional SQL Server 2005 (and 2008) Administration and Professional SQL Server 2005 (2008) SSIS (Wrox Press). Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.pragmaticworks.com. Brian is a Principal Consultant and owner of Pragmatic Works.
See the other sessions Brian is presenting at PASS Community Summit 2009 here.
Register now for PASS Summit 2009!