Microsoft Report Builder

Course Overview

This course is built to give delegates the comprehensive skills and in-depth knowledge needed to analyse and access information using Report Builder and pre-built Data Cubes.

In this course delegates will learn how to create documents for their reporting needs, to retrieve data by building queries against the cube, and edit reports that may have already been written. Delegates will also learn how to analyse and share the data that they have with others.

Not sure whether this is the right Microsoft training course for you? For a more advanced search, click on our course category page

Related Courses

• Microsoft Systems Management Server 2003 (SMS): Managing
• Microsoft Systems Management Server 2003 (SMS): Planning and Deploying
• Microsoft: Designing Security for Microsoft Networks
• Microsoft: Introduction to Programming (3 day)
• Virtualisation Technologies: Deploying VMware and Microsoft Virtual Machines (VM) Technologies: Hands on Introduction
• Microsoft SoftGrid Application Virtualization
• Microsoft: Introduction to Microsoft Tools (SQL Server, Excel SharePoint) for Business Intelligence: Hands-On
• Microsoft Windows Small Business Server 2008: Implementing and Administering Microsoft Windows Small Business Server 2008
• Microsoft MCITP Server and Enterprise Administrator Combo Boot Camp
• Microsoft Certified IT Professional (MCITP): Server Enterprise Administrator Upgrade Boot Camp

Audience

This course is designed for delegates who design and build reports, and who need to access and analyse information as part of their job role

Skills Gained

Delegates will be able to

• Design their own reports using Report Builder as well as sharing their own analysis with other users.
• How to organise, manage and distribute reports.

Prerequisites

There are no pre-requisites for this course

Course Outline

Introducing 'Cubes' and Report Builder

• What is a cube?
• What is Report Builder?
• Understanding Report Builder core functionality

Connecting to your data

• How to connect to a cube and other data sources

Working with your data

• Designing a query
• Adding parameters to your report
• Filtering data
• Using the wizard to create a report

Adding value to your report

• Adding formatting
• Applying sorting
• Adding different visualisation to display your data e.g. graphs, gauges
• Adding other report items e.g. Databars, Sparklines, Indicators
• Adding conditional formatting
• Grouping and sorting data
• Creating calculated members to display custom calculations

Modifying existing reports

• Editing a query
• Adding fields to a table
• Modifying parameters
• Adding default values to parameters
• Creating drill through actions to other existing reports

Publishing and Managing Reports

• Publishing, viewing and managing reports on a report server
• Publishing, viewing and managing reports in SharePoint

Exporting reports

• Altering the page layout of a document
• Understanding rendering behaviours
• Exporting to multiple file formats e.g. Word, Excel, .pdf, .csv
• Printing reports