M50263: Introduction to Microsoft Business Intelligence from SQL 2008 through SharePoint and Office

Level
Total time
Logo Perpetual Solutions
Provider rating: starstarstarstarstar 10 Perpetual Solutions has an average rating of 10 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Prerequisites:

Before attending this course, students must have:

- A working knowledge of RDBMS
- A working knowledge of Business Intelligence Studio
- A working knowledge of Excel and the Office Ribbon
- An understanding of the goals of Business Intelligence

Course Description:

This instructor-led course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0, SharePoint 2007 Integration, Reporting Services Content Typ…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Prerequisites:

Before attending this course, students must have:

- A working knowledge of RDBMS
- A working knowledge of Business Intelligence Studio
- A working knowledge of Excel and the Office Ribbon
- An understanding of the goals of Business Intelligence

Course Description:

This instructor-led course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0, SharePoint 2007 Integration, Reporting Services Content Types, Business Data Catalog, and Business Intelligence with Excel 2007 and Visio 2007.

On completion of this course, delegates will be able to:

  • Understand the pros and cons of Integration into SharePoint.
  • Create a Report using Report Builder 3.0.
  • Load and Manage Reports with SharePoint.
  • Create Report Subscriptions in SharePoint.
  • Create and customize the SharePoint Report Center.
  • Realize the importance of and customize SharePoint Content Types.
  • Explain the differences in workflows in SharePoint.
  • Understand and Create a Shared Service Provider in SharePoint.
  • Understand and Create a Business Data Catalog in SharePoint.

This course includes the following modules:

Overview Of the Microsoft BI Stack

  • The Goal of Business Intelligence
  • SQL 2008 Business Intelligence Platform
  • Integration Services
  • Analysis Services
  • Reporting Services
  • SharePoint Report Center
  • Multidimensional Space Terminology
  • SharePoint 2007 Terminology
  • Tools for Developers and Users
  • Business Intelligence Project Skill Sets Required
  • Business Intelligence Life Cycle
  • Lab: Introduction To The Stack Tools

Unified Data Model

  • UDM Vision
  • Problems UDM addresses
  • Benefits
  • Situations in which the UDM is inappropriate
  • Lab: Unified Data Model

SQL Server Integration Services

  • Major Components
  • Practice: Import Wizard, DtwTypeConverssion.xml
  • New or changed features
  • Script task
  • Practice: Script Task
  • Change Data Capture
  • Data Profiling Task and Viewer
  • Practice: Data Profiler and Viewer
  • SSIS Connection Project
  • Practice: Connection Project
  • Extract Transform Load
  • Best Practices for Deployment
  • Advanced Features of Packages
  • Practice: Logging
  • Transactions
  • Checkpoints
  • Practice: Work with Transactions and Checkpoints
  • Best Practices for Design
  • Lab: SQL Server Integration Services

SQL Server Analysis Server

  • Cubes
  • Multidimensional Space
  • Measures
  • Practice: Explore Measures
  • Dimensions
  • Practice: Create an unnatural hierarchy
  • Special Dimensions, Time and Slowly Changing
  • Schemas
  • Cube Processing
  • Partitions
  • Proactive Caching
  • Aggregations
  • Practice: Monitoring Aggregations
  • SSAS 2008 Enhancements
  • Lab: SQL Server Analysis Server

MDX Query Language

  • Overview
  • Editor
  • Select Statement
  • Where Clause
  • Tuples
  • Cells
  • Partial Tuples
  • Sets
  • Functions
  • Limiting Sets
  • Working With Time
  • Lab: MDX Query Language

SQL Server Reporting Services

  • Integration with SharePoint
  • Report Processing and Rendering
  • Report Authoring
  • Practice: Prepare SharePoint for Reporting Services
  • Data Access
  • Practice: Create Shared Data Sources
  • Data Sets
  • Practice: Create Datasets, Add a report Parameter
  • Semantic Models
  • Practice: Create a Report Model. Modify and Deploy the Model and Design a report based on the model
  • Tablix
  • Charts
  • Geospatial Data
  • Lab: SQL Server Reporting Services

SharePoint Server 2007

  • SharePoint Terminology
  • Functionality
  • Portals
  • Practice: Create a Portal
  • Content Types
  • Practice: Create a Content Type
  • Workflows
  • Web Parts
  • Practice: Create a web page and add web parts
  • Data Connection Libraries
  • Shared Service Provider
  • Report Center
  • Dashboards/Scorecards
  • Key Performance Indicators
  • Practice: KPIs
  • Subscriptions
  • Lab: SharePoint Server 2007

SharePoint Business Data Catalog

  • Why the BDC
  • BDC Web Parts
  • Application Definition Files
  • Authentication and Security
  • Lab: SharePoint Business Data Catalog

SharePoint Excel Services

  • Excel on the Server
  • Using Excel Services
  • Limitations
  • Trusted File Locations
  • Excel Web Service
  • Excel Web Access
  • Excel Calculation Service
  • Lab: SharePoint Excel Services

Data Mining and Excel

  • Notable Uses OF Data Mining
  • Key Terms
  • Types Of Data Mining Algorithms
  • The Microsoft Implementations OF The Algorithms
  • Excel and The BI Extensions
  • Lab: Data Mining and Excel

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.