Here is its definition:
Raw information - initial information, primary information.
Based on these definitions, it is not obvious why to buy BI products, if in almost any enterprise the process of comprehending primary information already exists. It uses:
- Automation of the collection of primary information: In the modern world, such automation has been introduced almost everywhere. Starting from payment terminals and ending with employees who manually enter this information into a computer every day.
- Data Warehouse: They try to somehow analyze the received information, for which they most often create a database that stores information for the current day (OLTP), and a separate database where information is stored for all previous days (Data Warehouse); at night, data is usually moved from one database to another.
- Data analysis in the warehouse: They try to analyze the accumulated information by organizing downloads from it, which are reduced to an Excel file, using the capabilities of Excel to comprehend the information received.
- Microsoft Excel as an analytics tool: To help analysts, Microsoft offers Power BI, which turns Excel into a very serious and modern BI tool. Working with it, business analysts get a complete picture of the current financial processes of the organization.