Modern Reporting with SQL Server 2016 and 2017 Reporting Services [BI]

Speaker: Paul Turley

Duration: Full Day

Track: Design

The 2016 product release was a big upgrade that, once again, brought SSRS into center stage as a market-leading reporting and dashboard design tool for operational and BI reporting.  The big news was that SSRS reports truly run in all modern web browsers and work on mobile devices and all desktops in a new modern web portal.  The introduction of Mobile Reports, formerly known as Datazen, gives mobile device users interactive, tactile and actionable dashboard style reporting on all the popular mobile smartphones and tablets.  The 2017 product brings even more goodness with the integration of Power BI Report Server, on-premises Power BI report integration in a cloud-free platform.  Join Paul for a full-day pre-conference session where you will explore new capabilities and learn to integrate modern reporting into your data platform.

This session covers: 
  • What’s new in Reporting Services 2017 (and 2016)?
  • Reporting Services and Power BI Report Server Architecture
  • Parameter improvements
  • Overview of report solution design general best practices
  • Integrating and managing Power BI on-premises
  • Integrating SSRS with the Power BI service
  • Graphical report design
  • Visualization choices
  • Chart visual types and new visual options
  • Indicators and sparklines
  • Creating dashboard reports
  • Advanced and analytic reporting
  • Advanced design techniques
  • Conditional visibility & drill-down
  • Pagination & flow control
  • Error management
  • Drill-through navigation
  • Query design beyond the basics
  • Reporting with SQL Server and Analysis Services
  • Using the DAX and MDX query editors
  • Analytical and Business intelligence reporting
  • Managing report projects and consolidating reports
  • Upgrading from prior versions of SSRS
  • Framing and integrating reports the easy way
  • Introducing Mobile Reports
  • Multi-device mobile reporting, business cases & scenarios
  • Visual control categories & behavior
  • Mobile reports and parameters
  • Filtering an navigating mobile reports
  • Building mobile report solutions
  • Mobile drillthrough – targeting mobile reports and paginated reports
  • Content management
  • Managing the web portal
  • SSRS and Power BI Report Server administration
  • Custom branding
  • Instance caching
  • Server management and configuration


Share
cage-aids
cage-aids
cage-aids
cage-aids