Overview

This course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 R2 in an integrated environment with SharePoint 2010 and Office 2010.

Objectives

After completing this workshop, students will be able to:
  • Use the Microsoft Exchange Server 2007 Management Pack for Microsoft Operations Manager (MOM) 2005 to monitor Exchange servers.
  • Monitor and troubleshoot client performance and connectivity.
  • Identify and resolve issues related to access of resources and messages.
  • Monitor and troubleshoot mail flow.
  • Monitor and troubleshoot Mailbox servers.
  • Monitor and troubleshoot external and additional services.
  • Identify trends in a messaging system.

Audience

The audience for this course includes people with experience with Exchange Server 2007 or previous versions of Exchange Sever. These people will have experience installing and configuring Exchange Server, configuring recipients and mailboxes, and supporting Exchange Server clients. People coming into the course are expected to have at least three years experience working in the Information Technology field—typically in the areas of network administration or Windows Server administration—and one year of Exchange Server administration experience.

Syllabus

The Business Intelligence Stack

  • SQL 2008R2 Business Intelligence Platform
  • SQL Analysis Services
  • SQL Reporting Services
  • Performance Management Tools
  • SharePoint 2010
  • Multidimensional Space
  • MDX
  • Data Mining
  • Understanding the Terminology
  • Lab : The Business Intelligence Stack

Unified Data Model

  • UDM Defined
  • User Experience: Relational vs. UDM
  • Advantages
  • Trouble in River City
  • Lab : Unified Data Model

SQL Server Integration Services

  • Major Components
  • New or Changed Features
  • Script Task
  • SSIS and ETL
  • Transformers
  • Best Practices 1
  • Best Practices 2
  • Lab : Lab SSIS Projects

SQL Server Analysis Services

  • Key Concepts
  • Schemas
  • Measures
  • Dimensions
  • Cube Processing
  • Partitions
  • Proactive Caching
  • Aggregations
  • Lab : Lab SQL Server Analysis Services

SQL Server Reporting Services

  • Integration with SharePoint
  • Report Builder 3.0
  • Differences Between Environments
  • Tablix
  • Charts
  • Lab : Lab SQL Server Reporting Services

MDX (0ptional)

  • What is MDX?
  • MDX Query Editor
  • Select Statement
  • Key Concepts
  • Sets
  • Functions
  • Time Intelligence
  • Lab : MDX (Optional Module)

PerformancePoint Services 2010

  • Integration with SharePoint Server 2010
  • Common Service Application Framework
  • New PerformancePoint Features
  • Storage Security
  • Time Intelligence and Dynamic Filters
  • Linking of Web Parts
  • KPI Details Report
  • Retired Features
  • Scorecards in PPS
  • KPI Collections
  • Dashboard Design Guidelines
  • Dashboard Designer Internals
  • Dashboard Designer Interface
  • First Class Objects
  • Main Window
  • Properties
  • Dashboard Designer Features
  • Lab : PerformancePoint Services 2010

Excel Services, Business Connectivity Services

  • Integration with SharePoint Server 2010
  • Storage Security
  • Single version of the truth
  • Excel Web Services
  • New capabilities in Excell Services
  • Business Connectivity Services
  • Lab : Excel Services 2010

Excel PowerPivot

  • Integration with SharePoint Server 2010
  • Understanding Modeling
  • Lab : PowerPivot 2010

Data Mining

  • Key Terms in Data Mining
  • Types of Data Mining Algorithms
  • The Algorithm
  • Excel and The BI Extensions
  • Visio 2010
  • Lab : Lab Excel 2010 and Data Mining BI

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 5 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Business intelligence
Worldwide
This skill has an average salary of
US$83,102
and is mentioned in
1.18%
of job ads.
User experience
Worldwide
This skill has an average salary of
US$87,686
and is mentioned in
1.95%
of job ads.
Microsoft Exchange Server
Worldwide
This skill has an average salary of
US$65,513
and is mentioned in
2.09%
of job ads.
Microsoft SQL Server
Worldwide
This skill has an average salary of
US$82,269
and is mentioned in
1.76%
of job ads.