Mastering Business Intelligence with MicroStrategy电子书

Mastering Business Intelligence with MicroStrategy

Mastering Business Intelligence with MicroStrategy

Credits

About the Authors

About the Reviewer

www.PacktPub.com

eBooks, discount offers, and more

Why subscribe?

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the color images of this book

Errata

Piracy

Questions

1. Getting Started with MicroStrategy

Modern BI

BI market

Maturity level of the organization

BI project life cycle

Meet MicroStrategy 10

MicroStrategy 10 education and certification

History of MicroStrategy

Deploying MicroStrategy 10

Overview of training architecture

Creating a Red Hat Linux virtual machine

Performing prerequisites for MicroStrategy 10

Installing MicroStrategy 10 Intelligence Server

Installation process

Configuring Intelligence Server

Installing a PostgreSQL database

Creating a metadata database

Creating a metadata data source

Creating metadata tables

Installation of MicroStrategy Web

Web application server installation

Deploying WAR files

Creating a network

Installing MicroStrategy 10 tools

Installing Oracle database

Deploying data in Oracle database

BI tips

BI skills

BI users' development

BI portal

Summary

2. Setting Up an Analytics Semantic Layer and Public Objects

BI architecture

Components of BI architecture

The project design process

Logical data model design

Data warehouse schema design

Project creation in MicroStrategy architecture

Creating a data source

Creating a project

Using the project creation assistant

Using MicroStrategy Architect

Creating schema objects

Managing project schema

Schema objects

Attributes

Attribute types

Attribute form expression types

General attribute example

Creating an attribute from Architect

Creating an attribute from the Desktop

Facts

Fact types

Fact expression types

SQL representation

Creating a fact from Architect

Creating a fact from the Desktop

Hierarchies

Example

Creating a user hierarchy and attribute relationships

Creating a user hierarchy and attribute relationships from Architect

Creating a user hierarchy and attribute relationships from Desktop

Public objects

Metrics

Types of metric

Creating metrics

Prompts

Example of creating an Object prompt

Filters

Create a standalone filter

Filter operators

Example of how these filters are used

SQL based on report filter

Summary

3. Building Advanced Reports and Documents

Advanced reporting components

Custom groups

Creating a custom group

Custom group examples

Custom group SQL

Custom group display options

Custom group interaction with report filters

Consolidation

Consolidation elements

Creating consolidations

Consolidation examples

SQL based on consolidation

Consolidation and custom group comparison

Transformations

Building a transformation

Transformation components

Drill maps

Freeform SQL

Creating a Freeform SQL report

Freeform SQL features

Prompt

Security filters

Intelligent cube

Enabling and disabling intelligent cube usage

Advanced reports

Creating and adding data to the document

Document controls

Moving towards a dashboard

Linking reports and documents

Summary

4. Advanced Visualization Techniques

Dashboard style document

Panels

Filter panel

Selectors

Types of selector

Basic visualization (graphs)

One attribute, one metric - Vertical Line - Absolute graph

One attribute, two metrics - Budgeting

One attribute, three metrics - Bubble chart

One attribute, four metrics - Stock: Hi-Lo-Open-Close

One attribute, five metrics - Boxplot

Complex graph - Gantt

Widgets

Date selection widget

Graph matrix widgets

Heat map widget

Map widget

Network widgets

Survey widget

Timeline widget

Visual insight

Adding additional visualizations

MicroStrategy and ESRI map integration

Creating reports in MicroStrategy for Geo-based analysis

MicroStrategy and Google Maps integration

Summary

5. Customization of MicroStrategy

Before we start

What is SDK

Where to get documentations and resources

Overview of Web SDK

MicroStrategy Web architecture

MicroStrategy plugin architecture

Deploying SDK and configuring WCE in Linux

Installing SDK and configuring WCE in Windows

Best practices for customizations and upgrades

Customization pages

Web Beans

Applications of Web Beans

Customizing MicroStrategy styles with CSS

Applications of CSS customization

Adding advanced visualization with SDK

Installing Visualization SDK

Introduction to Visualization Builder

Application of Visualization Builder

