Executive summary: The purpose of this proposal is to analyse the information given in the data and determine how the security payments by government is fairly distributed across the country. All the data is based on the payments/ funding to the different sectors by the government. In this proposal, the data will be read though and will be discuss about the tools that going to be use to analyse the data. Introduction: The proposal data is based on security payments distributed by government across the country. The data provided shows various different security payments which includes health, study, pension, disability, fax tax benefits and healthcare. The data shows security payments provided in each suburb in one particular state with different sums. However, the data doesn’t specify the labels of the given values or sums. However, to make the work easy, the most applicable software will be used for analyse the data Section 1- Identification: DSS- DSS is a department of social services. The mission of DSS is to improve the lifetime wellbeing of people and families in Australia. DSS is charged with the responsibility for national policies and programs which helps deliver a strong and fair society for all Australians. DSS also provides data every year on security payments given by government for different reasons. The Australian department of social service is charged with responsibility for national policies and program, which helps to deliver strong and fair society for all Australians. However, the dataset given by DSS is not clear as there are no values labelled. It is hard to identify whether the data shows number of people or the amount of money. For example: The Abstudy (living allowance) and Abstudy (non-living allowance) showed different value numbers which didn’t specify whether it was number of people or the amount of money, which makes it hard for the reader to analyse. The data is also very broad which makes it difficult to analyse. The data also doesn’t show the gender or age of people receiving security payments which makes it harder to elaborate the data and that leads to assumptions. Data visualization is used to analyse the data in business analytics. By using excel software the data become more understandable and presentable while using Excel tools such as charts, tables and graphs. Pivot table is a useful tool in excel which can analyse data and the particular data can be selected in order to see it in table. The pivot table is very useful and handy when it comes to big data as it is difficult to analyse broad data. Section2 - Analysis and design: The design of the data is based on Microsoft excel spreadsheet because it provides various different features in order to analyse the data. The features include graphic tables, sorting tables such as pivot table which allows to elaborate the data of specific content. Microsoft excel is helpful in order to do basic data analysis which can provide a reasonable alternative to find statistics. Problem and solution: The problem of the data is that its content is very broad with minimum information provided. The data only shows main headings of the payments but doesn’t specify any values or labels which makes it meaningless for the analysist. To be able to make sense of this data, it is important to label it with the proper information which makes it meaningful for the analysist. The challenge of this task is to find alternative way which can assess and help the user to come up with certain prototype to be able to analyse the given data. Users of proposed system: The proposed data is a class of computerized information system which supports decision making activities. The level of managerial control is both operational and strategic and this data would be useful in a short term rather than long term because it is only based on government payments of 2016. This data can be useful to both dependent and independent communities to be aware of their facilities and rights that are provided by government. Structured: The data is very simple. In structured data, all the data can be stored in database SQL in tables with rows and columns. Semi Structured: This data is information that doesn’t reside in a relational database but that does have some organizational properties that make it easier to analyse. Unstructured: This data represents around 80% of data. It often includes text and multimedia content. Examples include e-mail messages, word processing documents, videos, photos, audio files etc. After analysing the data, the decision will be semi-structured. Structured issues require totally accurate and clear data with clear patterns and trends. The data should be cleaned and treated before any analysis can be carried out. Decision Support System The software named Microsoft Excel will be used to analyse the data for the report. This software has many tools and options such as charts, tables and graphs that will be used to analyse the data. All the information about the security payments can easily store in this software and can easily compare with each other. Interface about findings The designed interface will be very easy to use. It will have many functions that would be very easy for use. Users don’t need to study all data. Conclusion: The proposed data requires further investigation in order to use or learn other disciplines such as face to face interaction, database design and pivot tables. If the research is gathered through analysing what department of social service does in order to see how they collect their data and how it’s being used. In order to improve this proposed data in future, it would be beneficial to use pivot tables to present the evidence collected from data. To make the data more understandable it would be good to use instance graphs and charts to find out the individual payments. References: Department of Social Services, Australian Government. 2017. Department of Social Services, Australian Government. [ONLINE] Available at: https://www.dss.gov.au/. [Accessed 15 March 2017]. Datasets - Page 1 - data.gov.au. 2017. Datasets - Page 1 - data.gov.au. [ONLINE] Available at: https://data.gov.au/dataset?groups=community. [Accessed 15 March 2017]. DSS Payments by Commonwealth Electoral Division - Datasets - data.gov.au. 2017. DSS Payments by Commonwealth Electoral Division - Datasets - data.gov.au. [ONLINE] Available at: https://data.gov.au/dataset/dss-payments-by-commonwealth-electoral-division. [Accessed 15 March 2017]. 5 Excel Tools You Need Right Now. 2017. 5 Excel Tools You Need Right Now. [ONLINE] Available at: http://www.smallbusinesscomputing.com/biztools/5-excel-tools-you-need-right-now.html. [Accessed 15 March 2017].