Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Microsoft Report Builder

( Duration: 2 Days )

This Microsoft Report Builder training course provides an introduction to creating useful reports on varied datasets using Microsoft Report Builder. Report Builder is a tool designed for data analysts who need to create and publish engaging business reporting solutions built upon SQL Server Reporting Services, who do not necessarily wish to use Microsoft Business Intelligence Development Studio (BIDS) - which is itself based on Visual Studio. In this course, you will gain valuable hands-on experience delivering commercial-quality report solutions.

By attending Microsoft Report Builder workshop, delegates will learn:

  • Utilize Report Builder Wizards
  • Create an embedded data source
  • Create an embedded data set
  • Create shared data sources and data sets
  • Use report parameters
  • Use report expressions
  • Create report gauges
  • Use images in reports
  • Use report lists
  • Use report tables
  • Use the matrix
  • Create sub reports
  • Use report parts
  • Create interactive reports

  • Experience manipulating and presenting data within Microsoft Excel and / or Microsoft Access. Practical knowledge of SQL would be useful too. Other equivalent Relational Database experience (such as Oracle, MySQL) should also be sufficient.

  • The Microsoft Report Builder class is intended for Power Users, Developers and IT Professionals who will be involved with the design, development and maintenance of reports created with Report Builder.

COURSE AGENDA

1

Introduction to Report Builder

  • Getting to know Report Builder
  • Overview of tools and functions
2

Connecting to Data

  • Types of Data Sources
  • Shared Data Sources
  • Report-specific Data Sources
  • Data Source credentials
3

Retrieving Data

  • Data Sets
  • Query Designer
  • Stored Procedures
4

Designing Reports

  • Report and page properties
  • Headers and Footers
  • Data regions
  • Matrices
  • Lists
  • Charts
  • Gauges
  • Maps
  • Other Report Items
  • Text boxes
  • Sub Reports
  • Formatting Report items
5

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
6

Enhancing Basic Reports

  • Report item visibility
  • Interactive sorting
  • Expressions
  • Display Report information and parameters
  • Values
  • Highlighting Exceptions in Data
  • To stripe Data rows
  • Document maps
7

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X