MasterClass: SQL Server 2008 End-to-End Business Intelligence Workshop - Uddannelser

Kursus

Business intelligence solutions provide the infrastructure that enables users at all levels of a business to make better decisions based on more accurate and up-to-date information. This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build, deploy, and operate a business intelligence solution using SQL Server 2008 Integration Services, Analysis Services and Reporting Services.

Ingen planlagte afholdelser

Nr.: 87065 A

DKK 27.950,- ekskl. moms

Deltagerprofil

This course is designed for IT professionals who are interesting in learning how to implement Business Intelligence solutions on the Microsoft SQL Server platform. Basic knowledge of BI concepts, relational database system and Windows Security is assumed and some experience with SQL Server is required.

Indhold

Module 01: Introduction to Business Intelligence

BI Practice
Components of a BI solutions
MS BI stack
Intro to the MS SQL BI Platform
Highlight some major changes between SQL Server 2005 and 2008
Client Tools for development and management

Module 02: Preparing Data for Analytics

Dimensional Modeling and Modeling Concepts

Module 03: Implementing workflows using SQL Server Integration Services

SSIS Components
Package Components
Changes in SQL Server 2008
Data Sources and Connections
Tasks, Containers and Precedence Constraints
Highlight: Script Task and VSTA
Variables
SSIS Expressions

Module 04: Processing data using SQL Server Integration Services

Data Flow Components: Source and destination adapters, transformations, data flow paths
Building data flows
Changes in SQL Server 2008
Highlight: ADO.Net data provider

Module 05: Loading a Dimensional Model using SQL Server Integration Services

Slowly Changing Dimension Concept
Highlight: Slowly Changing Dimension Transform
Loading Date Dimension
Load Fact Tables
Highlight: Lookup transform and persistent cache

Module 06: Deploying SQL Server Integration Services Packages

Deployment locations and options
Scheduling a package

Module 07: Introduction to the Unified Dimensional Model (UDM)

Intro to OLAP Fundamentals
The UDM and Benefits
Analysis Services Fundamentals
Basic Components of the UDM: Data Sources, Data Source Views, Cubes, Dimensions
Components of a SQL Server Analysis Services Database
Building a basic cube
Deployment and processing

Module 08: Customizing the UDM

Introduction to the SSAS designer
New design features in SSAS 2008
Dimension customization: Dimension properties, attributes and hierarchies
Cube customization: Cubes, measure groups, measures
Advanced SSAS database components: Dimension relationships, Calculations, KPI's,
Review of the best practices
Highlight: Designer improvements, Best Practices Warnings, and Attribute Relationship Designer

Module 09: Deployment, Management and Optimization

Storage Modes
Scale-out deployment options
Data processing optimization techniques
Aggregation design
Backup Improvements
Scaling out with Shared Databases

Module 10: Managing SSAS using SSIS

Accessing data from the UDM
Interacting with and managing SSAS objects
Data Processing options

Module 11: Introduction to Data Mining

Data Mining Process
Data Mining Algorithms
Changes in SQL Server 2008
Data Mining add-ins in Excel 2007

Module 12: Introduction to SQL Server Reporting Services

SSRS 2008
SSRS Architecture and Components
What's new in SSRS 2008 Architecture
Report Components
What's new in SSRS 2008 Report Components

Module 13: Designing Reports in SQL Server Reporting Services

SSRS 2008 Designer
What's New in SSRS 2008 for Report design
Report Queries and Parameters
Report layout and customization
Report Interactivity
Charts and Graphs
Extending Report Functionality

Module 14: Publishing, Accessing and Managing Reports

Report deployment options
Report deployment architectural scenarios (Scalable deployment)
Mechanisms for accessing reports
Processing and rendering architecture
Memory usage management
What's New in SSRS 2008 Rendering Architecture

Module 15: Advanced Reporting against the UDM

Report Designer as an end-user tool
Creating and Deploying Report Models
Ad-hoc Reporting using Report Builder Client
Reporting with Microsoft Office Excel 2007
Other Reporting and Delivery Mechanisms

Dr Mark Whitehorn

Mentor with Solid Quality Mentors, specializes in the areas of data analysis, data modelling, data warehousing and business intelligence (BI). He also works as a consultant for a number of national and international companies, designing databases and BI systems. He was invited by Microsoft to help define the role of BI architect. This definition was captured as a USD (Unified Skills Domain). Marks database column in Personal Computer World has been running for 15 years, his BI column in Server Management magazine for five. He has written eleven books on database and BI technology.

For yderligere information kontakt
Produktansvarlig, Mette Hougaard Holm
Email: mette.holm@teknologisk.dk

Godkendt: 22. juni 2010