MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set

MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set

Obtain START Recordsdata:

Obtain FINISHED File:
Obtain pdf Notes about Energy Question to import Excel information:

Assigned Homework:
Obtain Phrase Doc and browse:

Then obtain the remainder of the recordsdata and full the homework:

Examples of Completed Homework:

Purchase excelisfun merchandise:

On this Video discover ways to import information from a number of Excel Workbook Recordsdata and append right into a single Correct information Set.
Matters:
1. (00:12) Introduction
2. (02:18) Have a look at Knowledge Import Recordsdata and the completely different objects which can be in an Excel File
3. (06:56) Import Excel Recordsdata From Folder
4. (08:11) Have a look at Excel File in Energy Question Editor
5. (08:26) Rework extensions to all lowercase
6. (08:34) Filter to incorporate solely Excel Recordsdata in import course of
7. (09:10) Extract Excel File Identify to create New Column for Metropolis. Break up By Delimiter.
8. (10:01) Energy Question Choices: Don’t Change Knowledge Kind
9. (11:10) Rename Column and Take away undesirable columns
10. (11:34) Add Customized Column with Excel.Workbook Perform (M Code Perform). Clarification of what features extracts from the Excel Recordsdata.
11. (15:14) Filter Out Excel Objects that don’t meet Standards = Sheet
12. (15:37) Filter out names that Do Not Start With Sheet. Extract Worksheet Identify to create New Column for SalesRep.
13. (16:08) Last Append to get all Excel Worksheet that include Correct Knowledge Units with a correct SalesRep Identify.
14. (17:41) Apply appropriate Knowledge Varieties
15. (18:50) Load to Excel Sheet
16. (19:41) Change Default PivotTable Structure & Choices
17. (21:19) Construct PivotTable Report
18. (23:40) Definition of a PivotTable
19. (26:12) Add New Excel Workbook Recordsdata to the Folder & Refresh the Question and PivotTable
20. (29:35) Edit Question when Folder Path Adjustments
21. (30:57) Abstract

Complete Microsoft Energy Instruments for Knowledge Evaluation Class, BI 348, taught by Mike Girvin, Excel MVP and Highline Faculty Professor.