This chapter shows the users how to prepare data for analysis. We also covered different types of data sources that can be imported into the PowerPivot interface. Some information about the provider and a general overview of the ETL process has also been given. Users now know how the ETL process works in the PowerPivot interface; also, users were shown an introduction and the advantages of DAX.
Users have learned how to import different data sources into one PowerPivot workspace. In this chapter, a successful import of two kinds of industry data from different data sources has been shown and explained in detail with each of the functionalities and features of the data source import wizard, connection details, filtering, ignoring unwanted columns, and so on. The user now knows details on data refresh with provided detailed diagrams and screenshots for easy understanding.
In the next chapter, we will cover a brief introduction of the data model and later, a full description of data model...