Business Question

Description

LD7206-Data Analytics and Project Management for Business Intelligence- Assignment Task 2 (2000 WORDS )

Unformatted Attachment Preview

Module Code:
LD7206
Module Title:
Data Analytics and Project Management for Business Intelligence
Distributed on:
02-10-2023
Hand in Date:
Project Presentation 11/12/2023, Time 11:59 GMT
Individual Report 18/01/2024 Time: 11:59 GMT
Further information about general assessment criteria, ARTA regulations, referencing and plagiarism can be found on the module’s site on the e-Learning
Portal. Students are advised to read and follow this information.
Instructions on Assessment:
Data-driven decision making has become increasingly important for modern businesses as it helps organisations to develop, implement, monitor and control
their strategies and tactics. Indeed, using data-driven decision making can help you to better understand and analyse business problems and opportunities and
identify potential solutions. As such developing data analytics skills can give you competitive edge as more and more employers are increasingly seeking
candidates with data analysis and problem-solving skills.
Module Learning Outcomes (MLOs)
1.
2.
3.
4.
Have a critical understanding of project management principles, methods, techniques, and tools.
Be able to critically apply decision making, problem solving and project management skills in a given problem/opportunity scenario.
Be able to critically apply data analytics tools/software packages in a given problem scenario.
Be able to demonstrate and reflect on the interpersonal and team working skills.
Instructions on Assessment
The module will be assessed by two summative assessment, one group presentation and one individual essay having 30% and 70% weight respectively.
Assignment Task 1 (30%)
Task 1 covers MLO3. This is a group assignment, and the module tutor will assign students to the groups. The presentations will be scheduled in the week 11
and 12. In addition to the module tutors an industry professional will also attend the presentations. The presentation will be of 15 minutes for each group,
followed by at 5 minutes questions and answers session. Each group member must contribute to the presentation and must present his or her part.
Background of the task
Northumbria University London is planning to organise convocation in London to ensure most of the graduates of London Campus should get opportunity to be
part of the celebrations. The convocation is followed by a concert. The planning and execution on these projects are already stared. The organising committee
wants to assess the progress of these two projects.
Task
Your groups are appointed as a Project Analyst by the university management to review the progress. Your group may choose one of the projects (either
graduation ceremony or concert). You are expected to deliver a presentation that will critically appraise your chosen project.
The presentation should include these parts:
1. An introduction to the problem/opportunity statement regarding the chosen project [10%]
2. Identifying the stakeholders and deliverables of the project [20%]
3. Evidence of knowledge of key business intelligence/data analytics systems (developed dashboard MS Excel or other softwares) [30%]
4. Critical analysis and justification of developed dashboard (MS Excel) [20%]
5. Conclusion and recommendations for the successful implementation and use of a BI / DA solution in your chosen project [10%]
6. Clarity of expression. The presentation must be supported by academic references and examples and include a single reference list [10%]
Assignment Task 2: (70%)
Each student will submit an individual report (word limit 2,000 words). This report will consist of the following sections laid out as follows:
1.
Provide the introduction of the project on which you worked a team member. Discuss its planning, execution, and evaluation phase. Critically analyse
the tools and techniques used in project management. (600 words, 30%) [MLO1]
2.
Identify the stakeholders of the project and evaluate the potential causes of conflicts amongst stakeholders for your chosen project. Assess the risk
associated with the project during various project life cycle stages and the risk mitigation strategies (1000 words, 50%) [MLO2]
3.
Reflect on your role as a member of project analyst team. Critically analyse the project team dynamics amongst the team members and role of the
team leadership in creating effective project teams to achieve objectives by applying SCRUM Agile Leadership. (400 words, 20%) [MLO4]
Assignment Guidance Notes:
In the task one each group of students must do a 15-minute presentation followed by a five-minute question and answer session. Each group must upload the
PPTs (power point file) on the Blackboard assignment submission sites. Only one group member will upload the file.
The task two is an academic essay. Each student will submit an individual report (word limit 2,000 words). The assignment has to be uploaded on the Blackboard
assignment submission sites. References: Remember that all sources cited in the assignment should appear in the reference list. And you should follow APA
referencing style.
Appendices (not more than 6 pages). These should be used for supporting data and can include tables and graphs.
Where to find additional assessment support:
Include information on folders on Blackboard, assessment Q&As, assessment sessions, etc.
General notes:
Word limits and penalties for assignments
If the assignment is within +10% of the stated word limit no penalty will apply.
The word count is to be declared on the front page of your assignment. The word count does not include:
• Title and
Contents page
• Glossary
• Reference list
• Appendices
• Bibliography
• Quotes from
interviews and
focus groups.
• Appropriate tables,
figures and
illustrations
Please note, in text citations [e.g. (Smith, 2011)] and direct secondary quotations [e.g. “dib-dab nonsense analysis” (Smith, 2011 p.123)] are INCLUDED in the
word count.
If this word count is falsified, students are reminded that under ARNA page 30 Section 3.4 this will be regarded as academic misconduct.
If the word limit of the full assignment exceeds the +10% limit, 10% of the mark provisionally awarded to the assignment will be deducted. For example: if the
assignment is worth 70 marks but is above the word limit by more than 10%, a penalty of 7 marks will be imposed, giving a final mark of 63.
Academic Misconduct
The Assessment Regulations for Taught Awards (ARTA) contain the Regulations and procedures applying to cheating, plagiarism and
other forms of academic misconduct for example use if Auto generated AI or any other form of Artificial Intelligence.
The full policy is available at: http://www.northumbria.ac.uk/sd/central/ar/qualitysupport/asspolicies/
You are reminded that plagiarism, collusion and other forms of academic misconduct as referred to in the Academic Misconduct procedure of the
assessment regulations are taken very seriously by Newcastle Business School. Assignments in which evidence of plagiarism or other forms of
academic misconduct is found may receive a mark of zero.
Submission of Assessment:
All assignments must be submitted on e-Learning Portal (Blackboard) site for the module. The assignments will be double marked.
Mapping to Programme Goals and Objectives:
This assessment will contribute directly to the following Postgraduate programme goals and objectives.
Goal One: To develop the skills necessary for employment and career progression
1.
Demonstrate awareness of personal strengths and weaknesses and the ability to engage in
continuing self-development.
x
2.
Demonstrate the development of inter-personal and intra-personal skills.
3.
Demonstrate competence in contemporary analytical and ICT applications.
Goal Two: Be culturally and ethically aware
x
1.
Demonstrate their ability to work in culturally diverse groups and teams and make
appropriate and personal contribution to team effectiveness.
2.
Reflect on their own ethical values.
3.
Understand the wider impact of individual or organisational decision making on social and
environmental contexts.
Goal Three: Have developed leadership and management capability
x
1.
Communicate complex issues effectively.
2.
Demonstrate decision making and problem solving and project management skills.
Goal Four: Have developed and applied knowledge of international business and management theory
x
1.
2.
3.
Acquire, interpret and apply knowledge of international business, management and
organisational functions.
Demonstrate an understanding of the impact of innovative and contemporary research on
the business and management community.
Acquire, interpret and apply specialist functional knowledge in relation to their programme
of study (specialist programmes only).
Goal Five: Have developed a range of research skills and project capabilities
x
1.
2.
Plan and complete a major individual piece of research on a contemporary business,
financial, management or leadership topic of their choice.
Demonstrate skills of analysis and synthesis in the application of research methods to the
exploration of contemporary business issues.
Marking criteria for the assignment A
90-100% Exceeds
Standard 3
80-89% Exceeds
Standard 2
70-79% Exceeds
Standard 1
60-69% Meets
Standard 1
50-59% Meets
Standard 1
40-49%
Standard Not
Met 2
0-39% Standard
Not Met 1
Clear understanding
of project and
opportunity analysis
(10%)
Outstanding
understanding of
project and challenges
and opportunities
related to the project
Excellent
understanding of
project and
challenges and
opportunities related
to the project
Very good
understanding of
project and
challenges and
opportunities related
to the project
Good understanding
of project and
challenges and
opportunities related
to the project
Excellent and
theoretical
understanding of the
stakeholders’ analysis
and excellent
explanation of the
project deliverables
Excellent analysis and
understanding of
materials
Very good theoretical
understanding of the
stakeholders’ analysis
and very good
explanation of the
project deliverables
Very good
understanding of the
stakeholders’ analysis
and good explanation
of the project
deliverables
Very good analysis
and understanding of
materials
A good depth of
analysis with a
reasonable appraisal
Some analysis, and
understanding
Excellent justification
of using BI tools
provided with the
critical evaluation of
the tools
Excellent use of
analytics and
conclusions that link
theory and practice
Very good
justification of using
BI tools provided with
the evaluation of the
tools
Very good
conclusions and case
studies that link
theory and practice
The presentation and
referencing style are
outstanding
The presentation and
referencing style are
excellent
Very good
presentation and
referencing style
Limited case
studies no real
linkage between
theory and
practice
The presentation
and referencing
detracts from the
work
Poor or non-existent.
No attempt to link
theory and practice
Presentation and
referencing
(10%)
Good justification of
using BI tools
provided with some
evaluation of the
tools
Some good case
studies and
conclusions and
evidence of linking
theory and practice
Generally good
presentation and
referencing style
Some justification
of using BI tools
provided
Application of the
theoretical models to
the project
(10%)
Outstanding and
impressive theoretical
understanding of the
stakeholders’ analysis
and excellent
explanation of the
project deliverables
An outstanding
analysis and
understanding of
materials
Outstanding
justification of using BI
tools provided with
the critical evaluation
of the tools
Outstanding use of
analytics and
conclusions that link
theory and practice
Little
understanding of
project and
challenges and
opportunities
related to the
project
Little
understanding of
the stakeholders
and little
explanation of the
project
deliverables
There are
significant gaps in
analysis and / or
understanding
Little justification
of using BI tools
provided without
any analysis
Poor understanding
of project and
challenges and
opportunities related
to the project
Critical understanding
of project
stakeholders and
project deliverables
(20%)
Adequate
understanding of
project and
challenges and
opportunities
related to the
project
Adequate
understanding of
the stakeholders’
analysis and fair
explanation of the
project deliverables
Application of key
business intelligence
tools and techniques
(30%)
Justification of BI
tools used for each
stakeholder.
(20%)
An attempt at case
studies and
conclusions linking
theory, practice,
Reasonably well
presented and
referencing
Poor and does not
really understand the
stakeholders and no
explanation of the
project deliverables
Lacks any cohesive
analysis and shows
little understanding
Clearly lacks in
providing any
justification of using
BI tools provided
Poor presentation
and referencing
writing style
1.
2.
3.
4.
5.
6.
Clear understanding of the project and stakeholders needs of the identified project areas including critical evaluation, wellstructured and correctly referenced showing evidence of wide reading and use of a range of recent sources
(10%)
Identifying the stakeholders and deliverables of the project [20%]
(20%)
Evidence of knowledge of key business intelligence/data analytics systems (developed dashboard MS Excel)
(30%)
Critical analysis and justification of developed dashboard (MS Excel/Power BI)
(20%)
Conclusion and recommendations for the successful implementation and use of a BI / DA solution in your chosen project
(10%)
Clarity of expression. The presentation must be supported by academic references and examples and include a single
reference list
General Comment
Marking Criteria for assignment B
90-100% Exceeds
Performance Area
Standard 3
Student Demonstrates
(10%)
Overall Mark/Grade:
80-89% Exceeds
70-79% Exceeds
60-69% Meets
50-59% Meets Standard 40-49%Standard Not Met 0-39% Standard Not
Standard 2
Standard 1
Standard 1
1
2
Met 1
An introduction of the
An outstanding
An excellent
A very good
A good introduction, An adequate
An insufficient
Poor or no evidence of
project and project life cycles introduction, providing introduction, providing introduction, providing a providing a clear
introduction, providing introduction is given. The the introduction and
stages
an exemplary rationale an excellent rationale very clear rationale for rationale for the
some rationale for the
rationale and evaluation the is not rationale
(30%)
for the project, with
for the selected project, the selected project,
selected project, with selected project, but the of project life cycles
provided. There is a
outstanding evaluation with excellent
with some very good
some evaluation of
evaluation of project life stages need attention.
little evidence of
of project life cycles
evaluation of project evaluation of project life project life cycles
cycles stages
project life cycles
stages
life cycles stages
cycles stages
stages
stages.
Identifying stakeholders and A clear identification of A clear identification of A clear identification of A limited identification Some identification of
An insufficient
Poor or no evidence of
conflicts between/among
the stakeholders and the stakeholders an
the stakeholders and
of the stakeholders
the stakeholders and
identification of the
identification of the
stakeholders
outstanding evaluation excellent evaluation of very good evaluation of and good evaluation of limited evaluation of the stakeholders and without stakeholders and
(50%)
of the conflicts
the conflicts
the conflicts
the conflicts
conflicts between/among any evaluation of the
without any evaluation
between/among
between/among
between/among
between/among
stakeholders
conflicts between/among of the conflicts
stakeholders
stakeholders
stakeholders
stakeholders
stakeholders
between/among
stakeholders
Identifying risks and risk
A clear assessment of A clear assessment of A clear assessment of Good assessment of Fair assessment of risk Some risk assessment of An insufficient risk
mitigation strategies in
risks and outstanding risks and excellent
risks and good
risks and fair
and description of risk
risk without much risk
assessment of risk
lifecycle stages of the project evaluation of risk
evaluation of risk
evaluation of risk
evaluation of risk
mitigations without much mitigation strategies
without much risk
mitigation strategies
mitigation strategies
mitigation strategies
mitigation strategies analysis
mitigation strategies
Reflections as project team
member and the project
team leadership using
SCRUM Agile Leadership
(20%)
1.
2.
3.
There is evidence of
Excellent assessment of Very good assessment of Good assessment of
outstanding assessment your role as a team
your role as a team
your role as a team
of your role as a team member and the role of member and the role of member and the role
member and the role of team leadership is
team leadership is
of team leadership is
team leadership is
critically analysed.
analysed.
analysed.
critically analysed.
Fair assessment of your
role as a team member
and the role of team
leadership is analysed.
Some assessment of your Poor assessment of
role as a team member your role as a team
and the role of team
member and the role
leadership is not
of team leadership is
evaluated.
not analysed.
Clear introduction of the project, understanding of the project life cycles stages and tools and technique used in project
management
(30%)
Identifying the stakeholders and assessing the potential conflicts among/between stakeholders and risk mitigation strategies
(50%)
Reflecting on the role of as a project team member and critical evaluation of team leadership using SCRUM Agile Leadership
(20%)
General comments
Overall Mark/Grade:
Data Analytics and Project
Management for Business
Intelligence
Instructor. Muhammad Rizwan
MURUGANANTHAM SABARINATHAN – 23049138
MASHINAM SAI – 23047201
GAONA PUENTES DAVID SANTIAGO – 23054882
LIU CHENHUI – 23057432
ABOUT THE TEAM
• Group members:
Mashinam Sai – Gather information and establish project satarting
points.
Sabarinathan – Stakeholders and portfolio managment.
Gaona Puentes David Santiago – Dashboard development.
Lui Chenhui – Analysis.
• Meetings
8 presential meetings
3 Online meetings
ABOUT THE TEAM
• Trello
https://trello.com/b/XQnagbq9/assesment
INTRODUCTION
• This consultant Group has been hired to appraise the progress of planning the concert
event to London Campus Officials.
• As part of the convocation panned by London Campus for Graduation students, it was
also followed up with concert event. Due to involvement of multiple stakeholders for
hosting such event. London Campus hired our Project analysis team to review the
progress of various systems involved in hosting Concert.
• This project will Give a holistic outlook of the progress of the event with use of Project life
cycles, scope. This is followed by WBS, Creation of Dashboard for the visual simplicity of
the clients. A SSM has been developed to explain the entire process in subtle fashion.
Finally, recommendations and conclusion has been presented.
PROJECT STAKEHOLDER
PROJECT STAKEHOLDER/Objectives
• Bolloré SE
It is a French conglomerate located
in Puteaux. It is a large-scale
company holding oil storage and
pipelines in France, solid state
batteries, access control systems for
buildings, palm oil and rubber in Asia
and Africa, olive groves in the US
and wine production in France .
Bollore SE which is one the larger
shareholder of Vivendi (Mass media
company located in Paris). Vivendi is
one of the shareholder groups of
“Shady Records” which is owned by
Eminem.
• James Todd Smith (LL Cool J)
He is an American Rapper. He is an
old friend of Eminem who helped in
sponsoring concerts in his country.
His net worth is $120 billion.
• Daniel G. Ek
He is the CEO pf Spotify(Music and
podcasts application).He holds
16.7% shares of Spotify
company.Since Spotify is the leading
music streaming company, we have
approached them
PROJECT STAKEHOLDER/Objectives
• Jeremy de Maillard
He is the CEO of Marshall Group AB. Marshall is one of the leading companies in the
market for speakers and headphones.
• William Frewen
He is member of the UK’s startup ecosystem. William Frewen has invested in over 80 UK
businesses, and currently has shareholdings in over 50 private tech startups. These include
Health messaging app Pando, data management software Push Technology, and workplace
mental health app Unmind. In order for publicity around the UK they have the Idea of doing
a concert in London. We engage in conversation with him and explained the concert plan.
PROJECT DELIVERABLES
PROJECT DELIVERABLES
GANTT CHART/Project dates
Sponsor evaluation
Sponsor meeting
Meeting artist crew
Meeting artist
Artist sign
Places meeting
Places visit
Place selection
Place sign
Meeting Legal C
Legal C sign
Supplier meeting
Logistics sign
Promotion meeting
Social media promotion
Promotion contract
Publicity
Tickets selling
Event making
Sound tests
Artist tests
Staff meeting
Concert
01/10/2023
0 3/10/2023
19/10/2023
24/10/2023
25/10/2023
28/10/2023
29/10/2023
31/10/2023
03/11/2023
05/11/2023
08/11/2023
13/11/2023
20/11/2023
22/10/2023
23/10/2023
23/10/2023
25/10/2023
25/10/2023
25/11/2023
09/12/2023
15/12/2023
19/12/2023
19/12/2023
03/10/2023
18/10/2023
22/10/2023
25/10/2023
26/10/2023
29/10/2023
30/10/2023
01/11/2023
04/11/2023
08/11/2023
15/11/2023
20/11/2023
21/11/2023
23/10/2023
20/12/2023
26/10/2023
20/12/2023
15/12/2023
04/12/2023
13/12/2023
17/12/2023
20/12/2023
20/12/2023
DASHBOARD
❑ Excel Dashboard
ANALYSIS OF DASHBOARD
• Sponsor evaluation
• Sponsor meeting
• Meeting artist crew
• Meeting artist
• Artist sign
• Places meeting
• Places visit
• Place selection
• Place sign
• Meeting Legal C
• Legal C sign
• Supplier meeting
• Logistics sign
100%
100%
100%
100%
100%
100%
100%
100%
80%
100%
84%
100%
70%
•
•
•
•
•
Promotion meeting
Social media prom
Promotion contract
Publicity
Tickets selling
100%
50%
100%
74%
73%
•
•
•
•
•
Event making
Sound tests
Artist tests
Staff meeting
Concert
65%
1%
1%
1%
1%
ANALYSIS OF DASHBOARD
✓ At this day, the project is completed by 91,1%, the remain task still on date and still in time
to complete after some changes on the timeline.
ANALYSIS OF DASHBOARD
ANALYSIS OF DASHBOARD
Based on the events that occurred in the
development and the costs of carrying out each of
the projects, we found an over budget of almost
18%
The expense ratio for each project is presented
below.
Conclusion
• The project’s aim was a graduation ceremony, the audience was students,
and the chosen guest star, James Todd Smith, was more in tune with the
students’ aesthetic preferences and well known to the student body. The
analytical data visualisation and reporting of the project is very clear, as
can be seen from the report, a careful assessment of the investor, the
budget and cost analysis is very clear, the main budget expenditure is on
guest invitations and venue contracts, the project is more than 90%
complete, and it is important to step up testing of the venue’s audio and
guest previews. Ticket sales were 73, which is a high rate for a small to
medium-sized concert, indicating that the students were pleased with the
event’s preparations. The project budget was slightly overspent by 17.86%,
however it was still within acceptable limits.
Recommendations
• A number of other areas of the project might be enhanced.
• To begin, audience group analysis can be incorporated, and data
analysis tools can be utilised to delve further into the audience data.
Understanding the participants’ age group, interests, and other
information will allow you to better modify the marketing plan.
• Second, as the project continues, regular review sessions might be
organised to maintain communication with key stakeholders, examine
the success of the solution, and handle any concerns that may occur.
• Third, because the concert will take place during the university
graduation ceremony, the promotional expenditure can be decreased
even further to keep the overall budget acceptable.
References
• Bryson, J. (2004). What to do when Stakeholders
matter. https://books.google.nl/books?id=jWwpVIsx5SoC&dq=anders
on+bryson+crosby&source=gbs_navlinks_s
• Bryson, J., Cunningham, G. and Lokkesmoe, K. (2002). ‘What to Do
When stakeholders Matter: The Case of Problem Formulation for the
African
American
Men
Project
of
Hennepin
County
Minnesota’. https://onlinelibrary.wiley.com/doi/abs/10.1111/15406210.00238
• “Journal of Business Ethics” by David A. Ralston’s.(2013)
https://link.springer.com/article/10.1007/s10551-011-0924-8
References
• Hmina, H., & Hniche, O. (2022). Understanding and measuring project
success, a key ingredient in project management: An analytical
research paper. International Journal of Accounting, Finance,
Auditing, Management and Economics, 3(6-1), 292-305.
https://ijafame.org/index.php/ijafame/article/view/864
• Berge, O., & Kleppe, B. (2022). How concert promoters think: Five
approaches to concert promotion in Norway. Popular Music, 41(1),
20-36. 10.1017/S0261143021000726
Appendix
Excel sheet link to review the calculations and dashboard made.
Dashboard.xlsx

Purchase answer to see full
attachment