Business Intelligence Application: Analyzing Design Issues and Developing a Prototype Dashboard

This project investigates the design issues of a business intelligence case study of Lawrence Smith Animal Rescue Hospital and develops a prototype dashboard to analyze key performance indicators. The business requirements are identified and a multidimensional model is presented using Thomsen diagrams. The dashboard includes financial status, rescued animals, donations, and revenue grants. The proposed system helps the hospital organization to categorize the budget assigned initially and the total cost which includes both revenues and expenditures and thus overall cash flow.

Business Intelligence
Application Design
Assignment 2a

Table of Contents
1. Introduction 1
2. Analyzing the Design Issue of the Business Intelligence Case Study 2
2.1 Background Study of Given Case 2
2.2 Background of Company’s Client 2
3. About Organizational Process 2
3.1 Analyzing Business information of the Organization 2
3.2 Identifying the Problem of the Given Case Study 3
3.3 Scope of the Solution 3
4. Designing Approach 3
4.1 Business Requirements 3
4.2 Solution Overview 4
5. Prototype of the Business Intelligence Application using Dashboard 5
6. Multi-Dimensional Model with Thomsen Diagram 8
7. Conclusion 10
1

1. Introduction
This project aims to investigate the problem regards the typical business intelligence
design of a company and determining the key business decision requirements of the senior
managers of that company which was given in case study. A suitable decision support needs to
be chosen according to the data visualization approach. The application design model needs to be
identified based on the business requirements and the model need to be designed well. According
to the multidimensional model Thomsen diagram will be drawn. The prototype of the business
intelligence will be designed in order to the application design. The key performance indicators
can be analyzed through Dashboard which will be created using appropriate tool.
2. Analyzing the Design Issue of the Business Intelligence Case Study
2.1 Background Study of Given Case
In Melbourne city, there was a famous hospital named ‘Lawrence Smith Animal Rescue
Hospital’ which was found on 1973 and by a vet surgeon. The main specialty of the hospital
rather than others is that it treats especially for rescued animals rather than other home pet
animals and other financial oriented cases. So that this hospital is running as a non-profit
association.
2.2 Background of Company’s Client
In the Lawrence Smith Animal Rescue Hospital, the General Manager is Sasha Gordon.
3. About Organizational Process
As the organization is managed as a not-progit organization, it is fully depends on
funding resources. They are getting fund amounts through regula payments given by nearby
councils, other animal helping associations and services for rescued animals caught by the
members of the council. It deserves donation amounts from animal charity organizations,
associate peoples and other animal protecting organizations. People also very tentative to donate
some amount for the welfare of rescued animals.
3.1 Analyzing Business information of the Organization
The Lawrence Smith Animal Rescue Hospital organization maintains the following
information regularly.
The below information are stored in the form of records and in the hospital management
system.
2

1) Animal Species name
2) Date of the admission
3) The name of admitted by
4) Origin of the animal
5) Name of the staff who admits that animal
6) Address of the Owner
7) Contact Details of the Owner
8) Results of the admitted animal
The information about the animals and their owner were stored in a secured manner.
These information can be accessed by the administrator throughout the Access Database and the
data entry has been done through Donor Management System.
3.2 Identifying the Problem of the Given Case Study
In Lawrence Smith Animal Rescue Hospital, a nurse who was working as a vet nurse
voluntarily. In the Year of 2012, that nurse had complicated in the problem of disagreement with
the senior manager of the same hospital. The nurse had some trouble while caring about some
animals and the general manger, Sasha Gordon. She was disagreement with the management. As
the nurse was going to be retired, after a year of authorizing move gave out to media false
entitlements of systematically euthanizing animals and wrong doing of funds being provided. As
told in the above, all information about animals and funds are kept in Records and in Access
Database. The name of the database is Donor Management System. But the information retrieval
form database, and integrate them for presenting before new board members is a very difficult
process for Sasha and her teammates. Because they are retrieving the information manually
throughout formulating work sheets.
3.3 Scope of the Solution
The general manager, Sasha Gordon was interrogated and constrained by the new board
members and she needs to do arrangements for meeting with association members. This meeting
is for the members to ask about their accessibility to access the database information and they
needs to watch the act of administrator and the administrator should rely for every queries asked
by the board members and workers immediately. So that the proposed system should be able to
3

