SQL Server Business Intelligence Overview
Introduction to Integration Services, Reporting Services, and Analysis Services
Authored by:
Bret Stateham
,
et al.
Duration: 3h 47m
Level: Beginner
Released: 5/10/2010
Duration: 3h 47m
Level: Beginner
Released: 5/10/2010
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using: {{getCurrentPlayerName()}} [Change]
| expand all | collapse all | Progress | Duration | |
|---|---|---|---|
SQL Server Integration Services |
|
01:35:47 | |
|
Introduction
|
|
02:48 | |
|
Overview
|
|
01:49 | |
|
Package
|
|
01:28 | |
|
Package Example
|
|
06:23 | |
|
Control Flow
|
|
01:20 | |
|
Control Flow Example
|
|
13:25 | |
|
Parallel Control Flow example
|
|
08:37 | |
|
Loop example
|
|
12:31 | |
|
Data Flow
|
|
00:59 | |
|
Data Flow Source
|
|
01:02 | |
|
Data Flow Source example
|
|
17:15 | |
|
Data Flow Transform
|
|
01:14 | |
|
Transform Example
|
|
14:26 | |
|
Package Deployment
|
|
01:07 | |
|
Deploy and Run example
|
|
07:39 | |
|
Summary
|
|
03:44 | |
SQL Server Reporting Services |
|
00:57:51 | |
|
Introduction
|
|
00:28 | |
|
What is SSRS?
|
|
03:54 | |
|
Sample Reports
|
|
01:02 | |
|
Features
|
|
02:37 | |
|
Server Components
|
|
04:55 | |
|
Client Components
|
|
01:42 | |
|
Report Wizard
|
|
11:13 | |
|
Control Properties
|
|
03:52 | |
|
Report Data Window
|
|
02:53 | |
|
The Toolbox
|
|
02:05 | |
|
TextBox Controls and Expressions
|
|
05:04 | |
|
Tables and Grouping
|
|
10:02 | |
|
Using Parameters
|
|
06:40 | |
|
Summary
|
|
01:24 | |
SQL Server Analysis Services |
|
00:59:24 | |
|
Introduction
|
|
01:22 | |
|
Defining OLTP
|
|
03:08 | |
|
Defining OLAP
|
|
01:41 | |
|
The Data Warehouse
|
|
01:07 | |
|
Star Schema
|
|
01:40 | |
|
Multi-Dimension Concepts
|
|
01:13 | |
|
Understanding Dimensions
|
|
00:31 | |
|
Members, Levels and Hierarchies
|
|
01:16 | |
|
Measures and Aggregates
|
|
02:03 | |
|
SQL Server Analysis Services
|
|
01:52 | |
|
System Roles and Workflow
|
|
02:22 | |
|
Creating an Analysis Services Project
|
|
01:27 | |
|
Creating a Data Source
|
|
02:15 | |
|
Creating a Data Source View
|
|
01:18 | |
|
Customizing the Data Source View
|
|
02:52 | |
|
Creating Name Queries
|
|
02:02 | |
|
Creating the Customer Dimension
|
|
03:57 | |
|
The Product and Date Dimensions
|
|
01:43 | |
|
Creating the Cube
|
|
03:22 | |
|
Deployment and Processing
|
|
01:48 | |
|
Verifying Deployment
|
|
00:33 | |
|
Browsing the Cube
|
|
01:52 | |
|
SSAS Clients
|
|
02:56 | |
|
Querying from Excel
|
|
02:18 | |
|
Querying from SSRS
|
|
04:53 | |
|
Querying with ADOMD.NET
|
|
07:05 | |
|
SUmmary
|
|
00:48 | |
SQL Server Integration Services Precedence Constraints |
|
00:14:53 | |
|
SSIS Precedence Constraints
|
|
14:53 |
SQL Server Integration Services