Assignment Preparation and Support – Hire Academic Expert

Data Driven Decisions
for Business
Assignment Preparation and Support
– Understanding the CSFs for production of a good D3 report
and your action plan for achieving that

Learning Outcomes

To have conducted a thorough self-assessment of your current
progress against each of the assessment tasks


To understand the Critical Success Factors for success against
each of the assessment tasks
Task CSFs


To understand the Critical Success Factors for delivering a well
researched, well-presented and well-argued report
Report CSFs


Action Plan To have a personal action plan for delivering your final report

Session Roadmap
• Recap on last week plus starter exercise
• Self-evaluation across the five assessment tasks
• Approach and CSFs for
Task 1 (Introduction and project plan – 20 marks)
• Approach and CSFs for
Task 2 (Data quality issues and remedies – 10 marks)
• Approach and CSFs for
Task 3 (Data analysis and commentary – 20 marks)
• Approach and CSFs for
Task 4 (Data charting and commentary – 20 marks))
• Approach and CSFs for
Task 5 (Conclusions and recommendations – 20 marks)
• Approach and CSFs for delivering
a well-researched, well argued and wellpresented report (10 marks)
• Excel Practice Session
• Developing your action plan for acing your assignment

Recap – Pitfalls, issues and biases in data analysis
• Data issues in collection, quality and governance
• Simple versus complex models – advantages and disadvantages
• ‘Ambient AI’: The emerging AI-enabled data and operations model
• Classic failures in data analytics
You should by now have a draft of
your assignment.

Let’s review your Assignment Brief PDF
Purpose of the report clearly stated in the first sentence
(Remember the Pyramid Principle)
Remember: There are two linked objectives (overall
performance across years, regions and product lines, and
the success or otherwise of the marketing campaign)
Providing a clear structure of the report contents
Including reference to a DA project framework and
Including a nice DA framework diagram
Referencing KPIs – including non-stated items such as
profitability, growth, brand reputation, stock performance
Task 1: Introduction and purpose (20 marks)
Lack of clarity on purpose and clear structure
Not including and explaining a DA project framework
Induction rather than deduction e.g. First sentence “Data
analysis can be described by…”
Being too specific on the purpose of the analysis – it is not
just about the 2020 campaign in the UK.
Including sample screenshots of data quality issues, how
you identified them and how you fixed them
Put screenshots in Appendix
Task 2: Data quality issues and remedies (10 marks)
Not spotting and fixing the negative numbers
Not spotting and fixing the data tagging errors
Not spotting and addressing the ‘0’ numbers
Not converting to a Common Currency
Not spotting that there is an erroneous ‘2030’ date
Colour-highlighting key numbers in your data tables (e.g.
max and min numbers)
Combining the three years of data
Giving summary points, e.g. percentage change in sales
over a year or across the three years
Commenting on performance over time
Commenting on performance between regions
Commenting on performance across product lines*
Task 3: Data analysis and commentary (20 marks)
Not addressing the data tables specified in the Brief
Including ‘Charts’ where ‘Tables’ were specified.
Talking about ‘profit’ and ‘profitability’. You do not have
enough information to comment on these.
* Use the term ‘product line’ rather than ‘sub-type’
A sample table
– Sales volume and value by year
Aim for something
that looks like this
Year Sales volume Sales value (£)
2018 10,327.00 12,477,737
2019 10,037.00 11,793,139
2020 9,199.00 10,678,452
Total 29,563.00 34,949,329
What can we infer
from the data?

Another sample table
– Comparisons across the 12 quarters
Quarter Year Volume Value (£)
1 2018 2,768 3,369,509
2 2018 2,541 3,172,820
3 2018 2,665 3,179,153
4 2018 2,353 2,756,254
Annual 10,327 12,477,737
5 2019 2,501 2,807,077
6 2019 2,764 3,467,680
7 2019 2,745 3,190,685
8 2019 2,027 2,327,696
Annual 10,037 11,793,139
9 2020 2,281 2,615,812
10 2020 2,775 3,269,003
11 2020 2,515 2,898,095
12 2020 1,628 1,895,542
Annual 9,199 10,678,452
Total 29,563 34,949,329
Adding meaningful chart titles
Labelling axes
Using primary and secondary axes where needed
Task 4: Data charting and commentary (20 marks)
Not providing the charts specified in the Brief
Providing the wrong chart types
Sample chart type
– This chart is good. How could it be better?
By adding
a trend line

Remember – you should always visualise your data
– All these datasets have the same mean, standard deviation, correlation and
regression line
Source: Twitter (@pickover)
Including page numbers, for example ‘Page 5 of 11’
Including a meaningful report title and/or sub-title
Including table, chart, figure references in the content page
Only including relevant references
Citing all references in the body text
Clear and well-constructed report file names
Presentation and research 1
Lack of a contents page with (i) Meaningful section
headings and (ii) Meaningful sub-section headings
Including non-relevant references
Not citing references in the body text
Giving the report title as ‘Data Driven Decisions for
Business’ without a subtitle
Not following the report structure set out in the brief
Not including meaningful titles to tables etc under or above
Zero typos and spelling mistakes
Explaining that the work is primarily EDA in nature
Descriptive analysis, with some implied Diagnostic analysis
(i.e. there is no predictive or prescriptive analysis)
Presentation and research 2
Using excessive decimal places e.g. £1230.234.56. Not
including currency unit commas. Should be £1,230.
Including an Executive Summary when not specified
Not proofreading your report prior to submission
Typos and spelling mistakes
Calling the client ‘bungles’ (!)
Clearly answering the key questions on (i) Performance:
Over time, across regions, across categories and (ii)
Success or otherwise of the UK marketing campaign
Ensuring your conclusions are explicitly data driven
Providing practical recommendations
Augmenting your recommendations using your own
business knowledge
Task 5: Conclusions and recommendations (20 marks)
Not providing at least five conclusions and associated
Making assertions that are not based on supporting facts
and argument
Module evaluation
• Towards the end of each term, the Business School collects
feedback regarding the teaching and learning that you have
experienced in each of your modules.
• Teaching is the most important thing we do to help you learn and
we need to know how well we are doing it.
• Evaluation links are provided for each module you have studied
this term and are completely anonymous.
• For the next five minutes you will have the opportunity to
complete the evaluation relevant to this module. Please use your
mobile phone to scan the QR code on this slide. This will open
the student feedback survey.
Module: Data Driven Decision for Business (MSc Management)
Tutor initials: XX

Or use this link:
MSCMAN/MSCMPM/MSCMDA&module=63707&mode=FT&cohort=September 2021

Thank you for

Session Part 2: Excel practice
Excel capabilities you should be familiar with

Task Excel capabilities
General Writing simple formulas in cells. Using brackets
1 n/a
2 Conditional formatting, Filter, Sort, xlookup, concatenate
3 Pivot tables. Max, Min, highlighting cells. Average. Percentage change
4 Charting
5 n/a

Remember you need to be competent at using Excel
(For both D3 and your future career)

Key takeaways and Q&A
By completing this session you should:
• Understand what is required to produce a good
• Have identified gaps that you need to work on
• Have an action plan for delivering your report