Book Image

MicroStrategy Quick Start Guide

By : Fernando Carlos Rivero Esqueda
Book Image

MicroStrategy Quick Start Guide

By: Fernando Carlos Rivero Esqueda

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.
Table of Contents (17 chapters)
Title Page
Copyright and Credits
Dedication
Packt Upsell
Foreword
Contributors
Preface
Index

Chapter 2. Project Design - Creating Your Project Foundation

Technically speaking, MicroStrategy's core task is to translate business questions into the language that databases speak: SQL. In other words, MicroStrategy offers a logical bridge between business users and the data. This bridge is possible because of MicroStrategy's Objects, which in turn reside in its metadata database.

This chapter will establish the base for designing and building a MicroStrategy project. It will first define and explain the concept of MicroStrategy Objects and then describe the main object categories. Then the main Schema Objects, such as Attributes and Facts, will be covered. The following topics will be the focus of this chapter:

  • What is a MicroStrategy Object?
  • Which are the main object categories?
  • Understanding a MicroStrategy Project and how to create one
  • Understanding a MicroStrategy Schema Object
  • Explaining MicroStrategy Attributes and how to create one
  • Explaining MicroStrategy Facts and how to create one...