Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Business Intelligence with MicroStrategy Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
Business Intelligence with MicroStrategy Cookbook

Business Intelligence with MicroStrategy Cookbook

By : Davide Moraschi
3.8 (11)
Buy this Book
close
close
Business Intelligence with MicroStrategy Cookbook

Business Intelligence with MicroStrategy Cookbook

3.8 (11)
By: Davide Moraschi
Buy this Book

Overview of this book

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 (25 chapters)
close
close
close
Business Intelligence with MicroStrategy Cookbook
Icon
Business Intelligence with MicroStrategy Cookbook
Credits
Icon
Credits
Foreword
Icon
Foreword
About the Author
Icon
About the Author
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Free Chapter
1
Getting Started with MicroStrategy
Icon
Getting Started with MicroStrategy
Icon
Introduction
Icon
Installing SQL Server 2012 Express LocalDB
Icon
Installing SQL Server Native Client 11.0
Icon
Installing SQL Server 2012 Command Line Utilities
Icon
Setting up the AdventureWorks DW sample database
Icon
Installing the .NET Framework 4.0 and the 4.0.2 update
Icon
Checking whether IIS is enabled and working
Icon
Installing MicroStrategy Suite
Icon
Registering the MicroStrategy License
Icon
Metadata and data warehouse
Icon
Creating ODBC DSN for metadata and data warehouse
Icon
Modifying the logon account for the Intelligence Server
Icon
Creating the metadata and configuring the Intelligence Server
Icon
Opening the MicroStrategy Desktop application
2
The First Steps in a MicroStrategy Project
Icon
The First Steps in a MicroStrategy Project
Icon
Introduction
Icon
Creating an empty project
Icon
Setting up a data warehouse connection and selecting tables
Icon
Modifying a table structure
Icon
Using logical tables to create custom views
Icon
Generating constants with SELECT statements
3
Schema Objects – Attributes
Icon
Schema Objects – Attributes
Icon
Introduction
Icon
Attribute forms – ID and DESC
Icon
Using functions in an attribute form
Icon
Parent-child relationship I
Icon
Parent-child relationship II
Icon
Other attribute forms
Icon
Selecting which forms are displayed
Icon
Building Data Explorer Hierarchies
Icon
Creating an attribute-only report
Icon
Parent-child relationship in a report
Icon
Filters on attributes
4
Objects – Facts and Metrics
chevron up
Icon
Objects – Facts and Metrics
Icon
Introduction
Icon
Creating a simple counter fact and metric
Icon
Using SQL View to inspect SELECT statements
Icon
Understanding the GROUP BY clause
Icon
Adding more facts
Icon
Filters on metrics
Icon
Creating ranking metrics
Icon
Grouping at a different level (level metrics)
Icon
Embedding filters inside metrics
Icon
Using Metric Join Type in reports
Icon
Creating a previous month metric (transformation)
5
Data Display and Manipulation – Reports
Icon
Data Display and Manipulation – Reports
Icon
Introduction
Icon
Going deeper into data with drill down
Icon
Manipulating grids – Pivot and page-by
Icon
Dynamically adding and removing objects in reports
Icon
The bottom line – customizing subtotals
Icon
Avoiding missteps – NULL values in facts
Icon
How to sort data in grids
Icon
Emphasizing numbers with conditional formatting
Icon
Printing and exporting reports
Icon
Restricting results with view filters
6
Data Analysis and Visualization – Graphs
Icon
Data Analysis and Visualization – Graphs
Icon
Introduction
Icon
Displaying both grid and graph in the same view
Icon
Drag-and-drop objects using drop zones
Icon
Beautify your chart
Icon
Display multiple metrics with dual axis charts
Icon
Conditional formatting with thresholds
7
Analysis on the Web – Documents and Dashboards
Icon
Analysis on the Web – Documents and Dashboards
Icon
Introduction
Icon
Setting up MicroStrategy Web
Icon
Creating your first "Hello World" document
Icon
Adding data to a document – the dataset
Icon
Modifying the grouping in a document
Icon
Stepping up to dashboards
Icon
Using the editable mode to fine-tune the design
Icon
Adding interactivity with panels and selectors
Icon
Embedding images, HTML, and links
Icon
Switching to Adobe Flash mode
8
Dynamic Selection with Filters and Prompts
Icon
Dynamic Selection with Filters and Prompts
Icon
Introduction
Icon
Restricting rows – compare an attribute to another attribute
Icon
Restricting rows – evaluate on moving dates
Icon
Changing the level of a metric filter
Icon
Adding interactivity to filters using prompts
Icon
Using prompts as object selectors
9
Mobile BI for Developers
Icon
Mobile BI for Developers
Icon
Introduction
Icon
Setting up the Mobile Server
Icon
Setting up a mobile connection
Icon
Installing and configuring the mobile client
Icon
Adapting content to the iPad screen
Icon
Using mobile views in documents
Icon
Adding panels to mobile documents
Icon
Creating panel selectors
Icon
Adding details with pop-up windows
Icon
Linking from one document to another
10
Mobile BI for Users
Icon
Mobile BI for Users
Icon
Introduction
Icon
Answering prompts in reports or documents
Icon
Sorting, drilling, and paging
Icon
Adding notes and sharing
Icon
When things go wrong
11
Consolidations, Custom Groups, and Transformations
Icon
Consolidations, Custom Groups, and Transformations
Icon
Introduction
Icon
Creating virtual attributes with consolidations
Icon
Aggregating results with custom groups
Icon
Creating bands on metrics (custom groups banding)
Icon
Month-to-date and year-to-date transformations
12
In-Memory Cubes and Visual Insight
Icon
In-Memory Cubes and Visual Insight
Icon
Introduction
Icon
Creating a cube from an existing report
Icon
Building a new cube
Icon
Scheduling data refresh
Icon
Creating reports and documents based on a cube
Icon
Exploring data with Visual Insight
Icon
Using the network visualization
13
MicroStrategy Express
Icon
MicroStrategy Express
Icon
Introduction
Icon
Creating an Express account
Icon
Importing Excel data
Icon
Using filters
Icon
Importing cross-tabbed data
Icon
Connecting to a RDBMS
Icon
Refreshing dashboard data
Icon
Sharing a dashboard by e-mail
Solution to Exercises
Icon
Solution to Exercises
Icon
Exercise 1
Icon
Exercise 2
Icon
Exercise 3
Icon
Exercise 4
Icon
Exercise 5
Icon
Exercise 6
Icon
Exercise 7
Icon
Exercise 8
Icon
Exercise 9
Icon
Exercise 10
Icon
Exercise 11
Icon
Exercise 12
Icon
Exercise 13
Icon
Exercise 14
Icon
Exercise 15
Icon
Exercise 16
Icon
Exercise 17
Icon
Exercise 18
Icon
Exercise 19
Icon
Exercise 20
Icon
Exercise 21
Icon
Exercise 22
Icon
Exercise 23
Icon
Exercise 24
Icon
Exercise 25
Icon
Exercise 26
Icon
Exercise 27
Icon
Exercise 28
Icon
Exercise 29
Icon
Exercise 30
Icon
Exercise 31
Icon
Exercise 32
Icon
Exercise 33
Icon
Exercise 34
Icon
Exercise 35
Where to Look for Information
Icon
Where to Look for Information
Icon
Online resources
Icon
Blogs
Icon
Books
Cloudera Hadoop
Icon
Cloudera Hadoop
Icon
Introduction
Icon
Connecting to a Hadoop database
HP Vertica
Icon
HP Vertica
Icon
Introduction
Icon
Connecting to a Vertica database
Index
Icon
Index

Understanding the GROUP BY clause

Aggregate data is what reports are made of; speaking ANSI SQL, this means GROUP BY. MicroStrategy applies GROUP BY to all the attributes present on a report grid. Well, this is not completely correct, but we begin with this simple concept:

Every attribute on a grid is reflected in the GROUP BY clause of the resulting SELECT statement.

Hence, we have:

  • Metrics that represent the aggregation (sum, count, and so on) of facts

  • Attributes BY which we GROUP the data

I hope this is clear enough, because this concepts will return every now and then with metrics. In this recipe, anyway, we'll see an example of how it works.

Getting ready

We are using now the SalesAmount metric and the Product attribute. Before going on we need to establish a connection between the fact table and the attribute table, so that MicroStrategy knows how to JOIN them.

The connection is represented by the FK (ProductKey) in FactInternetSales. In other words, the ID form of Product is present in both...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 5
Next Section

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY