Developing in SQL Server Business Intelligence Training Course

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