Book Image

Business Intelligence with MicroStrategy Cookbook

By : Davide Moraschi
Book Image

Business Intelligence with MicroStrategy Cookbook

By: Davide Moraschi

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)
Business Intelligence with MicroStrategy Cookbook
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Foreword

Information is the most important competitive force shaping the business landscape today. Companies that harness information well are more efficient because they manage their resources with less waste. They are more nimble because they can sense what is happening in the market more keenly and quickly. The other major economic factors, land, labor, and capital are important, but after 300 years of the Industrial Age experience, their use has been reduced to commoditized best practices. Companies and products are no longer distinguished by innovative uses of land, labor, or capital. But when you find an organization that creates marketing strategies based on deep customer insight, or manages inventory using predictive analytics, or sets prices dynamically based on fine-grained demand variations, then you have found an organization that is outperforming its competitors. In this new information age, information is king.

The power of information is becoming greater every year. Our digital world is being “instrumented” at an unprecedented level. Computing is everywhere and it is capturing everything—every transaction, every website visit, every image viewed, every product shipped, every container stacked, and every product scanned. Businesses are drowning in opportunities to exploit so much data. They are limited only by the ingenuity of the information professionals whose job it is to tame it and business professionals who consume it.

MicroStrategy technology was created to tackle the biggest challenges in business intelligence, that is, to analyze the largest datasets with the most sophisticated analytics, and to empower the largest business user populations to consume and manipulate it. To this day, MicroStrategy is widely recognized as one of the most powerful analytic technologies available. MicroStrategy technology is like a nuclear power plant generating information energy for millions of business consumers. But like a nuclear power-plant, it is entirely dependent on skilled professionals to run it.

Mr. Moraschi’s excellent book is designed to bring information proficiency to a whole new generation of information producers and business people whose jobs increasingly revolve around information, and not just IT professionals. The brilliance of this book is that it blends both concepts and mechanics into one narrative. Readers learn about the structure and terminology that underlie information engineering, and then learn the mechanics of how to use MicroStrategy to turn that information into insight. At a macro level, this is an important book because it will accelerate information literacy in business professionals. At a personal level, it is important because it can propel people into new and prosperous careers in information.

Mark S. LaRow

Executive Vice President of Products, MicroStrategy