Now that you have a working model in PowerPivot, you will enhance your SQL Server data that was imported with new external data that is stored in Excel. You will add new data from an Excel sheet that contains codes for two other columns. This is an example of how users can continue to enhance corporate data and make the model more useful for all people that need to leverage the data.
This recipe requires the
Crash_Data_PowerPivot_new_tables.xlsx Excel data that is available from the Packt Publishing site.