Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics

© Dan Clark 2020

D. ClarkBeginning Microsoft Power BIhttps://doi.org/10.1007/978-1-4842-5620-6_10

10. Introducing Power Pivot in Excel

Dan Clark¹ 

(1)

Camp Hill, PA, USA

 

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