Data Schema Design
Depending on the specific need and the demands of the system that will be required to meet that need, it often makes sense to designate a separate database for reporting/analytics or redesign/enhance an existing data mart. It is important that this database be built (or rebuilt) with many factors considered:
- Business processes
- What the Database needs to do
- What systems are providing the data (ERP, CRM, SCM, Financial/Accounting Systems)
- Attributes to include
- Facts to be measured
- Handling of changes and historical information
Whether you have an existing database that needs to be redesigned, or you need an entirely new database to support a new reporting system, we can help. In the case of a separate database for reporting/analytics, you will need to be loading your data from your source system into it on a routine schedule. This is commonly known as the Extract/Transform/Load (ETL) phase.