/

Data Analysis using Microsoft SQL Report Builder

PCWorkshops
(4.8)17 reviews
Recent reviews of this course provider

Pivot tables in 45 minutes

Excellent course. My teacher Sarah was really good and took me through how to cr...more

See all reviews
Add to shortlistShortlisted by 14 people

https://www.hotcourses.com/courses-by-subject/Data-Analysis-using-Microsoft-SQL-Report-Builder-courses/56250568/

Course description

Data Analysis using Microsoft SQL Report Builder:

This course focus on producing reports using MS SQL Server Report Builder 3.0 : how to use the product features and tools related to data retrieval, visualisations and deployment.
The Target Audience: end-users who will produce reports for their department or group without in-depth SQL knowledge.

MS SQL Server Report Builder 3.0 gives you a user-friendly visual interface to create report.

Course Outline

Report Models

  • Data source views
  • Creating a model
  • Entities, attributes and roles

Tables

  • Creating tables
  • Interactive sorting
  • Floating headers

Grouping

  • Inserting groups
  • Group headers/footers
  • Displaying group totals
  • Expanding and collapsing

Expressions

  • The expression builder
  • The ReportItems collection
  • Built-in fields
  • Conditional formatting expressions

Page set-up

  • Page headers and footers
  • Page names and numbers

Exporting reports

  • The various report formats
  • Using RenderFormat.Name

Parameters

  • Creating parameters
  • Filtering using parameters
  • Drop list parameters
  • Coping with empty tables

Matrices

  • Row and column groups
  • Sorting and filtering matrices
  • Creating subtotals

Charts

  • Creating charts
  • The parts of a chart
  • Formatting charts

Basic reports

  • Text boxes and images
  • Selecting report items
  • Formatting parts of a report

Miniature charts

  • Creating sparklines
  • Creating data bars

Graphical indicators

  • Creating and customising indicators
  • Linear and radial gauges

Lists

  • Page-per-record lists
  • Dashboard lists
  • Other list ideas

Subreports

  • Creating a child report
  • Creating the main report
  • Linking the two reports

Report parts

  • Publishing report parts
  • The report part gallery
  • Updating report parts

Additional entry requirements

SQL 1-Day or SQL 3-Day course or knowledge of SQL

Training for employers

This course has been specifically designed for companies training their employees.

Course info
342 views
Start Date: Thu 19th September 2019
START DATES
SEPTEMBER 2019
Sun Mon Tue Wed Thu Fri Sat
OCTOBER 2019
Sun Mon Tue Wed Thu Fri Sat

Location:

Manchester, M1 5AN, Southend-On-Sea, SS1 1NE, Milton Keynes, MK9 2UB, London, WC2N 4JF

Time:

11:00am - 6:00pm

Duration:

2 Days, 2 days

Attendance:

Full time

Qualification:

Certificate of Attendance

Level:

Beginner IntermediateAdvanced

From: £750

Summary of all course reviews for PCWorkshops

17 reviews

(94%)
(6%)

Average student ranking

Reviews of other courses at PCWorkshops

pcworkshops

Pivot tables in 45 minutes
5 5
Hotcourses
December 2017

Excellent course. My teacher Sarah was really good and took me through how to create pivot tables step by step. She made it simple and straightforward. I can now create a pivot table with confidence. You also get a certificate of attendance. I would highly recommend this course to a friend. Sharmini Shanthakumar

Was this review helpful? Yes No
3 Hotcourses user(s) found the following review helpful.

pcworkshops

Java taster
5 5
Hotcourses
by Rahul - December 2017

Sarah is an excellent mentor . She taught me well in such a short span of time and gave sufficient material to get a feeling of programming in Java. Thanks!! Rahul

Was this review helpful? Yes No
3 Hotcourses user(s) found the following review helpful.

Please note reviews of Java Programming "Taster" Course, 1 Day are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Data Analysis using Microsoft SQL Report Builder by PCWorkshops on Hotcourses
Add to shortlist

You might like...

Others viewed...