As the project manager of the newly designed system for the oncology department, you are asked to provide a memo for the upcoming meeting with the chief executive officer (CEO) and a few senior managers. They are unaware of the features that have been designed and need a quick refresher prior to implementation. Therefore, in a 2-3 page paper, provide and explain the details of the following:
- Explain the purpose of data analysis, data transformation, and visualization.
- Give an overview of business intelligence and a data warehouse.
- Explain the basics of building tables.
- Explain the use of pivot tables.
- Identify the database to be used.
- Explain the concept of functions and expressions.