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

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