Reference no: EM133117715
CMP1042 Information Systems - Academy of Information Technology
Assessment - Information Systems Analysis
Purpose
This assessment provides you the chance to demonstrate your understanding of Data Warehouse and Data Mart concepts, combined with OLAP and Data Mining.
Assessment Task
Submit a 1000-word report in MS Word (or equivalent), as described in the ‘Assessment Instructions' below.
Assessment Instructions
To complete this assessment, read the following case study then complete the tasks below.
Imagine Pty Ltd
You are employed by a major Australian supermarket/retail chain (Imagine Pty Ltd). Imagine P/L operates over 500 supermarkets and/or department stores across all states and territories.
You must describe how Imagine P/L can use its large database of transaction data to better target specific market segments or individual customers to improve sales.
Tasks
Submit a 1000-word report which:
1. Briefly describes what data warehouse, data mart, OLAP and Data mining technology are
2. Explains how Imagine P/L can leverage Data Warehouse/Data Mart technology in combination with OLAP and Data Mining to increase sales through targeting of specific customer groups and/or individual customers
3. Discusses how these groups will be targeted (once identified), by explaining three (3) digital marketing options such as email, voice, text, app alert, app redemption token, etc.
The report should be in MS Word format (or equivalent). For the purpose of this assessment, the following assumptions apply:
? 95% of sales are electronic (credit card/phone), 5% are cash;
? 55% of customers use a loyalty card at time of transaction;
? customers who have a loyalty card have provided credit card/phone/email details; and
? Imagine P/L has a smartphone app, which supports tokens (price discounts, etc) and alerts. 25% of customers have downloaded and use the app.
Report Structure
Your report should include the following sections:
? Introduction: Briefly explaining the purpose of the report
? Technology Options: Where you describe each type of technology
? Sales Solution: Where you explain how the options will increase sales
? Marketing Channels: Where you discuss how to reach customers
? Conclusion: Where you summarise what has been proposed.
Attachment:- Data Warehouse and Data Mart concept.rar
What is the amount of their tax refund or taxes due
: They have made prepayments of $1,940 and also have a child tax credit of $3,000. What is the amount of their tax refund or taxes due
|
Make sure your team is locking workstations
: As a healthcare administrator, what would you do to make sure your team is locking their workstations? Would you provide ongoing education?
|
How much do you need to contribute each year
: You will contribute the same amount to the plan at the end of every year that you work. How much do you need to contribute each year to fund your retirement
|
What is the amount of gross purchases
: During 2020, company returned defective merchandise costing P500,000. What is the amount of gross purchases for 2020 under the accrual basis
|
Briefly explaining the purpose of the report
: Briefly explaining the purpose of the report - Discusses how these groups will be targeted (once identified), by explaining three (3) digital marketing options
|
Calculate the amount of revenue and gross pro?t or loss
: In 2022, costs incurred were $2,500,000 with remaining costs estimated to be $3,600,000. Calculate the amount of revenue and gross pro?t or loss
|
Air cargo quality and performance measures
: Describe the quality requirements associated with that area. What quality defects do you believe can be present or observed?
|
Entry-level brand management position
: Coca-Cola Company is considering you for an entry-level brand management position.
|
How much loss will be reported by divergent
: How much loss will be reported by Divergent if the property was destroyed by fire after the 8th year, using the outright method and spread-out method
|