Enterprise Resources Report

Introduction

Write a research report, of 1600 words in length, on the business intelligence systems that need to be implemented to support the Enterprise Resource Planning (ERP) and decision making process inherent in meeting the objectives of a given organisation’s business objectives and strategies.

The assignment is in two parts (Part A, worth 10% and part B, worth 30%).

The first part of this assignment is to build a support prototype for ERP. It consists of:

a) A data warehouse and dashboards

b) The dashboards are to be used as an aid to support ERP and decision making Before you create your dashboards you will need to articulate how it will “support Enterprise Resource Planning and the decision making process inherent in meeting the objectives of a given organisation’s business objectives and strategies”.

The second part is the report proper; you will analyse and evaluate recent ERP literature and appropriate professional online sources to determine current trends and approaches to use the data warehouse and dashboards effectively to support decision making in an enterprise. Then, based upon your findings, you will provide a brief evaluation of your ERP decision support prototype.

Note: As discussed in class, resources that may be of use have been posted onto the course web site.

Part A: Data Warehouse (10%)

Simulate a Data Warehouse Application using MS Access/MS Excel/SAS Studio

Based on data provided (optional) you will use MS Access to:

1. Create production data tables

2. Decide on the relevant dimensions required for the data warehouse, and then create tables to store the dimensions of a data warehouse.

3. Decide what facts are required and then create tables to store these facts.

4. Create a data warehouse via a query that joins the dimension and fact tables.

ERP and Decision making

5. Create queries designed to retrieve data (for use in forms or reports) from the data warehouse in support of specific decision making activities.

6. Use Pivot tables in MS Excel or Visual Analytics on SAS Viya (in support of ERP and decision making of an organisation).

7. Create dashboards for various departments contributing towards enterprise-wide decisions.