This Microsoft SQL Server Reporting Services SSRS training course gets delegates to grips with a key part of the Microsoft BI stack, The course covers the discovery and preparation of data, the modelling of the data, and the presentation of the data in insightful and attractive reports and dashboards.
We spend two days looking at Reporting Services (SSRS) and other visualisation tools such as Power BI – when you return to the office, you will easily be able to create wonderful and informative reports and dashboards.
All the work you do is saved and you can take it with you for future reference.
Developers and analysts who need to design and build reports. Administrators who wish to deploy and manage reports. Some basic SQL skills would be an advantage.
SSRS overview
Reporting Services
Report Server
Report Designer
Report Builder
Report Manager
Report Wizard in SSDT-BI (aka BIDS/Visual Studio)
SQL relational reports
Tablixes (tables and matrixes)
Previewing reports
Deploying reports to Report Manager
Formatting (including dates and currency)
Using expressions
Conditional formatting (and green-band reporting)
KPIs for SSRS
Grouping and drilldown
Grand totals, subtotals, and running totals
Interactive sorting
Charts and gauges
Parameterized SQL reports
Exporting reports to Excel or PDF
Report templates with global parameters
Drilldown versus drillthrough
Subreports
Jump reports
Linked reports
Reporting Services Configuration Manager
Report caching
Report snapshots
Report subscriptions (emailing reports)
Security overview
See why people choose JBI
09/01/2018: With the modern expectation for all data to be presented to use in a bright, interactive and engaging format, many businesses are opting for...
08/01/2018: BI is the combination of collecting data, analysing it, and reporting it in a way that is simple to understand. Businesses that make use of BI...
08/01/2018: Microsoft’s Power BI is an analytics tool used to analyse data and share insights. The distinguishing feature of Power BI are the dashboards,...
16/01/2018: Data Analysts at a Government establishment required the ability to respond rapidly to ad-hoc requests for information, including parliamentary...
18/12/2017: The Client A leading developer and manufacturer of sophisticated industrial products, abatement solutions and related value-added services. Their...
31/01/2019: Java is a well-established programming language that has been around since the mid 1990s. It’s used extensively in industry and commerce, and...
PRIVATE COURSES
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
You can customise this course to
suit your exact needs here
0800 028 6400 or request quote
Get in touch
0800 028 6400
Microsoft Business Intelligence 2016
SQL Server Analysis & Int Services
Cube Design
Power BI
Power BI - Beyond the Basics
Power BI - Dax in a Day
Excellent feedback, consistently !
"great tips help reduce build times"
"we got access to exclusive content"
"Short course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe