Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Mastering Business Intelligence with MicroStrategy
Mastering Business Intelligence with MicroStrategy

Mastering Business Intelligence with MicroStrategy: Master Business Intelligence with Microstrategy 10

Arrow left icon
Profile Icon Dmitry Anoshin Profile Icon Neil Mehta Profile Icon Ma Profile Icon Rana
Arrow right icon
$65.99
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.7 (7 Ratings)
Paperback Jul 2016 396 pages 1st Edition
eBook
$35.99 $51.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m
Arrow left icon
Profile Icon Dmitry Anoshin Profile Icon Neil Mehta Profile Icon Ma Profile Icon Rana
Arrow right icon
$65.99
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.7 (7 Ratings)
Paperback Jul 2016 396 pages 1st Edition
eBook
$35.99 $51.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m
eBook
$35.99 $51.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Table of content icon View table of contents Preview book icon Preview Book

Mastering Business Intelligence with MicroStrategy

Chapter 1. Getting Started with MicroStrategy

The modern market for Business Intelligence (BI) tools is full of various products with different advantages and disadvantages. For example, some of them are easy to deploy but hard to maintain. Another has strong data discovery capabilities but restricted data governance and struggles with complex enterprise data models. MicroStrategy 10 is one of the leading platforms on the market, can handle all data analytics demands, and offers a powerful solution. It combines self-service BI, data discovery and preparation, and big data exploration, bringing the vision of a single-vendor solution within reach of BI and analytics leaders. It combines data discovery and enterprise BI in a single platform, allowing organizations to invest in a single vendor that provides both agile self-service BI and traditional reporting, with integration between the two.

This chapter will cover:

  • BI best practices
  • BI maturity model
  • MicroStrategy 10 new features
  • Deploying MicroStrategy 10 on top of Linux
  • Deploying business case

Modern BI

According to a Gartner survey conducted among 2,800 CIOs of top companies, BI and analytics remain the number one investment priority. MicroStrategy has done a great job since 1991. MicroStrategy is a leader in Enterprise BI and can handle the modern demand for BI and analytics.

MicroStrategy 10 can easily handle modern hot topics such as big data analytics, predictive analytics, and mobile analytics. It is easily scalable and secure.

The main roles of BI are to discover new opportunities, improve processes, help to make the right decisions at the right time and reduce operational costs. As a result, BI tools should improve business performance and help to meet organizational goals, such as higher revenue, lower costs, and decreased risks.

BI market

Nowadays, we see lots of BI tools. Sometimes, we have to ask "What is the best BI tool?" In order to find the answer, we can look at reports from two main analytical agencies: Gartner and Forrester. Here is the Gartner Magic Quadrant for BI & Analytics Platforms for 2015:

BI market

This quadrant shows us the leaders in the market. But do not trust this rating, because it is a kind of marketing. The best way to understand the pros and cons of any BI tool is practically; just download and install a trial version and play with it. Most tools, especially the leading ones, have common functionality or similar features. A good example is the interface of Tableau. It is so good that other companies have tried to reproduce it in their own products.

Maturity level of the organization

Every organization uses BI. The question is, just how good are they? Even if the organization does not have BI at all, it at least uses spreadsheets to consolidate numbers. This is also a kind of BI. We can observe many levels of BI maturity. Let us try to demonstrate this, based on four phases shown here:

Maturity level of the organization

The first phase is Scattered Reporting, in other words, the organization doesn't have any BI solution and even doesn't try one. Various departments grab data from transaction systems and try to figure out what's going on. We see this situation especially in startups or small companies. It is the most inefficient way to measure business and make decisions.

Tip

If you are at the beginning of your analytics journey, then we highly recommend you meet Lean Analytics methodology.

The next phase is Centralized BI Solution. It is the most common approach nowadays, when organizations build corporate data warehouses, integrate data from internal sources and systems, deploy a BI solution, and try to force everyone to use a single point of truth. It is a long journey to leave this phase, and sometimes it is an endless process because business constantly changes.

The third phase is Big Data Analytics. Despite the fact that the term big data is almost gone, we still use it, because it is a very popular phrase that means lots of unstructured data such as social data, open source data, and so on. In other words, organizations try to enrich their internal data in order to find more insights. As a result, companies are forced to use new technologies such as Hadoop or NoSQL datastores. In addition, companies start to use machine learning technologies and try to make them part of their BI framework.

