Database Reference
In-Depth Information
How it works...
The add-ins for Microsoft Excel provide additional functionality to gather and analyze Sys-
tem Center data. Wizards can be added, interfaces can be made available to combine differ-
ent sources, and a common language,
Data Analysis SyntaX
(
DAX
), can be made avail-
able for calculations and performing different forms of visualizations.
The steps discussed in this recipe are required for the use of the Power BI features and
functionality using Microsoft Excel. You followed the steps to install Power Query and
Power Map, and you enabled PowerPivot and Power Views. These add-ins provide the
foundation for self-service Business Intelligence using Microsoft Excel.
