16. How do Power BI Desktop and Power Pivot for Excel vary from one another in terms of data modeling?
Compared to Power BI, using Power Pivot in Excel isn't as intuitive and easy. Of course, once you get a hang of it, it'll be easier. But against Power BI's interface, Excel's Power Pivot falls a little bit flat. In Power BI, changing from reports to dashboards to datasets is easy.
