INFO6090 – Assignment 1Page 1Business Intelligence – INFO6090Assignment 1Worth: 25% of your course Mark (Report 20% Presentation 5%)Assignment OutcomesThis assignment requires multiple outputs to be created to exhibit your understanding of businessintelligence/data analysis through an example ‘real world’ question that is comparable to what you may beasked of you as you become an IT professional. You will do the assignment as a team but will receiveindividual marks based on your contribution to the assignment.Key outcomes to be delivered are: Data Modelling of the provided dataset, Extract Transform Load (ETL)processing undertaken to make the data usable, Output of your analysis, a Report summarising yourfindings and recommendations, and a presentation to the class of your work. The presentation is expectedto concentrate more on your findings/recommendations as if it were a situation where you are presentingthe response to the head sales executive’s question.Assignment QuestionThe head Sales Executive of ‘BIA Inc’ comes to you as the lead Business/Data Analyst and asks you to helpwith a problem they have.“I’ve heard that people aren’t motivated at the moment and sales aren’t as good as we had hoped. To tryand provide incentives for staff, I want to provide an award (and probably associated cash prize) to my bestperformer for sales from this Office, I need you to tell me who that is?”“As part of your response I want you to provide the justification as to why the particular sales officer wasselected because we need governance over things like this.…. By the way, we don’t currently have any of this information stored centrally in a database thingy, but Ihave gotten the Office Business Manager to collate a summary of the recent sales into a rough excel filethat can be used as a starting basis. As part of the processes of getting me an answer on my bestsalesperson, can you also create a database as part of the preparation of the answer. We will then use thatas the base of further reporting into the future. We haven’t ever had people with your skills working with usbefore so I expect there will be lots of questions that will come up as we utilise your expertise.”You have been given hints regarding the assignment and its expected deliverables in lectures and orWeekly Learning Activities. You will be judged on your technical ability in producing analytics as well asyour ability to interpret them and provide the clients with information and knowledge that may be usefulfor them.INFO6090 – Assignment 1Page 2Assignment DeliverablesUsing the data file provided in Excel and associated notes about the data, (Assignment 1 – data.xlsx) youare required to complete the following elements as part of the assignment.• Your team report should have a group assessment sheet followed by a title page that provides theteam identification and peer review.• Data Modelo Using the information made available to you and your understanding of concepts arounddata mart design in the labs, design a “Sales” DataMart to store the information in a formatthat will allow the information to be expanded and one that would enable analysis to occur.• ETL: Data Load Process undertakeno Provide an overview of the ETL/ELT process completed and what (if any) Quality Assuranceprocesses you undertook as part of this.o Ensure you record any assumptions you have made as part of this component and yourreasoning behind the assumption.• Output of Analysis (including SQL used)o Once the data loaded and is available and ready for use, you need to create a set of SQLscripts to be used to generate the results to the business question provided to you from theHead Sales Executiveo Provide a snapshot of the raw results of your analysis that provides the basis of yourrecommendationso Provide your recommendations based on your analysis – this could include any businessrecommendations and presentations that might be helpful in explaining your analysis andresults to a business manager. You should always think of the business as well as thetechnical side of analysis, ie you produce an analysis of data, but how are the resultsinterpreted? Are they beneficial or useful to the business? The following hints will help yourteam achieve the most marks for this section:
(Hint: It might be nice to present graphs of the top salespersons) (Hint: What criteria will you use to determine the best performer?)• It might be good to provide the best sales performer based on differentcriteria. For example, how do you decide the criteria used to determine thebest sales performer??? By total dollars returned to the business or by thetotal number of sales made?.o Ensure you record any assumptions you have made as part of this analysis component andyour reasoning behind the assumption.• Executive Summary in response to business question.o Provide a short Executive brief/summary that presents a clear concise response back to theSales Executive’s question about possible incentives to the best salesperson. This shouldclearly detail the recommendation and any key assumptions/restrictions the executive needto be aware of.• Team Presentationo A YouTube team presentation will be required indicating recommendations to management.Details of the presentation will be explained by week 4 but you should anticipate that it willbe a YouTube presentation. Your team’s presentation should be delivered as if you weresummoned to the board room with the Head Sales Executive to provide a formal responseto his questions.NB: As part of your responses, you should also specifically include any assumptions you have madethroughout the process.INFO6090 – Assignment 1Page 3Assignment Progress Requirements:• Each team is to have a weekly meeting, starting in week 2. Team documentation includes weeklyaction items resulting from the team meeting. These should be in a document with an entry for eachweek of work. Each week’s entry should show the allocation of work/tasks to each team memberand a summary of the team member’s weekly progress on their allocated tasks, i.e. the result(finished/continuing/needs to be redone, etc) and the quality of the work/tasks assigned in acomment. This document will be attached to the team’s assignment report. It may be used as abasis for an individual team member‘s assignment mark if the lecturer is not satisfied with the peerreview. A template is in the Blackboard assessments folder.• Each team is to have a file repository that keeps team member’s work-in-progress. This can beanywhere the team chooses and it also chooses when work-in-progress is to be available before theweekly team meeting. The choice of platform is up to the team (google docs, one drive, etc) but itshould be able to be produced when requested by a tutor or lecturer.• A peer review will be the primary means of allocating a contribution percentage of the teamassignment mark to get an individual team members mark. If there is a dispute regarding the peerreview the lecturer will arbitrate and award the individual mark based the team documentation ofaction items and allocation of work as described below.• Please make sure that you engage with your team members and be proactive in theassignment and progression of work through weekly communication – you establish with yourteam the best methods for communication, progression and storage of work-in-progress. Youare all in a team of at least 4 people (allowing for the potential risk of one student withdrawal)and you have enough time and skills in your teams to complete the work to a high standard.If there are any problems within your team, please contact me urgently so we can try andmitigate them.• I will not know who does what in your team, or the quality of the week-by-week submissionsof tasks, nor do I know which team members lead, perform work, be proactive, respond ontime, submit work regularly, consistently submit quality work, always need checking, arealways late, do not make suggestions, etc. You, and the members of your team, are the oneswho know that for your team. For that reason, the initial individual assignment of marks is bypeer review.• The peer evaluation will be analogous to handing $100 to the team and getting it to split themoney amongst its members according to individual contribution (any change goes to thelecturer 
• As an example, if there are 4 people in the team and everyone is roughly consistentin contributions to the final submission, then everyone gets $25. Remember that apeer review is subjective and also that some people do better or finish quicker insome tasks than others, but that generally should even out in other tasks.• As indicated in the Course Outline, if there is disagreement regarding the peer evaluation, thewhole team will be assessed, and individual marks arbitrated by the lecturer. This will involvesubmission of individual diaries of team members, followed by a concurrent zoom meetingbetween the team and the lecturer to arbitrate individual marks.• You are to fill in a team peer review on the title page (the first page following groupassignment cover sheet) of your assignment. It should simply list each member andcontribution as a % (the total of all member percentages should add up to 100%). If there is adisagreement, or a low contribution, the team should briefly indicate a reason.INFO6090 – Assignment 1Page 4Breakup of assignment Marks (total course mark for assignment = 25%.A detailed marking guide is provided in the assignment one folder.Key Documents Required & FormatYou are required to upload all files in a single zip, not rar, file called “INFO6090 Assignment One TeamOLxx” (OLxx is your team ID). This file includes your SQL database, your analysis report, your PowerpointPresentation slides and your weekly progress and status Excel file, via blackboard to the assignment 1 dropfolder by the deadline on Blackboard.You are required to submit your Analysis Report (excluding weekly status report and any SQL or data files)as a Word document called “INFO6090 Assignment One Analysis Report” to the TurnItIn folder forAssignment One by the deadline on Blackboard.Important: This is a TEAM assignment. Only 1 load per team for the report to TurnItIn and the zip files tothe Assignment Dropbox folder – only the first load will be accepted for marking so ensure that it iscomplete and contains all of the required deliverable items.
