Objective: Design, develop, deploy, and maintain Datamarts with a focus on performance, security, and usability.
Steps:
Data Discovery and Requirements Gathering
- Action: Identify business requirements, profile data, and align with stakeholders.
- Deliverable: Business requirements document, stakeholder alignment summary.
- Control Measures: Data discovery supported by myBMT, ensuring all in-scope data is discoverable.
Datamart Design and Security Planning
- Action: Design the data models, schema, and architecture for the Datamart. Plan for security and access control.
- Deliverable: Data models (conceptual, logical, physical), security specifications.
- Control Measures: Sensitivity levels defined, data tagged for owner and metadata classification, schemas with restricted access policy applied.
MVP Development and Iteration
- Action: Develop a minimum viable product of the Datamart, iterating based on feedback.
- Deliverable: MVP with essential features, test reports.
- Control Measures: Prototypes developed, feedback logged, and iterated on MVP features.
Deployment and Go-Live
- Action: Deploy the Datamart into the production environment, ensuring system readiness and user training.
- Deliverable: Deployed Datamart system, user training materials.
- Control Measures: Environments set up, data integrated, security measures validated, users trained.
Maintenance and Performance Testing
- Action: Regular maintenance, performance testing, and documentation updates for Datamarts.
- Deliverable: Performance test reports, updated documentation.
- Control Measures: Snapshots of DataMart views taken weekly, performance testing conducted, and documentation stored in myBMT.