MicroStrategy Quick Start Guide

By : Rivero Esqueda

5 (1)

Buy this Book

MicroStrategy Quick Start Guide

5 (1)

By: Rivero Esqueda

Buy this Book

Overview of this book

MicroStrategy is an enterprise business intelligence application. It turns data into reports for making and executing key organization decisions. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. It takes you from setting up and configuring MicroStrategy to security and administration. The book starts by detailing the different components of the MicroStrategy platform, and the key concepts of Metadata and Project Source. You will then install and configure MicroStrategy and lay down the foundations for building MicroStrategy BI solutions. By learning about objects and different object types, you will develop a strong understanding of the MicroStrategy Schema and Public Objects. With these MicroStrategy objects, you will enhance and scale your BI and Analytics solutions. Finally, you will learn about the administration, security, and monitoring of your BI solution.

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

Architecture - Installing and Configuring MicroStrategy

MicroStrategy architecture

Main server components

Client applications

Installation and configuration

The MicroStrategy metadata

Intelligence Server configuration

Summary

Project Design - Creating Your Project Foundation

MicroStrategy Objects

MicroStrategy Analytics Modules

MicroStrategy Developer

MicroStrategy Projects

Your building blocks – Schema Objects

The Source – Tables

Business raw measures – Facts

Business context – Attributes

Grouping business context – Hierarchies

Comparing data across time – Transformations

Summary

Basic Reporting - Building Your First Reports

Your analyzing blocks – Public Objects

Your main analysis tool – Reports

Reusing your report designs – Templates

Limiting your data – Filters

Business calculations – Metrics

Performing Report manipulations

Summary

Advanced Reporting - Interacting with and Improving Your Reports

Grouping data together – Custom Groups and Consolidations

Dynamic filtering and report creation – Prompts

Drilling paths – Drill maps

Publishing data sources – iCubes

Summary

Dashboarding - Creating Visual Reporting

Importing Data

Creating enterprise-certified dashboards – Documents

For the self-serving enthusiasts – web Dashboards

Summary

Security - Managing Your Users and Their Access

Your management blocks – Configuration Objects

MicroStrategy security levels

Summary

Administration - Maintaining and Monitoring Your Project

Database connectivity in MicroStrategy

Connecting to your source – Database Instances, Connections, and Logins

Improving Reporting Performance – MicroStrategy Cache

Monitoring your Project – MicroStrategy Developer Monitors

MicroStrategy Administrative Clients

Summary

Quick Reference Tables by Object Type

Schema Objects

Application / Public Objects

Configuration Objects

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

5 (1)

5 star

100%

4 star

3 star

2 star

1 star

Publishing data sources – iCubes

Intelligent Cubes, also known as iCubes, are Application objects that allow developers to pre-calculate and publish data sources. These data sources are stored in memory in the Intelligence Server so that result sets for Reports and Documents (Dashboards) can be retrieved immediately, without having to wait for the SQL to be executed against the database.

The following is a quick reference table for this MicroStrategy Object:

When a Report uses an iCube as a source of data, as opposed to a relational database, it is referred to as a Data set. A single iCube can source many Data sets. Intelligent Cubes improve performance and user experience by pre-aggregating and pre-calculating the data. In order to be able to create, use, and manage iCubes, it is necessary to license and install MicroStrategy OLAP Services.

The iCube creation process...