Data Analysis with Microsoft SQL Report Builder (v2.0 and v3.0)

2 Day Course
Hands On
Official Microsoft Curriculum
Code QASQLRB08

This course has been retired. Please view currently available Microsoft SQL Server Training Courses.

Modules

Collapse all

Overview of Report Builder

Adding Data Sources and Data Sets (2 topics)

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

Tabular Reports (7 topics)

  • 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

Visualisations (6 topics)

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

Interactivity (3 topics)

  • Add parameters
  • Linked parameters
  • Actions

Report Builder 3.0 features (7 topics)

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

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

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Course PDF

Print

Sections