PacktLib: Business Intelligence with MicroStrategy Cookbook

Business Intelligence with MicroStrategy Cookbook

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Preface

Getting Started with MicroStrategy

Introduction

Installing SQL Server 2012 Express LocalDB

Installing SQL Server Native Client 11.0

Installing SQL Server 2012 Command Line Utilities

Setting up the AdventureWorks DW sample database

Installing the .NET Framework 4.0 and the 4.0.2 update

Checking whether IIS is enabled and working

Installing MicroStrategy Suite

Registering the MicroStrategy License

Metadata and data warehouse

Creating ODBC DSN for metadata and data warehouse

Modifying the logon account for the Intelligence Server

Creating the metadata and configuring the Intelligence Server

Opening the MicroStrategy Desktop application

The First Steps in a MicroStrategy Project

Introduction

Creating an empty project

Setting up a data warehouse connection and selecting tables

Modifying a table structure

Using logical tables to create custom views

Generating constants with SELECT statements

Schema Objects – Attributes

Introduction

Attribute forms – ID and DESC

Using functions in an attribute form

Parent-child relationship I

Parent-child relationship II

Other attribute forms

Selecting which forms are displayed

Building Data Explorer Hierarchies

Creating an attribute-only report

Parent-child relationship in a report

Filters on attributes

Objects – Facts and Metrics

Introduction

Creating a simple counter fact and metric

Using SQL View to inspect SELECT statements

Understanding the GROUP BY clause

Adding more facts

Filters on metrics

Creating ranking metrics

Grouping at a different level (level metrics)

Embedding filters inside metrics

Using Metric Join Type in reports

Creating a previous month metric (transformation)

Data Display and Manipulation – Reports

Introduction

Going deeper into data with drill down

Manipulating grids – Pivot and page-by

Dynamically adding and removing objects in reports

The bottom line – customizing subtotals

Avoiding missteps – NULL values in facts

How to sort data in grids

Emphasizing numbers with conditional formatting

Printing and exporting reports

Restricting results with view filters

Data Analysis and Visualization – Graphs

Introduction

Displaying both grid and graph in the same view

Drag-and-drop objects using drop zones

Beautify your chart

Display multiple metrics with dual axis charts

Conditional formatting with thresholds

Analysis on the Web – Documents and Dashboards

Introduction

Setting up MicroStrategy Web

Creating your first "Hello World" document

Adding data to a document – the dataset

Modifying the grouping in a document

Stepping up to dashboards

Using the editable mode to fine-tune the design

Adding interactivity with panels and selectors

Embedding images, HTML, and links

Switching to Adobe Flash mode

Dynamic Selection with Filters and Prompts

Introduction

Restricting rows – compare an attribute to another attribute

Restricting rows – evaluate on moving dates

Changing the level of a metric filter

Adding interactivity to filters using prompts

Using prompts as object selectors

Mobile BI for Developers

Introduction

Setting up the Mobile Server

Setting up a mobile connection

Installing and configuring the mobile client

Adapting content to the iPad screen

Using mobile views in documents

Adding panels to mobile documents

Creating panel selectors

Adding details with pop-up windows

Linking from one document to another

Mobile BI for Users

Introduction

Answering prompts in reports or documents

Sorting, drilling, and paging

Adding notes and sharing

When things go wrong

Consolidations, Custom Groups, and Transformations

Introduction

Creating virtual attributes with consolidations

Aggregating results with custom groups

Creating bands on metrics (custom groups banding)

Month-to-date and year-to-date transformations

In-Memory Cubes and Visual Insight

Introduction

Creating a cube from an existing report

Building a new cube

Scheduling data refresh

Creating reports and documents based on a cube

Exploring data with Visual Insight

Using the network visualization

MicroStrategy Express

Introduction

Creating an Express account

Importing Excel data

Using filters

Importing cross-tabbed data

Connecting to a RDBMS

Refreshing dashboard data

Sharing a dashboard by e-mail

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Solution to Exercises

Where to Look for Information

Where to Look for Information

Where to Look for Information

Where to Look for Information

Cloudera Hadoop

Cloudera Hadoop

Cloudera Hadoop

HP Vertica

HP Vertica

HP Vertica

Index