Masterclass programme

Separately Bookable Business Intelligence Masterclass

Wednesday 24th August 2005         

What’s New in Microsoft SQL Server 2005 Business Intelligence?
Led by: Dan Weinstein, Senior Consultant , Custom Business Solutions

Overview

This one day instructor-led course provides participants with an introduction to the new features of the SQL Server 2005 Business Intelligence products. This intensive course includes demonstrations to reinforce the key topics presented.

Benefits of attending

• Understand the Business Intelligence features of SQL Server 2005
• See Integration Services 2005 (formerly DTS) to copy and manage data
• Watch Analysis Services 2005 build databases, cubes and dimensions
• Design cube storage and aggregations
• Optimise the processing of dimensions and cubes
• Understand the data mining capability of Analysis Services 2005
• Create reports from Analysis Services cubes
  

Key Topics

• Business Intelligence Core Concepts
• Introducing the SQL Server 2005 end-to-end Business Intelligence Platform (including the new UDM "Unified Dimensional Model”)
• The SQL Server 2005 Business Intelligence Tools
• Introducing Integration Services 2005 (formerly DTS)
• Building an Analysis Services 2005 Database
• Managing Analysis Services
• MDX Enhancements
• Working with Data Mining
• New features in Reporting Services 2005
  

Target Audience

This course is intended for database analysts, programmers and developers with experience implementing business intelligence solutions with SQL Server 2000. Additionally the course will be appropriate for decision makers currently evaluating BI tool sets. Likewise, those with a current background in Business Intelligence but without SQL Server knowledge will benefit by gaining an appreciation of the SQL Server 2005 business intelligence features and capabilities.

About your Masterclass leader

Dan Weinstein is a Senior Consultant for Custom Business Solutions based in Melbourne. Custom Business Solutions is a Microsoft Certified Gold Partner focusing on SQL Server and ASP.Net solutions. Dan, sometimes known as ‘the SQL guy’, is responsible for designing and building SQL and BI solutions. He also spends time presenting in the classroom as a Microsoft Certified Trainer.  Dan joined Custom Business Solutions in 1997, and he has worked with their corporate and Government customers to deliver solutions and technical training. Dan has previously worked for National Australia Bank and Lockheed Missile and Space Corporation with software for projects such as the Space Shuttle and Submarine launched Fleet Ballistic Missiles. His current primary project is team leader of a Data Warehouse and BI solution for Tenix Defence Systems’ ANZAC Ship Project which is helping win contracts for the client, while producing significant savings on the $1,000,000,000 cost of delivering ships