350-700 word paper on Business Intelligence Reporting

User Generated

Fpehyhpr

Computer Science

Description

Document data warehouse reports against your data warehouse.

Write a 350- to 700-word paperexplaining how each report will help management analyze, solve, and monitor the issues

For reference, I am including the assignment from the prior week. Dimensional Model Hands On Project.docx 

Unformatted Attachment Preview

Running head: DIMENSIONAL MODEL 1 Dimensional Model Hands On Project Oran Schwinn DBM 460 December 8, 2014 Kurt Jost DIMENSIONAL MODEL Business and Management Scenario INTRODUCTION: The success of every company to properly manage the flow of data within the company and without depends on the efficiency of the dimensional model adopted to design the data warehouse of the specific company. Credible dimensional database models should be able to allow easy flow of data within the parties sharing the data. Moreover, easy data loading and retrieval characterizes a credible data warehouse. This paper shall therefore present an ideal dimensional data model that Kudler Fine Foods adopted in designing data warehouse (Ross & Kimball, 2013). DATABASE TABLE STRUCTURE OF KUDLER FINE FOODS: Supplier: Supplier name Supplier address Inventory: Quantity on hand Description Category of inventory Top management: Overseeing and controlling the company’s operations Order Order ID Customer ID Order source Consumer Name of the consumer Address of the consumer and consumer phone number REFINED DIMENSIONAL MODEL Tender: Tender: Tender type Tender type Order ID Order ID Code of store Code of store DIMENSIONAL MODEL The dimensional model adopted by Kudler Fine Foods in designing the data warehouse structure is optimized at centralizing database and management operations to the top management. The structure of the data warehouse shows that organization and management of database files shall be centralized within the top management of the organization. This is geared to enable easy operational data management by Kudler Fine Foods through centralizing the management of data files to the top management of the food company. Moreover, the data warehouse is designed to foster understanding and transparency within the company and its external environments. The data warehouse is designed to create extensibility. The model of the structure is ideal for allowing and accommodating of new data. Through centralizing data files management to the top management, the models dispense a centralized operator that can create room for new data (Ross & Kimball, 2013). The dimensional model of the warehouse is designed to allow easy loading and uploading of transactions through a well-defined operational framework. This is because; a data management structure with a centralized data manager reduces bureaucracy in the process of loading data and uploading data. In extensive conditions of bureaucracy in operations, the basic database operations are held at stuck hence causing redundancy. Therefore the model of the data warehouse structure is optimized for easing data management operations and hence mitigating reducing data redundancy in the data management system (Ross & Kimball, 2013). Data redundancy is a big threat in data management since it leads to mix up of data hence a great risk of data loss. Through reduction of bureaucracy, the model of the data warehouse creates transparency and accountability in data management. This is because; the identification of a single data management operator creates a sense of accountability. This is because; the data DIMENSIONAL MODEL management operations are centralized to the top management which shall manage and oversee the flow and management of data (Corr & Stagnitto, 2012). The dimensional model adopted by Kudler Fine Foods fosters understandability in the data management operations. The dimensional model identifies a well-defined data operation flow. The flow of data management operations is centralized manager which is the top management. According to the structure of the data warehouse, the top management is entitled to enter the vital data of transaction in data management system. This creates understanding of the flow of data in everyday’s transactions of the company and its external environments (Corr & Stagnitto, 2012). ETL PROCESSES FOR THE DIMENSIONAL MODEL DATABASE: Basically, the dimensional model database is optimized to allow easy Extraction, Transformation and loading of data into the data warehouse. This segment of the paper shall analyze the provided ETL process that is adopted in the dimensional model database (Corr & Stagnitto, 2012). • Extracting data from the ware house: The dimensional model allows for pulling of data from the data warehouse by allowing direct operational link between the top management, which is the central data manager, and the external environments of the Kudler Fine Foods Company. The dimensional model of the data warehouse allows for direct data retrieval from the top management to the tender, supplier and consumer. All the three external environments of the company have direct retrieval link for data (Corr & Stagnitto, 2012). • Transforming data: DIMENSIONAL MODEL The dimensional model allows the three external environment of the company to access data from the order and inventory bodies so as to allow applying of the business rules such as calculating measures and dimensions. The dimensional model also allows for quick cleaning, filtering and application of both simple and complex processes of data validation (Corr & Stagnitto, 2012). • Loading the data: The dimensional model identifies the central data operator as the top management of the company and therefore creating a monitored and transparent data loading strategy. The loading of the vital transactional data into the data warehouse is entitled to the central management (Corr & Stagnitto, 2012). A REPORT ON THE DATA WAREHOUSE: The data warehouse is designed to allow swift data operational activities. The structure of the model is set to reduce redundancy of data in the data management system. The dimensional model mitigates the options of data loss through complexity in data flow which normally characterizes redundancy of data in the data management system. The dimensional model also allows for easy monitoring of data management operations through centralizing the data management operations to the top manage. This allows for understanding in loading new data into the data management system. the allowing of the suppliers, tenders and consumers to access direct data from inventory and order segment enables easy transforming of data business rules applicable (Corr & Stagnitto, 2012). DIMENSIONAL MODEL References: Ross, M., & Kimball, R. (2013). The data warehouse toolkit: The complete guide to dimensional modeling. Hoboken, N.J: Wiley. Corr, L., & Stagnitto, J. (2012). Agile data warehouse design: Collaborative dimensional modeling, from whiteboard to star schema. Leeds: Decisionone Press.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags