Report Builder 3 can be used to create reports for SQL Server 2008 R2 and newer, including Power BI Report Builder.

This course provides the skills for delegates to create reports using Report Builder 3

Course Outline

•  Introduction
  • What it looks like.
  • Where everything is.
  • How easy it is to create reports.
• Connecting to Data
  • Types of data sources.
  • Shared Data Sources.
  • Report specific data sources.
  • Data source credentials.
• Retrieving Data
  • Data Sets.
  • Query Designer.
  • Stored Procedures.
• Designing Reports
  • Report and page properties
  • Headers & Footers.
  • Data regions.
  • Matrices.
  • Lists.
  • Charts.
  • Gauges.
  • Maps.
  • Other Report Items.
  • Text boxes.
  • Sub reports.
  • Formatting report items.
• Manipulating Data Sets
  • Sorting data.
  • Grouping Data.
  • Using parameters with your data.
  • Creating and using parameters in your data.
  • Setting default values for parameters.
  • Creating parameter lists.
  • Calculations.
  • Filters.
• Enhancing Basic Reports
  • Report item visibility.
  • Interactive sorting.
  • Expressions.
  • To display report information & parameters values.
  • To highlight exceptions in data.
  • To stripe data rows.
  • Document maps.
• Saving, Sharing and Printing Reports
  • Saving local reports.
  • Sharing reports.
  • To a report server.
  • To a SharePoint site.
  • Viewing, printing and exporting reports from a report server or SharePoint.
  • Creating report subscriptions

Duration

• This course can be completed in 2 days just using examples from the sample Adventure Works Database.
• By extending it to 3 days, delegates can practice their skills using their own data