BI Tips and Tricks with SQL Server Reporting Services

Corporate Business Intelligence does not have to be long and boring lists. Nor need it be usurped by smoke and mirrors solutions which lure IT departments into complex, unsuitable and expensive presentation layers for enterprise data. Most IT departments already have in place a powerful solution which they might not be using to its full potential – SQL Server Reporting Services. This session explains how to push SSRS to a new level and deliver:
  • Compelling Dashboards
  • Arresting KPIs
  • Stunning gauges
  • Descriptive Scorecards
  • Maps
  • Enhanced interactivity
  • Tablet and SmartPhone output
Delivering reports which can rival the output of competitive products does not require anything other than an appreciation of a series of tips and tricks which extend your SSRS knowledge and current skills. This session will teach you how to:
  • Extend the use of parameters in new and unexpected ways.
  • Push SSRS functions to their limits.
  • Use Images to powerful effect.
  • Use tables in ways you never imagined possible to align and present data, sparklines and trends.
  • Control positioning and layout using little-known options and properties.
Then you will see how revamp the SSRS interface to create:
  • Touch-enabled buttons and tabs to create reports better adapted to tablets and smartphones.
  • “Power-View” styling for a more modern look and feel.
  • Imitate popup menus in an SSRS report.
Finally you will see a few essential data techniques to:
  • Create reusable functions to calculate and return maximum values for gauges.
  • Link datasets.
  • Cache datasets.
  • Link an SSAS server to return data to T-SQL complex queries.
  • Page data sets.
Presented by Adam Aspin at SQLBits XII
  • Downloads
    Slide deck available Slide Deck 968 KB
    Video available MP4 Video HD 518 MB
  • SpeakerBIO

    Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for twenty years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft BI product suite.

    A graduate of Oxford University, Adam began his career in publishing before moving into IT. Databases soon became a passion, and his experience in this arena ranges from dBase to Oracle, and Access to MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe when using SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services and Power BI.

    Business Intelligence has been his principal focus for the last fifteen years. He has applied his skills for a range of clients in Banking, Finance, Insurance, Retail and Utilities.

    Adam has been a frequent contributor to for several years. He has written numerous articles for various French IT publications. A fluent French speaker, Adam has worked in France and Switzerland for many years. He is the author of “SQL Server Data Integration Recipes” – Apress, November 2012, "High Impact Data Visualization with Power View, Power Map, and Power BI"– Apress, June 2014, "Business Intelligence with SQL Server Reporting Services" - Apress February 2015 and "Pro Power BI Desktop" - Apress April 2016

  • Video