The last phase is Real-time Mobile Business Insight. This phase means that finally organizations can focus on the speed of delivery of business insights, their mobility, and predictive capabilities.

Of course, this maturity model is not standard, we just tried to structure BI maturity levels based on our experience. MicroStrategy can handle even the final phase, a real competitive advantage.

BI project life cycle

Every BI project has its own life cycle. Let us look at a common life cycle:

BI project life cycle

The first step is Analyze Business requirements, which means that we should gather the business requirements and transform them into functional and non-functional specifications, create a template for reports, and so on. The next step is Design the logical data model, where we build a logical data model based on business requirements, which shows the business entities and the relationships between them. The third step is Design the physical data model, where we transform the logical data model into a physical data model which defines the structure of the data warehouse. The fourth step is Build the data warehouse. In this step, we create the data warehouse, build data marts, and load data.

On the fifth step, Create the Project, we start to work directly in MicroStrategy, where we define schema, attributes, facts, hierarchies and so on. All this information is stored in metadata, the core of MicroStrategy, in a relation database. The sixth step is Develop Reports/Documents and of course dashboards. In addition, we share our insights across the organization using various channels such as email, FTP, and so on.

Meet MicroStrategy 10

MicroStrategy is a market leader in BI products. It has rich functionality in order to meet the requirements of modern businesses. In 2015, MicroStrategy provided a new release of MicroStrategy, version 10. It offers both agility and governance like no other BI product. In addition, it is easy to use and enterprise ready. At the same time, it is great for both IT and business. In other words, MicroStrategy 10 offers an analytics platform that combines an easy and empowering user experience, together with enterprise-grade performance, management, and security capabilities. It is true bimodal BI and moves seamlessly between styles:

  • Data discovery and visualization
  • Enterprise reporting and dashboards
  • In-memory high performance BI
  • Scales from departments to enterprises
  • Administration and security

MicroStrategy 10 consists of three main products: MicroStrategy Desktop, MicroStrategy Mobile and MicroStrategy Web.

MicroStrategy Desktop lets users start discovering and visualizing data instantly. It is available for Mac and PC. It allows users to connect, prepare, discover, and visualize data. In addition, we can easily promote to a MicroStrategy Server. Moreover, MicroStrategy Desktop has a brand new HTML5 interface and includes all connection drivers. It allows us to use data blending, data preparation, and data enrichment. Finally, it has powerful advanced analytics and can be integrated with R.

To cut a long story short, we want to notice the main changes of the new BI platform. All developers keep the same functionality, the looks as well as architect the same. All changes are about web interface and Intelligence Server. Let's look closer at what MicroStrategy 10 can show us.

MicroStrategy 10 expands the analytical ecosystem by using third-party toolkits such as:

  • Data visualization libraries: We can easily plug in and use any visualization from the expanding range of Java libraries
  • Statistical toolkits: R, SAS, SPSS, KXEN, and others
  • Geolocation data visualization: This uses mapping capabilities to visualize and interact with location data

MicroStrategy 10 has more than 25 new data sources that we can connect to quickly and simply. In addition, it allows us to build reports on top of other BI tools, such as SAP Business Objects, Cognos, and Oracle BI. It has a new connector to Hadoop, which uses the native connector. Moreover, it allows us to blend multiple data sources in-memory.

Meet MicroStrategy 10

We want to notice that MicroStrategy 10 has got reach functionality for work with data such as:

  • Streamlined workflows to parse and prepare data
  • Multi-table in-memory support from different sources
  • Automatically parse and prepare data with every refresh
  • 100+ inbuilt functions to profile and clean data
  • Create custom groups on the fly without coding

In terms of connection to Hadoop, most BI products use Hive or Impala ODBC drivers in order to use SQL to get data from Hadoop. However, this method is bad in terms of performance. MicroStrategy 10 queries directly against Hadoop. As a result, it is up to 50 times faster than via ODBC.

Let's look at some of the main technical changes that have significantly improved MicroStrategy. The platform is now faster than ever before, because it doesn't have a two-billion-row limit on in-memory datasets and allows us to create analytical cubes up to 16 times bigger in size. It publishes cubes dramatically faster. Moreover, MicroStrategy 10 has higher data throughput and cubes can be loaded in parallel 4 times faster with multi-threaded parallel loading. In addition, the in-memory engine allows us to create cubes 80 times larger than before, and we can access data from cubes 50% faster, by using up to 8 parallel threads. Look at the following table, where we compare in-memory cube functionality in version 9 versus version 10:

Feature

Ver. 9

Ver. 10

Data volume

100 GB

~2TB

Number of rows

2 billion

200 billion

Load rate

8 GB/hour

~200 GB/hour

Data model

Star schema

Any schema, tabular or multiple sets

In order to make the administration of MicroStrategy more effective in the new version, MicroStrategy Operation Manager was released. It gives MicroStrategy administrators powerful development tools to monitor, automate, and control systems. Operations Manager gives us:

  • Centralized management in a web browser
  • Enterprise Manager console within Tool
  • Triggers and 24/7 alerts
  • System health monitors
  • Server management
  • Multiple environment administration

MicroStrategy 10 education and certification

MicroStrategy 10 offers new training courses that can be conducted offline in a training center, or online at http://www.microstrategy.com/us/services/education. We believe that certification is a good thing on your journey. The following certifications now exist for version 10:

  • MicroStrategy 10 Certified Associated Analyst
  • MicroStrategy 10 Certified Application Designer
  • MicroStrategy 10 Certified Application Developer
  • MicroStrategy 10 Certified Administrator

After passing all of these exams, you will become a MicroStrategy 10 Application Engineer. More details can be found here: http://www.microstrategy.com/Strategy/media/downloads/training-events/MicroStrategy-certification-matrix_v10.pdf.

History of MicroStrategy

Let us briefly look at the history of MicroStrategy, which began in 1991:

  • 1991: Released first BI product, which allowed users to create graphical views and analyses of information data
  • 2000: Released MicroStrategy 7 with a web interface
  • 2003: First to release a fully integrated reporting tool, combining list reports, BI-style dashboards, and interface analyses in a single module.
  • 2005: Released MicroStrategy 8, including one-click actions and drag-and-drop dashboard creation
  • 2009: Released MicroStrategy 9, delivering a seamless consolidated path from department to enterprise BI
  • 2010: Unveiled new mobile BI capabilities for iPad and iPhone, and was featured on the iTunes Bestseller List
  • 2011: Released MicroStrategy Cloud, the first SaaS offering from a major BI vendor
  • 2012: Released Visual Data Discovery and groundbreaking new security platform, Usher
  • 2013: Released expanded Analytics Platform and free Analytics Desktop client
  • 2014: Announced availability of MicroStrategy Analytics via Amazon Web Services (AWS)
  • 2015: MicroStrategy 10 was released, the first ever enterprise analytics solution for centralized and decentralized BI

Deploying MicroStrategy 10

We know only one way to master MicroStrategy, through practical exercises. Let's start by downloading and deploying MicroStrategy 10.2.

Overview of training architecture

In order to master MicroStrategy and learn about some BI considerations, we need to download the all-important software, deploy it, and connect to a network. During the preparation of the training environment, we will cover the installation of MicroStrategy on a Linux operating system. This is very good practice, because many people work with Windows and are not familiar with Linux, so this chapter will provide additional knowledge of working with Linux, as well as installing MicroStrategy and a web server. Look at the training architecture:

Overview of training architecture

There are three main components:

  1. Red Hat Linux 6.4: Used for deploying the web server and Intelligence Server.
  2. Windows machine: Uses MicroStrategy Client and Oracle database.
  3. Virtual machine with Hadoop: Ready virtual machine with Hadoop, which will connect to MicroStrategy using a brand new connection.

In the real world, we should use separate machines for every component, and sometimes several machines in order to run one component. This is called clustering. Let's create a virtual machine.

Creating a Red Hat Linux virtual machine

Let's create a virtual machine with Red Hat Linux, which will host our Intelligence Server:

Now we can create a virtual machine with RHEL 6.4. We have several options in order to choose the software for deploying virtual machine. In our case, we will use a VMware workstation.

Before starting to deploy a new VM, we should adjust the default settings, such as increasing RAM and HDD, and adding one more network card in order to connect the external environment with the MicroStrategy client and sample database. In addition, we should create a new network.

When the deployment of the RHEL virtual machine is complete, we should activate a subscription in order to install the required packages. Let us do this with one command in the terminal:

# subscription-manager register --username <username> --password 
    <password> --auto-attach

Performing prerequisites for MicroStrategy 10

According to the installation and configuration guide, we should deploy all necessary packages. In order to install them, we should execute them under the root:

# su
# yum install compat-libstdc++-33.i686
# yum install libXp.x86_64
# yum install elfutils-devel.x86_64
# yum install libstdc++-4.4.7-3.el6.i686
# yum install krb5-libs.i686
# yum install nss-pam-ldapd.i686
# yum install ksh.x86_64

Moreover, we should change the parameters of the kernel:

# nano/etc/sysctl.conf
kernel.sem=250 32000 32 2048
kernel.shmmni = 4096
vm.max_map_count=5242880

Performing prerequisites for MicroStrategy 10

Then, save and reboot.

Installing MicroStrategy 10 Intelligence Server

In order to download MicroStrategy software, we should already have an account on the MicroStrategy Resource Portal at https://resource.microstrategy.com, or we can create one using a corporate email address. Even if we do not have a license for MicroStrategy, we can obtain one for 30 days. That is enough to finish this book and learn the new features of MicroStrategy 10.

MicroStrategy 10.2 is available, and we are going to use this version in the book.

Let's download distributive 10.2.0008.0052_10.2_GA_Linux.tar and put it on the virtual machine with Linux 10.2.0008.0052_10.2_GA_Linux.tar.

Let's create a folder for MicroStrategy using the root user and change its rights in order to extract the archive into this folder:

# mkdir mstr10
# chmod 777 mstr10

Then we should extract the MicroStrategy distributive into our new folder. We can use the default Archive Manager.

After successful extraction, we should create four folders for MicroStrategy, in order to deploy the software and write the installation logs.

Using the root user, we can run the following commands:

# mkdir /mstr10/microstrategy
# mkdir /mstr10/microstrategy_home
# mkdir /mstr10/microstrategy_logs
# mkdir /mstr10/microstrategy_health_agent

Installation process

By default, there are three methods of installation for MicroStrategy Server:

  • GUI: The most common approach, using a graphical interface and navigation with a mouse
  • Command line: The approach for terminal-only machines
  • Silent installation: Automatic installation process that does not need human participation, but it is important to think about parameters and settings

In Red Hat, we have a GUI and can use its benefits. Let's install:

# cd /mstr10/Installations/QueryReportingAnalysis_Linux
# ./setup.sh
user name Microstrategy
name masteringbi

Copy and paste your license key.

Choose the destination locations that we have already created:

  • Home directory: /mstr10/microstrategy_home
  • Install directory: /mstr10/microstrategy
  • Log directory: /mstr10/microstrategy_logs
  • Health agent: /mstr10/microstrategy_health_agent

All the other parameters we can leave as is.

Configuring Intelligence Server

After successful installation of MicroStrategy 10.2, we should set up a MicroStrategy repository and connect it to the Intelligence Server. In our case, we will use a PostgreSQL database on the RHEL virtual machine for the repository.

Installing a PostgreSQL database

Let's download and install the PostgreSQL database server:

# yum install postgresql-server
# service postgresql initdb
# chkconfig postgresql on
# service postgresql start
# s
# psql

Creating a metadata database

Let's create a new database in PostgreSQL for MicroStrategy metadata. In order to do this, we should go to the terminal and run the following:

# psql
# CREATE DATABASE mstrmd;
# CREATE USER mstr PASSWORD 'happy2016';
# GRANT ALL ON DATABASE mstrmd TO mstr;

In addition, we should register the plpgsql language in our new database:

# \c mstrmd
# CREATE TRUSTED LANGUAGE plpgsql;

By default, PostgreSQL uses IDENT-based authentication, and this will never allow you to log in with a username and password. We should change the method of authentication by modifying the pg_hba.conf file. Go to this folder:

# cd /var/lib/pgsql/data
# nano pg_hba.conf

