Mobile Report and Dashboards with SSRS

Part Of The On-Demand Courses


  • How to use the Mobile Report Publisher for designing Dashboards viewable on your desktop, tablet and phone
  • How to design KPIs in the Web Portal
  • How to administer and manage security on your Mobile Reports
This course includes:

Course Description

The release of SQL Server 2016 has now integrated the incredible dashboarding and mobile reporting capabilities from Microsoft’s acquisition of Datazen. These new capabilities are now available in SQL Server Reporting Services, along with many other improvements (some of which include a new Mobile Report Publisher) and upgrades to the existing Report Builder and Web Portal. At the end of this course, you will be proficient in designing, publishing, and applying security to KPIs, dashboards and mobile reports in SQL Server Reporting Services 2016.


Click here for a downloadable PDF



Module 00 | Mobile Reports and Dashboards Introduction
06m 12s total


Module 00A | Mobile Reports and Dashboards Introduction
06m 12s


Module 01 | Class Introduction
30m 16s total


Module 01A | Touring the Web Portal
12m 58s


Module 01B | Interactive Dashboards
17m 18s


Module 02 | Introduction to the Mobile Report Publisher
18m 03s total


Module 02A | Introduction to the Mobile Report Publisher
18m 03s


Module 03 | Creating a Basic Dashboard
18m 27s total


Module 03A | Creating a Basic Dashboard
18m 27s


Module 04 | Adding your Data
25m 12s total


Module 04A | Creating Data Sources
11m 02s


Module 04B | Creating the Dataset
14m 10s


Module 05 | Filtering with Navigators
39m 08s total


Module 05A | Time Navigator
15m 24s


Module 05B | Selection List and Scorecard Grid
13m 34s


Module 05C | Working with Filters
10m 10s


Module 06 | Using Gauges
18m 21s total


Module 06A | Using Gauges
18m 21s


Module 07 | Working with Charts
46m 58s total


Module 07A | Time Charts
16m 57s


Module 07B | Category Charts
09m 07s


Module 07C | Totals Chart
09m 02s


Module 07D | Other Charts
11m 48s


Module 08 | Showing Geographical Data with Maps
23m 33s total


Module 08A | Standard Maps
16m 34s


Module 08B | Custom Maps
06m 59s


Module 09 | Displaying Information on Data Grids
32m 47s total


Module 09A | Simple and Indicator Data Grids
19m 37s


Module 09B | Chart Data Grid
13m 10s


Module 10 | Publishing to the Web Portal
07m 18s total


Module 10A | Publishing to the Web Portal
07m 18s


Module 11 | Advanced Features
34m 04s total


Module 11A | Drillthrough
21m 24s


Module 11B | Parameters
12m 41s


Module 12 | Working with the Web Portal
48m 21s total


Module 12A | Whiteboarding Organization Structures
08m 18s


Module 12B | Adding Caching and Favorites
21m 27s


Module 12C | Branding the Web Portal
18m 36s


Module 13 | Building KPIs
22m 37s total


Module 13A | Building KPIs
22m 37s


Module 14 | Configuring Security
15m 29s total


Module 14A | Configuring Security
15m 29s


Module 15 | Consuming Dashboards on the Mobile Application
03m 52s total


Module 15A | Consuming Dashboards on the Mobile Application
03m 52s



Training Content Manager

Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.


System Requirements

  • Windows 7, Windows 8 or Windows 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer or Enterprise Edition 2016
    • SQL Server Database Engine
    • SQL Server Reporting Services
      • Mobile Report Publisher
      • Report Builder
    • SQL Server Management Studio
  • AdventureWorksDW2016 and AdventureWorks2016 databases installed on the database instance (database backups provided in class files)

What to Know Before Class

A basic understanding of T-SQL is recommended prior to taking this course.


Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.



• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!