Decision making is based on understanding the flow from data to information to knowledge so that it will support improved Business Intelligence (BI) decisions. There are three basic sections of any BI structure. They are:
- Data sources (databases);
- The Database Management System and Enterprise Resource Planning (DBMS and ERP); and
- The Dashboard display
The final research paper is for you to describe the high-level design and interfaces necessary to create a usable Dashboard to support General Manager (GM)-level business decisions.
First, the final research paper must identify the necessary internal and likely external databases that would be needed to support the Dashboard (from data silos, data marts, data warehouses, etc.).
Additionally, the paper must include critical Entity Relationships (ER) across databases to ensure high level of information accuracy.
Second, the paper must describe the DBMS and ERP relationships in high-level terms that support the Extract, Transform, and Load (ETL) functions necessary to deliver information and formats (e.g., charts, etc.) to the dashboard.
Lastly, the dashboard (shown graphically in addition to the appropriate narrative) must contain no less than three and no more than four pieces of information that a Department Store GM would need. The dashboard must be described sufficiently in terms of data visualization options (e.g., charts, texts, timelines). Layout of the dashboard must be specified.
0 comments