Excel has several other features and add-ins that make it a great tool for business intelligence. The following features are worth exploring for your analytics use cases.
For the features that are discussed in the following section, you might need to install additional software on top of Excel.
The PowerPivot allows you to build a data model, calculate key performance indicators (KPI), detect relationships, and visualize using charts or tables. The following screenshot shows you the POWERPIVOT menu:
Power View reports allow a host of new visualizations of your KPIs, including a Map view ...