Getting Started with PowerPivot for Excel



When I began working in business intelligence almost 18 years ago, the overarching goal was to create a subject-oriented data store that could be used by an ordinary business worker without SQL skills to answer questions and confirm hypothesis. Great work was done by my teammates and I to move data from data storage structures designed for transaction capture into dimensional models designed from the start for processing analytical queries. The analytical data store, in the form of a data mart, data warehouse, or otherwise will maintain a vital purpose in business decision-making.


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