Excel Magic Trick 1336

Power Query: Import Big Data Text Files: Connection Only or Data Model?

DESCRIPTION

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.
(00:18) Introduction & Look at Text Files that Contain 7 Million Transactional Records
(01:43) Power Query (Get & Transform) Import From Folder to append (combine) 10 Text Files that contain 7 Millions transactional records.
(05:07) Load Data as Connection Only and Make PivotTable
(08:17) Load Data into Data Model and Make PivotTable.
(10:46) Summary

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply