The KDS Group IT Solutions consultants have been involved in dozens of data warehousing and business intelligence projects. Our areas of expertise include:
- Project planning, organization and management
- Working with the business to gather business requirements, create data models based on these requirements and designing BI functionality to meet these needs
- Designing and implementing DW and BI architecture
- Designing data models and databases to implement these models
- Integrating data from other applications such as CRM, SCM, ERP, and Web
- Selection and use of Extract, Transform & Load (ETL) tools to populate the necessary databases
- Selection and use of Business Intelligence (BI) & On-Line Analytical Processing (OLAP) tools to provide the necessary business functionality
Project scope & initial analysis
- Business & IT Requirements
- Priorities
- Project plan
- Resource plan
Detailed design
- Logical data models
- Extract, transform and load (ETL)
- Reporting & analytical functionality
Development
- Infrastructure setup
- Physical databases
- Extract, transform and load (ETL)
- Reporting and analytical functionality
Testing
- Unit
- Integration
- Acceptance
Implementation
|
The following activities take place throughout all phases of the project: |
- Project management
- Status and communication
- Quality control
- Scope and change management
- Knowledge transfer
| |