Assume that you are consulting with a telecommunications company that is working on a data warehouse project. As the project approaches the implementation phase, you realize that success at this critical juncture depends on key stakeholders. Create a diagram that illustrates the concept of the ETL process. Incorporate data sources from their enterprise under study as part of your extraction. To create your diagram, you may use Microsoft Visio, Word, PowerPoint, or another software of your choice.

Explain your model in a two-page summary to include:

Outline the ETL process.

Describe any assumptions or limitations with data collection, extraction, and storage.

Identify the data sources as outlined by the manager or leader of the project team.

Provide a preliminary outline of the types of reports that can be used for business managers, leadership, and other stakeholders for data-based business decisions.

Identify the major challenges that exist. Suggest some practical steps to meet these challenges.