Syllabus BBP009AC Quick Mobile Reports with SQL 2016
Overview:
In this hyperconnected fast moving world information is king for the business person that needs to stay ahead of the game. Today it may not be possible to request a report for a changing business from traditional IT but instead it is much more practical to teach every business user how easy it is to create and modify their own or their team’s reports. Microsoft anticipated this trend with their purchase of the popular technology known as DataZen. DataZen was popular because it allowed regular business users to create visual reports quickly and easily. Microsoft included this technology in SQL 2016 with the SQL Mobile Report Designer which continues the tradition of ease of use. This lab intense course is designed to teach how easy it is to create Mobile Reports for either the mobile phone or tablet using the built-in functionality of Microsoft SQL 2016.
With fifteen exercises for the students plus three instructor led discussions the participants will leave gaining a understanding of the technology and the confidence to build out reports.
Duration:
One Day
Intended audience:
Team leads and Report Designers Business Decision Makers.
Module 1
Introduction
Module 2 - Getting started
This module is intended to get the participants thinking about their own areas of responsibility for which they need to create mobile reports. Here we explain the different chart types and the types of information that these different types present well. Later in the course when working with the charts in the Report Designer Dashboard the participant should reflect back on this module and tie together theory and practice.
Module 3 - Getting Data
In this module using five lab exercises and instructor led discussions the participant will learn about the different types of sources that they can use to retrieve their data for the reports and then how to connect to those sources and extract the data into datasets.
Module 4 - The report Designer Interface
This is the final module and the one where we will put to use the knowledge gained. Here we complete nine lab exercises and participate in three instructor led discussions and demonstrations. The participant will build multiple variations of reports using Gauges, Charts, Navigators and data grids then deploy them to the server.
