Proper design and implementation of the ETL process is crucial to a BI project. ETL is considered the most time consuming phase of the Data Warehousing project. Therefore, anything that might go wrong with this process will significantly affect the success of the BI application.
With that in mind, we have to answer the questions: What could go wrong in this process and how can it be corrected?
Let's break the question down into three parts:
1) Why is the proper design and implementation of the ETL process crucial to a BI project?
2) What could go wrong in this process?
3) How can it be corrected?
Briefly respond to all three parts in your post. We will elaborate more in the discussions.