Reference no: EM133024729

INFO6090 Business Intelligence

Assignment Outcomes

This assignment requires multiple outputs to be created to exhibit your understanding of business intelligence/data analysis through an example of ‘real world' questions, comparable to what you may be asked of you as you become an IT professional.

Key outcomes to be delivered are: Data Modelling/ETL to get the data in a usable format, Output of your analysis, Report summarising your findings and a presentation to the class of your work. The presentation is expected to concentrate more on your findings/recommendations as if it were a situation where you are presenting the response to the CEO. Remember that the statistics and answers you obtain have to provide information and they will be used as a basis for your business intelligence suggestions and recommendations to the CEO and the Board of BIA Incorporated.

Assignment Question
The CEO of ‘BIA Inc' had been speaking to the Sales Executive and had heard about some recent work you had completed and thought you might be able to assist them with a problem they have.

"I've heard that you helped the Sales Exec recently with understanding more about our Australian branch, especially the Newcastle site, and our business processes (we have reduced the discount to 5%).

I would now like your help to get a handle on the whole business in Australia. As you are aware, the Newcastle office is just 1 of 10 sites we have across Australia. Unfortunately, sales in some items have dropped across the country in recent years and we are currently running at a loss.

We need to consider consolidating our company offices in Australia. We need to reduce costs for the longevity of the company as a whole. I need you to get some numbers together around the performance of our 10 offices, so that I can factor this information into any decision regarding which office (or offices) we might consider closing.

I would like a summary of recent numbers and some trend analysis as well please. It would be great if you could also project sales for the next 12 months for each office as well. It would be helpful if you could indicate the 3 most popular and 3 least popular items in each of our stores, as well as the worst performing items for the company as a whole.

As you can imagine, this is a very sensitive topic so, as part of your response I want you to provide the justification as to which office we may close. Our decision will upset some people and I want to make sure we have all the background information on hand. If you can provide a Ranking of offices based on your analysis that would be wonderful.

.... I believe you started to bring together a data store of this information from the Newcastle Office, can you expand that and load all of the sales information for all offices and complete your analysis."

Assignment Deliverables

Using the data file provided in Excel and notes about the data (Assignment 2 - data.xlsx), you are required to complete the following elements as part of the assignment
• Data Model/Data Load Process
o Provide an overview of the data model & ETL process completed to get the data ready for analysis (including identification of any anomalies found, methods of cleaning them and the overall effect of cleaning on the final business analysis)
o Ensure you record any assumptions you have made as part of this component and your reasoning behind the assumption.

• Analysis including any predictive work undertaken and recommendations to Management
o Provide the SQL and raw output of your base analysis
o Provide workings of the predictive work you completed for the trending & prediction on future sales.
o Business recommendations to management (with justifications) based on your analysis
o Ensure you record any assumptions you have made as part of this component and your reasoning behind the assumptions. This includes answers to any relevant questions put to management (your lecturer) during workshops.

• Executive Summary & Presentation in response to business question.
o Provide an Executive report and Dashboard
- Your Executive report should include a short Executive brief/summary that presents a clear concise response back to the CEO question about possible downsizing of operations including evidence/justification.
- A dashboard that allows quick comparisons between the sites to be undertaken as well as containing at least one element of ‘predictive' analysis.
- You may use either Excel and pivot tables to provide a dynamic view of the dashboard, or you can use Power BI to construct your dashboard.

o Conduct an individual YouTube presentation as if it is to be in a formal boardroom meeting.
- Your presentation is worth 5 Course Marks. It should simulate presenting the report to management (CEO and the Board of ‘BIA Inc').
- You should time your presentation to be between 3-5 minutes (timing will be assessed).

Attachment:- Business Intelligence.rar