Logi Service is a provider of logistic service for SME organisations
Assignment Title: Individual Report
Description of the assignment, task, content, and structure:
Logi Service is a provider of logistic service for SME organisations. In recent times due to many successful marketing initiatives, they have been successful in securing many service contracts with reputed retailers in the UK. In order to support this operation, the management changed the business processes radically to reduce the delivery times and to enhance customer experience. Some of other changes include investing in digital technologies including data analytics software, easy to operate digital handled operators and state-of-the-art web interface for end customers as well as its direct clients. The employees currently are extremely happy with existing processes and the teams they belong to. The new change requires many employees to improve their digital skills as many lack digital literacy skills.
As a very knowledgeable business analyst and intelligence consultant, you have been contacted by the board of Logi Service through a recruitment firm, to help institute this change and create a sense of urgency among the employees through training that will result to quick wins, ranging from technological, organizational, human to cultural aspect including processes and information flows of the business systems.
The firm has also, allowed you to assess the operations of their major global partner, including the customer databases, sales and profits across regions and cities. And finally, the company handed over to you a CSV Superstore database folder containing information about their global business operations.
Your tasks are highlighted in two parts:
Part 1
v Using any favorite charts of yours, the board want you to design an executive Dashboard, and track and display any 3 of the 5 listed KPI’s:
1) Customer segment
2) Product category
3) Sales
4) Profit by province
5) Shipping cost
Note: The Superstore database table has been provided via your school email and can be downloaded from Canvas site. The designed Dashboard must be presented and submitted in Word/PDF file.
Part 2
v Write a critical report appraising the importance of integration of data analytics software and business intelligence platform such as Power BI, in enhancing business operations and performance, and clearly recommend with logical reasons why you think that the knowledge of these data-driven techniques and their applications are the best digital literacy skillsets that Logi Service employees required to support and drive the above change.
The report: Maximum of 2500 words excluding codes, charts, and references; codes can be given in appendices)
This report should
include:
1. A separate cover page indicating the title of the project, your full name and module code
2. An introduction section explaining the problem and how you intend to approach it.
3. Explanations of Power Bi 3 Main features – Interface, Workflow and Query environment
4. Identification of the concepts of Fact and Dimension tables relationship
5. An explanations and analysis of the KPI’s in the Dashboard design showing the intelligence applications for the organisations’ continuous performance improvement.
6. The proposed benefits that can be realized by the new system (i.e., interpretation of the result in terms of its relevance to Logi service’s challenges)
7. Conclusion
8. A reflection section that describes (using Gibb’s reflective framework):
a) what did you learn that you did not imagine you would have? if you had to do it all over again, what would you do differently?)
c) any final comments and conclusions
Note: Report submission must contain a Word/PDF file
Other useful information regarding working in teams and presentation skills is available via the CASE website
Specific instructions:
The HBS Grading Criteria (rubric) will evidence how marks are awarded for individual parts of
the assignment i.e., Presentation and Structure, Intellectual Curiosity and Referencing, Content, Analysis, Discussion
Marking Scheme for Individual Report: |
Weighting |
Presentation and Structure |
10% |
Introduction |
10% |
Explanations of Power Bi 3 Main features – Interface, Workflow and Query environment |
10% |
Identification of the concepts of Fact and Dimension tables relationship |
10% |
Dashboard report and KPI’s analysis and their relevance/applicability/explanation |
20% |
Conclusion |
15 |
Reflection |
20% |
Harvard Referencing |
5% |
Total |
100 |
|