Modern Reporting with SSRS 2016 & 2017, and Report Tool Options – PASS Sessions

It’s official.  The PASS Summit schedule was announced and I will be doing three sessions:  A full-day preconference, a regular session and a panel discussion with other industry professionals.  Come back to this post for follow-up information and selections of content from these sessions after the event.

The PASS Summit is my favorite event of the year and I always leave with so much valuable insight and information.  PASS is my annual battery recharge for the rest of the year.  It is a vibrant community of professionals and industry leaders who love to share and exchange learnings.  Not just an opportunity to attend sessions presented by top-notch experts and product owners from Microsoft but Summit presents many real opportunities to sit and talk, meet and socialize with these industry influencers.  My perspectives change and I go back to my clients, classrooms and projects with solutions and a fresh new approach.  I’ve been going to the PASS Summit for twelve years and every year is literally the best Summit ever.  In the industry, there is no better investment of time and energy compared with what you will gain by attending.  I look forward to meeting many of you at Summit.  Please introduce yourself and say ‘Hello’.

My session descriptions are following.  It was an honor to be selected to present a full-day preconference session.  Thanks to the program committee for this great privelege!

Modern Reporting with SQL Server 2016 and 2017 Reporting Services
The full-day preconference session is on Tuesday, October 31, 2017 from 8:30 to 4:30.

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.

The Data Visualization Panel Discussion is on Wednesday, November 1, 2017 at 4:45 PM.  This is a 75 minute session.  Join Mico Yuk, Ginger Grant, Meagan Longoria, Chris Webb and myself for an engaging discussion about data visualization tools, choices and challenges.

Your Complete BI Toolbelt: Using Power BI, Excel & SSRS Together to Create Integrated BI Solutions
This is also a 75 minute session on Thursday, November 2nd, 2017 at 10:45.

How do you choose the right reporting tool for the job? Everyone knows that Power BI brings kick-butt visuals and interactions but it doesn’t do multi page reports for print, Excel dishes meat and potato financial sheets and pivot reports but they always look like, well, spreadsheets; and of course our old friend Reporting Services delivers highly-formatted, multi-page reports but it just doesn’t look good in yoga pants anymore. Can we use these tools together? You bet your sweet patootie, we can. Come and learn how to choose the right tool for the job. I will show you how to orchestrate beautiful business solutions by stitching these bad boys together using actions and drill-through navigation…. and maybe a few tricks you haven’t seen before.

Modern Reporting with SQL Server 2016 and 2017 Reporting Services full day pre-conference session

I am thrilled to be presenting a full-day preconference session before the PASS Summit, on October 31st.  Please join me for a deep tour of the new capabilities and BI platform integrations for SQL Server Reporting Services 2016 & 2017.  The session will also review the essential skills and tasks to setup and configure the report server and web portal, report design and modern report solution planning.

Here’s an overview of the session:

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

Register for the PASS Summit and preconference here.  Also, look out for a sneak peek of this and many other sessions in the 24 Hours Of PASS which will run continuously through July 19th and 20th.  Watch the PASS Learning Channel for announcements.