Book Image

Mastering Business Intelligence with MicroStrategy

By : Dmitry Anoshin, Himani Rana, Ning Ma, Neil Mehta
Book Image

Mastering Business Intelligence with MicroStrategy

By: Dmitry Anoshin, Himani Rana, Ning Ma, Neil Mehta

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 an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. It lets you various delivery methods such as the Web, desktops, and mobiles. Using real-world BI scenarios, this book helps you to implement Business Analytics solutions in big e-commerce companies. It kicks off with MicroStrategy 10 features and then covers schema design models and techniques. Building upon your existing knowledge, the book will teach you advanced techniques for building documents and dashboards. It further teaches various graphical techniques for presenting data for analysis using maps, graphs, and advanced charts. Although MicroStrategy has rich functionality, the book will show how to customize it in order to meet your business requirements. You will also become familiar with the native analytical functions that will help you to maximize the impact of BI solutions with powerful predictive analytics. Furthermore, the book will focus on MicroStrategy Mobile Analytics along with data discovery and desktop capabilities such as connecting various data sources and building interactive dashboards. The book will also uncover best practices, troubleshooting techniques for MicroStrategy system administration, and also security and authentication techniques. Lastly, you will learn to use Hadoop for MicroStrategy reporting. By the end of the book, you will become proficient in evaluating any BI software in order to choose the best one that meets all business requirements.
Table of Contents (18 chapters)
Mastering Business Intelligence with MicroStrategy
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Preface

Deploying D3 visualization


MicroStrategy Desktop can be easily integrated with D3 visualization. Let's add more charts to our MicroStrategy Desktop:

  1. Go to https://github.com/mstr-dev/Visualization-Plugins and download the ZIP archive.

  2. Extract it.

  3. Copy all folders from the archive to <MicroStrategy Desktop Installation Folder>/code/plugins.

  4. Restart MicroStrategy Desktop.

As a result, we get lots of new visualizations. Let's try to build a simple Sankey diagram.

There is a small dataset:

  • source,target,value

  • Barry,Elvis,2

  • Frodo,Elvis,2

  • Frodo,Sarah,2

  • Barry,Alice,2

  • Elvis,Sarah,2

  • Elvis,Alice,2

  • Sarah,Alice,4

We should copy it and insert it into the clipboard by creating a new dashboard. Moreover, we should wrangle the dataset in order to split values. In addition, we need to convert Value to metric. As a result, we can build this Sankey Chart: