Duration
2 days
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.
Audience profile
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.
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.
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'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 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 : 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 : 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 : 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 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 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 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
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 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 : 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.
Prerequisites
None
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.