Business Intelligence: Data Analysis & Electronic Health Records

This report delves into business intelligence, focusing on the significance of electronic health records (EHR) and data analysis. It highlights the importance of EHR in modern healthcare, emphasizing data privacy and security. The report also explores changes in the EHR system due to technological advancements and discusses how these changes benefit patients and providers. Furthermore, the report includes an exploratory data analysis of a loan delinquency dataset using RapidMiner, aiming to develop a predictive model for loan defaults at ACME bank. The analysis covers various factors influencing loan delinquency, such as revolving utilization, age, debt ratio, and monthly income, providing a comprehensive overview of the dataset's characteristics.

Running Head: BUSINESS INTELLIGENCE
Business Intelligence
Name of the Student
Name of the University
Student ID

1BUSINESS INTELLIGENCE
Table of Contents
Task 1...............................................................................................................................................2
Introduction..................................................................................................................................2
Importance of the Electronic Records.........................................................................................3
Electronic Health Record Changes..............................................................................................4
Task 2...............................................................................................................................................6
Task 2.1........................................................................................................................................6
Task 2.2......................................................................................................................................14
Task 2.3......................................................................................................................................17
Task 2.4......................................................................................................................................18
Task 3.............................................................................................................................................20
Task 3.1......................................................................................................................................20
Task 3.2......................................................................................................................................22
Task 3.3......................................................................................................................................22
Task 3.4......................................................................................................................................23
Task 3.5......................................................................................................................................24
List of References..........................................................................................................................26

2BUSINESS INTELLIGENCE
Task 1
Introduction
My health record is the system which helps people to track all their important information
regarding the health care together in a single place. The system gives an online summary of the
major information regarding the health of a person. Significant benefits are provided to the
society with the help of this health research policy as well as its privacy policies for protection
(Digitalhealth.gov.au 2018). For the improvement of health care, this health research is an
extremely important policy. Protection of organizational information is extremely important and
hence the hardware of this application has been so developed that it will ensure the protection of
the information to getting disclosed to any unauthorized personnel. The technological assets used
by the organizations are also ensured by health research to be protected (Islam et al. 2015).
Protection of information is so important to the health care sector that misuse of any information
can cause life threats to an individual.
Thus, keeping in mind all these issues, the Digital Health Care system of Australia very
carefully handles all the information that are personal to the individuals as well as to the
company. A lot of health care systems have developed in the recent years. Thus, it is important
for the health care companies to have information about the health records of the individuals, so
that they can be treated properly. As there has been advancement of technology, it is applied to
therapies and diagnosis and hence the information also becomes available to everyone very
easily (My Health Record 2018). Generic data on an individual is necessary for prenatal testing.
With the help of this facility, the generic information has also become available very easily.
Certain people have certain risks to their lives under certain conditions, which at times they
forget to mention to doctors at the time of treatment quite often (Walsh et al. 2018). This might

3BUSINESS INTELLIGENCE
cause problems at the time of treatment and might also become life threatening. Hence, with the
record of all the medical records in this system, it can be accessible to the doctors at any point of
time, they go through the medical history and hence continue their treatments. The chances of
malpractices can be reduced with the help of this system of records. Thus, it can be said that this
health record tool is extremely significant to the treaters as well as to the patients (Lupton 2014).
The health care providers can record all the information, instructions and reports that the person
has observed while treating the patient. Further, if all the information is shared in the tool, the
third party can also access the information and make all the necessary payments that will be
required for all the treatments.
Importance of the Electronic Records
The most important aspect nowadays in the health care sector is the privacy of the
information. Thus, whenever the information is shared electronically, it becomes a challenge to
protect the privacy of the information. But maintaining the confidentiality is extremely
important. It is important because, nowadays, accessing information from various sources has
become extremely easy with the advancement of technology. It is not always possible to keep a
photocopy of the health records when there are large number of records available. Thus, storing
the records electronically is much more feasible (Meurk et al. 2016). Further, computer based
health record is a valuable commodity in the recent days. It has also been observed in recent days
that some of the companies gather information on health records and other pharmacies and
disclose it to their own company so that they can earn incentives by selling all this information
(Falster et al. 2015). In the recent days, all the data are linked to a lot of other sources, and thus
with the help of networking, it becomes extremely easy to access all this information. This even
possible from remote areas as well. Thus, if any kinds of privacy measures are not adopted, then

4BUSINESS INTELLIGENCE
all the information can be easily accessed by anybody and they will collect all the information
without even leaving any trail of it (Wang, Kung and Byrd 2018). It will not be a problem for the
programmers before they identify all kinds of health data from the systems which can contain all
information related to the health of the entire population. The information on the patients who
are being treated are accessible to the providers from the electronic source and can prescribe any
kind of medications or preventions for their problems. The electronic health care system has
recently been paired with the mobile technology and this is being termed as the technological
advancement which is the biggest in the recent years that the health care industry has seen (Shaw
et al. 2017). With the help of this technological advancements, the providers can provide service
to the needful in a very less time as compared to the paper reading method. All the health and the
financial management records are provided electronically as well so that it can be accessed to the
relatives at any point of time from anywhere. There can be errors in input which can also be
reduced such as objections by the insurance companies for the reimbursement of claims. The
confidentiality obligations are the same as that of the time when access was made by papers as
well as from the hospital electronic records. The confidentiality of the information though is
much more dependent on the user of the information holder as they have to password protect all
the information safely (Greene et al. 2015).
Electronic Health Record Changes
There have been huge changes in the electronic health record system as there has been
huge advancements in technology. To keep the system updated, these changes are necessary. The
support of the states in utilizing the electronic health records has been more due to the variation
in the nations. Thus the authorities have proposed various changes to the electronic health record
system and thus the market is going through all these changes. This system has become

