Introducing Power Pivot in Excel

  • Dan Clark


As you have seen in the previous chapters, Power BI is an excellent tool for developing analytic solutions. The Power BI portal is where you can host, share, and secure interactive dashboards and reports with others. Power BI Desktop is where you create the model and visuals on which the dashboards in the portal are based. It is great for sharing the results of your analysis with a broader audience. But where it is lacking (arguably) is when you need to perform pure data discovery. This is where most analysts turn to Excel. The great thing about Excel is that it uses the same tools you’ve been using in Power BI Desktop. It uses Power Query to get, clean, and shape the data. It then uses a Power Pivot Model Designer to construct a tabular model on top of which you create interactive pivot tables to explore the data.

Copyright information

© Dan Clark 2020

Authors and Affiliations

  • Dan Clark
    • 1
  1. 1.Camp HillUSA

Personalised recommendations