I have been actively involved in working with one of my clients to plan ,design and architect a solution to help them analysis their business critical data. The final solution consisted of a Data Warehouse and Data mart using Oracle tool set, an ETL solution using the Informatica tool set and a User Analysis solution using Business Objects. The lessons learnt during this engagement are discussed below in the following buckets:

Impact of end Users – The perception, awareness and domain knowledge of the users, all play an important role in the successfully development of the solution and its acceptance by the end users.

Data – The various issues which surround the core of the solutions need to be understood and addressed include transparency, confidence etc

Project Management- Successful completion of the project and the quality of the final deliverables are impacted by these issues which include – well defined process and milestones, change management etc.