Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering Business Intelligence with MicroStrategy

You're reading from   Mastering Business Intelligence with MicroStrategy Master Business Intelligence with Microstrategy 10

Arrow left icon
Product type Paperback
Published in Jul 2016
Publisher Packt
ISBN-13 9781785884405
Length 396 pages
Edition 1st Edition
Arrow right icon
Authors (4):
Arrow left icon
Neil Mehta Neil Mehta
Author Profile Icon Neil Mehta
Neil Mehta
Himani Rana Himani Rana
Author Profile Icon Himani Rana
Himani Rana
Ning Ma Ning Ma
Author Profile Icon Ning Ma
Ning Ma
Dmitry Anoshin Dmitry Anoshin
Author Profile Icon Dmitry Anoshin
Dmitry Anoshin
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. Getting Started with MicroStrategy FREE CHAPTER 2. Setting Up an Analytics Semantic Layer and Public Objects 3. Building Advanced Reports and Documents 4. Advanced Visualization Techniques 5. Customization of MicroStrategy 6. Predictive Analysis with MicroStrategy 7. Accelerating Your Business with Mobile Analytics 8. Data Discovery with MicroStrategy Desktop 9. MicroStrategy System Administration 10. Design and Implementation of the Security Model 11. Big Data Analytics with MicroStrategy 12. MicroStrategy Troubleshooting

Building ad hoc schemas


MicroStrategy Desktop allows us to build ad hoc schemas in intuitive ways using a friendly interface. Ad hoc schemas help business users to achieve quicker values. The core of the ad hoc building process is Data Import, which has many features such as auto-detect attributes type, auto-create metrics, auto-identify data relations, and allows us to preview data. In addition, it allows us to combine data from multiple sources in a single dataset, create multi-form attributes, and create and edit relationships across attributes. Finally, it can be mapped to project attributes in order to inherit project security filters in MicroStrategy Enterprise.

We are going to work with relational databases and use the same source as we used in Chapter 2, Setting Up an Analytics Semantic Layer and Public Objects when we built schemas. There is a picture from CA ERwin Data Modeler, that displays physical data models. Using this model, we can easily identify what tables we need and what...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime