Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Business Intelligence with MicroStrategy Cookbook
Business Intelligence with MicroStrategy Cookbook

Business Intelligence with MicroStrategy Cookbook: Over 90 practical, hands-on recipes to help you build your MicroStrategy business intelligence project, including more than a 100 screencasts with this book and ebook

Arrow left icon
Profile Icon Davide Moraschi
Arrow right icon
€18.99 per month
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.8 (11 Ratings)
Paperback Oct 2013 356 pages 1st Edition
eBook
€8.99 €36.99
Paperback
€45.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Davide Moraschi
Arrow right icon
€18.99 per month
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.8 (11 Ratings)
Paperback Oct 2013 356 pages 1st Edition
eBook
€8.99 €36.99
Paperback
€45.99
Subscription
Free Trial
Renews at €18.99p/m
eBook
€8.99 €36.99
Paperback
€45.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

Business Intelligence with MicroStrategy Cookbook

Chapter 2. The First Steps in a MicroStrategy Project

In this chapter, we will cover:

  • Creating an empty project

  • Setting up a data warehouse connection and selecting tables

  • Modifying a table structure

  • Using logical tables to create custom views

  • Generating constants with SELECT statements

Introduction


At this point, you should have a testing machine ready-to-use with all the samples in place. In the previous chapter, we have learned how to install SQL Server and the MicroStrategy platform. In this chapter, we start creating the schema objects that represent the building blocks of our BI project.

Schema objects are the metadata components that are logically closer to the physical structure of the database; they are used to create more complex elements (applications or public objects) that will later form reports and documents. Facts and tables, for example, are schema objects. Also attributes, which we'll cover in Chapter 3, Schema Objects – Attributes, are schema objects.

The first schema objects that we need to identify are the tables holding our facts and dimensions.

Note

We will use the sample database AdventureWorks, which is about a sport gear shop. The size of the data is limited but the overall structure of the tables is quite interesting and covers a number of use cases...

Creating an empty project


The first step in a MicroStrategy BI application is creating an empty project. An Intelligence Server can host many projects. Projects can be copied from one Intelligence Server to another. Think of a project as a way to keep all the related objects together. A project must have at least one connection to get data from the data warehouse.

Getting ready

You need to have completed the previous chapter to continue.

How to do it...

In this first recipe we'll create a project:

  1. Open Start | All Programs | MicroStrategy | Desktop menu and click on the Desktop icon.

  2. Log in with Administrator and the corresponding password and right-click on the topmost folder named MicroStrategy Analytics Modules.

  3. From the context menu that appears, select Create New Project....

  4. In the Project Creation Assistant, click on Create project.

  5. Type a name in the first textbox, for example, COOKBOOK and click on OK. We accept all the defaults for now. Once the wizard terminates creating the project, you...

Setting up a data warehouse connection and selecting tables


At the core of a data warehouse, there are facts and dimensions. They can be organized in star schemas, snowflake schemas; they can be more or less complex, and to some extent undocumented. This is not a book about dimensional modeling and discussing how a database layout works better than other is out of scope. Some common sense rules always apply: consistent column naming can be useful (user_id, iduser, user_code, key_user, yetanotheruserid, you name it…), constraints on tables help to pull the strings and find a way into unexplored databases. NOT NULL fields also come in handy.

I personally had my share of good and bad data. I always remember a development team manager who once asked me, "Why do you need primary keys, anyway?" I looked around and thought, "This must be a candid camera…"

If you are drowning in a very complex DB and want some relief, you can go to http://at5.us/Ch2U2 and read about the Directive 595, it may be a...

Modifying a table structure


Like it or not, database tables change. Due to upgrades in source systems, mergers and acquisitions, or simply because of a shift in the project management, we suddenly find that an SKU or a customer ID is not there anymore. Let alone systems in continuous development where the database seems to have a life of its own and morphs every now and then into different shapes. We all know how difficult it is to go back and test every ETL script and every report to see if they still return reliable data.

Sometimes changes happen without notice, you come to the office on a Monday morning to see that the CFO has a different color…, then you realize that something went wrong.

There is no vaccine for this, other than carefully documenting everything and hope for the best. Let's see how to refresh our table structure information using the Warehouse Catalog window.

Getting ready

You need to have completed the previous recipe and exercises to continue.

How to do it...

First of all...

Using logical tables to create custom views


Logical tables are schema objects that are somehow similar to SQL views. They are not a representation of an existing table but a SELECT statement that returns a series of columns. There are cases in the course of a BI project when you need the data to be in a different shape than in the source tables, so you have two choices: modify the data warehouse or create logical tables.

Sometimes access to the data warehouse is simply out of the question, or it takes weeks, or the paperwork needed to approve the modification is just not worth it.

To be clear, whenever possible, I prefer changing the data warehouse over creating logical tables because there may be other applications that use that data and it's probably wise to have a common base for every app, but I resort to logical tables for cases like the one in this recipe when I need the data to be prefiltered for a specific purpose.

