Developing a Data Analysis and Reporting Platform with Microsoft Excel

You must develop a data analysis, interpret and report platform based on the selected organization sources. The platform needs to developed using MicrosoftExcel. You need to write a report on how you developed 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 influence 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 organisationaldecision-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 organisation 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.

Task

The organisational decisions you make in relation to this assessment must be made with regards to the following:

1. Reduction of Staff overhead by 30%
2. Increased sales by 20%
3. Improved Staff Morale by 20% on the previous year
4. Improved Customer Experience by 30% on the previous year 5. Retention of Customer Service Staff
6. A merger with another company of similar size
7. Increased occupancy by 15%
8. Other specific targets.........

This is an individual assessment and you must choose one of the above targets that relateto your organisation 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 specific 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 investments, losses of reputation or revenue, etc...
Your submission will include two submissions- Report + Excel work file

You will be assessed as follows:

1. Structure of the written report: Background information is relevant, issues are logically ordered,recommendations clearly relate to the issues.
2. Identify main issues: Prioritize choices, justify and prioritize issues chosen.
3. Analyse the issues: Each issue is discussed using relevant concepts and principles, insight is shown in analyzing the information.
4. Demo of the recommendations panel: Identify recommendations from the case study, show decisions thatyou have captured for the recommendations to be put into practice.
5. Write clearly and concisely: Arguments are explicit and succinct, appropriate headings are used, grammarand spelling are accuratte.