Large Data sets and slow spreadsheets dealing with Retail sales Data from Walmart

[Tim_D]

Hi all,

We have a great problem, sales during 4th Qtr were larger than expected and as a result, Walmart WFS reports are too large to house them within the Sales Margins Workbook, or I have an insanely slow Excel file.

My ask is this, what is the most efficient way to deal with large csv or xlsx files and house them externally, but also allow XLookup, and other Functions to access these data sets? I have done power query in the past, but it has been years and lot has changed. Suggestions on how to access large datasets from excel that will not slow down the final workbook used to calculate the margins based on the data files downloaded from the source sales channel, Walmart WFS in this case, would be most appreciated.

Thanks to all who can help!

Timothy

 

[alansidman]

You can bring the data into PQ, do any necessary mash ups and then close and load your data to the "Data Model". Once in the Data Model you can then create pivot tables for analysis. Size is not an issue either in PQ or Power Pivot (Data Model).