Business Intelligence with MicroStrategy Cookbook
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
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.
What you will learn from this book
- Install a complete MicroStrategy server (including a web interface)
- Create a project and connect to a data warehouse
- Build reports, graphs, documents, dashboards, and interactive visualizations
- Configure and use MicroStrategy on mobile devices
- Add values to the data with month to date and year to date analyses
- Use In-Memory technology for instant results and data discovery
- Analyze data in the cloud with MicroStrategy Cloud Express
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.
totally different attribute? The customer's birthday, for example, would be a different attribute, since we may later filter or GROUP BY this column; and surely does not uniquely identify a single customer. Getting ready You need to have completed the previous recipes to do this one. We are now adding the long description to the Product attribute. 54 Chapter 3 How to do it... We are modifying the Product attribute: 1. Go to the Schema Objects | Attribute folder. Double-click on the yellow
metrics. In the following recipes we will create both facts and metrics, and see their effect on reports. 70 Chapter 4 One more thing: we cannot use a fact directly in a report; we always need to wrap the fact into a metric in order to display it on a grid or a graph. Sounds weird? Well, think that we are issuing a SELECT query with a GROUP BY clause, so every field that is not in the GROUP BY should be aggregated someway. It will be easier to see as we read on. Creating a simple counter fact
a maximum number on the left vertical margin of the graph (Y1). If the second metric has minimum and maximum values that do not fall into the first metric range, we can create a second Y axis and have the new minimum and maximum values displayed on the right margin of the chart (Y2). Let's see it with a practical example. We want to picture the sales amount from the resellers and the real product margin that each category of products has scored. We know from the previous chapters that we lost
welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of. To send us general feedback, simply send an e-mail to firstname.lastname@example.org, and mention the book title via the subject of your message. If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors. Customer support
Installation. If a User Account Control dialog pops up, click on Allow. 3. The MicroStrategy-InstallShield Wizard appears asking you to choose a language for the setup, accept the default English and click on OK. 16 Chapter 1 4. You will find yourself in front of yet another welcome page; politely click on Next and agree to the following warning message saying that the print spooler and remote registry service will be shut down during the setup (they will restart when you reboot the