Getting ready

Look at the DimEmployee table in the database diagram...

Generating constants with SELECT statements


During the development of a BI project, sometimes we need to use values which do not necessarily come from tables; these can be constants such as Data refreshed at or Today. The logical tables come in very handy for this purpose.

Getting ready

You can find the SELECT statement for this recipe in the companion code file.

How to do it...

To create a logical table that returns the current date as a constant, do the following:

  1. Go to the Schema Objects | Tables folder and right-click on an empty space in the right pane. From the context menu, choose New | Logical Table.

  2. In the SQL statement text area, paste this sentence:

    select DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) DateValue
    
  3. Add one Column Object and name it DateValue, and select Date from Data Type.

  4. Click on Save and Close and name it Today.

  5. Update the schema.

How it works...

We created a very simple table with one row and one column. This table will always return the current date at midnight; it is...

Left arrow icon Right arrow icon

Key benefits

  • 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

Description

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.

Who is this book 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.

What you will learn

  • 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

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Oct 26, 2013
Length: 356 pages
Edition : 1st
Language : English
ISBN-13 : 9781782179757
Category :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Oct 26, 2013
Length: 356 pages
Edition : 1st
Language : English
ISBN-13 : 9781782179757
Category :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 124.97
Business Intelligence with MicroStrategy Cookbook
€45.99
Discovering Business Intelligence using MicroStrategy 9
€28.99
Mastering Business Intelligence with MicroStrategy
€49.99
Total 124.97 Stars icon
Banner background image

Table of Contents

13 Chapters
Getting Started with MicroStrategy Chevron down icon Chevron up icon
The First Steps in a MicroStrategy Project Chevron down icon Chevron up icon
Schema Objects – Attributes Chevron down icon Chevron up icon
Objects – Facts and Metrics Chevron down icon Chevron up icon
Data Display and Manipulation – Reports Chevron down icon Chevron up icon
Data Analysis and Visualization – Graphs Chevron down icon Chevron up icon
Analysis on the Web – Documents and Dashboards Chevron down icon Chevron up icon
Dynamic Selection with Filters and Prompts Chevron down icon Chevron up icon
Mobile BI for Developers Chevron down icon Chevron up icon
Mobile BI for Users Chevron down icon Chevron up icon
Consolidations, Custom Groups, and Transformations Chevron down icon Chevron up icon
In-Memory Cubes and Visual Insight Chevron down icon Chevron up icon
MicroStrategy Express Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.8
(11 Ratings)
5 star 54.5%
4 star 18.2%
3 star 0%
2 star 9.1%
1 star 18.2%
Filter icon Filter
Top Reviews

Filter reviews by




eric h souare Jan 03, 2014
Full star icon Full star icon Full star icon Full star icon Full star icon 5
One of the first manuals outside of the official Microstrategy (vendor) publications. I like that it takes you through an entire report development cycle. The steps are easy to follow and the instructions accurate.On a personal note, I have known Davide for a few years now. When I am stuck on a complex microstrategy problem, he is the only one I go to.
Amazon Verified review Amazon
SF Dec 24, 2014
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The author leads the reader through a series of bona-fide workshops that will give you a strong understanding of the sophisticated and robust data warehouse/business intelligence environment of MicroStrategy. If you have already used MicroStrategy tools, the labs can fill out your knowledge set. Either way, the Kindle and this book together are the perfect application for investing your time in the labs - and you SHOULD go through all the labs - because you not only can read through the directions on the Kindle, you can EASILY navigate to the URI links provided in the book without losing your train of thought in your extant lab. Either way: go through the book, and the author will have opened a door of BI knowledge that is difficult to penetrate: the MicroStrategy BI environment.
Amazon Verified review Amazon
Dmitry Mar 28, 2016
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Very good book, especially for the people who has experience with other BI and want to quickly switch on Microstrategy.
Amazon Verified review Amazon
Ashish Feb 11, 2014
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This is the first book by an independent MSTR expert which goes from scratch till full development cycle. Absolutely recommended for beginners, good refresher for architects. The best part is it takes on a Data Model, goes through every step of development in a very precise and simple to understand steps. It gives explanation through its "How it works" section which I think should be how a good guide should be written.It covers almost every aspects of MSTR objects which a developer needs to know.It also gives good input of various new products from MicroStrategy.Just for note: This is a cookbook and not a detail theory book so it will give reader all the ammunitions to fight the extreme curve of learning MSTR but for detail learning reader should keep MSTR product guides handy and go through them. These product guides are still the ones without which learning MSTR is incomplete.For the author: I would like to see a similar cookbook, a sequel to this basic guide which is on advance topics simulating the common DW scenarios and one on Administration for beginners including EM, Metadata, IM, OM. Thanks for this good read!Regards,Ashish
Amazon Verified review Amazon
Jag Feb 25, 2015
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Price is very less compare to competitors. 👌👍
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.