Replace IDENT on trust and restart PostgreSQL:

# service postgresql restart

Creating a metadata data source

Using the MicroStrategy connectivity wizard, we can create a new DSN. In order to open the wizard, we should run the following commands:

# cd /mstr10/microstrategy_home/bin
# ./mstrconnectwiz

Let's choose PostgreSQL ODBC driver and fill in the form with our credentials:

Creating a metadata data source

MicroStrategy has a configuration file that keeps all DSNs. We can create a new DSN directly in this file. We can look at our new DSN like this:

# vi /mstr10/microstrategy_home/odbc.ini

Here is our DSN metadata. In addition, we can configure the parameters of our connection in order to increase performance.

Creating metadata tables

In order to create metadata tables in the brand new database, we should run Configuration Wizard:

# cd /mstr10/microstrategy_home/bin
# ./mstrcfgwiz

During this process, wizard will automatically:

  • Create metadata tables and history list tables
  • Configure Intelligence Server

Tip

MicroStrategy metadata is a core piece of software. In other words, the number of tables in a database that contain a definition of all MicroStrategy objects.

In Configuration Wizard, we should create a new database and choose our DSN:

Creating metadata tables

The next step is the configuration of Intelligence Server using fresh metadata tables. We can use masteringbi as a server definition. After successful configuration we can close wizard and deploy MicroStrategy Web.

Installation of MicroStrategy Web

We need a web server in order to deploy MicroStrategy Web and other components, such as Mobile Server and Operations Manager. For this book, we have chosen the Tomcat web server as our web application server.

Web application server installation

Let us install Tomcat on our RHEL server. Open the terminal and give the following commands:

  1. Install Java if it is needed:
    # yum install java-1.8.0-openjdk
    # java -version
    openjdk version "1.8.0_65"
    
  2. Download and deploy the Tomcat server:
    # cd /tmp
    # wget 
          http://www.us.apache.org/dist/tomcat/tomcat-7/v7.0.67/
          bin/apache-tomcat-7.0.67.tar.gz 
    # tar xzf apache-tomcat-7.0.67.tar.gz 
    # mv apache-tomcat-7.0.67 /usr/local/tomcat7
    
  3. Run Tomcat:
    # cd /usr/local/tomcat7
    # ./bin/startup.sh
    
  4. Create a Tomcat user for MicroStrategy Web:
    # cd /usr/local/tomcat7/conf
    # nano tomcat-users.xml 
      <role rolename="admin"/>
      <role rolename="manager-gui"/>
      <user username="admin" password="admin" roles="admin,manager-gui"/>
    
  5. Then, restart Tomcat.

In order to access Tomcat, we should go to http://localhost:8080/.

Deploying WAR files

Now we can deploy MicroStrategy Web and Operations Manager on a brand new Tomcat server. Let's do it:

# cp /mstr10/microstrategy/OperationsManager/MicroStrategyWeb.war 
      /usr/local/tomcat7/webapps
# cp /mstr10/microstrategy/OperationsManager/MicroStrategyOM.war 
      /usr/local/tomcat7/webapps

Then we need restart Tomcat:

# /usr/local/tomcat7/bin/shutdown.sh
# /usr/local/tomcat7/bin/startup.sh

After deploying, we should go to the web admin:

http://localhost:8080/MicroStrategy/servlet/mstrWebAdmin

Then, connect to our server. We can do this just by adding the localhost server. In properties, we should mark that it automatically connects to Intelligence Server.

Later in the book, we will create projects and they will be available here:

http://localhost:8080/MicroStrategy/servlet/mstrWeb

In addition, we can go to Operations Manager in order to configure it:

http://localhost:8080/MicroStrategyOM/servlet/mstrOM

Tip

If you change the war filename, you will have to use a different URL. For example, mstr.war the URL will be http://localhost:8080/mstr.

The Operation Manager will be configured in Chapter 9, MicroStrategy System Administration.

We have finished the installation and configuration of Intelligence Server. Now we need to install the MicroStrategy Client tools on the Windows machine.

We should open a port in the firewall for Tomcat on the Linux machine, in order for the Windows machine to access it:

# nano /etc/sysconfig/iptables

Add a new line for port 8080:

-A INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT

