INFS2036 Business Intelligence Report 1 Sample
Assignment Details
The Five Steps to Building a Dashboard
Building a working dashboard comes from completing 5 major steps:
1. Choosing an organisation of interest;
2. Identifying a priority for that organisation;
3. Identifying questions that support this priority by showing insight (not a final answer);
4. Obtaining data to visualise these insights, including dealing with data quality issues and joining the data; and
5. Building visualisations of the data to provide insights into the priority.
In Assignment Part 1 you will need to complete Steps 1, 2 and 3. Step 4 involves data so you will start this step here in Assignment Part 1 and complete this data step in Assignment Part 2, when you build the working dashboard (Step 5).
A visual summary of the dashboard-building process is in Figure 1. Steps 1 + 2 are your starting point for any organisation. The supporting questions, which you will produce in Step 3 of Assignment Part 1, are designed to shed insight into the priority – not provide a definitive answer. In this part of the assignment you will write questions you believe support the organisation and its priority, with these questions supported in terms of available data.
Guidance for each of these steps for Assignment Part 1 is given in the following sections.
Step 1: Your Organisation for SP5 2023
This study period our chosen organisation will be the winner out of these four organisations. Who wins? The one that receives the most votes in the online survey.
The choices are:
• Coca-Cola
• Royal Flying Doctor Service
• Amazon
• Apple
Your assignment must focus on the winning organisation only – vote for your favourite one by going to the Week 0 tab on your course site. The link is at the bottom of that space.
Step 2: Identify a priority from your enrolled program perspective
Identify a single key priority, that would be of interest to the winning organisation and is relevant to your enrolled degree program.
How to identify a priority?
You have two choices: (1) Come up with one yourself; or (2) look up publicly available reports produced in this area/by the organisation and identify a priority from their reports that is most relevant to your degree.
Step 3: For Assignment Part 1 come up with 5 questions the proposed dashboard will be able to deliver insights that the user can’t answer now or easily (otherwise why would you get the job?!?).
Included in the word count:
• The body of the assignment:
• Headings
• Direct quotes (you will gain more marks by writing using your own words then using lots of direct quotes)
• Introduction
• Diagram headings and captions
Solution
Proposal for Building a Strategic Dashboard for Apple: Streamlining Reliable Global Product Distribution and Customer Segmentation.
Introduction
The effective distribution of Apple's high-quality products plays a crucial role in sustaining its market leadership in an era characterised by technological advancement and customer-centric innovation. I suggest creating a strategic dashboard that provides vital insights into simplifying global product distribution in order to further strengthen this advantage and guarantee operational excellence (?erban & Herciu, 2019). The CEO and leadership team will be given the tools they need to use this dashboard to make well-informed choices that will improve consumer satisfaction, assure compliance, and optimise Apple's distribution procedures.
Key Priority: Ensuring Quality and Reliability of Apple Watches:
The major key priority is what can reduce faults in Apple Watches and why there are retaining customers and by how we can Rectifying Errors in a Cost-effective Manner?
Key Supporting Questions:
Q1. What is the Percentage Value for Each Complaint Type?
Relevance: This inquiry will shed light on how frequently various Apple Watch-related complaints are made. For instance, if navigation issues account for 45% of complaints, this information will assist in identifying the top priorities for development.
Q2: What is the Consumer Complaint Trend Over the Past Quarter?
Relevance: For evaluating the success of quality improvement initiatives, it is essential to follow the trend of customer complaints over time. An increase in complaints could indicate persistent problems that require immediate action.
Q3. What is the Sales Income Returned Following Error Correction vs. Costs Expensed?
Relevance: It's important to comprehend how fixing mistakes will affect your bottom line. We may determine the return on investment (ROI) for quality improvement programmes by comparing the increase in sales income with the specific cost required to correct errors.
Q4. What is the Cost Estimation for Warranty Payments and Compensation vs. the Cost of Rectifying Errors?
Relevance: The expense of proactively fixing faults will be contrasted to the potential financial liabilities from warranty claims and compensation in this question.
It supports risk management and budgeting.
Q5. What percentage of customers report faults the most and least?
Relevance: The areas with the highest and lowest levels of customer dissatisfaction can be clearly seen by identifying the most and least reported faults. For instance, if voice commands not working are the subject of 56% of complaints, this points to a particular area that needs to be improved.
Alternative Question: What is the Percentage of Users Affected by Various Types of Errors in Apple Watches?
Relevance: This inquiry aims to determine the proportion of market customers who have encountered Apple Watch errors in order to gauge the size of the problem. It aids in determining the extent of the issue with quality for university assignment help.
Data Sources and Description:
.png)
.png)
.png)
.png)
Example Dashboard:
Please note that the example dashboard provided below is a conceptual representation and does not contain actual data. Here is an example of the custom dashboard that could be developed to address the priority of ensuring the quality and reliability of Apple Watches:
Dashboard Title: Quality Assurance in Apple Watches
Figure 1: Sample Dashboard.
It will cover all these things:
• Percentage of Complaint Types: A pie chart displaying the distribution of complaints by type, highlighting major areas of concern, such as navigation defects.
• Consumer Complaints Trend: A line graph showing the trend of consumer complaints over the last quarter, helping track improvements or identify worsening issues.
• ROI from Quality Improvement: A bar chart comparing the sales income received after error rectification to the specific cost incurred, demonstrating the financial impact of quality initiatives.
• Cost Estimation vs. Warranty Payments: A side-by-side comparison of estimated costs for warranty payments and compensation versus the cost of proactively rectifying errors, aiding in financial planning.
• Most and Least Reported Faults: A table showcasing the most and least reported faults by customers, such as 56% of complaints related to voice commands not working.
Benefits and anticipated results:
• Apple Inc. will gain a number of advantages from the installation of this unique dashboard for quality assurance in Apple Watches:
• Greater Customer Satisfaction as a Result of Improved Quality: By proactively correcting flaws, Apple can improve the quality and dependability of its timepieces.
• Customer Retention: A more reliable customer base is ensured by higher product quality, which will keep hold of current clients and cut down on turnover.
• Cost savings: By fixing problems before they get worse, Apple can cut down on the expenses related to warranty claims and settlements.
• Making strategic decisions: Apple will be able to decide on projects for quality improvement and budget allocation based on data-driven insights.
• Competitive Advantage: By upholding exceptional quality, Apple may differentiate itself from rivals and strengthen the reputation of its brand.
Conclusion:
In addition to being essential to Apple's market dominance, streamlining global product distribution is a sign of the company's dedication to quality and customer pleasure. The CEO and leadership team will receive actionable data from the suggested strategic dashboard to promote effective distribution, improve compliance, and improve customer experiences. In an industry that is continually changing, Apple may achieve operational excellence by optimising its operations, reducing risks, and taking into account the various disciplinary viewpoints mentioned above. This dashboard will be a crucial tool for making strategic decisions, encouraging innovation, and preserving Apple's status as a major player in the technology industry.
References
?erban, R. A., & Herciu, M. (2019). Performance management systems–proposing and testing a conceptual model. Studies in Business and Economics no, 14, 1.
Landutama, J. F., & Chowanda, A. APPLIED DESIGN THINKING FOR KIMBALL LIFECYCLE TO IMPROVE BUSINESS INTELLIGENCE DASHBOARD USABILITY.
Suhaime, S. (2021). Stock Price Prediction Analysis Dashboard using Machine Learning with LSTM Neural Network.
Batt, S., Grealis, T., Harmon, O., & Tomolonis, P. (2020). Learning Tableau: A data visualization tool. The Journal of Economic Education, 51(3-4), 317-328.
Would you like to schedule a callback?
Send us a message and we will get back to you
Highlights
Earn While You Learn With Us
Confidentiality Agreement
Money Back Guarantee
Live Expert Sessions
550+ Ph.D Experts
21 Step Quality Check
100% Quality
24*7 Live Help
On Time Delivery
Plagiarism-Free
81 Isla Avenue Glenroy, Mel, VIC, 3046 AU
