• Authored Course

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

Learn via: Classroom / Attend from Anywhere
  • Duration: 2 Days
  • Code: QASQLRB08
  • Tech Type: Performance Plus
  • Full Details

Price: £1759

Dates and Locations

About this Course

This two-day instructor-led course provides delegates 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.

Please note - This course covers Report Builder 2.0 and 3.0, for SQL Server 2008 R2 and 2012.

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.

Target Audience

This course is intended for end users who will produce reports for their department or group.

Learn from the UK's leading Microsoft training provider

  • Comprehensive curriculum

    We deliver over 20,000 Microsoft training courses in the UK each year

  • Experienced experts

    Our first-class learning specialists all have a minimum of 5 years training experience

  • Superb satisfaction scores

    99% of our delegates are satisfied with their Microsoft course

  • Trusted training

    We are the largest Microsoft Gold Learning Partner in the UK

  • Microsoft Partner Gold Learning

Why people choose QA

Locations

There are over 20 QA learning centres and many other sites spread across the UK, providing a convenient choice of learning locations and ensuring that over 90% of the population is within 45 minutes of a training destination. Learn more

  • London

    London

    International House

  • Manchester

    Manchester

    Oxford Street

Delegate portal

Booking courses with QA has always been easy, but now we've made it even easier. With myQA you can book, administer and manage all your bookings online, in one place. Login / sign-up

Detailed Information

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

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

Microsoft
Microsoft Certifications

Take the next step in your career by achieving certification in Microsoft Technologies.

Microsoft Azure
Microsoft Azure

Master Azure with QA, the 2015 Microsoft Worldwide Learning Partner of the Year.

Windows Server
Windows Server 2016

Learn to efficiently manage corporate IT infrastructures with Windows Server 2016.

MOC on Demand

Delivers Microsoft Official Curriculum (MOC) courses online straight to your device.