C H A P T E R  1

images

Getting Started with PowerPivot for Excel

A journey of a thousand miles begins with a single step.

—Lao-tzu

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 ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.