Contact Us info@learnquest.com

??WelcomeName??
??WelcomeName??
photo

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.

title

Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014

Course content updated by LearnQuest
Price
590 USD
2 Days
MOC-55005
Classroom Training, Online Training
Microsoft
Prices reflect a 22.5% discount for IBM employees.
Prices shown are the special AWS Partner Prices.
Prices reflect the Capgemini employee discount.
Prices reflect the UPS employee discount.
Prices reflect the ??democompanyname?? employee discount.
GSA Private/Onsite Price: ??gsa-private-price??
For GSA pricing, please go to GSA Advantage.
This course is eligible for the IBM Full Access Training Pass
Enroll today and save 10% on this course. Use promo code CLOUD10 when registering.
Working on a laptop
Gain access to IBM’s library of digital, on-demand courses for one low annual subscription fee
IBM Full Access Training Pass
$500 off any IBM Full Access Training Pass Option
See Offer
Get a 30% Discount on IBM Self-Paced Courses
See Offer

Class Schedule

Delivery Formats

Sort results

Filter Classes

Guaranteed to Run

Modality

Location

Language

Date

    Sorry, there are no public classes currently scheduled in your country.

    Please complete this form, and a Training Advisor will be in touch with you shortly to address your training needs.

View Global Schedule

Course Description

Overview

This instructor-led course provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL Express 2012 and SQL 2012 Standard and Enterprise so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.
 

Objectives

This instructor-led course provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL 2012, and SQL 2014 Standard and Enterprise, so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.

The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters, a detailed section exploring report expressions and how to properly configure them, filters, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts, subreports, subscriptions, and exporting options.


 

Audience

This course is intended for power users, developers, and IT professionals that will be involved with the design, development, and maintenance of reports created with Report Builder 3.0.


 

Prerequisites

    • A basic understanding of relational databases.

     

Topics

Course OutlineModule 1: Course OverviewThis module explains how the class will be structured and introduces course materials and additional administrative information.Lessons
  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
Lab : Course Overview
  • None
  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.
Module 2: Introduction to Report Builder 3.0This module introduces the interface of Report Builder 3.0, the different features available, and variances in data sources and datasets.Lessons
  • Planning Your Reports
  • Understanding Variances Between SQL Versions
  • Exploring The Report Builder 3.0 Interface
  • Examining Management
  • Utilizing Data Sources
  • Working with Datasets
Lab : Introduction to Report Builder 3.0
  • Explore the Report Builder 3.0 Interface
  • Create an Embedded Data Source into SQL 2014 Engine
  • Create an Embedded Data Source into SQL 2014 Analysis Services
  • Create a Shared Data Source Using the Report Manager
  • Create a Shared Dataset Using the Shared Data Source
  • Plan the reports.
  • Use Report Builder 3.0 and understand the parts of the interface.
  • Launch Report Builder 3.0 from multiple sources.
  • Understand management options.
  • Create embedded data sources and datasets.
  • Create shared data sources and datasets.
Module 3: Report Builder 3.0 WizardsThis module covers report basics exploring lists, matrices, and tables along with the wizards. Data regions will also be explained.Lessons
  • Exploring Table or Matrix Wizard
  • Utilizing Chart Wizard
  • Working with Map Wizard
Lab : Report Builder 3.0 Wizards
  • Create Five Shared Data Sources and Two Shared Datasets
  • Use the Table or Matrix Wizard
  • Use the Chart Wizard
  • Use the Map Wizard
  • Create shared data sources and datasets.
  • Understand and utilize the Table or Matrix Wizard.
  • Understand and utilize the Chart Wizard.
  • Understand and utilize the Map Wizard.
Module 4: Report Builder 3.0 Basic ReportsIn this module we examine parameters, filters, and the expressionable aspect of reports. We also cover formatting options.Lessons
  • Utilizing Lists
  • Using Tables
  • Exploring Matrix
  • Mastering Data Region(s)
  • Examining Parameters
  • Working with Expressions
  • Understanding Report Parts
  • Formatting Reports
