NEED HELP? TALK TO AN EXPERT (904) 638-5743

Mobile Report and Dashboards with SSRS

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • 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

Outline

 

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

Instructor

MITCHELL PEARSON

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.

REVIEWS

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.

 

Bonus:

• 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!