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 using the Microsoft BI Stack
BI Tips and Tricks with SQL Server Reporting Services
Impress the boss and your colleagues by delivering Dashboards, KPIS, maps and Scorecards wrapped in a tablet-ready interface with SSRS
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
- Enhanced interactivity
- Tablet and SmartPhone output
- 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.
- 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.
- 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.