Mobile Reports and Dashboards with SSRS 2016

$95.00

What Will You 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

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.

Instructor

MITCHELL PEARSONMITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

What to Know Before the Class

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


Duration: 5:26:40
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.
Mobile Reports and Dashboards - What you need to get started
Module 00 - Mobile Reports and Dashboards Introduction
06:12
Module 01A - Class Introduction (Touring the Web Portal)
12:58
Module 01B - Class Introduction (Interactive Dashboards)
17:18
Module 02 - Introduction to the Mobile Report Publisher
18:03
Module 03 - Creating a Basic Dashboard
18:27
Module 04A - Adding your Data (Creating Data Sources)
11:02
Module 04B - Adding your Data (Creating the Dataset)
14:10
Module 05A - Filtering with Navigators (Time Navigator)
Module 05B - Filtering with Navigators (Selection List and Scorecard Grid)
13:34
Module 05C - Filtering with Navigators (Working with Filters)
Module 06 - Using Gauges
18:21
Module 07A - Working with Charts (Time Charts)
Module 07B - Working with Charts (Category Charts)
09:07
Module 07C - Working with Charts (Totals Chart)
09:02
Module 07D - Working with Charts (Other Charts)
11:48
Module 08A - Showing Geographical Data with Maps (Standard Maps)
16:34
Module 08B - Showing Geographical Data with Maps (Custom Maps)
06:59
Module 09A - Displaying Information on Data Grids (Simple and Indicator Data Grids)
19:37
Module 09B - Displaying Information on Data Grids (Chart Data Grid)
13:10
Module 10 - Publishing to the Web Portal
07:18
Module 11A - Advanced Features (Drillthrough)
Module 11B - Advanced Features (Parameters)
12:41
Module 12A - Working with the Web Portal (Whiteboarding Organization Structures)
08:18
Module 12B - Working with the Web Portal (Adding Caching and Favorites)
21:27
Module 12C - Working with the Web Portal (Branding the Web Portal)
18:36
Module 13 - Building KPIs
22:37
Module 14 - Configuring Security
15:29
Module 15 - Consuming Dashboards on the Mobile Application
03:52
Class Survey

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)