The general manager, need information to make a decision, so it asked his assistants: they do not have that information so the request to the functional areas, personnel from these areas in turn, isplaces to work in Microsoft Excel or ask a new report systems. Finally the IT department or functional area generates information that the CEO is asking, and it makes it go.
How much time elapsed between the generation of the information needs of the director and obtain the same?
How much effort is required to generate this information?
It’s called a meeting of results, the staff of each area works, usually in Microsoft Excel and / or Microsoft Power Point, to format the reports to be presented at the meeting. Once on board the director asks what sales were up yesterday and the sales department says a number ‘X’, and the accounting department said that sales were actually a number ‘Y’.
The historical information, the budget or information outside the company have been registered in Microsoft Excel sheets, and when it needs to integrate this information to the reports generated by the system, do you have to recapture information and generate a new report?
If any of the above situations in your company has undoubtedly Business Intelligence (BI by its acronym in English) is an alternative to solve the problems that arise because of them.
Why use BI?
BI is an alternative technology and business management, covering aspects of management information for decision-making, from its extraction in the systems, debugging, transformation, design of data structures or special models for data storage, to the exploitation of information through business-friendly tools for users. This concept is also called the DataWarehouse.
It is, therefore, to have a tool that is responsible for performing all the functions mentioned above automatically, in real time and presenting a final result in a clear and understandable by the user for example Microsoft Office Excel sheets.
Sample purchases BI Analysis
This tool must have, in addition, sufficient flexibility to allow for easy adaptation to constant changes in business analysis enabling the shift of focus in the collection and presentation of key data.
Analysis of income and expenses
In a future post we will see what are the indicators and what are the most widely used in different business areas.