Book Image

Business Intelligence with MicroStrategy Cookbook

By : Davide Moraschi
Book Image

Business Intelligence with MicroStrategy Cookbook

By: Davide Moraschi

Overview of this book

Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. MicroStrategy Reporting Suite is a complete business intelligence platform that covers all the data analysis needs of an enterprise. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. With the latest Visual Insight tool, MicroStrategy brings the power of BI to the business users, allowing them to discover information without the help of IT personnel. Business Intelligence with MicroStrategy Cookbook covers the full cycle of a BI project with the MicroStrategy platform, from setting up the software to using dashboards in the cloud and on mobile devices. This book uses step-by-step instructions to teach you everything from the very basics to the more advanced topics. We will start by downloading and installing the software and a well-known sample SQL Server database. Then, one brick at a time, we will construct a fully-featured BI solution with a web interface, mobile reporting, and agile analytics. The chapters are ordered by increasing difficulty, and each one builds on top of the preceding chapter so that the learning process is progressive. The examples given in this book are practical, and you will be able to see the immediate result of your efforts. We will first cover setting up the platform, including the creation of the metadata and the different objects that are part of a BI project: tables, attributes, and metrics. Then, we take a look at how to create and analyze reports, charts, documents, and dashboards, as well as how to manipulate data with the desktop application, the web Interface, and an iPad device. The last part of the book is dedicated to advanced topics like the new agile analytics technology from MicroStrategy, where we cover both Visual Insight and MicroStrategy Cloud Express. Whether you are a database developer, data analyst, or a business user, Business Intelligence with MicroStrategy Cookbook will get you up to speed with one of the most powerful BI platforms on the market with the smallest possible investment of time and money.
Table of Contents (25 chapters)
Business Intelligence with MicroStrategy Cookbook
About the Author
About the Reviewers


This book is intended for Business Intelligence (BI) developers who want to expand their knowledge in a technology that is in huge demand at the moment, and for advanced data analysts who are evaluating different technologies. In this first chapter, we will start by downloading and installing the software and a well-known sample SQL Server database. You do not need to be a SQL rock star to read this book, yet some concepts, such as foreign keys or many-to-many relationships, are taken for granted.

Having previous basic knowledge about dimensional modeling (fact tables and dimensions) will also help the comprehension.

The chapters are ordered by increasing difficulties, and each one builds on the top of the preceding, so the learning is progressive; you'll get the most out of it, if you follow the recipes one after the other.

You may already have a working MicroStrategy environment; if so, you can just install the example database and skip the rest of this chapter. However, I suggest using a dedicated installation to follow the recipes; it would be easier and cleaner.

These initial recipes may seem too easy for the more experienced BI specialists, I apologize for that; I only want to be sure that starting from Chapter 2, The First Steps in a MicroStrategy Project, everyone has a common setup.


The operating system installation is outside the scope of this book; nevertheless, it is of vital importance that the machine where you will be doing the exercises is correctly configured and loaded with everything we will need. Throughout the course of this book, I will use Windows 2008 Web Server SP2; I have a VMware virtual machine with 2 GB RAM and two cores. The operating system is 32 bits. You may follow the whole book with a 64-bit software, but the examples and the instructions are written and tested on a 32-bit system. While this is a very small setup for a BI machine, it is enough to start.