Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Mastering Business Intelligence with MicroStrategy
  • Toc
  • feedback
Mastering Business Intelligence with MicroStrategy

Mastering Business Intelligence with MicroStrategy

By : Dmitry Anoshin, Rana, Ma, Neil Mehta
3.7 (7)
close
Mastering Business Intelligence with MicroStrategy

Mastering Business Intelligence with MicroStrategy

3.7 (7)
By: Dmitry Anoshin, Rana, 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 (13 chapters)
close

Performing Pareto analysis


One good thing about data discovery tools is their agile approach to the data. We can connect any data source and easily slice and dice data. Let's try to use the Pareto principle in order to answer the question: How are sales distributed among the different products?

The Pareto principle states that, for many events, roughly 80% of results come from 20% of the causes. For example, 80% of profits come from 20% of the products offered. This type of analysis is very popular in product analytics.

In MicroStrategy Desktop, we can use shortcut metrics in order to quickly make complex calculations such as running sums or a percent of the total.

Let's build a visualization in order to see the 20% of products that bring us 80% of the money:

  1. Choose Combo Chart.

  2. Drag and drop Salesamount to Vertical and Englishproductname to Horizontal.

  3. Add Orderdate to the filters and restrict to 60 days.

  4. Right-click on Sales amount and choose Descending Sort.

  5. Right-click on Salesamount | ShortcutMetrics...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete