© Dan Clark 2017

Dan Clark, Beginning Power BI, 10.1007/978-1-4842-2577-6_1

1. Introducing Power Pivot

Dan Clark

(1)Camp Hill, Pennsylvania, USA

The core of Microsoft’s self-service business intelligence (BI) toolset is Power Pivot . It is integrated into both Excel 2016 and Power BI and forms the foundation on top of which you will build your analytical reports and dashboards. This chapter provides you with some background information on why Power Pivot is such an important tool and what makes it perform so well. The chapter also provides you with an overview of the Power Pivot interface in Excel 2016 and gives you with some experience using the different areas of the interface .

After reading this chapter you will be familiar with the following: ...

Get Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.