Business Intelligence with MicroStrategy Cookbook

封面

版权信息

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Preface

Chapter 1. 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

Chapter 2. 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

Chapter 3. 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

Chapter 4. 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)

Chapter 5. 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

Chapter 6. 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

Chapter 7. 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

Chapter 8. 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

Chapter 9. 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