Microsoft Business Intelligence (BI) Bootcamp Workshop

Dimension Data Learning Solutions
Adelaide, Brisbane, Canberra, Melbourne, Perth, Syndey, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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
�Microsoft’s 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
...''

Elements of this syllabus are subject to change.

Phone:13 12 01 / 08 8236 8200

School Address:

Level 7
553 Hay St
Perth WA 6000

Level 4, PKF House
139 Frome St
Adelaide 5000

Level 10, Thakral House
301 George St
Sydney 2000

Level 3, Dimension Data Building
11-17 Dorcas St
South Melbourne 3205

Level 12
307 Queen St
Brisbane 4000

Jobs & Resumes: Adelaide, Brisbane, Canberra, Melbourne, Perth, Syndey
Houses & Roommates: Adelaide, Brisbane, Canberra, Melbourne, Perth, Syndey
Travel Agencies: Brisbane, Melbourne, Perth,

Search other schools for Microsoft Business Intelligence (BI) Bootcamp training resources.

Implementing a Microsoft SQL Server 2005 Database
Maintaining a Microsoft SQL Server 2005 Database
Queries Using Microsoft SQL Server 2008 Transact-SQL
Updating SQL Server 2005 Skills to SQL Server 2008
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006
BizTalk 2006 R2 �Developer BootCamp
Microsoft BizTalk RFID Workshop
Microsoft Office PerformancePoint Server
Supporting Users Running the Microsoft Windows XP Operating System
Supporting Users Running Applications on a Microsoft Windows XP Operating System
Implementing and Supporting Microsoft Windows XP Professional

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.