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.
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.
Background of Company’s Client
In the Lawrence Smith Animal Rescue Hospital, the General Manager is Sasha Gordon.
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.
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.
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.
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.
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 find their desires and complications that are necessary for the board members and need to analyze the act of administrator and deliver their desire.
Business Requirements
The business requirements of the Lawrence Smith Hospital are given below:
Dashboard for a reporting system: Analysis of the hospital’s key performance indicators:
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.
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.
Dashboard:
The above dashboard is explained in detail.
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.
COMPANY:
TIME:
Month: Fiscal Year: July, August, September, October, November, December, January, February, March, April, May, June
STAFF:
FUNDING SOURCE:
Animals:
REVENUE FACT:
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.
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. The key performance indicators can be analyzed through Dashboard which will be created using appropriate tool. Then the basic concept of data warehouse will be analyzed. The technical architectural design of data warehouse will be discussed and then advantages and disadvantages of architectures will be examined in detail. Data dictionary will be generated for the fact and dimension tables and the main purpose is for ETL process.
The star schema for data warehouse is designed with fact tables that reference to the dimension tables. In each dimension tables, there are associated attributes are presented. These attributes are applied for the construction of dimensional data marts and data warehouses that support the analytic applications of business intelligence.
In the above start diagram, the underlined attributes are primary keys. ‘Communication Event’ is a Fact table. The dimensional tables are Fundraising Campaign, Communication Type, Donation, Animal Treatment and Communication Receipt.
In the above Star diagram is designed for Thomsen diagram 2. The underlined attributes are primary keys. The fact table is ‘Revenue fact’. The dimensional tables are Donor, Grants, Organization, Line Item Invoice and Council Invoice.
The data warehouse mainly aims to store the data. Generally, the data warehouse can be defined as a collected, interrelated and organized data from various data sources in an organization. The main purpose of designing data warehouse is that designing and developing business intelligences in various applications which helps in decision making for the management. It integrates the heterogeneous data from different sources and it produces an analysis output in the form of reports. It is the basic data storage structure. The data stored in data warehouse could not be transformed. But this data can be de-normalized into augmented presentation or scalability. There are various architectures designed and presented for data warehouse according to their advantages and disadvantages related to Art Works Organization and its data management system.
The architecture design of the Enterprise Data Warehouse is a typical and very suitable for storing the data of big corporations. Here, the data are thoroughly examined, analyzed, integrated, documented and collected data from heterogeneous resources. These data are integrated from the extensive fundamentals history of exchange level data. This type of data warehouse is designed for reporting and data analysis and a central constituent of business intelligence.
Advantages:
Disadvantages:
Federated Data Mart or Meta-(computer file full of information)/data management is like independent data marts and maps many (computer files full of information) which are independent in nature and are all over the place. This data warehouse supports to eliminate (having more than one for safety or backup purposes) in the system.
Advantages:
Disadvantages
In Dependent data warehouse, there are a unit multiple de-normalized knowledge marts that area unit passionate about knowledge warehouses. The subsections of knowledge of information area unit derived from enterprise data warehouse and systematic to suit into the wants of a company system or application.
Advantages:
Disadvantages:
Independent Data Mart consists of clear/separate, (separated far from others) and many small dimensional data warehouses for each business unit all over the place, used to extract information (surviving with no outside help).
Advantages:
Disadvantages:
After figuring out the worth, amount, or quality of the advantages and disadvantages of the above described technical related to the beautiful design and construction of buildings, etc., Business/project Data Warehouse is the most appropriate and completely fits to the needed things and systems of Art Works organization which will benefit them to complete their goals and detailed descriptions of exactly what is required and because of this, the recommended structure.
|
Name of Table &Description |
Name of Attribute & Description |
|
FUNDRISING CAMPAIGN This dimension table uniquely identifies different time values |
Campaign ID Primary Key to identify different and unique ID of Campaign |
|
Campaign Name Attribute for name of Campaign |
|
|
Notes Attribute for different values of notes |
|
|
Managing Staff Member ID Attribute for identifying Managing staff members |
|
|
Campaign Start Date Attribute for identifying the starting date of each Campaign |
|
|
Campaign End Date Attribute for identifying the completion date of each Campaign |
|
|
Total Raised from Campaign Attributes for Total amount raised from different Campaign |
|
|
DONATIONS This dimension table provides details of the donations made |
Donation ID Primary Key to uniquely identify and provide details of a particular donation |
|
Donation Date Attribute for displaying the date on which a particular donation was made |
|
|
Donation Amount Attribute to display the amount of donation made in dollars |
|
|
Notes Description attribute to designate how the donation was made and whether it was part of a show or just a walk-in |
|
|
Organisational Donor ID Attribute to identify the details of the donor organisation through the organisation’s ID |
|
|
Contact Donor ID Attribute to identify the details of the donor individual through the individual’s contact ID |
|
|
Event ID Attribute to identify the details of the event in which and for which the donation was made |
|
|
GRANTS This dimension table provides details of the grants asked for and thus made towards the organisation |
Grant Application ID Primary Key to uniquely identify the application and details of a grant |
|
Grant Submission Date Attribute to identify the date on which grant was application submitted |
|
|
Grant Outcome Attribute to identify the outcome of the grant application submitted |
|
|
Grant Amount Applied for Attribute to identify the amount of grant applied, in dollars, in the application |
|
|
Amount Granted Attribute to identify the amount of grant approved and thus given |
|
|
Amount Received Attribute to identify the amount of approved grant received till a particular date as compared to the total approved grant |
|
|
Notes Description attribute to designate how the grant was made and whether it was part of a show or not |
|
|
Programme ID Attribute to recognize the details of the programme for which grant was made |
|
|
GRANTING ORGANISATIONS This dimension table provides the particulars of the granting organisations who make the grant towards the organisation |
Granting Organisation ID Primary Key to uniquely identify the details of a particular business unit who made the grant |
|
Name Description attribute to display the name of the granting organisation |
|
|
Contact Description attribute to display the contact details of the granting organisation |
|
|
Street Address Description attribute to display the street address of the granting organisation |
|
|
City Description attribute to display the city where granting organisation is based |
|
|
Postcode Description attribute to display the postcode of the place where granting organisation is based |
|
|
State Description attribute to display the state where granting organisation is based |
|
|
Country Description attribute to display the country where granting organisation is based |
|
|
REVENUE FACT This fact table provides the revenue generated and expenses incurred by the Art Works organisation |
Time Key ID Foreign Key from Time dimension to identify the time details |
|
Donation ID Foreign Key from Donation dimension to identify donations details |
|
|
Sale ID Foreign Key from Donation dimension to identify sales details |
|
|
Grant Application ID Foreign Key from Grants dimension to identify the details of the grants made |
|
|
Granting Organisation ID Foreign Key from Granting Organisation dimension to identify the details of the granting organisations who make the grants |
|
|
Total Revenue Attribute which calculates and displays total revenue generated from the three revenue/income streams |
|
|
Total Expenses Attribute which calculates and displays total expenses incurred |
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. Then the basic concept of data warehouse is analyzed. The technical architectural design of data warehouse is discussed and then advantages and disadvantages of architectures will be examined in detail. Data dictionary is generated for the fact and dimension tables and the main purpose is for ETL process.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download