Reference no: EM132840618

You have been asked to provide training for the newly hired staff of the oncology department. Prepare a PowerPoint presentation that you will use in your training. The presentation must cover the following:

Section 1: Queries

Creating, appending, updating, and deleting table queries

How queries can be used as a data source

How to locate duplicate records

Using subqueries as a criteria

The use of selecting criteria (e.g., comparison operators, limiting row and pattern matching)

Section 2: The Need for Data Warehousing

Using the library and Internet, search for information about the need for data warehousing. Additionally, consider how different approaches toward collecting data warehouse requirements help organizations in their decision-making processes.

From your research, identify the needs, basic elements, and trends in data warehousing.

Discuss how approaches to collecting data warehouse requirements can help the chosen organization in the decision-making process.

Why would this collection of data warehouse requirements help the organization?

Describe characteristics of applications and technology infrastructures commonly used in healthcare (e.g., clinical, administrative, financial).

Employ comparative analysis strategies (e.g., indicators, benchmarks, budgets, systems, performance) using business intelligence tools.

Plan, design, build, and populate a successful Data Warehouse (DW).

Differentiate various forms of graphical modeling methods used in health analytics.