The core of Microsoft

Prévia do material em texto

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: