Business Intelligence with MicroStrategy Cookbook
eBook - ePub

Business Intelligence with MicroStrategy Cookbook

  1. 356 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Business Intelligence with MicroStrategy Cookbook

Book details
Book preview
Table of contents
Citations

About This Book

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.

Approach

Written in a cookbook style, this book will teach you through the use of recipes with examples and illustrations. Each recipe contains step-by-step instructions about everything necessary to execute a particular task.

Who this book is for

This book is intended for both BI and database developers who want to expand their knowledge of MicroStrategy. It is also useful for advanced data analysts who are evaluating different technologies. You do not need to be an SQL master to read this book, yet knowledge of some concepts like foreign keys and many-to-many relationships is assumed. Some knowledge of basic concepts such as dimensional modeling (fact tables, dimensions) will also help your comprehension of this book. No previous MicroStrategy knowledge is needed.

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Business Intelligence with MicroStrategy Cookbook by Davide Moraschi in PDF and/or ePUB format, as well as other popular books in Business & Business Intelligence. We have over one million books available in our catalogue for you to explore.

Information

Year
2013
ISBN
9781782179757

Business Intelligence with MicroStrategy Cookbook


Table of Contents

Business Intelligence with MicroStrategy Cookbook
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
Getting ready
How to do it...
How it works...
There's more...
Installing SQL Server 2012 Command Line Utilities
Getting ready
How to do it...
There's more...
Setting up the AdventureWorks DW sample database
Getting ready
How to do it...
How it works...
There's more...
Exercise 1
Installing the .NET Framework 4.0 and the 4.0.2 update
How to do it...
How it works...
Checking whether IIS is enabled and working
Getting ready
How to do it...
How it works...
There's more...
Installing MicroStrategy Suite
Getting ready
How to do it...
There's more...
Registering the MicroStrategy License
Getting ready
How to do it...
There's more....
Metadata and data warehouse
Getting ready
How to do it...
How it works...
There's more...
Creating ODBC DSN for metadata and data warehouse
Getting ready
How to do it...
How it works...
There's more...
Modifying the logon account for the Intelligence Server
Getting ready
How to do it...
How it works...
There's more...
Creating the metadata and configuring the Intelligence Server
Getting ready
How to do it...
How it works...
There's more...
Opening the MicroStrategy Desktop application
Getting ready
How to do it...
How it works...
There's more...
See also
2. The First Steps in a MicroStrategy Project
Introduction
Creating an empty project
Getting ready
How to do it...
How it works...
There's more...
Setting up a data warehouse connection and selecting tables
Getting ready
How to do it...
How it works...
There's more...
Exercise 2
Exercise 3
Modifying a table structure
Getting ready
How to do it...
How it works...
Using logical tables to create custom views
Getting ready
How to do it...
How it works...
There's more...
Exercise 4
Generating constants with SELECT statements
Getting ready
How to do it...
How it works...
There's more...
See also
3. Schema Objects – Attributes
Introduction
Attribute forms – ID and DESC
Getting ready
How to do it...
How it works...
There's more...
Using functions in an attribute form
Getting ready
How to do it...
How it works...
There's more...
Parent-child relationship I
Getting ready
How to do it...
How it works...
There's more...
Exercise 5
Parent-child relationship II
Getting ready
How to do it...
How it works...
There's more...
Exercise 6
Other attribute forms
Getting ready
How to do it...
How it works...
There's more...
Exercise 7
Selecting which forms are displayed
Getting ready
How to do it...
How it works...
There's more...
Building Data Explorer Hierarchies
Getting ready
How to do it...
How it works...
There's more...
Exercise 8
Exercise 9
Exercise 10
Creating an attribute-only report
Getting ready
How to do it...
How it works...
There's more...
Parent-child relationship in a report
Getting ready
How to do it...
How it works...
There's more...
Filters on attributes
Getting ready
How to do it...
How it works...
There's more...
Exercise 11
See also
4. Objects – Facts and Metrics
Introduction
Creating a simple counter fact and metric
Getting ready
How to do it...
How it works...
There's more...
Exercise 12
Exercise 13
Using SQL View to inspect SELECT statements
Getting ready
How to do it...
How it works... ...

Table of contents

  1. Business Intelligence with MicroStrategy Cookbook