Reference no: EM133676839 , Length: word count:1500
Managing Decision Making Process
Assessment - Data Collection Platform Development Individual Assignment
Students will develop a model platform to analyse, interpret and report sets of complex information based on data drawn from specific organisational sources. Students will need to demonstrate their ability to develop a model to organise and report the data in a suitable manner to inform the decision-making processes of the organisation.
Task
You must develop a data analysis, interpret and report platform based on the selected organization sourc- es. The platform needs to developed using Microsoft Excel. You need to write a report on how you devel- oped it and the use of this data analysis platform. You should be able to use the platform to analyze a set of complex data from a selected organization to influ- ence management decision-making processes.
The report should be written in appropriate business language so that your analysis and discussion have an objective tone. Your writing should be clear and concise and be in your own words. Use headings and subheadings to guide the reader and include tables or diagrams to interpret your findings more clearly.
Follow below guide to complete your assignment.
› 1. Use Microsoft Excel to demonstrate your ability to analyse and interpret and report appropriate data for organisational decision-making.
› 2. A report on -how you produced the platform-MS Excel, the data set you have used to analyse, why you have used the data from that particular organ- isation and why you chose certain types of analysis and interpretation of data using graphical view, then your conclusions.
The written report must be of 1,500 words in length excluding references. The referencing style must follow the APA referencing style.
The organisational decisions you make in relation to this assessment must be made with regards to the following:
Reduction of Staff overhead by 30%
Increased sales by 20%
Improved Staff Morale by 20% on the previous year
Improved Customer Experience by 30% on the previous year
Retention of Customer Service Staff
A merger with another company of similar size
Increased occupancy by 15%
Other specific targets...
This is an individual assessment and you must choose one of the above targets that relate to your organisa- tion or another organisation of your choice. You need to research all the data that will inform management in such a way that they will have sufficient data and information that they are able to make the decisions appropriately.
You also need to analyse the data interpret data and report your findings.. To analyse the data, you need to decide what analysis you should use, how to model it and how to report it . Once you have decided this, you need to build your analysis on MS excel format and create a dashboard that interpret the information with representation of the different visual data summary options for the management decisions. That means you need to take into consideration that if the original data changes, how will this change the final data that you present to your management for decision making.
You required to set up the MS Excel dashboard to assist any user to make decisions. You are to provide decision making outcomes for the organization by using these tools and validate the importance of spe- cific analysis and interpretation for the management decisions. Next, add at least 4 recommendations panel that has suggestions for each of the decisions that the management may make including risks and invest- ments, losses of reputation or revenue, etc...
Your submission will include two submissions:
Report + Excel work file
You will be assessed as follows:
Structure of the written report: Background infor- mation is relevant, issues are logically ordered, recommendations clearly relate to the issues.
Identify main issues: Prioritize choices, justify and prioritize issues chosen.
Analyse the issues: Each issue is discussed using relevant concepts and principles, insight is shown in analyzing the information.
Demo of the recommendations panel: Identify recommendations from the case study, show decisions that you have captured for the recom- mendations to be put into practice.
Write clearly and concisely: Arguments are explicit and succinct, appropriate headings are used, gram- mar and spelling are accurate.