Main Components of a DataMart
Data Marts serve as the “system of record” for decision making and information retrieval purposes of an organisation; providing easy and powerful access to data. Its architecture is made up of five main components:
a) Internal Data Source / Operational Databases; Information that is procured, reported and consolidated within your organization, for example: purchase orders from sales, transactions from accounting, and leads from marketing or information from CRM software.
b) External Data Sources: any information obtained from a source outside of your organization, for example: information collected through census or surveys.
ETL = Extract – Transform – Load
4/5. OLAP DATAMART / REPORTING
The OLAP DataMart is made up of the relational database (Data Mart) and the OLAP Cube.
(OLAP) Online Analytical Processing is the analyses of business data for the release of business insight.
Similar to the staging database; the relational database is specifically created and loaded with the subset of data. The OLAP cube is built and processed; and uses its in-built reporting tools to provide enhanced analytics and value add data to the organisation.
** Depending on your reporting requirements; you may receive just the OLAP cube or both components**
Using OLAP cubes, an organisation can: