Getting Started with PowerPivot for Excel
- 1.7k Downloads
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.