Breeze Microsoft Business Intelligence (BI) Bootcamp

Breeze Microsoft Business Intelligence (BI) Bootcamp

Vendor Course Code:

Course Length:

5 days

Course Price:

$3,400.00 + GST

Availability:

If your preferred city or time is not currently listed, please call DDLS on 13 12 01 and we can try to accommodate your needs.

Overview:

Written and presented by industry experts, this intensive five-day workshop gives professional developers the information and hands-on experience they need to deliver state-of-the-art, integrated reporting and analytics solutions using Microsoft Business Intelligence.

Delivering the right information in the right format at the right time to all users in the organizationthat is Microsofts Business Intelligence (BI) strategy and vision for enterprise information management. Microsofts integrated BI tools enable developers to create effective solutions that information workers use every day to find meaningful patterns in the vast sea of data they collect and to use that insight to quickly respond to changing business conditions.

Skills Gained:

After this workshop, attendees will be able to position different types of business intelligence solutions, from enterprise data warehousing to data marts to real-time operational reporting and analytics. Attendees will learn how to design and build powerful integrated solutions that provide users with rich reporting, analysis, visualization and performance management capabilities by targeting operational data from an existing line-of-business application using the Microsoft Business Intelligence platform.

This is a practical workshop with at least 40% of the class time dedicated to comprehensive hands-on labs. The labs accumulate to build a complete Business Intelligence solution.

Key Topics:

Workshop Agenda
Microsofts BI Strategy, Dimensional Modeling, and ETL
Relational Reporting and Collaboration
Multi-Dimensional Analysis, Reporting, and Collaboration
Dashboards and Performance Management Solutions

Through interactive presentations and concrete hands-on labs, attendees will learn:

How to use Microsoft SQL Server 2005 to build and manage data marts which provide a consolidated view of business intelligence information.
How to use the 2007 Microsoft Office system, Office SharePoint Server 2007, and Office PerformancePoint Server 2007 to provide a rich data analysis, visualization and performance management experience for end users
How to use dimensional modeling techniques and Visio 2007 database modeling tools to create data models in SQL Server 2005 for hosting consolidated BI information.
How to build consolidated data marts using SQL Server 2005 Integration Services to extract, transform, and load business-critical information into SQL Server 2005 databases from disparate sources such as business applications and corporate databases.
How to use SQL Server 2005 Reporting Services to develop predefined and ad hoc relational reports that simplify access to business-critical information, and how to publish and share those reports using Office SharePoint Server 2007 report libraries.
How to use SQL Server 2005 Analysis Services to create a unified dimensional model (UDM) that simplifies analytical access to business-critical information stored in SQL Server 2005, and how to publish and collaborate on findings using SQL Server 2005 Reporting Services and Excel Services in Office SharePoint Server 2007.
How to use SQL Server 2005 Analysis Services to create data mining models that explore, uncover and predict patterns in a BI solution
How to use Excel 2007, Visio 2007 and ProClarity Professional Desktop for advanced data analysis and visualization.
How to build dashboards in Office SharePoint Server 2007 that expose business-critical information in compelling ways, and how to build and deploy custom dashboards.
How to use Office PerformancePoint Server 2007 to provide integrated performance-management solutions with scorecarding functionality.

The workshop will empower developers to exploit the BI functionality in the following technologies:
SQL Server 2005 Database Services
SQL Server 2005 Integration Services
SQL Server 2005 Reporting Services
SQL Server 2005 Analysis Services
SQL Server 2005 Data Mining
Office SharePoint Server 2007
Office PerformancePoint Server 2007
2007 Office system client tools, including Excel 2007 and Visio 2007
ProClarity Professional Desktop 6.2

Target Audience:

These presentations and labs were designed specifically to give professional developers the information they need to deliver integrated solutions on the Microsoft BI platform.

Prerequisites:

The following skills and knowledge will help attendees have a positive experience in the workshop:

Active development experience with C# and/or VB.NET
Basic understanding of SQL and relational database technology
Basic understanding of SharePoint portal technology