SQL Server Report Builder Course
Short course
Online
Description
-
Type
Short course
-
Level
Beginner
-
Methodology
Online
-
Duration
2 Days
Are you ready to separate yourself from the crowd by learning how to use MS SQL Server Report Builder? With the course SQL Server Report Builder Course offered by Emagister and imparted by PCWorkshops you’ll be set!
What makes this course exceptional is its lessons in MS SQL SSRS, which is a report builder especially good, that gives you a user-friendly visual interface to create a report and most importantly, very easy to learn!
The program focuses on making reports with this program, including its features and different tools regarding data retrieval, visualizations and deployment. At the beginning you’ll learn about report models and how data source is composed, also, creating tables and displaying them into groups: expanding and collapsing them.
Furthermore, you’ll get in touch with matrices, charts and expression builder. Exporting reports and how to keep them all updated and published properly.
This programme includes a SSRS Course certificate, including the notes, practical exercises, revisions of your work and also coffee and tea. In order to prepare you for the certification, you’ll have one free session via Skype or TeamViewer for questions online. (Maximum groups of 4 students).
So, if you want to learn more, don’t hesitate to contact PCWorkshops through Emagister
Facilities
Location
Start date
Start date
About this course
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.
End-users who will produce reports for their department or group without in-depth SQL knowledge.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Server
- SQL
- Builder
- Visualisation
- Reports
- Conditional Formatting
- Charts
- Data Analytics
- Graphical Indicators
- Data Retrieval
Teachers and trainers (1)
Sarah Barnard
Coder, Instructor
Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.
Course programme
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 Report Items collection
- Built-in fields
- Conditional formatting expressions
- 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
Read more:
https://pcworkshopslondon.co.uk/sql-server-report-report-builder.html
SQL Server Report Builder Course