EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE
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.
Report Wizard in SSDT-BI (aka BIDS/Visual Studio)
SQL relational reports
Tablixes (tables and matrixes)
Deploying reports to Report Manager
Formatting (including dates and currency)
Conditional formatting (and green-band reporting)
KPIs for SSRS 2008 and earlier (optional)
KPIs for SSRS 2014/2012/2008 R2 (and data bars)
Grouping and drilldown
Grand totals, subtotals, and running totals
Charts and gauges
Parameterized SQL reports
Exporting reports to Excel or PDF
Report templates with global parameters
Drilldown versus drillthrough
Reporting Services Configuration Manager
Report subscriptions (emailing reports)
SSRS with BI overview
SQL relational reports (5-minute revision of day 1 topic)
MDX multidimensional cube reports
DAX tabular model reports
DMX data mining reports (overview)
Parameterized SSRS reports with BI
Parameterized SQL reports with stored procedures
Parameterized MDX reports
Parameterized DAX reports
Parameterized DMX reports (overview)
Date parameters and calendar controls with SQL reports
Date parameters and calendar controls with MDX reports
Common business solutions
Hand-rolling MDX reports
Hand-rolling DAX reports
MDX queries on multidimensional cubes and tabular models
DAX queries on multidimensional cubes and tabular models (also DAX queries in Excel 2013)
Period-on-period changes (in both MDX and DAX reports)
Period-to-date totals (in both MDX and DAX reports)
Percentage of grand total (in both MDX and DAX reports)
Percentage of parent total (in both MDX and DAX reports)
Moving averages (in both MDX and DAX reports)
Dynamic up-to-today reports (in both MDX and DAX reports)
SSRS alternatives to Report Manager
SSRS SharePoint 2013/2010 integration
Deploying reports to SharePoint 2013/2010
SSRS Report Viewer and creating a customized web site
SSRS Report Viewer and creating a C# or VB.NET Winform application
SSRS Power View in Excel 2013
SSRS Power View in SharePoint 2013
Alternative visualizations to SSRS
Power Pivot in Excel 2013/2010
SSRS into Power Pivot
Power Pivot into SSRS
Excel pivot tables on Power Pivot tabular models
Excel pivot tables on SSAS tabular models
Excel pivot tables on SSAS multidimensional cubes
Power Pivot gallery in SharePoint
Power Map (overview)
Power Query (overview)
PowerPoint slide shows with Power View reports (overview)
PerformancePoint dashboard reports (embedded SSRS reports and Excel pivot tables)
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
Get in touch
0800 028 6400
This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....
Over many years the members of this Software Engineering team have developed web applications using the popular .NET technology of ASP.NET WebForms....
A team of existing C++ Developers needed to bring its skills right up to date in order to ensure that they were making the most of new features...
Our inspiring and up-to-date courses gain exceptional feedback
"great tips to help reduce build times"
"we got access to exclusive content"
"intensive course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"
Traditionally Cyber security has been associated mainly with penetrating networks and infrastructure. Now a more subtle level of attack needs...
Back in March 2014, the Angular team dropped a bomb by announcing Angular 2 and everyone started yelling. Instead of an evolutionary step forward,...
MVC The Model View Controller (MVC) architectural pattern has a long history (together with its variants) and has been used in many languages...