Highlights
- Gain an understanding of SQL Server Reporting Services (SSRS)
- Learn how to maximise the powerful and integrated SSRS capabilities
- Retrieve your corporate data with SSRS to gain a competitive advantage
- Create Business Intelligence (BI) reports
- Deploy BI reports
- Manage BI reports
- Optional days - explore SSRS more broadly and in more depth
Course Details
SSRS Fundamentals
- SSRS overview
- Reporting Services
- Report Server
- Report Designer
- Report Builder
- Report Manager
Designing reports – fundamentals
- Report Wizard in SSDT-BI (aka BIDS/Visual Studio)
- SQL relational reports
- Tablixes (tables and matrixes)
Previewing reports
Deploying reports to Report Manager
Designing reports – further techniques
- 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
- Multiple reports
- Drilldown versus drillthrough
- Subreports
- Jump reports
- Linked reports
Administration
- Reporting Services Configuration Manager
- Report caching
- Report snapshots
- Report subscriptions (emailing reports)
- Security overview
Who should attend
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.
Feedback
4.8 out of 5 average
"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"
Brian Leek, Data Analyst, May 2022
“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”
Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022
