Besides the grid and graphical objects, a key component of the MicroStrategy platform is the ability to analyze and drill the information in order to resolve business issues, detect trends, opportunities or risks, as well as to define different views of data for different audiences. In this section, we will learn about these capabilities and use them.
MicroStrategy has the capability to add your own metrics (columns used for calculations, cost, revenue, and so on) or attributes (columns that organize and group metrics) besides the data loaded in the model. For advanced analysis, attributes and metrics can leverage mathematical and financial formulas; for example, it is possible to calculate average, standard deviation, sum, and variance as a new attribute, and aggregation and advanced mathematical formulas as the new metrics.
Let's start with some definitions and platform usability. The main interface includes three panels for metrics' and attributes...
