THIS MEETING IS FULL - INVITES ARE GOING OUT TODAY (MON) SO YOU SHOULD ONLY ATTEND IF YOU HAVE A CONFIRMED INVITE.
This will be the first combined SQL user group meeting. We will be running BI and non-BI presentations at the same time. This will give you the opportunity of meeting more like minded users from the SQL community
We can accommodate 35 people for each track, registration will be run separately so we can manage numbers. Please only register for one of the streams.
This is the agenda for the BI stream.
Registration is at 5.30, evening will commence at 6pm and finish 9pm.
6:00pm - 6.30pm
Introduction, news and gossip.
6.30pm - 7:15pm
Performance Point Server – Budgeting and Planning Under the Covers
Reed Jacobson - Hitachi Consulting (http://www.hitachiconsulting.com/)
This session will introduce you to Performance Point Server’s solution for budgeting & planning and will take a deeper look under the covers at how different design choices will ultimately impact the cubes that are created.
7:15pm - 8.00pm
Loading dimension tables and fact tables with SSIS
Allan Mitchell - Konesans(http://sqlis.com/)
Ever wondered what a slowly changing dimension is and how to load one using SSIS? Do you know what to do with early and late arriving facts? This session will reveal the tricks and tips you need to know about when using SSIS to handle these scenarios.
Allan is a co-author of Professional SQL Server 2005 Integration Services and co-founder of SQLDTS.com and SQLIS.com
8:00pm - 8:20pm
Break - Pizza and drink
8:20pm - 9:00pm
Monitoring and Analytics in PerformancePoint 2007.
David Francis (http://conchango.com/)
PerformancePoint 2007 is comprised of Planning, Monitoring and Analytics.
In CTP1 the majority of development has been focused on the Planning side, but some if not all of the Monitoring functionality is also available through the first release of PerformancePoint Scorecard Builder.
In CTP2, Microsoft will improve on this functionality and also include Analytics in the form of a version of Proclarity Dashboard Builder.
This presentation will take you through some of the features of the PerformancePoint Scorecard Builder and some issues that have been discovered on the way.
In addition, you will be shown what you can do now with the Proclarity suite and how to make it work with a PerformancePoint 2007 CTP1 model.
How to get there
Nearest tubes are, Mansion House, London Bridge, Southwark and Borough
Nearest stations are Blackfriars, London Bridge and Waterloo