Management Information System
Management Information System is nothing but it is a collective data of a particular product or group of products and their flow on the market. A particular product can be handled by many sales executive on the market to various sellers and MIS helps to track each sales executive's report and each sellers target achieved by their sales performance on set deadline.
Management Information System must have some data to follow up and it should have some technology helps which can help to audit and clear the statistics or numeric count and comparison.
How MIS (Management Information System) handled?
Once data collected from various source of organization operation, MIS executive then proceed based on the overall data received and it is handling via MS-Excel using three different operations such as using Pivot table, VLook up and HLook up along with chart etc. to determine the result of the product flow. Once they get the data and statistics results of the each product or each executive, they then forward it to management for further decision on each product where it has affected or improved, they can easily find out the positive and negative of the overall production cycle of each product by using this method including executive's performance and profit.
How MIS helps an organization?
Most of the production companies including Telecom companies uses this MIS method to determine where they lose or gain the profit either from the production or end users. These statistic via MIS helps a lot to each organization for further improving on their product business or further improve on their investment to gain later, Management Information System not only helps to show off the overall result of the past but it helps for the present and future of their cycle.
About MIS using MS-Excel Pivot table, VLook up and HLook up along with chart etc.
MS-Excel is one of the best and friendly calculation software packages that helps many; MS-Excel has an advanced options to be used by various users but advance option like Pivot table etc. using only the relevant professional and not all.
The above mentioned (MS-Excel Pivot table, VLook up and HLook up) calculation helps a lot to business professional by having MIS executives who handle them in a professional manner to track each product performance individually by using MS-Excel Pivot table, VLook up and HLook up along with chart etc. it has unique formula and multi sheets in the same worksheet where you can get all the detail pertaining to particular product with multi executives performances along with variation of each product with each executive's performance output shown. All are automatically calculated by its own formula and MIS executive just have to handle or design it properly per organization requirement.
Please note: If you would like to know more or to be expert in MS-Excel Pivot table, VLook up and HLook up then please visit the help key facility by pressing F1 in excel that will guide you step by step showing example for Pivot table, VLook up and HLook up formulas.
Hafeezur Rahman has joined ISC in 2009 and he is a Job Editor at ISC since 2010, he also a Blogger. Hafeez continue to contribute in various sections of ISC and its sister sites like Techulator, NewRecruitments & Goaspider etc. He is a renowned feature writer & social enthusiast. He loves to write in a simple manner and share his visionary write-ups with the readers on the topics related to his field of interests and different niche. All his write-ups have been popularly read & shared by global readers.
Follow Hafeezur Rahman or read 534 articles authored by Hafeezur Rahman