Lab : Report Builder 3.0 Basic Reports
  • Creating a Report Using Lists
  • Creating a Report Using Tables
  • Creating a Report Using a Tablix
  • Creating a Report with a Query Parameter
  • Report Parameter with a Shared Dataset
  • Create Parameters Using a Dataset as a Filter
  • Using Expressions in Your Report
  • Creating a Report Using Report Parts
  • Report Formatting
  • Understand and utilize lists.
  • Understand and utilize tables.
  • Understand and utilize matrices.
  • Understand and utilize data regions.
  • Understand and utilize parameters.
  • Understand and utilize expressions.
  • Understand and utilize report parts.
  • Understand and utilize formatting options.
Module 5: Report Builder 3.0 GraphicsThis module is a detailed look at graphics including charts, images, sparklines, data bars, gauges, and Bing maps.Lessons
  • Understanding Visualizations
  • Utilizing Charts
  • Exploring Gauges
  • Examining Maps
Lab : Report Builder 3.0 Graphics
  • Using Sparklines in a Report
  • Report Builder Chart Borders, Titles, and Legends
  • Linear Gauges
  • Basic Maps
  • Basic Maps with Color
  • Understand visualization options.
  • Understand and utilize charts.
  • Understand and utilize sparklines.
  • Understand and utilize gauges.
  • Understand and utilize maps.
Module 6: Intermediate ReportingThis module covers intermediate reporting with emphasis on actionable reports, and a section exploring report subscriptions and security.Lessons
  • Filtering, Grouping, and Sorting
  • Utilizing Dynamic Headers and Footers
  • Visualizing Your Company Report Templates
  • Understanding HTML5 and Textboxes
  • Using the List Object to Combine Other Items
  • Creating Subreports and Drillthrough Reports
  • Exploring Subscriptions
  • Examining Security
Lab : Intermediate Reporting
  • Report Header and Footer
  • Creating Report Templates
  • Embedding HTML in a Textbox
  • Lists as Containers
  • Subreports
  • Understand filtering, grouping, and sorting.
  • �Understand and utilize dynamic headers and footers.
  • Understand and utilize report templates.
  • Understand and utilize HTML and texboxes.
  • Understand and utilize lists as containers.
  • Understand and utilize subreports.
  • Understand report subscription options.
  • Understand security.
Module 7: Report Builder 3.0 Tips and TricksThis module is optional and contains 20 tips and tricks with step-by-step instructions.Lessons
  • None
Lab : Report Builder 3.0 Tips and Tricks
  • None
  • Use what they've learned throughout this course.
Additional Reading
  • None

 
2020 Top 20 Training Industry Company - IT Training

Need Help?

Call us toll free at 877-206-0106 or e-mail us at info@learnquest.com

Personalized Solutions

Need a personalized solution for your training? Contact us, and one of our advisors will help you find the best solution to your training needs.

Contact us

Need Help?

Do you have a question about the courses, instruction, or materials covered? Do you need help finding which course is best for you?

Talk to us

Self-Paced Training Info

Learn at your own pace with anytime, anywhere training

  • Same in-demand topics as instructor-led public and private classes.
  • Standalone learning or supplemental reinforcement.
  • e-Learning content varies by course and technology.
  • View the Self-Paced version of this outline and what is included in the SPVC course.
  • Learn more about e-Learning

Course Added To Shopping Cart

bla

bla

bla

bla

bla

bla

Self-Paced Training Terms & Conditions

??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??

Sorry, there are no classes that meet your criteria.

Please contact us to schedule a class.
Nothing yet
here's the message from the cart

To view the cart, you can click "View Cart" on the right side of the heading on each page
Add to cart clicker.

Purchase Information

??elearning-coursenumber?? ??coursename??
View Cart

Need more Information?

Speak with our training specialists to continue your learning journey.

 

Delivery Formats

Close

By submitting this form, I agree to LearnQuest's Terms and Conditions

heres the new schedule
This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.
Your use of this LearnQuest site affirms your consent to our use of session and persistent cookies to track how you use our website.