1-An analyst collects surveys from different participants about their likes and
ID: 3200176 • Letter: 1
Question
1-An analyst collects surveys from different participants about their likes and dislikes. Subsequently, the analyst uploads the data to a database, corrects erroneous or missing entries, and designs a recommendation algorithm on this basis. Which of the following actions represent data collection, data preprocessing, and data analysis? (a) Conducting surveys and uploading to database, (b) correcting missing entries, (c) designing a recommendation algorithm.
2-An analyst obtains medical notes from a physician for data mining purposes, and then transforms them into a table containing the medicines prescribed for each patient. What is the data type of
(a) the original data, and
(b) the transformed data?
(c) What is the process of transforming the data to the new format called?
Explanation / Answer
a) Conducting surveys and uploading to database, (b) correcting missing entries,
through surveys data is colleceted ,
and sending it to database (collection of data)
Data analysis includes elimnation of missing values,
replacing null values for the variables
eliminating duplicates for the variables.
First 2 steps covers the above
Answer:
(a) Conducting surveys and uploading to database, (b) correcting missing entries,
Solution2:
It is called transformed data.
Healthcare data can be classified into four categories: patient-centric data, which is directly related to patients; aggregate data, which is based on performance and utilization/resource management data; transformed-based data for planning, clinical and management decision support; and comparative data for health services research and outcomes measurement. The data source is usually the on-line transaction processing (OLTP) system or operational support system (OSS) of an enterprise.
Solutionc:
ETL comes from Data Warehousing and stands for Extract-Transform-Load.
ETL can be used to transform the data into a format suitable for the new
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.