Cargando…
Business Intelligence with MicroStrategy Cookbook.
Written in a cookbook style, this book will teach you through the use of recipes with examples and illustrations. Each recipe contains step-by-step instructions about everything necessary to execute a particular task. This book is intended for both BI and database developers who want to expand their...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2013.
|
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; Foreword; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; 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 warehouseModifying 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 formParent-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 metricsUsing 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.
- IntroductionDisplaying 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.