Download PDF
of this course

MS55145 - SQL Server Dashboards with Microsoft DataZen (MS55145)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration : 2 Days

This instructor-led course is intended for those interested in utilizing Microsoft Datazen and SQL Server to easily create highly secure dashboards, scorecards, KPIs, and much more that run on Windows, iOS, and Android.

Who Should Attend

  • This course is targeted at business intelligence developers and Power Users that are currently, or are in process of, developing data visualizations for the organization.

Course Certifications

This course is part of the following Certifications:

Prerequisites

Course Objectives

After completing this course, students will be able to:

  • Understand company background (purchased by Microsoft) / philosophy and software intent.

  • Understand architecture and security.

  • Understand the apps and their purposes.

  • Understand the custom branding options available.

  • Understand system requirements.

  • Understand deployment.

  • Understand installation and options.

  • Understand connecting to data.

  • Understand what a KPI is.

  • Create and configure a KPI.

  • Understand what a dashboard is.

  • Create and configure a dashboard.

  • Understand what a scorecard is

Course Content

Module 1 : Course Overview 

This module explains how the class will be structured and introduces course materials and additional administrative information

Lessons

  • Introduction
  • Course Materials
  • Facilities 
  • Prerequisites
  • What we will be discussing 

Lab : Course Overview 

After completing this module , students will be able to :

  • successfully log into their virtual machine
  • Have a full understanding of what the course intneds to cover

 

Module 2 : What is Datazen ?

In this module , we will explore how Datazen got staryed  and what it was designed to do . We expred architecture and security , along with the appps available and branding options.

Lessons 

  • Philosophy and Software Intent
  • Architecture and Security 
  • Apps and their purposes 
  • Custom Branding

Lab : What is Datazen ?

After completing this module , students will be able to ;

  • Philosophy and software intent
  • Understand architecture and security
  • Understand the apps and their puropses
  • Understand the custom branding options available

 

Module 3 : Installation and Deployment

In this module , we cover system requirements and examine the installation process along with the deployment options available. Finally , we examine how to connect to data and utilizie views 

Lessons

  • Examining System Requirements
  • Understanding Deployment 
  • Exploring Installation and Options
  • Connecting to Data

Lab : Installation and Deployment 

  • Creating a BI Hub and Connecting to Data

After completing this moduel , students willbe able to :

  • Understand system requirements
  • Understand deployment
  • Understand installation and options
  • Understand connecting to data

 

Module 4 : KPI Repository 

In this module , we will explore what a KPI is and its intended use , then we will walk through ihe process to create both KPI's and their corresponding groups.

Lessons

  • Wha is a KPI?
  • Creating KPIs

Lab : KPI Repository 

  • Creating a KPI

After completing this module , students will be able to :

  • Understand what a KPI is
  • Create and configure a KPI

 

Module 5 : Dashboards 

In this module , we will explore dshboards and cover best practices in designning them . We will then examine how to create , modify and save them
Lessons

  • What is a Dashboard?
  • Creating a Dashboard

Lab : Dashboards

  • Creating a Dashboard

After completing this module , students will able to :

  • Understand what a dashboard is
  • Create and configure a dashboard

 

Module 6 : Scorecards

In this module , we examine scorecards , their intended user , and how to create and configure them.

Lessons

  • What is a Scorecard?
  • Creating a Scorecard 

Lab : Scorecards

  • Creating a Scorecard

After completing this module , students will be able to :

  • Understand what a scorecard is 
  • Create and configure a scorecard

 

Module 7 : Sharing and Accessing Reports 

In this module , we will examine the sharing and publishing options , explore the ways Datazen content can be accessed and cover embedding content into custom apps and Sharepoint.

Lessons 

  • Sharing / Publishing
  • Accessing
  • Embedding Reports in Cusom Apps
  • Embedding Reports in Sharepoint

Lab : Sharing and Accessing Reports 

  • Sharing / Publishing a Report
  • Accessing Reports

After completing this module , students will be able to :

  • Understand and utilize sharing/publishing
  • Understand how to access reports
  • Understand how to embed reports in custom apps
  • Understand how to embed reports in sharepoint

 

Module 8 : Advanced Reporting

This module covers advanced reporting techniques including utilizing parameterized queries , drill-through reports , hierachies and maps.

Lessons

  • Utilizing Parameterized and Custom Queries / Dat Views
  • Understand drill-through
  • Examining Hierachies
  • Exploring Maps

Lab : Advanced Reporting 

  • Utilizing Advanced Reporting 

After completing this module , students will be able to :

  • Understand parameterized and custom queries/data views
  • Understand how to configure drill-through
  • Understand how to configure hierachies
  • Understand how to configure maps
  • Understand and utilize advanced reporting

 

Module 9 : Repository Management and Maintenance

In this final module , we will explore Repository management and maintenance including compacting , index reset , log viewing and utilizing backup and restore

Lessons

  • Compacting 
  • Utilizing Index Reset
  • Viewing Logs
  • Using Backup and Restore 

Lab : Repository Management and Maintenance 

  • Repository Mangement and Maintenance

After completing this module , students will be able to :

  • Understand compacting 
  • Understanding index reset
  • Understand and view logs
  • Understand backup and restore

Course ID: MS55145


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register