find their desires and complications that are necessary for the board members and need to
analyze the act of administrator and deliver their desire.
4. Designing Approach
4.1 Business Requirements
The business requirements of the Lawrence Smith Hospital are given below:
● Key performance indicators: The administrator of the system should able to
determine and measure the budget, result of each rescued people, how the animals are
treated and how many animals are treated.
● Current grants: Analyzing that how the councils took cases and what type of
cases and analyzing the council which provides most funding.
● Income streams: The hospital should able to take the strategic assessment towards
their revenues and from donation amounts, generated grants and they can able to do
streams comparison.
● Current donations: The administrator need to analyze the current funding mix
from different funding resources. They should know the details about which
organization is the most generous, their profiles, and public donors and how has this
changed over time?
● Hospital employee works patterns: The business requirement helps to know the
relationship among volunteer vet staff and pain staff.
● The association desires toward evaluates the animals being euthanized versus the
ones getting consistent treatment, which will benefit them to keep track of the processes
needed for operations.
4.2 Solution Overview
Dashboard for a reporting system: Analysis of the hospital’s key performance
indicators:
4

The proposed business intelligence application system should be designed based on the
hospital’s business key requirements that are mentioned in previous section. These contraints
need to be validated with the revenues and expenses of a hospital’s entire year. This report
should be produced in the form of monthly basis and yearly basis. The proposed business
intelligence application design should investigate the organizstion;s overall performacen. This
application needs to support the hospital organization to categorize the budget assigned initillay
and the total cost which includes both revenues and expenditures and thus overall cash flow.
Moreover, the hospital organization can retrieve the information easily throughout the database
realted to the profits created done and rate of chage of income stream. SO that it iseasy to fetch
information about how many awards and donations got from others over the year. The act f each
individual workers should be monitored by the administrator and they know the difference
between paind and volunteer staff. The application should help in offering provided by the
councils and when they gave more donation and total animals from the specific welfare
organization. The health facility may also be able to recognize which yielding our bodies and
donors are the maximum supportive or grant and donate the most amount which include their
frequencies and when the presents and donations are made. In the end, the medical institution
may be capable of maintain song of diverse fees (and the associated amounts) that they're
incurring.
5. Prototype of the Business Intelligence Application using Dashboard
Design of the prototype consists of dashboards. These dashboards are used to develop the
solution according to the business requirements.
Generally, dashboard is a graphical structure producing tool and used for data
management and data visualization. The main purpose of using dashboard is to keep track, show
and analyze the overall performance of the organization. The present status of the organization
can be viewed as a daily basis, weekly basis, monthly basis, quarterly basis and yearly basis. It
includes the key performance indicators that are related to the organization’s key requirements.
5

Dashboard:
The above dashboard is explained in detail.
 The above Dashboard, the financial status is analyzed. Remaining budget is $15044,
and Expenses is $45133 and so the organization earned the profit of $25142.
 Therefore the organization achieved 85%of the target and the expenses are 75%. So
that the profit has been increased as 13% and expenses are increased as 4%.
 The total rescued animals are treated 522 and it is an increased percentage of 21%
rather than other months. The Euthanasia animals are decreased about 13% rather
than last month.
6

 Then the bar chart shows that the comparison between donations amount versus
expenditure. In that year, $23,580 is obtained as the donations over expenses. SO it is
profit for the organization.
 The top most graph shows that the curve indicates that the fundraising has been
increased.
 The top most graph shows that the comparison between organizations business
viability, expenses versus revenues. In the year of April 2018, the Revenue
expenditure is calculated as $2500 and it is retrieved through comparison between
correlation of donations and expenditure.
7

 And finally the bottom most graph shows that the revenue grants by comparing the
grants amount and expenditure. The obtained Revenue Grants is $3500.
6. Multi-Dimensional Model with Thomsen Diagram
The multidimensional model is also known as conceptual model. Generally, this model is
mainly involved in the analysis process of the dimensions of organization and the board
members with those dimensions. In this modelling, Thomsen diagrams are used to present the
conceptual model.
Thomsen diagram:
Above stated can be drilled down to following-
COMPANY:
8

● Name of the State
● Name of the City
● Name of the Suburb
● Name of the company
TIME:
● Year: 2018, 2017, 2016, 2015, 2014, 2013,……,1987
Month: Fiscal Year: July, August, September, October, November, December, January,
February, March, April, May, June
STAFF:
● Name of the Staff
● Date of Birth
● Sex
● Name of Country
● Phone number
● Email ID
FUNDING SOURCE:
● Granting Bodies
➢ Name of the grant
➢ Total Amount
9

➢ Address details
● General Public
➢ Name of person
➢ Total Amount
➢ Address detail
● Donations
➢ Name of the donor
➢ Donation Amount
➢ Address Details
Animals:
● Animal Species
● Native
REVENUE FACT:
● Total amount of Revenue
● Total amount of Sales
● Total amount of expenses
● Total amount of profit
10

● Total amount of donations
● Total amount of grants
7. Conclusion
A suitable decision support is chosen according to the data visualization approach. The
application design model is identified based on the business requirements and the model is
designed well. According to the multidimensional model Thomsen diagram is drawn. The
prototype of the business intelligence is designed in order to the application design. The key
performance indicators can be analyzed through Dashboard which is created using appropriate
tool.
11