Data Warehouse

Operational data is a key asset to the organization, but sometimes such data is generally not utilized to its full potential. Thus, the fundamental goal of the data warehouse is to enable user’s appropriate access to a homogenized and comprehensive view of the organization, supporting forecasting and decision-making processes at the enterprise level. 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.

DWH uses consistent data so whatever be the drill down level, data will be same. Inconsistent data may create a situation of confusion so consistency is necessarily maintained.

Features & Benefits

The major benefits of maintaining a data warehouse are summarized below :

  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Improves access to the historical data. Historical data will be available to the broader campus community for ad hoc access and analytical processing.
  • Provides direct support to Institute executives and the organizations in collection, analysis, interpretation, and provision of Institute information.


DWH mainly works in three layers that are as explained below :

  • Top level managers

    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. These individuals are at the top level in organization. Top managers do not direct the day-to-day activities of the firm; rather, they set goals for the organization and direct the organization to achieve them. Top managers are ultimately responsible for the performance of the organization and often these managers have very visible jobs.

    Here we can see data from all the locations that is required by top level managers. They can see data for current year and current month too for all the locations so they come to know about the working and actual situation of the different locations under one hood. They can view data by several criteria by sliding pointer.

  • Middle level managers

    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. Because iddle managers are more involved in the day-to-day workings of a organization, they may provide valuable information to top managers to help improve the organization's bottom line.

    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. Data is shown in grid as well as in graphs so that data can be exported to excel spread sheets for reporting purpose. Here the criteria given above can be customized under settings.

  • First level managers

    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. There are firstline managers in every work unit in the organization. Although first-level managers typically do not set goals for the organization, they have a very strong influence on the organization.

    Here we can see data from one division under one location for one month. Data is displayed by drill down from last level. They can see data by day for selected month based on selected criteria. Data is shown in grid as well as in graphs so that data can be exported to excel spread sheets for reporting purpose.