Book description
MicroStrategy products allow you to take control of your business intelligence, and this book gives you the know-how to undertake successful data analysis. With over 90 practical recipes, it’s a fully comprehensive cookbook.
- Learn about every step of the BI project, starting from the installation of a sample database
- Design web reports and documents
- Configure, develop, and use the Mobile Dashboard
- Master data discovery with Visual Insight and MicroStrategy Cloud Express
- Learn with the help of practical, real-life examples and screencasts for every exercise
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 a complete business intelligence platform that covers all the data analysis needs of an enterprise. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. With the latest Visual Insight tool, MicroStrategy brings the power of BI to the business users, allowing them to discover information without the help of IT personnel.
Business Intelligence with MicroStrategy Cookbook covers the full cycle of a BI project with the MicroStrategy platform, from setting up the software to using dashboards in the cloud and on mobile devices. This book uses step-by-step instructions to teach you everything from the very basics to the more advanced topics. We will start by downloading and installing the software and a well-known sample SQL Server database. Then, one brick at a time, we will construct a fully-featured BI solution with a web interface, mobile reporting, and agile analytics.
The chapters are ordered by increasing difficulty, and each one builds on top of the preceding chapter so that the learning process is progressive. The examples given in this book are practical, and you will be able to see the immediate result of your efforts. We will first cover setting up the platform, including the creation of the metadata and the different objects that are part of a BI project: tables, attributes, and metrics. Then, we take a look at how to create and analyze reports, charts, documents, and dashboards, as well as how to manipulate data with the desktop application, the web Interface, and an iPad device.
The last part of the book is dedicated to advanced topics like the new agile analytics technology from MicroStrategy, where we cover both Visual Insight and MicroStrategy Cloud Express. Whether you are a database developer, data analyst, or a business user, Business Intelligence with MicroStrategy Cookbook will get you up to speed with one of the most powerful BI platforms on the market with the smallest possible investment of time and money.
Table of contents
-
Business Intelligence with MicroStrategy Cookbook
- Table of Contents
- Business Intelligence with MicroStrategy Cookbook
- Credits
- Foreword
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
-
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 warehouse
- Modifying the logon account for the Intelligence Server
- Creating the metadata and configuring the Intelligence Server
- Opening the MicroStrategy Desktop application
- 2. The First Steps in a MicroStrategy Project
-
3. Schema Objects â Attributes
- Introduction
- Attribute forms â ID and DESC
- Using functions in an attribute form
- Parent-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
-
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 metrics
- Using Metric Join Type in reports
- Creating a previous month metric (transformation)
-
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
- 6. Data Analysis and Visualization â Graphs
-
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
- Switching to Adobe Flash mode
- 8. Dynamic Selection with Filters and Prompts
-
9. Mobile BI for Developers
- Introduction
- Setting up the Mobile Server
- Setting up a mobile connection
- Installing and configuring the mobile client
- Adapting content to the iPad screen
- Using mobile views in documents
- Adding panels to mobile documents
- Creating panel selectors
- Adding details with pop-up windows
- Linking from one document to another
- 10. Mobile BI for Users
- 11. Consolidations, Custom Groups, and Transformations
- 12. In-Memory Cubes and Visual Insight
- 13. MicroStrategy Express
-
A. Solution to Exercises
- Exercise 1
- Exercise 2
- Exercise 3
- Exercise 4
- Exercise 5
- Exercise 6
- Exercise 7
- Exercise 8
- Exercise 9
- Exercise 10
- Exercise 11
- Exercise 12
- Exercise 13
- Exercise 14
- Exercise 15
- Exercise 16
- Exercise 17
- Exercise 18
- Exercise 19
- Exercise 20
- Exercise 21
- Exercise 22
- Exercise 23
- Exercise 24
- Exercise 25
- Exercise 26
- Exercise 27
- Exercise 28
- Exercise 29
- Exercise 30
- Exercise 31
- Exercise 32
- Exercise 33
- Exercise 34
- Exercise 35
- B. Where to Look for Information
- C. Cloudera Hadoop
- D. HP Vertica
- Index
Product information
- Title: Business Intelligence with MicroStrategy Cookbook
- Author(s):
- Release date: October 2013
- Publisher(s): Packt Publishing
- ISBN: 9781782179757
You might also like
book
Microsoft® Business Intelligence For Dummies®
Learn to create an effective business strategy using Microsoft's BI stack Microsoft Business Intelligence tools are …
book
Mastering Business Intelligence with MicroStrategy
Build world-class enterprise Business Intelligence solutions with MicroStrategy 10 About This Book Fix the gap between …
book
Business Intelligence For Dummies®
You're intelligent, right? So you've already figured out that Business Intelligence can be pretty valuable in …
book
Large Scale and Big Data
Large Scale and Big Data: Processing and Management provides readers with a central source of reference …