We should also open a port for Intelligence Server:

-A INPUT -m state --state NEW -m tcp -p tcp --dport 34952 -j ACCEPT

Then, restart the service:

# service iptables restart

As a result, we can access MicroStrategy from Windows.

Creating a network

According to our training architecture, we will use at least two machines. One is a Windows machine for client tools and the Oracle database, and a Linux machine for Intelligence Server and the PostgreSQL repository database. Let's look at how we can quickly create a network. This knowledge is very important for BI guys, because usually BI software has complex architecture and communicates with each other through the network. In our small example, the reader can learn basic considerations for building a network between several machines. Let's build a network using VMware:

  1. At the top of the VMware Workstation desktop, select Edit and then select Virtual Network Editor.
  2. Change the settings on this screen to match these:

    Creating a network

  3. Enable Use local DHCP service to distribute IP address to VMs.
  4. Click the OK button. Now the preset IP address included in the images should work for VMware Workstation and VMware Player.
  5. Open Control Panel and locate the Network and Sharing Center option. Double-click on it.
  6. The private network is the bridged adapter and the public network is host-only. If your image is not making connections, look at the properties of the public network. Select the Local Area Connection 2 link:

    Creating a network

  7. Click the Properties button.
  8. Select the Internet Protocol Version 4 (TCP/IPv4) entry and then click the Properties button.

    Creating a network

Now we should change the network for Red Hat also. Let's do it:

  1. Go to the terminal and run the system-config-network utility to change the IP address:
    # system-config-network
    
  2. With the red highlight on the Device Configuration option, press the Enter key.
  3. If you need to update the IP address, use the cursor keys to move up and down through the fields and then you can make the update. Use the cursor keys or the Tab key to move to the Ok button and press the Enter key or the spacebar to select Ok.

    After you work your way back to the first screen, you'll have to use the Tab key to navigate to the Save & Quit button:

    Creating a network

  4. Restart the network service:
    # service network restart
    
  5. Check the result:
    # ifconfig
    

As a result, the Linux and Windows machines now live on one network and can easy communicate with each other. Using this approach, we can connect other machines that run other software. For example, we could run Oracle on a separate machine. In addition, we can create a cluster of several machines running MicroStrategy.

Tip

MicroStrategy prefers up to four nodes in a cluster, but you can install more than four if you want.

Now we can install the MicroStrategy Client tools and connect Intelligence Server.

Installing MicroStrategy 10 tools

One of the simplest tasks is installing the client tools on the Windows machine. We should install the following software:

  • MicroStrategy Analyst
  • MicroStrategy Developer
  • MicroStrategy Architect
  • MicroStrategy Server Administrator
  • MicroStrategy Object Manager
  • MicroStrategy Command Manager
  • MicroStrategy System Manager
  • MicroStrategy Integrity Manager

We should connect to our Intelligence Server, which is based on RHEL. Let's run Developer on port 34952 with the server name as the IP address 192.168.81.134. There are not any projects yet, but soon we will create one good project using our great expertise.

Installing Oracle database

For our book, we decided to use Oracle 11g because it is the most popular RDBMS in the world. We can download Oracle from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html.

In our case, we will install it on the same machine as MicroStrategy, in order to save resources. In the real world, we should use a separate server. The installation process is pretty simple and straightforward. Just download the software and run setup.exe.

Deploying data in Oracle database

The last step before finishing this chapter is to deploy our sample database, which we will use throughout this book in order to build advanced visualizations, dashboards, and many other things.

There are SQL files in the attachment that comes with this book. We are going to deploy these in our Oracle database:

  • Schema.sql
  • dw.sql

In order to deploy these files in the Oracle database, we should:

  1. Run SQLPlus.
  2. Connect to the Oracle database as a system user.
  3. Run these commands:
    @<Full_path>/Schema.sql;
    @<Full_path>/dw.sql;
    

In the next chapter, we will create a schema based on this database.

BI tips

We want to share some of our tips that help to improve perception of BI users and make their lives a little bit easier. We also want to share some great books and training that can help to increase skills and expertise, in order to grow within your organization or find a better job.

BI skills

