Designing Business Intelligence Reports
In this assignment, you will learn how to create new reports that will be used by different people in the organization. Business intelligence reports are very important communication tools in managerial decision-making and are targeted to a variety of audiences that include accountants, finance professionals, marketers, salespeople, product managers, among others. The relevance, utility and timeliness of presented information are critical for effective and efficient decision-making.
This exercise will provide you with a hands-on experience in understanding and building information-rich business reports.
Business Case
You are the analyst at the business intelligence department of a retail, marketing and auditing consulting company and your new client is a Global Toys
Corporation, one of the world’s largest toy manufacturers with operations across the globe. Few weeks ago, the company appointed a new Marketing Director, and in a recent presentation he announced a new strategy for some of the best-selling toy products. You are asked to lead in developing a case study (a visual story line) that will help the executive team for better and faster understanding of the presented information. In the new director’s keynote, he wants to go over some facts about current business performance and then use that data to make the case for a new strategy. The director is not sure what type of data/numbers he will ultimately be using in his presentation, and therefore, he asked you to make the business report as flexible as possible in order to allow for further explorations, e.g., filtering, slicing and dicing.
Important Points to note:
As a minimum, explore the data to produce a report for senior management along the following lines.
Business locations or sites, products, sales, and customers.
Create a BI report with at least four sections but not more than six
This BI report should include key facts about the company’s performance on a global and regional level. These facts should include financial, marketing related data, and or efficient use of
Decide on the appropriate visualization tool/type to use based on the data you choose, and information you intend to portray. How will this chart be perceived by a non-technical user? What questions may he/she ask and what answer(s) could she get with it?
You may consider a report along the following lines: Analyse the sites
Analyse the Products Analyse the Sales Evolution
Analyse Customer Satisfaction
DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma
Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t
Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th
1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of
1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
30 | 31 | 1 | 2 | 3 | 4 | 5 |
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 1 | 2 | 3 |
