万本电子书0元读

万本电子书0元读

顶部广告

Mastering Business Intelligence with MicroStrategy电子书

售       价:¥

45人正在读 | 0人评论 9.8

作       者:Dmitry Anoshin,Himani Rana,Ning Ma

出  版  社:Packt Publishing

出版时间:2016-07-01

字       数:152.6万

所属分类: 进口书 > 外文原版书 > 电脑/网络

温馨提示:此类商品不支持退换货,不支持下载打印

为你推荐

  • 读书简介
  • 目录
  • 累计评论(0条)
  • 读书简介
  • 目录
  • 累计评论(0条)
Build world-class enterprise Business Intelligence solutions with MicroStrategy 10 About 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 lets you implement business intelligence with MicroStrategy 10 in your organization Create the best user experience with BI dashboards using MicroStrategy using this up-to-date, comprehensive guide Who This Book Is For This book is intended for BI, DWH, ETL developers, BI/DWH/Analytics managers, analysts, and business users who already have MicroStrategy in their organization and want to take it to the next level in order to increase performance and improve user experience. In addition, it helps the reader to migrate from MicroStrategy 9 to MicroStrategy 10 and to start using the new capabilities. What You Will Learn Explore various visualization techniques for presenting analyzed data Customize MicroStrategy in order to meet your business requirements Develop and design mobile dashboards Use the advanced techniques such as designing reports, documents and interactive dashboards for building dashboards Understand the concepts of data discovery and Desktop capabilities Explore the best practices for Microstrategy system administration Find and fix issues based on connections, environment or documents Integrate third party ESRI map tools with MicroStrategy to create geo based reports In Detail Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. It lets you various delivery methods such as the Web, desktops, and mobiles. Using real-world BI scenarios, this book helps you to implement Business Analytics solutions in big e-commerce companies. It kicks off with MicroStrategy 10 features and then covers schema design models and techniques. Building upon your existing knowledge, the book will teach you advanced techniques for building documents and dashboards. It further teaches various graphical techniques for presenting data for analysis using maps, graphs, and advanced charts. Although MicroStrategy has rich functionality, the book will show how to customize it in order to meet your business requirements. You will also become familiar with the native analytical functions that will help you to maximize the impact of BI solutions with powerful predictive analytics. Furthermore, the book will focus on MicroStrategy Mobile Analytics along with data discovery and desktop capabilities such as connecting various data sources and building interactive dashboards. The book will also uncover best practices, troubleshooting techniques for MicroStrategy system administration, and also security and authentication techniques. Lastly, you will learn to use Hadoop for MicroStrategy reporting. By the end of the book, you will become proficient in evaluating any BI software in order to choose the best one that meets all business requirements. Style and approach This book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture for real world scenario, using Microstrategy 10, best practices and collected experience working with BI, predictive analytics, and Microstrategy and big data.
目录展开

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

累计评论(0条) 0个书友正在讨论这本书 发表评论

发表评论

发表评论,分享你的想法吧!

买过这本书的人还买过

读了这本书的人还在读

回顶部