Intro to Analysis Services and BI Workshop
Intro to Analysis Server and Business Intelligence
When Microsoft enters a software market, established players have good reason to be wary, With SQL Server 2005 now in play and the potential huge - BI and data analysis software is valued as a $22bn market that is growing at between 10% to 20% per year
With the infusion of new business intelligence capabilities into SQL Server 2005, Microsoft is set to take over the market, Are you ready?
Intro to Analysis Services and BI Class Overview
The goal of this 3 day, instructor-led course is to
provide you with an detail introduction to the Microsoft
Analysis Services and Business Intelligence. This hands-on course will explore these features using the development of an Analysis Services project as a solution-based training model. These features include Analysis Services with real-time analytics, Integration Services, Data Mining, Reporting Services, Key Performance Indicators, One-Click Cube, Proactive Caching, SQL Server Management Studio, Business Intelligence Development Studio, and integration with the Microsoft Office System.
Microsoft's SQL Server 2005 Business Intelligence Training Prerequisites
All attendees should have prior experience with relational databases and writing SQL queries for SQL Server 2005.
This course will give IT Professionals a jump-start on how to install, configure, administer, use, customize and develop for Microsoft Analysis Server and Business Intelligence. It is intended for administrators, developers, Webmasters and others who need to acquire these skills.
The course teaches SSAS features by having the students work
through project for a fictitious company.
After completing this course, students will be able to:
- New features of SQLServer 2005 for the Business Intelligence Developer
- Install and use SQL Server Analysis Services
- Install and use SQL Server Integration Services
- Install and use SQL Server Reporting Services
- Use SQL Server Management Studio
- Use Business Intelligence Development Studio
- Utilize new Data Mining algorithms
- Track Key Performance Indicators
- Use the Cube Wizard
- Implement Proactive Caching
- Use Analysis Services with Microsoft Office System
Student learning will be facilitated through a combination of instructor presentations and written lab exercises.
Agenda
Each day there will be a combination of presentations, code walk-throughs, and hands-on projects.
The final project incorporates everything we've covered during the course.
Total Cost of this individual course is $450.00 (includes code hand-outs/project).
Note: You can always “repeat” the classes you have taken earlier (provided seats are available)
Student Pre-Requisites
The technical student should be familiar with IIS. You should be
familiar with general programming in Visual Studio .NET. It is not required that you be a .NET guru, but as always the
more background you bring to the table the more you benefit. If you are not up
to speed with .NET, C#, or VB.NET, I believe you will find those sections
dealing with them fascinating, inspiring, and of course challenging.
Everything in Microsoft is evolving toward total and complete adoption of the
.NET platform and its various languages. This is an ideal place to take-a-look,
even if it’s a bit over the top for you at the moment.
