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, you will 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.