Metadata and data warehouse
These are two key concepts in every BI project with MicroStrategy so we'd better have them clear since the beginning.
Metadata is data about data (what?). Ok, let's say that in the metadata you won't find any customer names or sales figures or any other fact, you'll just find information about the columns where this data come from, the datatype, and several other details about how to create the customer entity, for example, how does it relate to other elements in the project and where it is stored, plus the definition of all the reports.
While the data warehouse is the real source of the facts and dimensions that you will analyze. So, in principle, metadata and data warehouse are different databases and/or different instances; ...
Get Business Intelligence with MicroStrategy Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
