Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 9. PowerPivot for Excel > Preparing the Data
Preparing the Data
Now that the data has been imported, we need to do some additional work to get it ready for use.
Creating Relationships Between the Tables
A relationship needs to be created between the imported Income data and the Sales data. Because this is Median Income by State, we relate it to the DimGeography table joined on the state name:
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint