Module 1: Course OverviewLessons
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We'll Be Discussing
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: Dashboard PrinciplesLessons
- Develop Multiple Dashboards
- Change Deployed Dashboards
- Provide Interactive Help For Your Dashboards
- Monitor Dashboard Utilization
- Control Dashboard Updates
After completing this module, students will be able to:
- Understand how to develop multiple dashboards.
- Understand how to change deployed dashboards.
- Understand how to provide interactive help for dashboards.
- Understand how to monitor dashboard utilization.
- Understand how to control dashboard updates.
Module 3: Sourcing the DataLessons
- Importing Data
- Relating Data
- Enriching Data
- Time Calculations
Lab : Sourcing the Data
After completing this module, students will be able to:
- Understand how to import data.
- Understand how to relate data.
- Understand how to enrich data.
- Understand how to use time calculations.
- Source data.
Module 4: Creating the Excel DashboardLessons
- Tabular Data
- Visual Data
- Linked Tables
Lab : Creating the Excel Dashboard
After completing this module, students will be able to:
- Understand tabular data.
- Understand visual data.
- Understand linked tables.
- Create a dashboard.
Module 5: Adding InteractivityLessons
- Adding Drillthrough
- Visualizations with Power View
Lab : Adding Interactivity
After completing this module, students will be able to:
- Understand how to add drillthrough.
- Understand visualizations in Power View.
- Add interactivity.
Module 6: Sharing with SharePoint Excel ServicesLessons
- Deploy to SharePoint
- Automatic Data Refresh
Lab : Sharing with SharePoint Excel Services
After completing this module, students will be able to:
- Understand how to deploy to SharePoint.
- Understand automatic data refresh.
- Share using SharePoint Excel Services.