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)
KeywordsBusiness 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.
© Barry Ralston 2011