O'Reilly logo

PowerPivot for Advanced Reporting and Dashboards by Robert Bosco J

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

This chapter allows the user to explore the features of data model and the fundamental concepts of relationship and hierarchy. The user, by now, should know how the ETL process and DAX expression are performed in PowerPivot, and how to use them to create structured data from unstructured data. Finally, the user will know how data can be homogenized from heterogeneous data.

More precisely, practical information about two industrial data has been clearly explained in order to make a good logical data model design, in which the user will know how to use PowerPivot to create a relationship, hierarchy, and make calculated columns, and do some troubleshooting if they encounter any errors while practising any of the functions. So, finally two ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required