Assignment 2 (group): development of bi reporting solution

 MIS781 Business Intelligence
Assignment 2 (Group): Development of BI Reporting Solution
Due date: 13 September 2015 (11:59pm AEST)
Mark: 40% of overall unit assessment mark
Word limit: up to 5500 words
Assignment: in a team of 3 students
(Note: off-campus/Cloud students can seek permission to do it individually; at least 2 weeks
before the assignment due date)
BI Solution Development and Report
In the BI software practicals, we saw how the tools interact with data sources to produce BI
reports and dashboards for managers. This practical assignment requires you to
demonstrate your understanding and apply IBM Cognos Insight and/or Watson Analytics
Walton Supermarket is a large supermarket chain in USA. Due to intense competition from
companies like Aldi, the company is facing a number of sales challenges. Your BI
company was hired to consult on a number of problems and your team were responsible for
the BI aspects of the solution.
After a discussion with the senior executive team (e.g. CIO, CEO, COO, Sales Director,
etc), your team managed to zone into a number of problems that they want you to address.
These problems span a number of areas in their business. Your task is to use your
appreciation of BI tools to address these problems. The Supermarket Transaction record
between 2012 and 2014 is provided to you too (Excel file).
The CIO reveals that the company has been collecting sales data and they are able to link a
large part of the sales to their customers through their loyalty rewards program “Uncle Sam
Card”. Through their analytics, they were able to categorise households into six different
 Affluent buyers – families buys mostly high quality product offerings from the
 Lifestyle shoppers – families who buy mostly high quality products but are
buyers of lifestyle products such as chocolates and pet food;
 Busy families – families who seem to buy a lot of ready to cook items and ‘fast
food’ such as instant noodles, can soups, etc.;
 Budget conscious – families whose total spend are largely below $100 per week;
 Discount shoppers – families whose purchases include mostly home brand
items and discount items;
 Battling families – families who purchases include mostly necessities and have a low number of GST applicable purchases.
The CIO went on to elaborate that the company at the moment deploys different ‘carrots’ for different family types. For example, the “affluent” group is not so concern about discounts (targeted at budget conscious families) but are more interested in incentives such as ‘VIP status’ or invitation to special events so you are to keep this in mind. Nonetheless, the following BI reports/performance indicators might be considered:
 Sales revenue over each month, quarter and year for each state, region and cities
 Year to date sales versus last year and Year to date profit versus last year
 Sales for each product category as a proportion of total sales, etc.
Your team have been asked to apply some BI tools to produce ‘Best practice’ BI reports for the senior executives of Walton next week.
1. What are the BI reporting solution/dashboards you will need to develop for the Senior Executives of Walton Supermarket? Develop the BI reporting solution/ dashboards based on the given Supermarket Transaction sample data file and IBM Cognos Insight and/or Watson Analytics tool.
2. Justify why these BI reporting solution/dashboards are chosen and why those attributes are present and laid out in the fashion you proposed (feel free to include all other relevant justifications).
Note: To ensure that you discuss task (2) properly, you must include visual samples of the reports you produce (i.e. the screenshots of the BI report/dashboard must be presented and explained in the written report; use ‘Snipping tool’), and also include any assumptions that you may have made about the analysis in your assignment report (i.e. the report to the senior executive team of Walton).
3. Furthermore, the CEO would like to improve the sales. Based on your BI analysis and the insights gained from “Uncle Sam” loyalty rewards program, make some logical recommendations to the CEO, and justify why/how your proposal could increase the sales revenue. Include the relevant screenshots of the BI analysis, and also any assumptions that you may have made about the analysis.
 You MUST produce the actual visuals in IBM Cognos and/or Watson using the sample dataset.
 If you think the best presentation above is to use, say, only a pie chart, then discuss using a pie chart and indicate what the pie chart would show, why you picked the pie chart, and so on.
 It may be useful to try with various BI reporting/dashboards/presentations before rushing to conclusion.
Report guidelines
1. The body of the report should contain ‘Table of Content’, logically organised sections, and ‘List of references’.
2. The contribution of each team member must be clearly stated on the Table of Content. E.g. Introduction (done by Alex Smith).
3. You may include figures, diagrams, tables and charts, etc.
4. For this practical assignment, the length of the assignment includes everything (e.g. Table of content and References list).
5. Reports should be written in Microsoft Word (font size 11) and submitted as a Word file.
6. Assignments are to be submitted online to the CloudDeakin dropbox (see submission details below).
Submission Details
The assignments should be submitted as a Word file, called surname1-surname1-surname3.docx (e.g. Smith-Patel-Tan.docx) and submitted via CloudDeakin (your group’s Dropbox; not individual one even though if you are allowed to do it individually – so, just join any group number as a sole member, or else your mark will not be automatically recorded by the group assignment system). It is worth 40% of your overall mark for this unit.
Also, the Cognos file (if you use only Watson, include your login detail on the first page – next to your name) AND the Turnitin report of the assignment (i.e. the entire Turnitin similarity report with highlights) must be submitted. Assignments with Turnitin index of 15% or more will be reported to Faculty Academic Misconduct Committee.
Referencing format
You should include any website, journal, or conference papers you have cited in your research paper as references.
Please use the Harvard or APA style for referencing your sources. See:
Assessment of Assignment
The Marking Rubric should give you an idea of the relative effort you need to apply to each section of your assignment.
Plagiarism will cause the grade on any written assignment to be zero (0). Do ensure your Turnitin similarity index is less than 15%.
Getting Help
All students can obtain help by posting messages to the Assessment Discussion in CloudDeakin. In addition, all students can seek help during the classes or consultation hours.
Academic Misconduct
Deliberate academic misconduct such as plagiarism is subject to severe penalties. Plagiarism includes:
 copying words from other students
 re-using assignment material done by other students
 contracting other people to do the assignment, etc.
No extensions will be considered for this assignment unless a written request (email is fine) is submitted and negotiated with the Unit Chair at least 48 hours before the due date. Assignments submitted late without an extension being granted will not be marked. It is your responsibility to keep backups of the assignment.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business and administrative studies
Customer 459947, April 6th, 2022
Excellent job.
Customer 456821, May 11th, 2022
excellent paper
Customer 456821, January 14th, 2023
Customer 463463, November 1st, 2022
English 101
Customer 458101, April 23rd, 2022
Healthcare & Medical
Good work!
Customer 463469, October 17th, 2022
Business and administrative studies
Commendable. Review credentials alignment in APA cover page. Student paper
Customer 453187, March 31st, 2022
Thank you very much
Customer 452763, December 6th, 2021
Customer 463813, April 18th, 2023
Business Studies
Very well done, thank you!
Customer 462533, February 6th, 2022
International Relations
Customer 462817, April 6th, 2022
Well-written and well-researched content. Followed the instructions to the letter. Good job mate!!
Customer 463679, April 27th, 2023
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat