VISUALISATION PROJECT ASSIGNMENT

22579: Data Visualization and Business Communication

(Autumn 2025)

1.        General Information

1.1.     Task Overview

The 22579 Visualisation Project 2025 assignment refers to the case study specification below.

The ability to analyse data,  answer questions,  document activities,  and generate  reports  reflects  the practice of business students in this assignment, which contributes to the graduate attributes, business knowledge and concepts, analytical skills, communication, and interpersonal skills, attitudes, and values, as well as business practice-oriented skills.

The assignment requires you to analyse problems using Tableau / MS Excel OR Power BI, answer questions and document them, and generate an interactive dashboard. You also must submit PowerPoint slides and a Project Management Report.

1.2.      Deliverables

a)         Tableau File or Power BI file, Report (Word file), PowerPoint slides and Timesheet (Excel)

You must analyse data using Tableau OR Power BI and document each step with screenshots of what they are doing and answering questions. The lecturer will assess the performance of individuals based on the analysis; the answers provided the documentation of the individual steps, and the quality of the reports that must be produced. The formal quality of the reports does impact the mark. The case study assignment also assesses your problem-solving capacity.

The final tableau(s) files/Power BI files(s), Excel/doc files, PowerPoint presentations, and documentation (Project Report) created must be submitted through Canvas.

b)          Project Management Report

Each of you must prepare and submit a Project Management Report, which consists of:

Part 1: Project Plan: You must describe the steps you will take in doing the Visualisation Project, including the tools and techniques used, the timeframe. and an estimate, and how long you think each task will take. You must also keep and hand in a timesheet.

Part 2: Implementation Documentation: You must generate an interactive visualisation dashboard and  communicate the dataset's insights and findings to the specified audience. You must also think about potential  questions,  the  audience  might  ask  and  answer  them,  you  must  also  create  a  report  and PowerPoint presentation as well as keep and hand in a time sheet.

(a)  a signed cover sheet that includes the standard content like subject name, subject number, date, your name and your student ID as well as a word count and the following statement of plagiarism and copyright

I have read and understood the statement of plagiarism and copyright in the subject outline. I'm fully aware that plagiarism and other breaches of academic integrity will be penalised when proven, following the UTS Student Rules. I declare solemnly that my contribution to this group assignment is neither copied nor plagiarised.

Student ID – Student Name – Student Signature

(b) A response to the specific tasks /documentation requirements/questions raised in the case study specifications – .

(c)  assumptions made, anything notable, problems encountered, and solutions found.

c)          Submission and Due Dates

a)    Submission

The Project Management Report and files must be submitted through Canvas. In subject 22579 DVBC, Assignment and  Visualisation  Project folders  are  set  up for the  submission of  (i) files  and  (ii)  Project Management Reports. The plagiarism software Turnitin is used to evaluate the authenticity of the work.

Late submissions are subject to a penalty of 5% per day for up to seven calendar days. Work submitted after seven business days is given zero marks.

b)     Due Dates

Part 1 – Project Plan: 23:59 on 3rd  April 2025

Part 2 – Project management report, Tableau files OR Power BI, Excel/Doc File and PowerPoint slides

The Tableau files/Power BI files, Google Sheets (Excel), and the Project Management Report are due at

23.59 on Thursday, May 8th, 2025. The presentation is due in class on May 14th, 2025.

Please Note:

•    Submission per email will not be accepted.

1.3.     Guideline for Project Management Report

a)          Purpose

The purpose of the Project Management Report Part 1 is to provide information about what you are doing (planning instrument) and the Project Management Report Part 2 is to document (incl. screenshots) the process and to answer the questions.

b)         Format

The recommendations, which are given in the Faculty of Business “Guide to Writing Assignments”, do apply. Some further hints:

•    The report (part 2) should have an introduction and a main part. A summary/conclusion is optional. An executive summary is not required.

•    The   use   of   resources   (references)   other   than  the   provided  assignment  specification   and appropriate quoting/referencing are required when using knowledge from authors other than the group members.

•    The formal quality of the reports does contribute to the mark.

•    The format should be as outlined in 1.2.2.

c)          Resources

The required resources for this assignment are:

•    The Case Study Specification (this document)

•    Legacy files (MS Excel) (links available in the document).

•    The required Software (tableau/Power BI) is available in all general access computer labs at UTS.

This assignment is open book, i.e., students can consult books, course notes, individual notes, and the World Wide Web, but must cite correctly.

Additional resources:

•    Faculty of Business (current version, 2020), Guide to Writing Assignments, Faculty of Business, University of Technology, Sydney (available on Canvas).

•    Emerson, L. (2022), Writing Guidelines for Business Students, 6th Edition, Cengage Learning Australia.

1.4.      File naming conventions& version control (keeping copies).

a.    YYYYMMDD _ student ID_last name, YYYY stands for year,  MM stands for months, and DD stands for day.

b.    Whenever you start working again on a file, you make a copy and change the date. So, you always have a backup copy in case something goes wrong.  You must keep all your copies and be able to show them to your lecturer if requested.

1.5.     General Remark on Project Work

a.    Information from the Case Study Specification may be missing. Please search on the internet or make reasonable assumptions. You must mention and justify them in the Project Management Report (see 1.2.2).

b.    You can work through the tasks in any order you think is appropriate.

c.    This assignment reflects a real-world scenario: At work … .

a.    Not all instructions may be 100% clear!

b.    not all information is neatly in one place! You need to look for information!

c.    You might need to make reasonable assumptions, so use common sense.

d.   you need to work in groups, coordinate the time and manage the group.

e.    Your success depends on the effort you put into the assignment and what you deliver at the end.

2.  The Case Study Specification

This year, the individual projects are all in the German airline industry business segment, the German Lufthansa Group.

Your task is to analyse the data provided for one business segment and compare it to the overall Lufthansa Group performance, generate six different analyses/charts on other sheets, and integrate them into an interactive dashboard. You can also compare your business segment to another one if you wish.

Furthermore, you need to generate four potential questions from your audience and answer them in your document.

Your audience is the head of the segment, and they have an analytical background.

You can use either Tableau or PowerBI to generate the analysis and visuals.

You can download the Excel spreadsheets with some financial information from the link/website provided. You cannot copy any charts from the internet if provided/found. If you use additional information from another source, please include the source in the resources.

On the website (Lufthansa Group), you will find more information about the economy, etc., that will help you tell the story. Go and explore.

You need to make a three-minute presentation, telling the story to the segment's head. What is the most important thing they should take away from your presentation?

For your presentation, you must prepare slides.

Furthermore, you must prepare two reports:

Project Report Part 1: That is your project plan. In that report, you must include what date/(timeframe) you plan to do. So, you describe in chronological order (timestamp) step by step the activities you need to do to complete the whole project.

This can be done in tabular format.

Please include time estimates. How long do you think the particular task will take?

Project Report Part 2: This is the documentation of your project.

Time sheet. Please record all the time you spend on the project. It is a good practice for any consultant to keep a timesheet, as the customer has to pay for their hours.

The reports need to be presented in business format. They should have a cover sheet, headings, subheadings, page numbers, and a reference/literature list. Please have a look at the earlier pages of this document.