We want to share some important skills from experienced BI developers. These cover several areas:

  • BI software: There are many BI tools on the market but they have many features in common. That's why it is good to master MicroStrategy, then it is easy to understand how others work.
  • Dimensional modeling: This approach is the most popular design schema.
  • Data modeling: Before starting to develop schema, we should understand the corporate data model, that's why we should learn how to read models.
  • Databases: Nowadays, relational databases are the most popular choice for data warehouses. As BI tools, there are plenty of databases, but all of them run SQL and have different advantages and disadvantages.
  • Network knowledge: Usually BI tools use three-tier architecture; as a result it is good to know how to set up the network, open the network ports, and so on.
  • Visualization: It is a well-known fact that graphical representation of data is the most effective way to represent data.
  • Security: There are many users who work with BI and have different levels of access. It is very important to understand security topics and different ways of authenticating users.
  • Unix operational systems: Usually big companies prefer to use Unix systems as their main operating system for software, because they are reliable. However, they have a console or a terminal, which is why it is good to have knowledge of working with such operating systems.

Tip

According to the MicroStrategy documentation, it runs faster in a Linux environment.

There is no secret to how to master BI. There is only one way - constantly learn through reading and technical exercises. www.packtpub.com offers us plenty of technical books that can help us to solve any technical issues.

The most critical skill for a BI developer is to quickly find a solution using Google. It is impossible to store all relevant information in our head, but we can easily Google it and find the right solution. Do not hesitate to ask Google if you are struggling.

BI users' development

One hot topic is the happiness of business users. Usually they are not technical guys and often struggle with report development. Another difficulty is that there are many attributes and metrics in the data warehouse, and sometimes we can't use them in one query because it could produce cross joins and even crash the database. There is only one solution - constantly train them and give them the opportunity to learn the technical and business sides of BI solutions. As a result, the BI department should develop two streams of training - business and technical. Technical training relates to BI software. For example, our book is an advanced training for MicroStrategy. At the same time, business users should learn different business cases. For example, how they can build reports in order to compare revenue for 2014 and 2015 across all branches in Canada?

The main challenge of this training is to motivate business users. But there is a lack of time to learn. As a result, they make wrong decisions on inaccurate data. In order to involve them in the training process, we want to share one of our success stories.

One of the authors implemented BI Academy. It was an internal brand; users who successfully finish the training and pass the internal exam get a branded T-shirt:

BI users' development

In order to make the training process fun, the author used special software that offers the opportunity to create cartoons:

BI users' development

These guys were very popular because they helped to solve real business problems. Another piece of advice is to contact heads of department and encourage them to make this online training mandatory for employees. There are some training courses based on this approach on YouTube: https://www.youtube.com/channel/UCAGzL89m1L3c675hn7DE2Uw

Or you can see the MicroStrategy example here:

https://www.youtube.com/channel/UCLDoF-D_CH51CfGVEn8PBvQ

BI portal

The final thing that is good to have in an organization is a BI portal. When companies run BI solutions, they do it for users. Usually, BI users are not technical. The best practice is to build BI and integrate it into an intranet website. For example, in the attachment to this chapter, there is a file called sweet home.html. It is not a BI portal, but it demonstrates the idea very well. It helps business users and developers to quickly get the latest news about BI changes and innovations. Moreover, it links to BI environments and training. For example, the company can use Microsoft SharePoint because it is easy to deploy, and we can easily integrate it with MicroStrategy and Office products.

Summary

In this chapter, we talked about BI and shared our thoughts on some BI-related topics, as well as some tips that can improve the BI ecosystem. We then met MicroStrategy 10 and its new features. Finally, we deployed MicroStrategy 10 on top of Red Hat Linux and Tomcat. In addition, we deployed Oracle and a sample database.

In the next chapter, we are going to create a semantic layer and learn best practices for Oracle integration, as well as the creation of schema and schema objects.

Left arrow icon Right arrow icon

Key benefits

  • Fix the gap between BI tools and implementation/integration processes with big data and predictive analytics using this comprehensive guide to MicroStrategy 10
  • Highly practical, example-rich guide that lets you implement business intelligence with MicroStrategy 10 in your organization
  • Create the best user experience with BI dashboards using MicroStrategy using this up-to-date, comprehensive guide

Description

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.

Who is this book for?

