Introducing Power Pivot in Excel
- 139 Downloads
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.