Future Proof your SQL Server Data Warehouse Processes – Sept 12, 2011
Future Proof your SQL Server Data Warehouse Processes
The role of Data Warehouses is growing to deliver more data, to more people, on a more frequent basis. This puts greater demands on the reliability and timeliness of data that’s being presented, as well as being able to quickly adapt to answer new business questions. SQL Server Integration Services provides a speedy mechanism to deliver information to business users, but presents the BI development team with a couple of soul-searching questions of how the ETL should be designed to ensure that the system “just works” on an ongoing basis. The session will explore some of the key questions on the design and organisation of your SSIS packages including: • How do we quickly deploy builds to the warehouse without a big configuration overhead? • How do we adapt to timing issues with data availability without pushing out the entire processing schedule? • How do we prove the data is right with each refresh and anticipate issues before they are raised by a business user? • How do we quickly diagnose data persistence issues that will inevitably arise? • How do avoid inconsistent ETL development controls developed with each project phase?
Nadav Rayman, BizData
Nadav Rayman is a Director at BizData, a Microsoft Gold Specialised Business Intelligence partner based in Melbourne, Australia. In addition to providing implementation services, BizData delivers Perspective http://www.perspectiveilm.com – a software suite to assist organisations to expedite and manage their Microsoft BI environments. Nadav has been working in the BI arena for 12 years, with exposure to a variety of sub-disciplines such as predictive analytics, campaign management, budgeting/planning/forecasting and knowledge management. For the last 8 years, Nadav has focused on the Microsoft BI Platform and works with customers to establish a BI strategy and create conditions for successful user adoption. Nadav regularly presents to customers and at industry forums such as Tech Ed Australia, on how to get the most value out of a Microsoft BI investment. When not talking BI, you’ll find Nadav collaborating with some great Melbourne musicians on his studio and live music projects.
09-12-2011 6:00 P.M. – 8:30 P.M.
Microsoft NYC offices, Microsoft – 1290 Avenue of the Americas, 6th Floor, , New York, NY, 10104,