5BUSINESS INTELLIGENCE
extremely in most of the hospitals and there has been observation of significant changes in the
outcomes of the patients in the recent days. It has been observed via a survey conducted by the
National Centre of Health Statistics that with the help of this electronic health record system, 75
percent of the patients has been benefitted. Still there is a scope for 25 percent of the patients
who have not been benefitted by the system and hence the system is on its development to reach
this target in the recent future. Despite of storing data, the system also provides various
information which can be used for the benefits of the patients (Greene et al. 2015). The system is
also eligible enough to remind a patient to go for new medications and also alert the doctors for
any kinds of issues. This has been the importance of the digital technology in the lives of the
providers. But the technology has also brought benefits to the lives of the patients.
The Australian digital agency has assured that they will be collecting the information
from the patients as well as from the doctors and the organizations and they will provide
necessary protection for the confidentiality of the documents. From the end of the privacy act in
1988, the organization has been protecting the confidentiality of the people of Australia
(Legislation.gov.au 2018). “My Health Record System” is a system which the system operator of
health record is instructed to maintain and would mostly be dealing with information on the
recipients of the health care. The state laws prevent the data from being shared. Other types of
records are thus sored as the instruction of the operators of the registered repositories. According
to the law, there are civil as well as criminal penalties involved if the information from these
databases are disclosed without any kind of authorization. Different undertakings and
enforcements can also be applied if anything of that sort happens (Legislation.gov.au 2018).
Information is received by the agency with the help of phone calls, mails, common public
and health care operators as well as from facsimiles. The information collected by the agency

6BUSINESS INTELLIGENCE
includes the job title of the individual, his or her respective image, records as an employee,
details of his or her bank accounts, contact information and history of his work life. With the
help of registration to the digital health services, identification of an individual to the healthcare
system can be accessed. This registration will help in registering every single first aid
information that the person has been provided (Walsh et al. 2018).
If there is need for any change in the information or any information is found to be
recorded wrongly, the individual or members of his or her family with proper identification, can
request the authority to make changes in the respective information on account of being recorded
wrongly. The identity of the individual asking to make the changes might be requested to provide
to the organization before making any alterations in their system (Lupton 2014). In case of filing
of any complaints, the authority has ensured that strict actions will be taken at the earliest for a
remedy to the complaint.
Task 2
Task 2.1
The exploratory data analysis of all the variables involved in the dataset loan.delinq.csv
as obtained from RapidMiner is illustrated in table 2.1. The main aim of conducting this analysis
is to develop a predicting model that will be helpful in predicting the likelihood of a customer in
becoming a loan delinquency and such that the customer can be able to forfeit the loan on
ACME bank. In order to perform the analysis and develop the prediction model, it is important to
understand the nature of the data that is present in the dataset. Thus, is the need to perform the
exploratory data analysis.

7BUSINESS INTELLIGENCE
From the results of the exploratory data analysis, it can be seen very clearly that the
average value of the first variable is 75000. It is an integral variable with a minimum of 1 and a
maximum of 150000. The second variable that has been considered here is whether a person has
experienced a delay in paying the loan for more than 90 days. There are two outcomes to this
variable, Yes and No. This has been identified as the variable that has to be predicted. From the
frequency distribution, it can be observed that the variable observed the value “0” in 139974 of
the cases and the value “1” in 10026 number of cases. The next variable that has been considered
is the “revolving utilization of unsecured lines”. The values of the variable range between 0 and
50708 with an average of 5.748. The next variable that has been considered is the age of the
respondents. This is a continuous variable present in the dataset. The values of the variable
ranges between 0 and 109, with an average age of 52.295 years. The next variable that has been
analyzed is the “number of times 30 – 59 days past due not worse”. The values of this variable
are integral values and the values lie between the range of 0 and 98, with an average of 0.421.
The next considered variable is the “Debt Ratio”, which is a continuous variable and the values
range between 0 and 329664. The average debt ratio has been obtained to be 353.005. It has also
been observed that most of the respondents have a monthly income of $5000. The average
number of open credit lines and loans has been found to be 8.453 and ranging between 0 and 58.
The number of times a person is 90 days late in paying the loan lies between the values 0 and 98.
From the data, the average number of times has been obtained to be 0.266. The average number
of real estate loans have been found to be 1.018, the average number of times a person is 60 – 89
days late in paying the loans is 0.24 and it has also been observed that in most of the families,
there are no dependents.
The graphs related to each of the variables are provided in the following figures.

8BUSINESS INTELLIGENCE
Table 2.1: Results of Exploratory Data Analysis for loan.delinq.csv
Figure 1

9BUSINESS INTELLIGENCE
Figure 2
Figure 3

10BUSINESS INTELLIGENCE
Figure 4
Figure 5

11BUSINESS INTELLIGENCE
Figure 6
Figure 7