2014
Lynda
Ron Davis
1:12
English

All it takes to point your business in the right direction are some strategic insights from your data. In this course, author Ron Davis uses the Power Pivot and Power View plugins to build robust dashboards for analyzing key metrics in Excel—all in just over an hour. First, learn some dashboard design guidelines—such as understanding your audience and identifying necessary metrics—before getting started. Then Ron walks you through importing data, setting up calculated fields and columns, creating key performance indicators (KPIs), and building the PivotTables and PivotCharts for the dashboards. Last, find out how to add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood.

Introduction
Welcome
Demonstration of the dashboard we will be building
Building an environment
Using the exercise files
1. Sourcing and Enhancing the Data Model
Dashboard design guidelines
Importing data
Relating data
Creating calculated fields and columns
Creating key performance indicators (KPIs)
2. Creating the Excel Power Pivot Dashboard
Add a linked table to the data model
Create the PivotTables
Create the PivotCharts
Create the PivotTables and charts for the customer KPI sheet
3. Completing Your Dashboard
Adding Power View visualizations
Formatting with color
Reviewing the completed dashboard
Conclusion
Next steps

Download File Size:140.07 MB

---