Book Image

Discovering Business Intelligence using MicroStrategy 9

Book Image

Discovering Business Intelligence using MicroStrategy 9

Overview of this book

Business Intelligence is a type of technology that has been proven to support business decisions in an organization. MicroStrategy 9 is a fully-integrated BI platform that makes Business Intelligence faster, easier, and more user-friendly. It enables businesses to generate their own reports and dashboards without the need for technical knowledge.This practical, hands-on guide will provide Business Intelligence for executives, as well as enable BI reports and dashboards without the dependency of IT savvy personnel. It will allow you to design, build, and share business relevant data in hours, in a secure way, including mobile devices and show you how to leverage your transactional information.This example-oriented book looks at the value proposition of cloud computing and the MicroStrategy platform, and features practical exercises for BI reports and dashboard enablement, including the design phase and best practices for when we design a BI report.The book begins with an exploration of MicroStrategy along with typical business needs. Our focus then shifts to best practices for BI reports and dashboard definitions from the functional stand point, with easy-to-do exercises that will allow you to enable the reports in the platform. You will learn about scorecards and dashboards, along with sharing the reports. Next, you will get acquainted with cloud-based services provided by the MicroStrategy platform. By the end of this book, you will able to design, enable, and share BI reports and dashboards without the need for comprehensive technical knowledge, and leverage the latest technology on the market.
Table of Contents (16 chapters)

Chapter 3. Reporting – from Excel to Intelligent Data

Microsoft Excel is the most common tool for business reporting and analytics. Despite its excellent capabilities in that role, the final objective of Microsoft Excel is not concerned with its Business Intelligence (BI) capabilities. There is a set of specialized platforms and tools for that purpose, and MicroStrategy is one of the best providers for BI.

Gartner defines BI as:

"Business intelligence (BI) is an umbrella term that includes the applications, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance."

In this chapter, we will learn the reporting concepts for data manipulation and their implementation in the MicroStrategy platform in a simple and practical way. Additionally, we will learn how to use the MicroStrategy platform to its maximum strength. At the end, using MicroStrategy will be as easy as using Microsoft Excel. Please keep in mind...