Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
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

BI architecture

BI is all about delivering timely and relevant information to the right level of audience, which helps them to make an appropriate decision. In this section, we will learn about BI architecture and the components involved in it.

Components of BI architecture

Components of BI architecture

Source system: This is any stored data that will be used for BI projects. It could be a database, mainframe system or flat files, or any other system that stores Online Transaction Processing (OLTP) data. This is where data is stored in its raw form.

ETL: This process then pulls the data from the source system and prepares it for the data warehouse. It involves three steps:

  • Extract: The process of reading data from source systems
  • Transform: The process of converting data from its previous form to the form it needs to be in, either by combining data from multiple sources or by applying business rules and logic
  • Load: The process of writing data into the target database, that is, the data warehouse

Data warehouse: This is...

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