Cargando…
Mastering Business Intelligence with MicroStrategy.
Build world-class enterprise Business Intelligence solutions with MicroStrategy 10About This Book Fix the gap between BI tools and implementation/integration processes with big data and predictive analytics using this comprehensive guide to MicroStrategy 10 Highly practical, example-rich guide that...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2016.
|
| Edición: | 1. |
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Authors; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with MicroStrategy; Modern BI; BI market; Maturity level of the organization; BI project life cycle; Meet MicroStrategy 10; MicroStrategy 10 education and certification; History of MicroStrategy; Deploying MicroStrategy 10; Overview of training architecture; Creating a Red Hat Linux virtual machine; Performing prerequisites for MicroStrategy 10; Installing MicroStrategy 10 Intelligence Server; Installation process; Configuring Intelligence Server.
- Installing a PostgreSQL databaseCreating a metadata database; Creating a metadata data source; Creating metadata tables; Installation of MicroStrategy Web; Web application server installation; Deploying WAR files; Creating a network; Installing MicroStrategy 10 tools; Installing Oracle database; Deploying data in Oracle database; BI tips; BI skills; BI users' development; BI portal; Summary; Chapter 2: Setting Up an Analytics Semantic Layer and Public Objects; BI architecture; Components of BI architecture; The project design process; Logical data model design; Data warehouse schema design.
- Project creation in MicroStrategy architectureCreating a data source; Creating a project; Using the project creation assistant; Using MicroStrategy Architect; Creating schema objects; Managing project schema; Schema objects; Attributes; Attribute types; Attribute form expression types; General attribute example; Creating an attribute from Architect; Creating an attribute from the Desktop; Facts; Fact types; Fact expression types; SQL representation; Creating a fact from Architect; Creating a fact from the Desktop; Hierarchies; Example; Creating a user hierarchy and attribute relationships.
- Creating a user hierarchy and attribute relationships from ArchitectCreating a user hierarchy and attribute relationships from Desktop; Public objects; Metrics; Types of metric; Creating metrics; Prompts; Example of creating an Object prompt; Filters; Create a standalone filter; Filter operators; Example of how these filters are used; SQL based on report filter; Summary; Chapter 3: Building Advanced Reports and Documents; Advanced reporting components; Custom groups; Creating a custom group; Custom group examples; Custom group SQL; Custom group display options.
- Custom group interaction with report filtersConsolidation; Consolidation elements; Creating consolidations; Consolidation examples; SQL based on consolidation; Consolidation and custom group comparison; Transformations; Building a transformation; Transformation components; Drill maps; Freeform SQL; Creating a Freeform SQL report; Freeform SQL features; Prompt; Security filters; Intelligent cube; Enabling and disabling intelligent cube usage; Advanced reports; Creating and adding data to the document; Document controls; Moving towards a dashboard; Linking reports and documents; Summary.