55145 SQL Server Dashboards with Microsoft DataZen

• 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.
• Create and configure a scorecard.
• 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.
• Understand parameterized and custom queries/data views.
• Understand how to configure drill-through.
• Understand how to configure hierarchies.
• Understand how to configure maps.
• Understand and utilize advanced reporting.
• Understand compacting.
• Understand index reset.
• Understand and view logs.
• Understand backup and restore.
• Understand and utilize repository management and maintenance.

Course Details:

Module 1: Course Overview

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

Lessons

Lessons

• Introduction
• Course Materials
• Facilities
• Prerequisites
• What We'll Be Discussing

Lab 1: Course Overview

• None

After completing this module, students will be able to:

After completing this module, students will be able to:

• Successfully log into their virtual machine.
• Have a full understanding of what the course intends to cover.

Module 2: What is Datazen?

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

Lessons

• Brief Company Background (purchased by Microsoft) / Philosophy and Software Intent
• Architecture and Security
• Apps and Their Purposes
• Custom Branding

Lab 1: What is Datazen?

• None

After completing this module, 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.

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 utilize data views.

Lessons

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

Lab 1: Installation and Deployment

• Creating a BI Hub and Connecting to Data

After completing this module, students will be 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 the process to create both KPIs and their corresponding groups.

Lessons

• What is a KPI?
• Creating KPIs

Lab 1: 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 dashboards and cover best practices in designing them. We’ll then examine how to create, modify, and save them.

Lessons

• What is a Dashboard?
• Creating a Dashboard

Lab 1: Dashboards

• Creating a Dashboard

After completing this module, students will be able to:

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

Module 6: Scorecards

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

Lessons

• What is a Scorecard?
• Creating a Scorecard

Lab 1: 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 Custom Apps
• Embedding Reports in SharePoint

Lab 1: 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, hierarchies, and maps.

Lessons

• Utilizing Parameterized and Custom Queries/Data Views
• Understanding Drill-through
• Examining Hierarchies
• Exploring Maps

Lab 1: 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 hierarchies.
• Understand how to configure maps.
• Understand and utilize advanced reporting.

Module 9: Repository Management and Maintenance

In this final module, we 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 1: Repository Management and Maintenance

• Repository Management and Maintenance

After completing this module, students will be able to:

• Understand compacting.
• Understand index reset.
• Understand and view logs.
• Understand backup and restore.
• Understand and utilize repository management and maintenance.