Creating Executive Dashboards for Optimizing the Decision Making Process in the Organizations

The purpose of this article is to examine the process of creating executive dashboards to optimize the decision making process in the organizations. In this regard, the data and information used in the executive dashboards for the sales and inventory control departments are all real data of a real manufacturing company in Tehran which are designed and arranged using the database of Afra Pooyesh Tyam Corporation, an engineering consulting firm of industries. With the employment of these dashboards, managers were able to find out the sales process in multiple years, months, and chapters according to the features that the software provided to them and based on this information and processes, they were able to plan their orders for the forthcoming months. Using this software, managers were able to filter out a very large amount of data on their desired fields in a shorter time. In the inventory control section, using these dashboards, experts could at any given moment have the availability of inventory at any store they wanted. One of the most important outcomes of these dashboards was that managers could find out the reason for the very low sale in some months of the year, which was contrary to the anticipation, was actually due to the low inventory at that moment, and not for instance because of bad product designing.

Keywords:

data and information , business intelligence , executive dashboards , managers , decision making process , QlikView software