課程大綱： Developing in SQL Server Business Intelligence培訓
Module 1: Introduction to SQL Server Reporting Services – SSRS
Overview of SSRS
Installing Reporting Services
The Reporting Lifecycle
Highlights of Reporting Services
Reporting Services Scenarios
Reporting Services Developer Tools
Module 2: Authoring Basic Reports
Creating a Basic Table Report
Report Definition Language
Accessing Data
Formatting Report Pages
Headers and Footers
Calculating Values
Common Aggregate Functions
Module 3: Enhancing Reports
Interactive Navigation
Use Show/Hide to Provide Drill-Down Interactivity
Navigate From Report To Report Using Links
Working with Data Regions
Using Report Manager
Distribute and Manage Published Reports
Module 4: Introduction to SQL Server Integration Services – SSIS
What Is SSIS?
When to Use SSIS?
SSIS Architecture
Integration Services Scenarios
Integration Services Developer Tools
Control Flow and Design Flow Design Surfaces
Migrating data across Excel, Flat Files, XML and database providers
Adding Tasks to a Package
Module 5: SSIS Going Further
Building a Package
Troubleshooting a Package
Deploying a Package to the SSIS Server
Scheduling a Package with SQL Server Agent
Securing a Package in Management Studio
Using Variables, Event Handlers and Configurations
Module 6: Introduction to SQL Server Analysis Services – SSAS
What Is SSAS?
When to Use SSAS
SSAS Architecture
Analysis Services Tools
Understanding Fact and Dimension tables
Module 7: SSAS Going Further
Creating an Analysis Services Project in Visual Studio
Fact and Dimension Tables
Creating a Data Source
Creating a Data Source View
Creating a Cube Object Definition
Deploy Definitions to OLAP Server and Load in Data
Browse a Cube to Query Data
Creating Key Performance Indicators (KPI’s) to Give Meaning to Data
加入高級會員獲得助教答疑
