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

• Creating a Basic Table Report
• Report Definition Language
• Accessing Data
• Formatting Report Pages
• Headers and Footers
• Calculating Values
• Common Aggregate Functions

• 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

• 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

• 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

• What Is SSAS?
• When to Use SSAS
• SSAS Architecture
• Analysis Services Tools
• Understanding Fact and Dimension tables

• 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