Summary
The Pivot Table is a very important tool in the toolbox of a modern data analyst, and Power Pivot adds more power to it. We have extensively covered the practical use of the Pivot Table and Power Pivot by creating interactive and beautiful dashboards. You have learned many useful concepts and report layout tricks. We have, thus, set you on the path to getting comfortable with DAX and its peculiarities.
In the next chapter, we will cover Excel functions and how to make your reports and dashboards fully responsive and automated by leveraging the many powerful functions of Excel.
