A Method to the Madness



The goal of this chapter is to take the skills you developed in the previous chapters and build on them to create the beginnings of a methodology for success with your PowerPivot for Excel solutions. Much like students of architecture begin not by designing a structure but by learning how to measure, cut, and fasten building materials together with basic tools, you have acquired the essential basics of PowerPivot. The basic carpentry skills of PowerPivot for Excel include
  • Installing the software

  • Loading data from text files, spreadhseets, and databases

  • Creating relationships between disparate data sources

  • Bending the data to our will using Data Analysis Expressions (DAX)


Business Intelligence Base Field Grand Total Excel Solution Excel Worksheet 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Barry Ralston 2011

Authors and Affiliations

There are no affiliations available

Personalised recommendations