Loading...

Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting

253,691 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 27, 2016

Download Files: https://people.highline.edu/mgirvin/A...
In this video learn about how to build Excel Dashboard based on Data Model and see first DAX Measure (Formula):
1. (00:22) Introduction
2. (02:43) Power Query to Clean, Transform & Import Text Files (From Folder feature)
3. (09:35) Import Data into Power Pivot Data Model
4. (11:23) PivotTable #1: for Month & Year Revenue
5. (11:38) Group Dates in PivotTable based on Data Model: Automatically adds Columns to Data Model Table.
6. (13:38) First DAX Measure: "Formula for PivotTable"
7. (19:04) Add Slicer to Multiple PivotTables
8. (19:52) Chart #1: Line Chart for Month and Year Data
9. (20:27) Name PivotTables
10. (21:20) PivotTable #2: Revenue for each SalesRep. Name Pivot. Connect to Slicer.
11. (22:39) Chart #2: Bar Chart for SalesRep Revenue
12. (23:52) PivotTable #3: Create Year PivotTable. Name Pivot. Connect to Slicer.
13. (26:00) Create Text Label for Chart #2 based on PivotTable #3 and Slicer.
14. (27:10) PivotTable #4: Cross Tabulated Table for Product and Region.
15. (28:45) Conditional Formatting for PivotTable #4.
16. (29:58) Paste Linked Picture of PivotTable in Dashboard
17. (30:48) Add formatting and Alignment to Dashboard
18. (33:25) Add new Text Files to Folder and Refresh Dashboard
19. (34:59) Edit Query to remove data from Dashboard.
20. (35:38) Summary

Reference Video:
Excel Magic Trick 1379: Power Query Combine Binary "Expand Button" January 2017 Update
https://www.youtube.com/watch?v=KqIMW...

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...