MicroStrategy Quick Start Guide
Fernando Carlos Rivero Esqueda更新时间:2021-08-13 15:19:08
最新章节:Leave a review - let other readers know what you think封面
Title Page
Copyright and Credits
MicroStrategy Quick Start Guide
Dedication
Packt Upsell
Why subscribe?
packt.com
Foreword
Contributors
About the author
About the reviewers
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Download the color images
Conventions used
Get in touch
Reviews
Architecture - Installing and Configuring MicroStrategy
MicroStrategy architecture
Main server components
The MicroStrategy Intelligence Server
MicroStrategy Web and Mobile servers
Client applications
For developers
For administrators
For users and analysts
Installation and configuration
Prerequisites
System requirements
Windows installation
Unix/Linux installation
The MicroStrategy metadata
Creating and configuring MicroStrategy metadata
Intelligence Server configuration
Project sources (2-tier and 3-tier)
4-Tier configuration (MicroStrategy Web and/or Mobile)
Summary
Project Design - Creating Your Project Foundation
MicroStrategy Objects
Framework to learn about MicroStrategy Objects
MicroStrategy Analytics Modules
MicroStrategy Developer
MicroStrategy Projects
Project structure
Exercise – create your first Project
Your building blocks – Schema Objects
Exercise – updating Schema
The Source – Tables
Warehouse Catalog
Table structure
Exercise – Import a few Tables
Business raw measures – Facts
Exercise – creating Facts
Business context – Attributes
Understanding the Attribute Editor
Exercise – creating Attributes
Grouping business context – Hierarchies
Exercise – Creating user Hierarchies
Comparing data across time – Transformations
Summary
Basic Reporting - Building Your First Reports
Your analyzing blocks – Public Objects
Your main analysis tool – Reports
Understanding the Report Editor
Exercise – create your first Report
Understanding Local Objects versus External Objects
Exercise – searching for components and dependents
Reusing your report designs – Templates
Limiting your data – Filters
Filters from Attributes
Filters from Metrics
Filters from Reports
Exercise – creating some Filters
Business calculations – Metrics
Describing the types of Metrics
Defining the report level
Understanding the Metric editor and components
Exercise – creating some Metrics
Performing Report manipulations
Manipulation – Autostyle format
Manipulation – Grand total
Manipulation – Subtotal
Manipulation – Pivoting
Manipulation – Page-by
Manipulation – Sorting
Manipulation – Exporting
Manipulation – Graph view
Manipulation – SQL view
Manipulation – Drilling
Manipulation – Derived Metrics
Manipulation – View Filters
Manipulation – Thresholds
Summary
Advanced Reporting - Interacting with and Improving Your Reports
Grouping data together – Custom Groups and Consolidations
Exercise – create a Custom Group
Exercise – creating a Consolidation
Dynamic filtering and report creation – Prompts
Understanding types of Prompts
Exercise – create some prompted Reports
Drilling paths – Drill maps
Exercise – create a Custom Drill Map
Publishing data sources – iCubes
Summary
Dashboarding - Creating Visual Reporting
Importing Data
Exercise – import data
Creating enterprise-certified dashboards – Documents
Document structure
Document controls
Exercise – creating a basic document
For the self-serving enthusiasts – web Dashboards
Exercise – creating a dashboard
Summary
Security - Managing Your Users and Their Access
Your management blocks – Configuration Objects
MicroStrategy Developer Administration
MicroStrategy security levels
Project-level security
Profiles for accessing Projects – Users and Groups
Exercise – creating your first User
Exercise – creating a User Group
Grouping privileges together – Security Roles
Exercise – creating and assign a Security Role
Object-level security
Permissions
Permissions groups
Exercise – setting permissions
Data-level security
Limiting the data by user – Security Filters
Exercise – create and assign a Security Filter
Summary
Administration - Maintaining and Monitoring Your Project
Database connectivity in MicroStrategy
Connecting to your source – Database Instances Connections and Logins
Exercise – Establish connectivity to a new database
Improving Reporting Performance – MicroStrategy Cache
Automating tasks – Schedules
Defining Triggers – Events
Refreshing your data – Subscriptions
Exercise – Subscribing your Reports
Monitoring your Project – MicroStrategy Developer Monitors
Jobs Monitor
Useful tips
User Connections Monitor
Useful tips
Database Connections Monitor
Useful tips
Caches Monitor
Operations for Caches
Operations for Intelligent Cubes
MicroStrategy Administrative Clients
Migrating your Objects – Object Manager
Comparing your Reports – Integrity Manager
Automating Scripts – Command Manager
Exercise – Using Command Object and Integrity Managers
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
更新时间:2021-08-13 15:19:08