Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 8, 2016
Download Files: https://people.highline.edu/mgirvin/A... In this video learn about: 1. (00:15) Overview: Clean & Transform & Import Multiple Excel Files with 1 Sheet Each & Create PivotTable Report 2. (03:00) Step 1: Import Multiple Excel Files, 1 Sheet Each, including Power Query (M Language) Excel.Workbook function. 3. (11:45) Step 2: Load to Data Model and create DAX Measure for Total Sales, Edit Power Query 4. (15:19) Step 3: Create PivotTable based on Data Model and Group Dates by Month and Year. 5. (16:50) Step 5: Use Show Values As feature in a PivotTable: % of Grand Total, Difference From, % Difference From, Running Total, and % Running Total. 6. (19:48) Step 4: Add Slicers for City and Year 7. (20:40) Step 6: Finalize Report 8. (21:40) Step 7: We Get New Files in Folder, After we Refresh: Everything Updates!