Summary
Power View and PowerPivot are tools that are simple enough for almost everyone to use, and allow you to quickly build reports and dashboards that are useful. It becomes even more useful to the power users since they can also create their own data sources within Excel, a tool that everyone is familiar with using.
Once you start creating dashboards, you will discover that there are a lot of cool features that you can take advantage of. You may want to try:
Adding external Azure services, XML feeds, and Dynamics AX ODataQueries to your PowerPivot data sources. This allows you to blend in dynamic reference data, such as weather, currency rates, or Twitter searches to make your dashboards more informative.
Turning URL columns into pictures to allow your users to filter out the information visually rather than having lo look at codes.
Using geographic information, such as city, state, and country to create geo-mapped reports.
Also, you don't just have to use Power View within Dynamics AX. Since...