Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions (M6234)

In this 5-day instructor-led course, you'll learn to design & maintain business intelligence solutions for your organization using SQL Server 2008.

Course Outline

In this five-day instructor-led course, you will learn to design and maintain business intelligence solutions for your organization using SQL Server 2008. You will learn how to use the SQL Server development tools to create Analysis Services databases and OLAP cubes. In addition, you will learn to implement complete business intelligence solutions from design to development to production and, finally, end user analysis and reporting.

This course incorporates material from the Official Microsoft Learning Product 6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services.

Why Global Knowledge?

This course includes two days of exclusive content, including hands-on labs where you will learn to implement a full end-to-end Business Intelligence Solution. You will learn how to leverage other Microsoft products, including Excel, Reporting Services, Report Builder, and SharePoint.

What You'll Learn

• How SQL Server Analysis Services can be used to implement analytical solutions
• Create multidimensional analysis solutions with SQL Server Analysis Services
• Implement dimensions and cubes in an Analysis Services solution
• Implement measures and measure groups in an Analysis Services solution
• Query a multidimensional Analysis Services solution
• Customize an Analysis Services cube
• Deploy and secure an Analysis Services database
• Maintain a multidimensional Analysis Services solution
• Implement a Data Mining solution
• Tune SSAS cubes
• Design SSAS for performance
• Load Data Warehouse solutions using SSIS
• Create and implement Reporting Solutions using SQL Server Reporting Services
• Integrate SSAS with Microsoft Excel
• Create Excel Reports against cubes
• Expose cubes in a Sharepoint environment

Who Needs to Attend

• Individuals who design and maintain business intelligence solutions and who work in environments where databases play a key role in their primary job and may perform database administration, database design, data warehouse design, maintenance, or ETL as part of their primary job responsibilities.
• Individuals, including report writers, business analysts, and financial analysts, who develop applications that deliver content from SQL Server Analysis Services to the organization.

Course Outline

1. Introduction to Microsoft SQL Server Analysis Services

• Overview of Data Analysis Solutions
• Overview of SQL Server Analysis Services
• Installing SQL Server Analysis Services

2. Creating Multidimensional Analysis Solutions

• Developing Analysis Services Solutions
• Creating Data Sources and Data Source Views
• Creating a Cube

3. Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Attributes

4. Working with Measures and Measure Groups

• Working with Measures
• Working with Measure Groups

5. Querying Multidimensional Analysis Solutions

• MDX Fundamentals
• Adding Calculations to a Cube

6. Customizing Cube Functionality

• Implementing Key Performance Indicators (KPI)
• Implementing Actions
• Implementing Perspectives
• Implementing Translations

7. Deploying and Securing an Analysis Services Database

• Deploying an Analysis Services Database
• Securing an Analysis Services Database

8. Maintaining a Multidimensional Solution

• Configuring Processing
• Logging, Monitoring, and Optimizing an Analysis Services Solution
• Backing Up and Restoring an Analysis Services Database

9. Introduction to Data Mining

• Overview of Data Mining
• Creating a Data Mining Solution
• Validating Data Mining Models

10. Exclusive - Tuning SSAS

• Index Creation, Maintenance, and Tuning
• Using SQL Server Profiler against SSAS Cubes
• Proactive Caching Overview
• Benefits of Proactive Caching
• Implementing Proactive Caching
• Aggregation Design and Tuning

11. Exclusive - SQL Server Integration Services

• Overview of SSIS
• SSIS Designer
• Running SSIS Packages
• Populating a Data Warehouse with SSIS

12. Exclusive - Integrating SSAS and MS Excel

• Installing Microsoft Office 2007 Tools
• Connecting to SSAS Cubes
• Creating Pivot Tables and Charts against Cubes

13. Exclusive - Reporting Services

• Overview of Reporting Services
• Setting Up and Configuring Reporting Services
• Creating Reports using Business Intelligence Development Studio
• Creating Ad Hoc Reports using Report Builder

Labs
Lab 1: Using SQL Server Analysis Services

• Installing SQL Server Analysis Services
• Verifying Installation

Lab 2: Creating Multidimensional Analysis Solutions

• Creating a Data Source
• Creating and Modifying a Data Source View
• Creating and Modifying a Cube

Lab 3: Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Relationships and Hierarchies
• Sorting and Grouping Dimension Attributes

Lab 4: Working with Measures and Measure Groups

• Configuring Measures
• Defining Dimension Usage and Relationships
• Configuring Measure Group Storage

Lab 5: Querying Multidimensional Analysis Solutions

• Querying a Cube by Using MDX
• Creating a Calculated Member
• Defining a Named Set

Lab 6: Customizing Cube Functionality

• Implementing a KPI
• Implementing an Action
• Implementing a Perspective
• Implementing a Translation

Lab 7: Deploying and Securing an Analysis Services Database

• Deploying an Analysis Services Database
• Securing an Analysis Services Database

Lab 8: Maintaining a Multidimensional Solution

• Configuring Processing
• Implementing Logging and Monitoring
• Backing Up and Restoring an Analysis Services Database

Lab 9: Introduction to Data Mining

• Creating a Data Mining Structure
• Adding a Data Mining Model
• Exploring Data Mining Models
• Validating Data Mining Models

