data warehouse it is a data warehouse digitals that serves to store information detailed for a company, creating and organizing reports across histories which are then used by the company to help make important decisions based on the facts presented.
O data warehouse serves to collect information from a company so that it can better control a given process, providing greater flexibility in research and in the information they need.
in addition to keep a history of information, the Data Warehouse create patterns improving the analyzed data from all systems, correcting errors and restructuring the data without affecting the operating system, presenting only a final and organized model for analysis.
Data warehouse and data mart
One date mart is a subdivision or subset of a data warehouse. You data marts are like little slices of data warehouse, which store subsets of data.
Usually the date mart is targeted to a line of business or team, with its information typically belonging to a single department.
Advantages and Disadvantages of Data Warehouse
Some of the main advantages of data warehouse they are:
- Inconsistencies are identified and resolved before data is uploaded, which facilitates analysis and reporting;
- They contribute to the decision-making process through trending, exception reporting, and reports that reveal objectives versus actual performance.
O data warehouse it also has some disadvantages, including:
- They are not an adequate solution for unstructured data;
- They can be costly and can get out of date quite quickly.
Data warehouse and Business intelligence
business intelligence (business intelligence in Portuguese), is the process of collecting and processing information that supports the management of a business.
Typically, the various strands of business intelligence use information collected in a data warehouse. Despite this, not all data warehouses are used in the context of business intelligence, because not all applications of business intelligence require one data warehouse.
OLAP
OLAP (Online Analytical Processing - Analytical Process in Real Time), is one of the most used tools for exploring a data warehouse. OLAP makes it possible to alter and analyze large amounts of data from many different perspectives.
The application of this tool can be used by managers from any area and level, providing information and helping in the final decision. The use of OLAP can be applied to very different functions, some of the most used vary from financial functions (analysis, flows of cash, accounts, budgets, etc.) going through marketing (price analysis, market volume) ending in sales (forecasts, profit, customers).
