What is the extraction of the data warehouse?

Data mining is an analysis of information contained in one or more databases to make the information useful. These databases or data warehouses are the central depository for data. Companies aggregate information that they collect on their customers in the data warehouse. Once the information is collected, it is "mined" and useful information from it is obtained to provide information that companies can help take business decisions that will increase profits or reduce costs. Retail traders often use data warehouse mining to analyze and predict the behavior of their customers.

For example, when shoppers go to the supermarket and give the cash register its frequent shopping card, information about its purchases is collected and stored in the company's data warehouse. The supermarket chain will have millions of data about what people buy, when, in how much and at what price. The shop may know that 50,000 packages of frozen peas were sold for the last year but this information itself is notNot particularly useful. However, if the data warehouse mining reveals that 75% of those frozen peas were sold in months when fresh peas were not available, or that 10% of the peas were sold in two weeks to Thanksgiving, the company can use this information to increase their annual sales of frozen dams.

Companies can use techniques of data warehouse mining to predict future sales. Data mining can also help them estimate the impact of storage and prices decisions. In the supermarket, data mining can prevent the trades from running out of a frozen peas in the event of a bad crop of fresh peas.

Data mining regression is a data mining technique that is used to display what is likely to happen with the data value if something changes in the equation. Using an example of a supermarket would regression predict sales of a frozen peas if fresh peasEC increased in price. Regression uses historical data and applies to the formula that predicts future behavior.

companies often use a software application for data warehouse mining to collect and focus their data. The correct application is determined by the amount of data they have and the type of analysis they want to do. Choosing the right data mining tool is decisive for collecting and interpreting useful data.