This book is intended for BI, DWH, ETL developers, BI/DWH/Analytics managers, analysts, and business users who already have MicroStrategy in their organization and want to take it to the next level in order to increase performance and improve user experience. In addition, it helps the reader to migrate from MicroStrategy 9 to MicroStrategy 10 and to start using the new capabilities.

What you will learn

  • Explore various visualization techniques for presenting analyzed data
  • Customize MicroStrategy in order to meet your business requirements
  • Develop and design mobile dashboards
  • Use the advanced techniques such as designing reports, documents and interactive dashboards for building dashboards
  • Understand the concepts of data discovery and Desktop capabilities
  • Explore the best practices for Microstrategy system administration
  • Find and fix issues based on connections, environment or documents
  • Integrate third party ESRI map tools with MicroStrategy to create geo based reports
Estimated delivery fee Deliver to Egypt

Standard delivery 10 - 13 business days

$12.95

Premium delivery 3 - 6 business days

$34.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jul 29, 2016
Length: 396 pages
Edition : 1st
Language : English
ISBN-13 : 9781785884405
Category :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Estimated delivery fee Deliver to Egypt

Standard delivery 10 - 13 business days

$12.95

Premium delivery 3 - 6 business days

$34.95
(Includes tracking information)

Product Details

Publication date : Jul 29, 2016
Length: 396 pages
Edition : 1st
Language : English
ISBN-13 : 9781785884405
Category :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 170.97
Business Intelligence with MicroStrategy Cookbook
$60.99
Mastering Business Intelligence with MicroStrategy
$65.99
MicroStrategy Quick Start Guide
$43.99
Total $ 170.97 Stars icon

Table of Contents

12 Chapters
1. Getting Started with MicroStrategy Chevron down icon Chevron up icon
2. Setting Up an Analytics Semantic Layer and Public Objects Chevron down icon Chevron up icon
3. Building Advanced Reports and Documents Chevron down icon Chevron up icon
4. Advanced Visualization Techniques Chevron down icon Chevron up icon
5. Customization of MicroStrategy Chevron down icon Chevron up icon
6. Predictive Analysis with MicroStrategy Chevron down icon Chevron up icon
7. Accelerating Your Business with Mobile Analytics Chevron down icon Chevron up icon
8. Data Discovery with MicroStrategy Desktop Chevron down icon Chevron up icon
9. MicroStrategy System Administration Chevron down icon Chevron up icon
10. Design and Implementation of the Security Model Chevron down icon Chevron up icon
11. Big Data Analytics with MicroStrategy Chevron down icon Chevron up icon
12. MicroStrategy Troubleshooting Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.7
(7 Ratings)
5 star 42.9%
4 star 14.3%
3 star 28.6%
2 star 0%
1 star 14.3%
Filter icon Filter
Top Reviews

Filter reviews by




Amazon Customer Apr 18, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Awesome book, very well written.
Amazon Verified review Amazon
Felipe Pereira Aug 02, 2016
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This is a great book for anyone who wants to learn more about MicroStrategy it's ecosystem. It explains the development, administration and even the integration with Big Data. I hardly recommend it if you need to learn more about BI and MicroStrategy.
Amazon Verified review Amazon
Sergey Dec 29, 2016
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The best book I ever read!
Amazon Verified review Amazon
Amazon Customer Oct 04, 2016
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This book provides a comprehensive summary of the entire feature set provided by Microstrategy 10.It is a good technical/pragmatic introduction for a Microstrategy novice developer as well as a useful resource for Microstrategy professionals who are specialized on a subset of the product's capabilities.
Amazon Verified review Amazon
Amazon Customer Jan 11, 2017
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3
In order to follow examples laid out in this book, we have been trying to set up the backend Oracle database per instructions provided in this book on pages 29-30. However, the scripts do not fully work. First, they rely on a package called UTILS that is not included with the book. We were able to generate it in SQL Developer after some research. Second, the scripts make use of a user defined function called udfBuildISO8601Date, which again was not provided. Finally, character set conversion errors occur when attempting to create two of the views from the scripts. Perhaps, some nonstandard database settings are needed to make the scripts run without errors. I would appreciate if the publisher could provide updated SQL scripts for download on the PACKT web site.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela