Data Analysis with Microsoft SQL Report Builder Training in Canada

  • Learn via: Classroom
  • Duration: 2 Days
  • Level: Intermediate
  • Price: From €3,419+VAT
We can host this training at your preferred location. Contact us!

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.

  • 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


Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Canada facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
19 May 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
02 June 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
17 June 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
19 July 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
08 August 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
18 August 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
12 September 2024
Toronto, Montreal, Calgary
2 Days
Classroom / Virtual Classroom
20 October 2024
Toronto, Montreal, Calgary
2 Days

Related Trainings

Data Analysis with Microsoft SQL Report Builder Training Course in Canada

Canada is a North American country. Known as the second-largest country of the world, Canada’s capital city is Ottawa. Toronto, Vancouver and Montreal are the biggest and most popular cities of this country. The 8,891-kilometer southern and western border between Canada and the United States is the world's longest intergovernmental land border. This country also has the longest coastline in the world.

Canada is a constitutional monarchy. The country was originally a British Empire colony and is now a part of the British Commonwealth. Both French and English are Canada’s official languages. Canada’s national animal is a beaver and the its flag design is a vertical triband of red and white with a red maple leaf charged in the centre. Some of the top-rated tourist attractions in Canada are Niagara Falls, Banff National Park and Rocky Mountains, CN Tower in Toronto City, Bay of Fundy, Old Quebec (Vieux-Quebec in French), the ski resort of Whistler, Ottawa's Parliament Hill and Vancouver Island.

Choose from our extensive selection of IT courses, covering programming, data analytics, software development, business skills, cloud computing, cybersecurity, project management. Our highly skilled instructors will deliver hands-on training and valuable insights at a location of your choice within Canada.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.