Data Analysis with Microsoft SQL Report Builder Training

• 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.

At the end of this course you will be able 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.

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