Lab 10: Exclusive - Tuning SSAS

• Index Creation, Maintenance, and Tuning
• Using SQL Server Profiler against SSAS Cubes
• Implementing Proactive Caching
• Aggregation Design Tuning
• Aggregation Tools

Lab 11: Exclusive - SQL Server Integration Services

• Overview of SSIS
• SSIS Designer
• Running SSIS Packages
• Populating a Data Warehouse with SSIS

Lab 12: Exclusive - Integrating SSAS and MS Excel

• Installing Microsoft Office 2007 Tools
• Connecting to SSAS Cubes
• Creating Pivot Tables and Charts against Cubes

Lab 13: Exclusive - Reporting Services

• Setting Up and Configuring Reporting Services
• Creating Reports using Business Intelligence Development Studio
• Creating Ad Hoc Reports using Report Builder
• Deploying Reports to Report Manager

Additional Details

Pre-Requisites

- Experience navigating the Microsoft Windows Server environment - Experience with Windows services (starting and stopping) - Experience creating service accounts and permissions - Experience with Microsoft SQL Server, including: * SQL Server Agent * SQL Server query language (SELECT, UPDATE, INSERT, and DELETE) * SQL Server System tables * SQL Server accounts (users and permissions) * Course 6182: Implementing and Maintaining SQL Server 2008 * Course 6174: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services * SQL Server 2008 R2 for Administration (M6231) * Maintaining, Troubleshooting, and Developing Solutions with Microsoft SQL Server 2008 Reporting Services (M6236)

Certificates offered

- Eligible for SATV Purchase - 3 Day SATV Voucher

Cancellation Policy

We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted.

Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.

Map & Reviews

Global Knowledge
[ View Provider's Profile ]

Global Knowledge Edmonton
10050 - 112 Street
Suite 400
Edmonton, Alberta
Canada   T5K 2J1

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

- do we get a certifiacate for completing the courseÉ - although the instructor did give us excercises to do I would have liked a few more - almost like a test, so that I made sure I retained and understood what was taught. I`m a learn to do by doing person and like the instrutor lead courses so I can have someone there to explain in my terms how things work. I`ll have to really use the online excercises to make sure Ì am confident when I need to do something in Excel.

Reviewed by Delores P. 2012

   

Should be time allocated for questions and answer

Reviewed by Vinod P. 2012

   

The instructor was excellent as was the hands-on learning approach. The only thing I took issue with was the fact that there were a lot of bilingual persons taking the course and they tended to ask questions in French, during this English class. The instructor was trying very hard to explain everything in both languages, but I felt that these students should have requested a French-speaking classroom setting if they wanted to speak French.

Reviewed by Sheila D. 2012

   

Very professional. Facility clean and comfortable.

Reviewed by Christine P. 2012

   

For the cost of this course, a hard copy of the course handout should be provided as the classes follows the handout word for word.

Reviewed by Caroline P. 2012

   

The facilities at Global Knowledge were great. The Instructor was very knowlegable and made it easy to learn the material. It was a very good experience:)

Reviewed by Tonia L. 2012

   

Note: We had 2 different trainers during this 3 day course. Course: Terminology should reflect North America and be consistent with our business lingo.

Reviewed by Harman M. 2012

   

Found the course very informative. I had little exposure to Sharepoint and learned a number of things I didn't know. Plan to take the next level of training

Reviewed by Michael R. 2011

   

A charged mannul would be provided for students to make notes whereever they think instructions are important as reminders

Reviewed by jinxiu z. 2011

   

The course is so expensive to be payed by oneself. In almost all the others participants their companies pay the fee.

Reviewed by Ricardo T. 2011

   

No course books were provided for us to take.

Reviewed by Hala M. 2011

   

Course was very detailed but more time would be helpful during workshops. An additional day would help lessen the course load.

Reviewed by Roydon F. 2011

   

should have discuss some case studies,,overall A+

Reviewed by Syed A. 2011

   

Our instructor was very knowlegable and he provided excellent real life stories.

Reviewed by Stephen W. 2011

   

The course was very relevant. I was able to apply the knowledge I aquired in the course to my job on the very next day. The only complaint I have is with the temperature of the room. It was freezing! Students has to wear a jacket or sweater. We were told the temp gage was shared with another classroom that was quite warm so they had turned the temp very low causing our room to be very uncomfortable.

Reviewed by Yasmine I. 2011

   

Given the cost of the course, the hardcopy of the manual should have been provided. It would have been useful to make notes alongside the material as we went along.

Reviewed by Jeff P. 2011

   

I am very disappointed with the handouts. I was told I could go online and download a copy of the manual, the problem is that I would like the printed copy of the manual. I chatted online with one of your technitian who was unable to help me. Then I was told someone would contact me by phone to help me. That never happened. When taking a training course, a person EXPECTS to leave the course with ALL the material.

Reviewed by Betty M. 2011

   

Great course provider, keep it on your roaster

Reviewed by Catherine G. 2011

   

Course content and labs were very good, everything worked as expected.

Reviewed by Francisco C. 2011

   

I really enjoyed this course and was surpised how ell everything was run...enjoyed the instructer very much (Par) and would like to take an other course with him. I wish we could have taken the work book home with us though!!!

Reviewed by gail h. 2010