The habits and actions that are executed routinely as part of every project are the practices of the method described in this chapter. Practices are the activities of execution that produce working, reusable PowerPivot solutions. The practices that follow include activities that are part of all modern software development, such as using revision control. The majority of these practices, however, pertain specifically to PowerPivot development, such as object naming and basics of dimensional modeling.

Take Advantage of Revision Control

Usually, when I am using a revision control system on my projects, it is Team Foundation Server. However, because of the compact unit of distribution, the Microsoft Excel .xlsx file, for distributing PowerPivot ...

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.