Business Intelligence with SQL Server Reporting Services

  • 5h 51m
  • Adam Aspin
  • Apress
  • 2015

Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines, indicators, and maps into compelling dashboards and scorecards. Create compelling visualizations that seize your audience’s attention and help business users identify and react swiftly to changing business conditions. Best of all, you'll do all these things by creating new value from software that is already installed and paid for – SQL Server and the included SQL Server Reporting Services.

Businesses run on numbers, and good business intelligence systems make the critical numbers immediately and conveniently accessible. Business users want access to key performance indicators in the office, at the beach, and while riding the subway home after a day's work. Business Intelligence with SQL Server Reporting Services helps you meet these need for anywhere/anytime access by including chapters specifically showing how to deliver on modern devices such as smart phones and tablets. You'll learn to deliver the same information, with similar look-and-feel, across the entire range of devices used in business today.

  • Key performance indicators give fast notification of business unit performance
  • Polished dashboards deliver essential metrics and strategic comparisons
  • Visually arresting output on multiple devices focuses attention

What you’ll learn

  • Produce designer dashboards which will wow your audience.
  • Mix and match relational, cube, and tabular data to drive BI.
  • Integrate gauges, maps, charts, and text to deliver targeted information.
  • Enhance SSRS interactivity to provide a more intuitive interface.
  • Adapt delivery to mobile devices such as phones and tablets.
  • Standardize presentation across the entire portal.

Who this book is for

Business Intelligence with SQL Server Reporting Services is written for Business Intelligence developers wanting to implement portals providing key performance indicators across the range of desktop and mobile devices used in business today. The book is ideal for readers having a basic knowledge of SQL Server Reporting Services, who want to step up and increase the value their business receives from it's investment in Microsoft's SQL Server ecosystem.

About the Author

Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for seventeen years, and Business Intelligence has been his principal focus for the last ten years. He has applied his skills for a range of clients, including J.P. Morgan, The Organisation for Economic Co-operation and Development (OECD), Tesco, Centrica, Harrods, Vodafone, Crédit Agricole, Cartier, Alfred Dunhill, The RAC and EMC Conchango.

Adam is a graduate of Oxford University. He is a frequent contributor to 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 2012 Data Integration Recipes (Apress, 2012), and of High Impact Data Visualization with Power View Power Map, and Power BI (Apress, 2014).

In this Book

  • SQL Server Reporting Services as a Business Intelligence Platform
  • KPIs and Scorecards
  • Gauges for Business Intelligence
  • Charts for Business Intelligence
  • Maps in Business Intelligence
  • Images in Business Intelligence
  • Assembling Dashboards and Presentations
  • Interface Enhancements for Business Intelligence Delivery
  • Interface Enhancements
  • BI for SSRS on Tablets and Smartphones
  • Standardizing BI Report Suites
  • Optimizing SSRS for Business Intelligence