O'Reilly logo

HDInsight Essentials - Second Edition by Rajesh Nadipalli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Other BI features in Excel

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.

Note

For the features that are discussed in the following section, you might need to install additional software on top of Excel.

PowerPivot

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:

PowerPivot

Power View and Power Map

Power View reports allow a host of new visualizations of your KPIs, including a Map view ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required