Reporting Services 2016 Training: online, free

I’m pleased to present a four-week, on-line SSRS 2016 course on behalf of Microsoft; hosted on the edX platform developed by  Harvard, MIT and other major universities.  The first session began this week but there is still time to get started.  Additional sessions will also be offered in the future.

This is not a promotional free trial or some kind of limited offer to get you to sign-up for a more expensive training class.  It is high-quality, in-depth training sponsored and produced by Microsoft for free, and led by yours truly – and co-presented by Chris Randall; Senior Content Developer for Microsoft Learning Experiences.  The course, with all the materials are free.  If you would like an official verification certificate, it’s optional and a mere $49 extra.  This course provides general knowledge, helps students develop basic, foundational skills and then focuses specifically on data visualization using existing and newer SSRS features.

Analyzing and Visualizing Data with SQL Server Reporting Services

Learn to create mobile reports, paginated reports, and KPIs using business data with SQL Server Reporting Services (SSRS).

Microsoft Logo

In this computer science course, you will learn to build reports with SQL Server Reporting Services, which includes new visualization features and mobile capabilities. You will learn to create reporting solutions, mobile reports and dashboards.

Whether you’re new to reporting services, or experienced with earlier versions, we’ll show you how to build tables, matrices, advanced visualizations, and dashboards with key performance indicators. You’ll design and deploy compelling, interactive reports for smartphones, tablets, and browsers.

By the end of the course, you’ll have developed a complete reporting solution and be ready to analyze and visualize your own business data with SQL Server Reporting Services.

Note: To complete the hands-on elements in this course, you will require an Azure subscription. You can sign up for a free Azure trial subscription (a valid credit card is required for verification, but you will not be charged for Azure services). Note that the free trial is not available in all regions. It is possible to complete the course and earn a certificate without completing the hands-on practices.

Course Syllabus

Skip Syllabus Description Module 1: Report and Dashboard Solutions
This module introduces report concepts, authoring roles, and tools available to create reports and dashboards.
Module 2: Basic Report Design
This module presents the reporting design and deployment ecosystem and lifecycle, report design techniques, and the expressions language of SQL Server Reporting Services.
Module 3: Visual and Interactive Reporting
This module introduces charts, scorecards and dashboards, and how to author analytic reports using data stored in multidimensional cubes and in-memory tabular models.
Module 4: Mobile Report Solutions
This module introduces mobile reports, including layouts and deployment, and how to add key performance indicators (KPIs) to your report environment.
Final Exam
The final exam accounts for 40% of your grade and will be combined with the weekly quizzes to determine your overall score. You must achieve an overall score of 70% or higher to pass this course and earn a certificate.

Meet the instructors

bio for Paul Turley

bio for Chris Randall
Paul Turley
Microsoft
Intelligent Business LLC
SolidQ
Chris Randall
Senior Content Developer, Microsoft Learning Experiences
Microsoft

Learn more and enroll

A companion to the course, my new Professional SQL Server 2016 Reporting Services book from Wrox Press, is in final production and should be available any day now…

Reporting Services 2016, The Force Awakens session at Summit 2016

THANK YOU…

everyone who attended my session today titled “Reporting Services 2016, The Force Awakens”  We had a packed house with attendees standing along all of the walls in two joining session rooms.  This is indeed a very popular topic!   The session was recorded and will be available to watch with all the Summit 2016 session recordings.  You can download the slides deck here.  Samples and demo material are available from these resources (which are on the References & Sample slide):

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports
Amazon (samples)

Self-paced online SSRS 2016 training
EdX course DAT214x: “Analyzing and Visualizing Data with SQL Server Reporting Services”
EdX.org (samples)

The Essential Guide to SQL Server 2016 Reporting Services
SQL Server Pro Magazine / SQLMag.com
Link (samples)

My Blog
SqlServerBiBlog.com

Reporting Services 2016, Power BI and PASS Summit 2016

What am I most excited about as I prepare for the PASS Summit here in Seattle this week?  A lot of things.  Preparing for my session, which will be on Thursday at 1:30, by far the most popular and interesting topics are about integration and tool choice.  Today’s public announcement on the SSRS product team blog about on-premises Power BI integration with Reporting Services is really big news.  It’s great to see two of the technologies I love working together.  Whether in the cloud or on-premises, Power BI and Reporting Services can be used together.

Thursday’s session is titled “Reporting Services 2016, the Force Awakens”.  The consensus among industry users is that Reporting Services was stalled and left alone for far too long.  Technology and industry trends have moved forward over the past five years or so but Microsoft have invested in other tools and products, aside from Reporting Services.  The SSRS server architecture is capable but the rendering and delivery components needed to be modernized.

The good news is that the modernization effort has been underway for quite some time.  Resources that were directed to other investments have been recommitted, not only to the Reporting Services product, but to integration across the product stack.  It’s really hard to build a reporting platform that addresses every need.  I think Microsoft have a history of creating false expectations by putting experimental and incomplete features  out in the industry that weren’t on the committed roadmap.  I know better than to believe that the pattern won’t ever be repeated but I firmly believe that there is a well-defined reporting and BI roadmap and product teams are making rapid progress against it.  It is once again an exciting time to invest in the Microsoft analytics, reporting and BI tool set.

I’ll publish the entire deck after the 2016 Summit.  Until then, here are some selected slides…

Comparing the progress of new features added to SSRS over the release cycles, the product really slept from 2010 until 2016.

2016-10-25 (1)

Microsoft’s reporting & analytic platform has shifted significant as they moved from products to services, and from servers to the cloud.  The dust is settling on this major refocusing effort.  Capabilities that were introduced in Azure, Cortana Analytics and Power BI are now becoming available to “the box”, on-premises or in hybrid cloud scenarios.  We can expect more announcements on this as the roadmap is played-out and gaps are filled-in.

2016-10-25 (2)

Reporting Services is a central player in the on-prem delivery of the BI, analytics and reporting tools offered by Microsoft.  These include Excel, Paginated reports created with SSDT/report designer or Report Builder, Mobile Reports and Power BI Desktop.

2016-10-25 (3)

…more to come!

check back for updates.