Subject Code & Title :- SBL1400D Introduction To Business Analytics
Assessment Type :- Assignment
Length :- No word-limit
Written task :- MS Word doc: dashboard, synopsis of the data and recommendations
MS Excel file: shows how Excel was used to arrive at the final dash board solution
Requirement :- MS Word Document (includes a copy of the EXCEL dashboard synopsis of the data and a list of recommendations)
MS Excel File original EXCEL file showing the final Dashboard and any working solutions
Assessment Value :- 30 marks
SBL1400D Introduction To Business Analytics Assignment
Unit learning outcomes :-
1. Outline the value and limitations of the analytical and financial approach to business decision making.
2. Identify appropriate techniques to assist in solving business problems across different business disciplines.
3. Perform basic analysis using Excel as a business decision-making tool.
4. Identify and interpret problems using a systematic approach to business decision-making.
TASK ONE :
Create a dashboard in Excel that showcases the key aspects of a data set
Dash boards track KPIs metrics and other data points in one visual central place. They are made up of tables charts gauges and numbers and give you a high level view of work helping you make quick decisions and keeping everyone up to date. A dashboard’s visual nature simplifies complex data and provides an at-a-glance view of status or performance in real time.
SBL1400D Introduction To Business Analytics Assignment
Before you start building your dashboard, consider the following:
Why are you creating this dashboard?
What purpose it will serve?
What capabilities do you need?
Who needs to see the dashboard?
You are required to:
Create a Dashboard that highlights the key aspects of your data. Your dashboard should include:
a heading title that appropriately addresses the type of data that you are displaying in your dashboard (focus)
graphs charts tables numbers images etc representing the data
interactive prompts (changing some of the data displayed – slicers)
any other graphical aspects that will help to present your dashboard in a professional manner (e.g. minor headings separating lines, etc)
The dashboard MUST be placed in one worksheet that is fully viewable with in the dimensions size of the screen.
name your worksheet tab = DASHBOARD
turn-off all scroll-bars
Use formal business English that is clear and easy for the reader to follow.
Check your work for expression grammar spelling and punctuation before submitting.
SBL1400D Introduction To Business Analytics Assignment
TASK TWO :
Provide a brief synopsis of the data highlighted in the dashboard and a list of business recommendations based on the findings.
To make effective decisions organisations need accurate timely objective and concise information. Often this information is delivered in a business report written in response to a business issue or problem.
The recommendations section of a report suggests actions that can be taken to address the issue based on findings. Recommendations could be for change improvement or new ideas to improve such areas as service productivity or performance.
You are required to:
Present your synopsis and recommendations on ONE A4 page.
Use formal business English that is clear and easy for the reader to follow.
Use new vocabulary introduced in the unit.
Check your work for expression grammar spelling and punctuation before submitting.
SBL1400D Introduction To Business Analytics Assignment
Your written work should include:
An appropriate heading.
A brief explanation and interpretation of the information presented in the dashboard. That is:
briefly explain what the dashboard is about (what is the focus of the dashboard)
provide an overarching understanding of the data (in all, what does the information mean to the organisation)
explain the outcome/meaning of each table, chart, graph, text or image
provide an understanding of the interactive elements used in your dashboard and how it varies the view of your data (filters / slicers)
Include suggestions on how you can supplement / improve your dashboard through the use of external data.
Provide recommendations that a Manager can consider implementing to improve or change the functions operations of the business. You should:
list your recommendations according to priority that is note the most important recommendation first
number each recommendation to show order of priority
write your recommendation in actionable terms
ORDER This SBL1400D Introduction To Business Analytics Assignment NOW And Get Instant Discount
