Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
              Sitemap
Main Areas
Onsite Training
Courses
Class Schedule
Registration
Tuition Discounts
Technology Library
Our Instructors
Our Customers
Why Object & Data Labs?

Hot New Courses:
XML: A Comprehensive Introduction
Disaster Recovery Planning

How students rate us

Free Newsletter
Visit our technology library and sign up to receive the latest word in technology from industry specialist.

Certification Available
Visit our certification page to see how you can be on the fast track to certification in advanced technologies.
  Home > Courses > Course Descriptions > Course Details Print Page
Course Description

Delivering Business Intelligence using Microsoft SQL Server 2005

Course Outline

Module 1: Introduction to BI principles
  • Data Warehousing & BI Concepts
  • Business Intelligence
  • Structure Continuum
  • Reporting Solution Alternatives
  • Quick Start: Introduction to BI Tools
  • Demos
Module 2: Integration Services (DTS)
  • Cleanse Data Input
  • Split an Output Channel
  • Script to Branch Control
  • Lookup Fuzzy Values
  • Loop through Folder
  • Configure and Deploy
  • Demos
  • Labs
Module 3: Analysis Services
  • Analysis Services (OLAP)
  • Programmability Preview
  • Deployment
  • Account Dimension
  • Measure Groups and Time
  • Alternate Aggregations
  • AMO Development
  • Tools Proactive Management
  • Demos
  • Labs
Module 4: Analysis Services Scalability
  • Partitions and Processing
  • Aggregation Concepts
  • Designing Aggregations
  • Aggregations and AMO
  • Specialized Topics
  • Demos
  • Labs
Module 5: Client Reporting Tools
  • Reporting Tool Overview – Excel, Reporting Services
  • Integrating Reports
  • Demos
Module 6: Analytical MDX
  • Introduction to MDX
  • Query Statements
  • Key Query Techniques
  • MDX Formulas
  • Formula Examples
  • Scripts
  • Stored Procedures
  • Demos
  • Labs
Module 7: Extending IS
  • DTS Extensibility
  • Custom Transformation
  • Custom Package
  • Demos
  • Labs
Module 8: Extending Reporting Services
  • Reporting Services Development Opportunities
  • Generating RDL Programmatically
  • Deploying Reports
  • Security Overview
  • Demos
  • Labs
Open Q & A

Back to Course Description   Onsite Training   Class Schedule

 

  Home | Courses | Class Schedule | Registration | About Us | Contact Call us TOLL FREE at 1-888-230-9052
Copyright 2003-2012, Object & Data Labs All Object & Data Labs Courses are certified courses with UC Berkeley & UCSC extension 

Website by Howard Pugh Web Design
Website maintained by Ann T. Comey