Chapter 2. Reports and Dashboards

In this chapter, we will show you how to create your own ad-hoc reports and dashboards by using tools that you are already using such as Excel, or by using PowerPivot and Power View to create interactive dashboards and reporting galleries. This chapter will cover:

• Creating a Power View report from Dynamics AX

• Creating a Power View report from Power View cubes

• Saving Power View dashboards and reports

• Adding a Power View report to a Role Center

• Exporting a Power View report to PowerPoint

• Creating a PowerPivot gallery in SharePoint

• Creating a PowerPivot data source for Power View

• Creating a Power View report via the PowerPivot gallery

• Linking Power View reports to Dynamics AX forms