Home Page Icon
Home Page
Table of Contents for
Table of Contents
Close
Table of Contents
by Ning Ma, Himani Rana, Dmitry Anoshin
Mastering Business Intelligence with MicroStrategy
Mastering Business Intelligence with MicroStrategy
Mastering Business Intelligence with MicroStrategy
Credits
About the Authors
About the Reviewer
www.PacktPub.com
eBooks, discount offers, and more
Why subscribe?
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the color images of this book
Errata
Piracy
Questions
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 database
Creating 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
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 architecture
Creating 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 Architect
Creating 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
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 filters
Consolidation
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
4. Advanced Visualization Techniques
Dashboard style document
Panels
Filter panel
Selectors
Types of selector
Basic visualization (graphs)
One attribute, one metric - Vertical Line - Absolute graph
One attribute, two metrics - Budgeting
One attribute, three metrics - Bubble chart
One attribute, four metrics - Stock: Hi-Lo-Open-Close
One attribute, five metrics - Boxplot
Complex graph - Gantt
Widgets
Date selection widget
Graph matrix widgets
Heat map widget
Map widget
Network widgets
Survey widget
Timeline widget
Visual insight
Adding additional visualizations
MicroStrategy and ESRI map integration
Creating reports in MicroStrategy for Geo-based analysis
MicroStrategy and Google Maps integration
Summary
5. Customization of MicroStrategy
Before we start
What is SDK
Where to get documentations and resources
Overview of Web SDK
MicroStrategy Web architecture
MicroStrategy plugin architecture
Deploying SDK and configuring WCE in Linux
Installing SDK and configuring WCE in Windows
Best practices for customizations and upgrades
Customization pages
Web Beans
Applications of Web Beans
Customizing MicroStrategy styles with CSS
Applications of CSS customization
Adding advanced visualization with SDK
Installing Visualization SDK
Introduction to Visualization Builder
Application of Visualization Builder
Overview of advanced web customization with MicroStrategy API
Overview of Mobile SDK
Mobile SDK for iOS
Mobile SDK for Android
Application of Mobile SDK – Rebranding
Set up the MicroStrategy Mobile project
Rebranding the application
Summary
6. Predictive Analysis with MicroStrategy
Predictive analysis in MicroStrategy 10
Licensing requirements
Native analytical functions in MicroStrategy 10
Integrating R with MicroStrategy
Installing R
Installing R Integration Pack
Creating a neural network model in R and exporting it as a PMML file
Data mining overview
Purpose of data mining
Limitations of data mining
Terminologies
Target variable, explanatory variable
Continuous variable, categorical variable
Training, validation, modeling
Supervised learning, unsupervised learning
Classification, prediction
Data mining techniques
Four steps to achieve data mining in MicroStrategy
Creating a dataset
Selecting variables
Developing the model
Creating a validation report
Deploying the model
Business applications of predictive analysis
Forecasting quarterly revenues using linear regression and exponential regression with seasonality
Forecasting quarterly revenues for different regions using tree regression analysis
Forecasting monthly revenues using time series analysis
Telco churn analysis using classification
Telco churn analysis using decision tree
Telco churn analysis using logistic regression
Automating the predictive mechanism
Summary
7. Accelerating Your Business with Mobile Analytics
Before we start
Mobile Server
Mobile Client
Mobile Server installation and configuration
Creating a mobile application
Determine business goals
Storyboarding and planning
Creating an iPad Landscape template
Unhide document templates
Creating templates
Dataset creation
Panel stack and panels for Sales Performance App
Creating a Home page for Sales Performance App
Creating a profit pie chart for Home
Creating a revenue time series graph for Home
Creating KPI for Home
Creating a top 5 units sold bar chart for Home
Creating a Product page for Sales Performance App
Creating a Region page for Sales Performance App
Creating a Trend page for Sales Performance App
Creating a Customer page for Sales Performance App
Prompts in mobile applications
Views in mobile applications
Linking
Best practices
Dedicated vs unified design
Purpose, audience, and prototype
Extending mobile capabilities
Transaction services
Mobile SDK
Deployment
Summary
8. Data Discovery with MicroStrategy Desktop
Meet MicroStrategy Desktop
MicroStrategy Desktop interface
Building ad hoc schemas
Data mashup of Oracle and flat files
Data profiling of geography data
Building a dashboard
Line charts
Area charts
Bar charts
Bubble charts
Publishing the dashboard
Performing Pareto analysis
Performing cohort analysis
Deploying D3 visualization
Desktop versus Tableau
Summary
9. MicroStrategy System Administration
Managing MicroStrategy platform
Monitoring MicroStrategy
Deploying Enterprise Manager and collecting statistics
Project life cycle with Object Manager
Integrity Manager overview
System Manager overview
Activating Change Journal
Summary
10. Design and Implementation of the Security Model
MicroStrategy security overview
Users and groups
Privileges and security roles
Row-level security
MicroStrategy objects permission
Security design
Security model deployment
Building an advanced security model
Summary
11. Big Data Analytics with MicroStrategy
Hadoop and MicroStrategy
Hadoop architecture
MicroStrategy Analytics Platform over Hadoop
Hadoop and MicroStrategy use cases
Example of log file analysis in a Hadoop system
Configuring Hortonworks and MicroStrategy
Connecting Hortonworks with MicroStrategy
Setting up an ODBC connector
Setting up a MicroStrategy environment
Design your first Hadoop dashboard
Data wrangling
Splunk and MicroStrategy
What is Splunk
Splunk architecture
Splunk and MicroStrategy use cases
Deploying Splunk
Installing the Splunk ODBC driver
Creating reports from Splunk
Summary
12. MicroStrategy Troubleshooting
Meeting the MicroStrategy Community
Setting up MicroStrategy Health Center
Discovering MicroStrategy logs
How the DSSErrors file works
Overview of the MicroStrategy Diagnostics and Performance Logging tool
Contacting MicroStrategy Support
Exploring problems with security
Discovering data discrepancy issues
Summary
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
Mastering Business Intelligence with MicroStrategy
Table of Contents
Mastering Business Intelligence with MicroStrategy
Credits
About the Authors
About the Reviewer
www.PacktPub.com
eBooks, discount offers, and more
Why subscribe?
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the color images of this book
Errata
Piracy
Questions
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 database
Creating 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
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 architecture
Creating 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 Architect
Creating 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
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 filters
Consolidation
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
4. Advanced Visualization Techniques
Dashboard style document
Panels
Filter panel
Selectors
Types of selector
Basic visualization (graphs)
One attribute, one metric - Vertical Line - Absolute graph
One attribute, two metrics - Budgeting
One attribute, three metrics - Bubble chart
One attribute, four metrics - Stock: Hi-Lo-Open-Close
One attribute, five metrics - Boxplot
Complex graph - Gantt
Widgets
Date selection widget
Graph matrix widgets
Heat map widget
Map widget
Network widgets
Survey widget
Timeline widget
Visual insight
Adding additional visualizations
MicroStrategy and ESRI map integration
Creating reports in MicroStrategy for Geo-based analysis
MicroStrategy and Google Maps integration
Summary
5. Customization of MicroStrategy
Before we start
What is SDK
Where to get documentations and resources
Overview of Web SDK
MicroStrategy Web architecture
MicroStrategy plugin architecture
Deploying SDK and configuring WCE in Linux
Installing SDK and configuring WCE in Windows
Best practices for customizations and upgrades
Customization pages
Web Beans
Applications of Web Beans
Customizing MicroStrategy styles with CSS
Applications of CSS customization
Adding advanced visualization with SDK
Installing Visualization SDK
Introduction to Visualization Builder
Application of Visualization Builder
Overview of advanced web customization with MicroStrategy API
Overview of Mobile SDK
Mobile SDK for iOS
Mobile SDK for Android
Application of Mobile SDK – Rebranding
Set up the MicroStrategy Mobile project
Rebranding the application
Summary
6. Predictive Analysis with MicroStrategy
Predictive analysis in MicroStrategy 10
Licensing requirements
Native analytical functions in MicroStrategy 10
Integrating R with MicroStrategy
Installing R
Installing R Integration Pack
Creating a neural network model in R and exporting it as a PMML file
Data mining overview
Purpose of data mining
Limitations of data mining
Terminologies
Target variable, explanatory variable
Continuous variable, categorical variable
Training, validation, modeling
Supervised learning, unsupervised learning
Classification, prediction
Data mining techniques
Four steps to achieve data mining in MicroStrategy
Creating a dataset
Selecting variables
Developing the model
Creating a validation report
Deploying the model
Business applications of predictive analysis
Forecasting quarterly revenues using linear regression and exponential regression with seasonality
Forecasting quarterly revenues for different regions using tree regression analysis
Forecasting monthly revenues using time series analysis
Telco churn analysis using classification
Telco churn analysis using decision tree
Telco churn analysis using logistic regression
Automating the predictive mechanism
Summary
7. Accelerating Your Business with Mobile Analytics
Before we start
Mobile Server
Mobile Client
Mobile Server installation and configuration
Creating a mobile application
Determine business goals
Storyboarding and planning
Creating an iPad Landscape template
Unhide document templates
Creating templates
Dataset creation
Panel stack and panels for Sales Performance App
Creating a Home page for Sales Performance App
Creating a profit pie chart for Home
Creating a revenue time series graph for Home
Creating KPI for Home
Creating a top 5 units sold bar chart for Home
Creating a Product page for Sales Performance App
Creating a Region page for Sales Performance App
Creating a Trend page for Sales Performance App
Creating a Customer page for Sales Performance App
Prompts in mobile applications
Views in mobile applications
Linking
Best practices
Dedicated vs unified design
Purpose, audience, and prototype
Extending mobile capabilities
Transaction services
Mobile SDK
Deployment
Summary
8. Data Discovery with MicroStrategy Desktop
Meet MicroStrategy Desktop
MicroStrategy Desktop interface
Building ad hoc schemas
Data mashup of Oracle and flat files
Data profiling of geography data
Building a dashboard
Line charts
Area charts
Bar charts
Bubble charts
Publishing the dashboard
Performing Pareto analysis
Performing cohort analysis
Deploying D3 visualization
Desktop versus Tableau
Summary
9. MicroStrategy System Administration
Managing MicroStrategy platform
Monitoring MicroStrategy
Deploying Enterprise Manager and collecting statistics
Project life cycle with Object Manager
Integrity Manager overview
System Manager overview
Activating Change Journal
Summary
10. Design and Implementation of the Security Model
MicroStrategy security overview
Users and groups
Privileges and security roles
Row-level security
MicroStrategy objects permission
Security design
Security model deployment
Building an advanced security model
Summary
11. Big Data Analytics with MicroStrategy
Hadoop and MicroStrategy
Hadoop architecture
MicroStrategy Analytics Platform over Hadoop
Hadoop and MicroStrategy use cases
Example of log file analysis in a Hadoop system
Configuring Hortonworks and MicroStrategy
Connecting Hortonworks with MicroStrategy
Setting up an ODBC connector
Setting up a MicroStrategy environment
Design your first Hadoop dashboard
Data wrangling
Splunk and MicroStrategy
What is Splunk
Splunk architecture
Splunk and MicroStrategy use cases
Deploying Splunk
Installing the Splunk ODBC driver
Creating reports from Splunk
Summary
12. MicroStrategy Troubleshooting
Meeting the MicroStrategy Community
Setting up MicroStrategy Health Center
Discovering MicroStrategy logs
How the DSSErrors file works
Overview of the MicroStrategy Diagnostics and Performance Logging tool
Contacting MicroStrategy Support
Exploring problems with security
Discovering data discrepancy issues
Summary
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset