Imagine that you are talking with a business colleague. Knowing that you have been studying BI and specifically data warehousing, your colleague describes his current project, which is a data mart dealing with sales planning.
Your colleague asks for your thoughts in terms of their next steps, which you see as being the need to develop a logical design.
Explain the steps that need to be taken and any potential problems or issues that need to be addressed by either the business partners or the IT professionals.
Be sure to address the benefits, risks, and other issues associated with using external data. Discuss the availability of ERP system as the primary data source.