Business intelligence with MicroStrategy cookbook / Davide Moraschi.

Format:

Book

Author/Creator:

Moraschi, Davide.

Language:

English

Subjects (All):

Business enterprises--Decision making.

Business enterprises.

Business intelligence.

Physical Description:

1 online resource (356 p.)

Edition:

1st edition

Place of Publication:

Birmingham : Packt Publishing, 2013.

Language Note:

English

System Details:

text file

Biography/History:

Moraschi Davide: Davide Moraschi is a Business Intelligence contractor and trainer. He is a MicroStrategy Certified Engineering Principal, specialized in healthcare data. Born in Italy and married to a Japanese woman, he now lives in what is probably the hottest city in Europe, Seville. He speaks English, Spanish, and fluent SQL. Since the early nineties hes been working as a Database Developer and BI specialist for multinational companies (Microsoft, Novartis) or public institutions like the European Commission. Hes the author of the blog http: //blog. eurostrategy. net, and an active member of the MicroStrategy group on LinkedIn. He can be reached at davidem@eurostrategy. net.

Summary:

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...

Contents:

Intro

Business Intelligence with MicroStrategy Cookbook

Table of Contents

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Getting Started with MicroStrategy

Introduction

Installing SQL Server 2012 Express LocalDB

Getting ready

How to do it...

How it works...

There's more...

Installing SQL Server Native Client 11.0

Installing SQL Server 2012 Command Line Utilities

Setting up the AdventureWorks DW sample database

Exercise 1

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

There's more....

Metadata and data warehouse

Creating ODBC DSN for metadata and data warehouse

Modifying the logon account for the Intelligence Server

How it works.

There's more...

Creating the metadata and configuring the Intelligence Server

Opening the MicroStrategy Desktop application

See also

2. The First Steps in a MicroStrategy Project

Creating an empty project

Setting up a data warehouse connection and selecting tables

Exercise 2

Exercise 3

Modifying a table structure

Using logical tables to create custom views

Exercise 4

Generating constants with SELECT statements

3. Schema Objects - Attributes

Attribute forms - ID and DESC

Using functions in an attribute form

Parent-child relationship I

Exercise 5

Parent-child relationship II

Exercise 6

Other attribute forms

Exercise 7

Selecting which forms are displayed

Building Data Explorer Hierarchies

Exercise 8

Exercise 9

Exercise 10.

Creating an attribute-only report

Parent-child relationship in a report

Filters on attributes

Exercise 11

4. Objects - Facts and Metrics

Creating a simple counter fact and metric

Exercise 12

Exercise 13

Using SQL View to inspect SELECT statements

Exercise 14

Understanding the GROUP BY clause

Exercise 15

Adding more facts

Exercise 16

Exercise 17

Exercise 18

Filters on metrics

Creating ranking metrics

Exercise 19

Grouping at a different level (level metrics)

Exercise 20

Embedding filters inside metrics

Exercise 21

Using Metric Join Type in reports

More Info

Creating a previous month metric (transformation)

Exercise 22

5. Data Display and Manipulation - Reports

Going deeper into data with drill down

There's more.

More Info

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

Sorting NULLs

Emphasizing numbers with conditional formatting

Printing and exporting reports

Restricting results with view filters

Exercise 23

6. Data Analysis and Visualization - Graphs

Displaying both grid and graph in the same view

Drag-and-drop objects using drop zones

Beautify your chart

Display multiple metrics with dual axis charts

Conditional formatting with thresholds

Exercise 24

7. Analysis on the Web - Documents and Dashboards

Setting up MicroStrategy Web

More Info.

Creating your first "Hello World" document

Adding data to a document - the dataset

Modifying the grouping in a document

Exercise 25

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

Restricting rows - compare an attribute to another attribute

Exercise 26

Restricting rows - evaluate on moving dates

Exercise 27

Changing the level of a metric filter

Adding interactivity to filters using prompts

Using prompts as object selectors

9. Mobile BI for Developers

Setting up the Mobile Server

Setting up a mobile connection.

Getting ready.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on online resource; title from PDF title page (ebrary, viewed November 29, 2013).

ISBN:

9781782179764

1782179763

OCLC:

862377487