I'm a JAVA developer involved in developing a data warehouse project. What are the processes involved in developing a data warehouse project and where do I start coding the project?


Les Barbusinski’s Answer: I highly recommend that you read Data Warehouse Project Management by Sid Adelman and Larissa Moss. It provides a comprehensive overview of the typical project life cycle for a data warehouse development effort.

Larissa Moss’ Answer: An excellent book that describes all of the processes involved in developing a data warehouse project is Business Intelligence Roadmap by Shaku Atre and Larissa Moss. It is a complete project life cycle methodology, which details the activities, tasks, subtasks, dependencies, entry and exit criteria, deliverables, roles and responsibilities for the 16 steps applicable to BI and DW projects. The book covers coding activities for ETL, OLAP (and reporting) and meta data repository in steps 11, 12 and 14.

Chuck Kelley’s Answer: First, and foremost, have you gotten user requirements. If not, this is the first step. Do you have a data warehouse champion from the user community who is located high enough in the management structure to effect change? If not, you need to get one. Once the requirements are gathered, then choose a small portion of the requirements and start the process of designing and implementing your data warehouse. With each iteration, add some more data to the project.

Clay Rehm’s Answer: Before you jump into the Java development, there are many activities and tasks that are needed to identify the business reason for the DW, define the project, gather the requirements, assemble the team, analyze the current environment, design the solution, etc!

The processes deal more with the purpose of the data warehouse and the requirements gathering and design – much more important than the actual coding. I would focus on understanding what the business purpose of the data warehouse is before thinking about coding.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access