Database ArchitectureDataGem is qualified to perform any or all of the following database architecture tasks:
- Analyze business process needs.
- Analyze consumers of data including transaction support, reports, electronic forms, and key performance indicators (KPIs).
- Analyze current and future sources of the required data including local and remote databases, spreadsheets, and data entry transactions.
- Develop and implement the required database architecture employing SQL Server or other database engines.
- Design and implement pathways to consolidate data into database warehouse and data marts that meet reporting needs.