MS55145

Ladda ner som PDF

SQL Server Dashboards with Microsoft DataZen

About this course

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.

Målgrupp

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.

Förkunskaper

None

Informator Training Cloud

Vår utbildningsportal stöttar dig genom hela utbildningen. Portalen är tidsbesparande och utformad för att ge dig som deltagare en mer effektiv inlärning - som leder till bättre resultat och större kunskapstillämpning efter kursen. Läs mer här >

At course completion

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.
    •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 OutlineModule 1: Course OverviewThis module explains how the class will be structured and... Läs mer

At course completion

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.
    •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 OutlineModule 1: Course OverviewThis module explains how the class will be structured and introduces course materials and additional administrative information.Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll 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 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 : What is Datazen?

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 DeploymentIn 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 : 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 RepositoryIn 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 : 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: DashboardsIn 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 : 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: ScorecardsIn 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 ReportsIn 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 : 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 ReportingThis module covers advanced reporting techniques including utilizing parameterized queries, drill-through reports, hierarchies, and maps.Lessons

  • Utilizing Parameterized and Custom Queries/Data 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 hierarchies.
  • Understand how to configure maps.
  • Understand and utilize advanced reporting.

Module 9: Repository Management and MaintenanceIn 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 : 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.
Kurs-ID: MS55145
Längd: 2 dagar
Pris exkl moms: 21 450 kr

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD

Ort och datum

Stockholm
27 feb-28 feb
Boka nu!
4 maj-5 maj
Boka nu!
3 jul-4 jul
Boka nu!
Göteborg
27 feb-28 feb R
Boka nu!
4 maj-5 maj R
Boka nu!
3 jul-4 jul R
Boka nu!
Malmö
27 feb-28 feb R
Boka nu!
4 maj-5 maj R
Boka nu!
3 jul-4 jul R
Boka nu!
Cloud Access
i Läs mer

Delta på kursen från ditt hem, jobb eller annan plats.

27 feb-28 feb
Boka nu!
4 maj-5 maj
Boka nu!
3 jul-4 jul
Boka nu!

Tipsa