2,500 words (±10%) report in MS Word, PDF AND Tableau.twbx packaged workbook to be handed in, as per the allocated questions. The file format is very important you will lose marks if you do not save the file correctly. Marks will be awarded for the Tableau workbook and data, and for the report;
Visualising Survey Data in Tableau and Executive Report Report: Presenting and analysing staff survey data PharmaCo is the manufacturing arm of a large multinational company (the name of the real company and the data have been disguised). They want to understand more about staff wellbeing and how this may be connected to where they work and to what gender they identify as. They need this so that they can present the result to the rest of the company at the annual forum.
Your job is to manipulate and merge the data then mine it for information and present this in an informative way, using visualisation and analytics techniques. Your work will go to the Managing Director of PharmaCo who will use it to take the most interesting and informative results to the annual forum to present to the rest of the company directors. We used this data in seminar 6, manipulating and blending data, and we handled survey data in seminar 7.
This is very similar but not the same, you have to do some data blending using one different file and the questions you select are different. You will need to do some data blending and manipulation using Tableau Prep, you will also need to produce a Tableau workbook which addresses the questions asked of you by the MD. You are also expected to produce a report. In the assessment of the data I will be looking for correct data, correct number of rows and no excess unrequired fields.
In the packaged workbook I will be looking for good use of visualisation techniques, a good understanding of the limitations of the analysis and novel application of Tableau functionality. Remember you are presenting this to someone who has not been on the journey of understanding the data with you, so you must tell the story well through the data without confusing or over embellishing. The final report should be an amalgam of your findings which are synthesised to make final recommendations/conclusions.
The suggested report layout is below. The executive summary is your window to the executive decision maker, so it is very important to make it clear and concise. It should set the stage for the report by stating the setup, it should use clear diagrams/visuals, and/or infographics. It should state the main findings of the report so make sure you have a sound basis for your conclusions and recommendations. Short paragraphs and bullet points are best and the summary should be no more than 1 to 2 pages.
There are many examples of good practice on the internet. The assessment is looking for excellent analysis and use of visualisation techniques, and logical conclusions which are arrived at through good storytelling with data. The report should be easy to understand by a lay person. Any references should be in the Harvard style but remember this is a company report so we are not expecting too many – you should put any extra resources that you used in the appendix for completeness.
Find good peer reviewed references to back up any recommendations you make, especially any that do not come directly from the data. There are no RIGHT answers in analytics but there are very wrong ones. Use what you have learned about the limitations of analysis and let the data tell the story.
Suggested report structure Digital Business Intelligence reports can take various forms and structures. The structure below is a recommendation, but it is not strict. Make your report in MS Word or another compatible programme, a pdf is acceptable. Graphics should be presented from Tableau, if you use others ensure they are licensed under creative commons, DO NOT USE COMPANY LOGO’s. The final report structure and report organisation is ultimately your decision, however the executive summary and recommendations are compulsory.
The suggested plan structure: Alternative 1: Cover page Table of contents Executive summary infographics 1. Task 1 1.1. Approach 1.2. Findings 2. Task 2 2.1. Approach 2.2. Findings 3. Synthesis of tasks 4. Recommendations References Appendices Suggested tips for the Tableau workbook.
Make sure you label each sheet/dashboard with a meaningful name If you use an internet tutorial or a book you need to reference it, add a note on the worksheets or dashboard, or include in the report. Ensure filters are used correctly Explain what is going on clearly and succinctly Save your file as a .twbx or I will not be able to mark it properly Check everything is doing what it should – sensitivity test Use dashboard/storyboards and try to tell a story. I will check all Tableau functionality and the data for correctness and ingenuity. Apply what you have learned about good visualisation techniques. KISS (Keep It Simple Stupid!!)
The Questions & the Data The data has been gathered at different points in the year and the data engineer originally just sent you the question text with respondent ID’s. You need to amalgamate this data with the appropriate master data to answer the question you have been allocated. You should explore these files and study their contents, then put the data together in Tableau Prep, as you have been shown in seminars, so that you can get the appropriate analysis in Tableau Desktop. You will need to save a .hyper data file to use in Tableau Desktop, and the final workbook must be saved as a packaged workbook .twbx for marking. This format saves your data file along with the workbook, without it the workbook cannot be marked.
The following questions are quite general, this is how you would often be asked to produce analysis in a company. If you have questions about the requirements then I am happy to answer them as if I were your in house client, I will not however, give you a detailed example of what your workbook should look like since you would never get this in reality. You should follow the lead of what we have done in the seminars and use online resources and tutorials.
Most importantly you should constantly sanity check your results and try to tell a compelling story with the data even if you get balanced and unexciting results (sometimes that is a good result!). The questions are as follows;
Q1 What effect, if any does geographic location have on the outcomes in the survey? They are particularly concerned about work/life balance and want to present this in the best way possible. Aggregate all of the agree terms and all of the disagree terms and see how this affects your analysis.
Q2 What effect, if any does gender have on the outcomes in the survey? They are particularly concerned about work/life balance and wants to present this in the best way possible. Aggregate all of the agree terms and all of the disagree terms and see how this affects your analysis. I will check all files for authorship. Please see the Module Guide for guidance on academic misconduct and rules about extensions.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
