Course Outline
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
Requirements
Before attending this course, students must have:
- Understanding of relational database concepts
- Experience of querying a relational database
- Fundamental understanding of reporting and analysis
Testimonials (5)
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
database optimization, dedicated approach, ability to ask questions, insight/assessment of our database
Aleksandra Czyndacka - Mikrobit
Course - Administering in Microsoft SQL Server
Machine Translated
i really liked the pace of the training, and the exercises given inbetween the explanations
Trana
Course - SQL in SQL Server
Really enjoyed compression data components
James - Medtech Limited
Course - Transact SQL Advanced
Lot of content and exactly the requested one.