Book Image

Discovering Business Intelligence using MicroStrategy 9

Book Image

Discovering Business Intelligence using MicroStrategy 9

Overview of this book

Business Intelligence is a type of technology that has been proven to support business decisions in an organization. MicroStrategy 9 is a fully-integrated BI platform that makes Business Intelligence faster, easier, and more user-friendly. It enables businesses to generate their own reports and dashboards without the need for technical knowledge.This practical, hands-on guide will provide Business Intelligence for executives, as well as enable BI reports and dashboards without the dependency of IT savvy personnel. It will allow you to design, build, and share business relevant data in hours, in a secure way, including mobile devices and show you how to leverage your transactional information.This example-oriented book looks at the value proposition of cloud computing and the MicroStrategy platform, and features practical exercises for BI reports and dashboard enablement, including the design phase and best practices for when we design a BI report.The book begins with an exploration of MicroStrategy along with typical business needs. Our focus then shifts to best practices for BI reports and dashboard definitions from the functional stand point, with easy-to-do exercises that will allow you to enable the reports in the platform. You will learn about scorecards and dashboards, along with sharing the reports. Next, you will get acquainted with cloud-based services provided by the MicroStrategy platform. By the end of this book, you will able to design, enable, and share BI reports and dashboards without the need for comprehensive technical knowledge, and leverage the latest technology on the market.
Table of Contents (16 chapters)

Analyze data


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.

Advanced metrics and attributes

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...