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)


This book covers various MicroStrategy 9 capabilities, such as the do-it-yourself approach, import and export of data from or into MicroStrategy, dashboards, scorecards, sharing or distribution of BI reports/dashboards, Cloud BI, and Mobile BI. It also explains standard designs and best practices applicable to each chapter depending on the content and context. This book, from start to finish, will guide you well on the various offerings and practices around creating various analyses using the MicroStrategy platform Cloud service.

What this book covers

Chapter 1, The Value Proposition of MicroStrategy, serves as a guide for the self-service concept, for the prerequisites to install and enable the platform, and for preparing a data set used in the book as a reference. At the end of the chapter, the user will understand the self-service concept and confirm that he can apply the DIY approach.

Chapter 2, Mapping Typical Business Needs, explains to the user the procedure and mechanism, with a very practical approach, of how to map business needs to MicroStrategy components. At the end of this chapter, users will have a clear understanding of how to map their real business to MicroStrategy components.

Chapter 3, Reporting – from Excel to Intelligent Data, explains the procedures and gives hints to design, build, and deploy BI reports using the MicroStrategy platform. The users will be able to generate their first report and analyze data based on a real business need.

Chapter 4, Scorecards and Dashboards Information Visualization, explains the procedures and mechanisms to design, build, and deploy scorecards and dashboards, focalized in the self-service approach. At the end of this chapter, the user will be able to identify the objects and rules of MicroStrategy for enabling dashboards and scorecards. This chapter will also serve as a practical guide for users to develop their own dashboards.

Chapter 5, Sharing Your BI Reports and Dashboards, covers the procedures to share reports and the subscription engine. At the end of this chapter, the user will be able to set up MicroStrategy components in order to share the reports to defined audiences in an automatic schema.

Chapter 6, MicroStrategy and the Cloud, explains the Cloud offering of MicroStrategy and its usage. At the end of this chapter, the user will be able to identify the Cloud offering of MicroStrategy and see that it is ready to use with basic models.

Chapter 7, BI Reports at Your Hands, explains the mobile offering of MicroStrategy, with some practical recommendations and guidelines to enable it. At the end of the chapter, the user will be able to identify the offering of MicroStrategy in the mobile arena, and will be able to design and build a specific model in an iPad and Android device.

Appendix A, MicroStrategy Express, explains the various types of MicroStrategy Cloud offerings with relevant screenshots.

Appendix B, Visualization, explains various visualization properties and some of the key visualizations in detail.

What you need for this book

  • A MicroStrategy account to enable the Cloud express service

  • Microsoft Excel

Who this book is for

This book is best for a beginner MicroStrategy developer or an analyst who wants to get more insight on various MicroStrategy business intelligence features and offerings. Senior MicroStrategy users can also benefit from the latest product offerings around Cloud and mobile implementations. Also, this book is useful for business users who want to analyze their data on their own using MicroStrategy. Though this book begins with the core concepts of business intelligence with MicroStrategy, it would be helpful to have some prior familiarity on business intelligence products and their applications.


In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "We can include other contexts through the use of the include directive."

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Select the Profit by Employee filter."


Warnings or important notes appear in a box like this.


Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to , and mention the book title via the subject of your message.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Downloading the example code

You can download the example code files for all Packt books you have purchased from your account at If you purchased this book elsewhere, you can visit and register to have the files e-mailed directly to you.

Downloading the color images of this book

We also provide you a PDF file that has color images of the screenshots/diagrams used in this book. The color images will help you better understand the changes in the output. You can download this file from: Please use the link:


Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from


Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.


You can contact us at if you are having a problem with any aspect of the book, and we will do our best to address it.