Chapter 1, Getting Started with MicroStrategy, covers the installation of training environments, complete with sample data, MicroStrategy Suite, metadata, and ODBC connections. Operating system and web server configuration are also covered.

Chapter 2, The First Steps in a MicroStrategy Project, explains the creation of a project: how to connect to a data warehouse, the use of tables as data sources, and how to create logical views with SELECT statements.

Chapter 3, Schema Objects – Attributes, shows the creation of the first objects: attributes and hierarchies, and how attributes relate to each other (parent-child relationship). We create our first report during this chapter.

Chapter 4, Objects – Facts and Metrics, covers the numbers: the use of aggregation functions, how to filter on metrics, the creation of level metrics, and a basic "previous month" transformation.

Chapter 5, Data Display and Manipulation – Reports, treats the design and manipulation of reports in the desktop application. Drill, page-by, custom subtotals, and conditional formatting are shown with practical tips and real-life examples.

Chapter 6, Data Analysis and Visualization – Graphs, covers the graphical part of data analysis, showing how to create compelling graphs with the use of the most common options. Advanced charting techniques like dual axis are demonstrated too.

Chapter 7, Analysis on the Web – Documents and Dashboards, shows how to port the project to the Web, set up the server, and create documents and interactive dashboards for consumption in the Internet browser.

Chapter 8, Dynamic Selection with Filters and Prompts, explains the usage of different filtering techniques and how to use dynamic selections to customize reports. It also explains the use of moving dates in filters.

Chapter 9, Mobile BI for Developers, covers the installation and configuration of mobile Business Intelligence. It shows how to design ad hoc reports and documents for the iPad, using linked documents and info windows.

Chapter 10, Mobile BI for Users, covers the most common scenarios for mobile usage and gives insights and tips on how to consume data (and ask for help) from the user's perspective.

Chapter 11, Consolidations, Custom Groups, and Transformations, explains advanced techniques and objects to solve specific reporting requirements, such as different aggregations, creating banded reports, or month-to-date and year-to-date running sums.

Chapter 12, In-Memory Cubes and Visual Insight, covers the latest In-Memory technology to create Visual Insight dashboards and self-service data discovery from the web interface. It demonstrates the usage of the new network graph visualization.

Chapter 13, MicroStrategy Express, introduces the SaaS version of MicroStrategy self-service data discovery tool and dashboards. It shows how to upload data or connect to on-premises and cloud-based databases to design interactive panels and visualizations without support from the IT personnel.

Appendix A, Solution to Exercises, gives answers to all the questions and exercises of the book.

Appendix B, Where to Look for Information, is a collection of useful resources, blogs, books, and discussion groups to network with fellow BI developers.

Appendix C, Cloudera Hadoop, explains how to connect from MicroStrategy to one of the most commonly used platforms for Big Data. The distribution used is CH4 with Impala.

Appendix D, HP Vertica, demonstrates the connection to a common platform for columnar databases, the Vertica engine by HP. The distribution used is the Community Edition, freely available from the vendor site.