Microsoft SQL Server 2008 Report Builder 3.0: Data Analysis with Microsoft SQL Server 2008 Report Builder 3.0

Course Overview

This two-day instructor-led course provides students with the knowledge and skills to produce reports using Report Builder. The course focuses on teaching individuals how to use the product features and tools related to data retrieval, visualisations and deployment. This course is intended for end users will produce reports for their department or group.

For enterprise Report Designers the M6236 course may be better suited as it covers report designer within Visual Studio, building report models, security and report server maintenance.

There is no exam or certificaton related to this course.

CourseMonster offers the best available Microsoft training in your area.

Related Courses

• Microsoft SQL Server 2008 New Features: Hands-On
• Microsoft SQL Server 2008 Comprehensive Introduction: Hands-On
• Microsoft SQL Server 2008: Database Administration
• Microsoft SQL Server 2008 Training Course UK: Comprehensive DBA & Programming Upgrade
• Microsoft SQL Server 2008 Analysis & Integration Services (SSAS & SSIS) - (Business Intelligence, BI, Data Warehouse, Mining)
• Microsoft SQL Server 2008 Reporting Services (SSRS) - (Business Intelligence, BI)
• Microsoft SQL Server 2008: Business Intelligence with SQL Server 2008 - (Microsoft, BI, SSRS, SSAS, SSIS, Data Warehouse, Mining)
• Microsoft SQL Server 2008: Maintaining a Microsoft SQL Server 2008 Database
• Microsoft SQL Server 2008 Reporting Services: Hands-On
• Microsoft SQL Server 2008: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Skills Gained

Delegates will learn how to

• Publish reports to a report server
• Create data sources and data sets
• Work with tablix reports
• Work with report visualisations
• Add interactivity to reports
• Use Report Builder v3.0 functionality.

Prerequisites

Before attending this course, students must have:

• Basic knowledge of the Microsoft Windows operating system and its core functionality. (Use windows explorer / internet explorer (i.e. things like find web page , create a folder); Login (CTRL+ALT+DELETE); Use a mouse, start menu etc.)
• Knowledge of Transact-SQL and MDX queries would be an advantage but not essential.

In addition, it would be an advantage if delegates had attended either of the following courses:

• M50027 Querying and Processing SQL Server 2005 Data with SQL Statements
• M2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Course Outline

Module 1 : Overview of Report Builder

Module 2 : Adding data sources and data sets

• Use various data sources and data sets including TSQL and MDX
• Set source connection and credentials

Module 3 : Tabular Reports

• Set page and report settings
• Review the different tabular report data regions (table, matrix and list)
• Set textbox properties such as number formatting
• Set table sorting and interactive sorting
• Add groups to columns and rows
• Add a document map
• Add interactivity with expand and collapse using hide and show

Module 4 : Visualisations

• Review chart types available
• Add visualisations to a report
• Chart
• Gauge
• Subreport
• Images

Module 5 : Interactivity

• Add parameters
• Linked parameters
• Actions

Module 6 : Report Builder 3.0 features

• Add maps
• New Visualisations
• Sparklines
• Data bars
• Indicators
• Shared data sets
• Report parts

 

Microsoft SQL Server 2008 Report Builder 3.0: Data Analysis with Microsoft SQL Server 2008 Report Builder 3.0 / SQLRB08

Request availability or enquire by clicking a date: