Excel 2013 PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data

Download file: http://people.highline.edu/mgirvin/excelisfun.htm Scroll to down to PowerPivot Section. Power Query and Power Pivot example. Big Data example. See how to improve spreadsheet performance (calculation speed) by replace a workbook with array formulas to do 3 way lookup for big data by using Power Query and PowerPivot: 1. ( minute mark) Using Power Query import three data sets from 3 Excel files that contain 1.2 million rows of data. Use Append feature. Import lookup table from 4th Excel file. 2. ( minute mark) Load data to PowerPivot Data Model. 3. ( minute mark) Create Concatenated columns (join columns) to create a unique identifier (primary Key). 4. ( minute mark) Create Relationship 5. ( minute mark) Create Pivot Table Report that simulates three way lookup in order to create summary sales report with categories from one table and sales from a second table. Big Data. Miguel Escobar and Ken Puls are doing online workshops on Power Query www.powerquery.training . This training is not by excelisfun.