Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model?

Download Files:

Start File: https://people.highline.edu/mg....irvin/YouTubeExcelIs

Finish File: https://people.highline.edu/mg....irvin/YouTubeExcelIs

https://people.highline.edu/mg....irvin/YouTubeExcelIs

Download File: http://people.highline.edu/mgirvin/excelisfun.htm

See how to use Import 10 Text Files and Append (combine) then into a single Proper Data Set before making a PivotTable Report. Compare and Contrast whether we should use Connection Only or Data Model to store the data.
1. (00:18) Introduction & Look at Text Files that Contain 7 Million Transactional Records
2. (01:43) Power Query (Get & Transform) Import From Folder to append (combine) 10 Text Files that contain 7 Millions transactional records.
3. (05:07) Load Data as Connection Only and Make PivotTable
4. (08:17) Load Data into Data Model and Make PivotTable.
5. (10:46) Summary