In this chapter, we learned the required functionality of MicroStrategy in order to build our BI reports for data analysis and transform data into valuable information for our business needs.

We learned the basic concepts of BI reports, attributes, and metrics. We defined the calculated metrics that leverage the formula options for specific calculations. Also, we learned how to filter data, find specific information, use ranking and threshold functionality, and manage the grid by sorting and summarizing information without complex software installation and IT or BI guru support. We are now able to generate our own reports and use the MicroStrategy platform for our specific reporting needs. Also, we can generate a basic graph for visual representation. The next chapter covers data visualization, and dashboard design and generation in detail.

From the value proposition stand point, we defined the differences between Microsoft Excel and MicroStrategy platform. As you may agree now, MicroStrategy is the best among the breed platforms for BI reports in the market, and Microsoft Excel is the best for data calculations and more sophisticated reports in term of calculations. In the next chapter, you will see more differences between the two.