Cleaning data and what inconsistencies the data were found

INFO6090 - Business Intelligence for the Enterprise

ASSIGNMENT 1 - INSTRUCTIONS


•
effectively.
•	ETL Processing: Perform Extract, Transform, Load (ETL) processes to prepare the

•

•
recommendations. The presentation should focus on your findings and recommendations as if you were presenting to Sarah Mitchell and her senior management team.

Assignment Question:
Sarah Mitchell is the head manager of a regional office of the Environmental Protection Agency (EPA) in Newcastle. You are a business analyst with IT expertise and have started a consultancy company called ‘Solver’. Sarah has heard of your company’s IT expertise in helping organizations and asks you to help with a problem she has at her Newcastle office.

prize) to my best field officer for their performance in monitoring and ensuring compliance

with environmental regulations in our region. I need you to tell me who that is and how best

Page 1

INFO6090 - Business Intelligence for the Enterprise

•

•	Data Load Process Undertaken
Provide an overview of the ETL/ELT process completed and what (if any) Quality Assurance (QA) processes you undertook as part of this, e.g., cleaning data and what inconsistencies in the data were found. The QA would be in the form of the QA applied with a SQL script that supports each QA step applied (e.g., checking for missing data). Ensure you record any assumptions you have made as part of this component as well as your team's reasoning behind the assumption.
•

•

Page 2

INFO6090 - Business Intelligence for the Enterprise

•

Breakup of Assignment Marks

Submission Instructions
You are required to upload all files, but the business report, in a single zip file to a TurnItIn folder. You must upload the business report separately. Please ensure that there is no plagiarism or AI-generated solution. Any violations will be seriously penalized.

EBUS3030 Team Peer Review
Team Name: