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