Adding data to Power Pivot
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.
Getting ready
This recipe requires the Crash_Data_PowerPivot_new_tables.xlsx Excel data that is available from the Packt Publishing site.
How to do it...
Open your model by clicking the Manage icon in PowerPivot to bring up the model window.
Select Get External Data and From Other Sources, scroll to the bottom and select Excel file, and then click Next.
Select the Use first row as column headers and then Next>. Then select CRASH_SEVERITY and MANNER_of_CRASH to add those tables to your model and select Finish.
Now switch to the Diagram View and build a relationship from the new tables...
