Operational data is a key asset to the organization, but sometimes such data is generally not utilized to its full potential. An additional goal of the data warehouse is to achieve information consistency. By bringing data from different data sources into a centralized repository, the data warehouse provides a homogenized view of the organization's data.
DWH is designed to keep all these things in mind. It is designed in a way that maximum can be utilized from the organization data. It utilizes data by showing it in three layers. The top layer is designed to keep in mind the high level authorities or policy makers(CEO, CFO, President, Vice President etc) that are interested in yearly data for all the locations. Second layer is for middle level authorities(General manager, Plant manager, Regional manager, Divisional manager etc) which are interested in one particular only for period of time. Third layer is for first level authorities(Office manager, Shift supervisor, Department manager etc) that are interested in one division of one location only for period of time.
Features & Benefits
o Empowers decision-makers by enabling direct access to accurate, consistent, and non-volatile information and by offering decision-support services that will facilitate the analysis and interpretation of Institutional data.
o Redirects costly personnel hours from data gathering, matching and consolidating to data analysis. Reduces the need for information consumers to replicate data and maintain redundant tracking systems.
o Promotes the “no walls” culture. The information sharing will lower the walls among all administrative and academic units, creating alliances and connecting people to each other and the Institute as a whole.
o Improves data quality over time. Broader access to information will help better to define what types of information we need on hand for effective decision-making. This will identify areas for improvement in data gathering functions and data entry.
o Enhances organizational effectiveness by extending and expanding the use of management information across the organization. The extensive use of management information will eventually promote the analytical culture that places value on information and analysis.
o Improves integrity and conformity of organization-wide information. As more people in organization use the data, error will be identified and corrected thereby improving data integrity over time.
o Improves access to the historical data. Historical data will be available to the broader campus community for ad hoc access and analytical processing.
o Provides direct support to Institute executives and the organizations in collection, analysis, interpretation, and provision of Institute information.
Operation
Top level managers
o This layer is primarily targeting at top level managers that includes CEO, CFO, COO, CIO, Chairperson of the Board, President, Vice president etc. Top-level anagers are also called senior management or executives. Top managers are ultimately responsible for the performance of the organization and often these managers have very visible jobs.
Middle level managers
o Middle-level managers or middle managers are one level below than top managers. Middle managers' job titles include: General manager, Plant manager, Regional manager, Divisional manager etc. These people are responsible for carrying out the goals set by top management. They do so by setting goals for their departments and other business units. They can motivate and assist first-level managers to achieve business objectives. Middle managers may also communicate upward, by offering suggestions and feedback to top managers.
o Here we can see data from one location only that is required by middle level managers. Data is displayed by drill down from last level. They can see data by month for previous 12 months based on several criteria. Here the criteria given above can be customized under settings.
First level managers
o First-level managers are also called first-line managers or supervisors. These managers have job titles such as: Office manager, Shift supervisor, Department manager, Foreperson, Crew leader, Store manager. First-line managers are responsible for the daily management of line workers—the employees who actually produce the product or offer the service.
o Here we can see data from one division under one location for one month. Data is displayed by drill down from last level.
