Students will learn how to use Excel PowerPivot, Power View, and SharePoint to develop and share dynamic dashboards during this two-day instructor-led training.
Course Price : $1295 Per Participant
Students will learn how to use Excel PowerPivot, Power View, and SharePoint to develop and share dynamic dashboards during this two-day instructor-led training.
Students will be guided through the process of creating a dashboard project, with all the necessary stages, ideas, formulas, and functions being thoroughly taught.
Courses
Years of Experience
Global Learners
The audience for this course is Power Users and Business Intelligence Developers who have recently begun or are actively working on creating Excel dashboards.
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
Lab 1: Course Overview
After completing this module, students will be able to:
In this module, we will explore the elements needed for effective and efficient dashboard building. We will cover best practices for success in business intelligence, and also examine visualization types, along with the pros and cons associated with each, and common pitfalls, so you’ll know what to avoid when designing dashboards.
Lessons
Lab 1: Dashboard Principles
After completing this module, students will be able to:
In this module, we will explore importing data, creating relationships, and utilizing date tables. We will also create and configure calculated columns, calculated fields, and KPIs.
Lessons
Lab 1: Sourcing the Data
After completing this module, students will be able to:
In this module, we will create an Excel dashboard. We will explore how to create and configure pivot tables and pivot charts using PowerPivot, and we’ll also cover how to create a custom table, add that table to the data model, and configure the results to format conditionally.
Lessons
Lab 1: Creating the Excel Dashboard
After completing this module, students will be able to:
In this module, we will explore Power View. We will explain the interface and cover the tables and charts available. Lastly, we will demonstrate how to share your dashboards using SharePoint.
Lessons
Lab 1: Adding Power View Maps and Sharing
After completing this module, students will be able to:
©2023 Microtek Learning – All Rights Reserved