Enterprise Data Warehousing and Data Mining Coursework

Enterprise Data W behousing and Data Mining - Coursework ExampleTo this end selective information mining systems are used, are they all they could be and are they really the only way of sorting the chaff from the wheat? Keywords data, mining, search, find, information, business intelligence. Implementing Data Warehousing To take on a data warehousing system into a company means first analyzing the situation that exists, the size of the organization, its present systems and what they poop do to improve the problem without extra costs, it is quite likely thither are professional statisticians in the company who simply need help to get their work done a little faster. To bring a new system into the company means ensuring there is a business need as that must always drive implementation so there must be an emphasised need such as competitors are getting point of intersections to the marketplace first. verbalise by Davis (1994). at a time it has been decided there is no choice, bu t to purchase, then a study of what applications are available in the marketplace must be done, a needs definition bequeath give information on just what is needed from the new system, it may need to be custom built or modified such as has been done for the data mining tool now used by Jaeger. Stated by Grant (2008). With a large company there are going to be many demands from different groups for something that addresses their needs, but as a person responsible for buying the tool it is important it can answer as many differing demands as possible. The implementation often means a company must upgrade its present IT, its hardware, networks and PCs may need alternate or upgrading, so the cost of implementation becomes more than just the cost of purchasing the new system. Thearling, (2003). Figure 1 Convergence of Three Technologies for Data Mining, Thearling (2003) Once the data warehouse is in place data mining can begin, but the two things are separate, data warehousing is not d ata mining. For data mining to go ahead it is probable that software for this role will have to be bought, and implemented after the warehousing system is in place, creating a time delay. Applications available include Sybase IQ 15.3 -- this business intelligence/analytics and data warehouse focused relational database management product is now powered by a so-called new generation of shared everything Massively Parallel Processing (MPP) technology. Bridgwater (2011). Another application is that used by Jaegers new loss prevention programme aims to change managers behaviour by giving them the data they need to take action. Jaeger went to UK loss prevention specialist Oris, which has a strategic partnership with product identity and shrink management company Checkpoint Systems. Oris also supplied IDM Systems Oracle-based LossManager data mining application. Data from its electronic point of sale system lets Jaeger identify the source of losses, mix information from other applicatio ns such as RFID and CCTV, monitor investigations, and provide action alerts for managers. From data mining we knew that 84% of goods stolen were taken from near doors, despite 70% of our more than 120 stores having tagging, Hearn said. Stated by Grant (2008). Benefits of a Data Warehousing System Data warehousing can be very useful in the right situation, it can give just the information needed from all