Overview of advanced web customization with MicroStrategy API

Overview of Mobile SDK

Mobile SDK for iOS

Mobile SDK for Android

Application of Mobile SDK – Rebranding

Set up the MicroStrategy Mobile project

Rebranding the application

Summary

6. Predictive Analysis with MicroStrategy

Predictive analysis in MicroStrategy 10

Licensing requirements

Native analytical functions in MicroStrategy 10

Integrating R with MicroStrategy

Installing R

Installing R Integration Pack

Creating a neural network model in R and exporting it as a PMML file

Data mining overview

Purpose of data mining

Limitations of data mining

Terminologies

Target variable, explanatory variable

Continuous variable, categorical variable

Training, validation, modeling

Supervised learning, unsupervised learning

Classification, prediction

Data mining techniques

Four steps to achieve data mining in MicroStrategy

Creating a dataset

Selecting variables

Developing the model

Creating a validation report

Deploying the model

Business applications of predictive analysis

Forecasting quarterly revenues using linear regression and exponential regression with seasonality

Forecasting quarterly revenues for different regions using tree regression analysis

Forecasting monthly revenues using time series analysis

Telco churn analysis using classification

Telco churn analysis using decision tree

Telco churn analysis using logistic regression

Automating the predictive mechanism

Summary

7. Accelerating Your Business with Mobile Analytics

Before we start

Mobile Server

Mobile Client

Mobile Server installation and configuration

Creating a mobile application

Determine business goals

Storyboarding and planning

Creating an iPad Landscape template

Unhide document templates

Creating templates

Dataset creation

Panel stack and panels for Sales Performance App

Creating a Home page for Sales Performance App

Creating a profit pie chart for Home

Creating a revenue time series graph for Home

Creating KPI for Home

Creating a top 5 units sold bar chart for Home

Creating a Product page for Sales Performance App

Creating a Region page for Sales Performance App

Creating a Trend page for Sales Performance App

Creating a Customer page for Sales Performance App

Prompts in mobile applications

Views in mobile applications

Linking

Best practices

Dedicated vs unified design

Purpose, audience, and prototype

Extending mobile capabilities

Transaction services

Mobile SDK

Deployment

Summary

8. Data Discovery with MicroStrategy Desktop

Meet MicroStrategy Desktop

MicroStrategy Desktop interface

Building ad hoc schemas

Data mashup of Oracle and flat files

Data profiling of geography data

Building a dashboard

Line charts

Area charts

Bar charts

Bubble charts

Publishing the dashboard

Performing Pareto analysis

Performing cohort analysis

Deploying D3 visualization

Desktop versus Tableau

Summary

9. MicroStrategy System Administration

Managing MicroStrategy platform

Monitoring MicroStrategy

Deploying Enterprise Manager and collecting statistics

Project life cycle with Object Manager

Integrity Manager overview

System Manager overview

Activating Change Journal

Summary

10. Design and Implementation of the Security Model

MicroStrategy security overview

Users and groups

Privileges and security roles

Row-level security

MicroStrategy objects permission

Security design

Security model deployment

Building an advanced security model

Summary

11. Big Data Analytics with MicroStrategy

Hadoop and MicroStrategy

Hadoop architecture

MicroStrategy Analytics Platform over Hadoop

Hadoop and MicroStrategy use cases

Example of log file analysis in a Hadoop system

Configuring Hortonworks and MicroStrategy

Connecting Hortonworks with MicroStrategy

Setting up an ODBC connector

Setting up a MicroStrategy environment

Design your first Hadoop dashboard

Data wrangling

Splunk and MicroStrategy

What is Splunk

Splunk architecture

Splunk and MicroStrategy use cases

Deploying Splunk

Installing the Splunk ODBC driver

Creating reports from Splunk

Summary

12. MicroStrategy Troubleshooting

Meeting the MicroStrategy Community

Setting up MicroStrategy Health Center

Discovering MicroStrategy logs

How the DSSErrors file works

Overview of the MicroStrategy Diagnostics and Performance Logging tool

Contacting MicroStrategy Support

Exploring problems with security

Discovering data discrepancy issues

Summary