Data Mining in the 21st Century: Business Intelligence Solutions Extract and Visualize

When you think of the term data mining, what comes to mind? If an image of a mine shaft and miners digging for diamonds or gold comes to mind, you're on the right track. Data mining involves digging for gems or nuggets of information buried deep within data. While the miners of yesteryear used manual labor, modern data minors use business intelligence solutions to extract and make sense of data.

As businesses have become more complex and more reliant on data, the sheer volume of data has exploded. The term "big data" is used to describe the massive amounts of data enterprises must dig through in order to find those golden nuggets. For example, imagine a large retailer with numerous sales promotions, inventory, point of sale systems, and a gift registry. Each of these systems contains useful data that could be mined to make smarter decisions. However, these systems may not be interlinked, making it more difficult to glean any meaningful insights.

Data warehouses are used to extract information from various legacy systems, transform the data into a common format, and load it into a data warehouse. This process is known as ETL (Extract, Transform, and Load). Once the information is standardized and merged, it becomes possible to work with that data.

Originally, all of this behind-the-scenes consolidation took place at predetermined intervals such as once a day, once a week, or even once a month. Intervals were often needed because the databases needed to be offline during these processes. A business running 24/7 simply couldn't afford the down time required to keep the data warehouse stocked with the freshest data. Depending on how often this process took place, the data could be old and no longer relevant. While this may have been fine in the 1980s or 1990s, it's not sufficient in today's fast-paced, interconnected world.

Real-time EFL has since been developed, allowing for continuous, non-invasive data warehousing. While most business intelligence solutions today are capable of mining, extracting, transforming, and loading data continuously without service disruptions, that's not the end of the story. In fact, data mining is just the beginning.

After mining data, what are you going to do with it? You need some form of enterprise reporting in order to make sense of the massive amounts of data coming in. In the past, enterprise reporting required extensive expertise to set up and maintain. Users were typically given a selection of pre-designed reports detailing various data points or functions. While some reports may have had some customization built in, such as user-defined date ranges, customization was limited. If a user needed a special report, it required getting someone from the IT department skilled in reporting to create or modify a report based on the user's needs. This could take weeks - and it often never happened due to the hassles and politics involved.

Fortunately, modern business intelligence solutions have taken enterprise reporting down to the user level. Intuitive controls and dashboards make creating a custom report a simple matter of drag and drop while data visualization tools make the data easy to comprehend. Best of all, these tools can be used on demand, allowing for true, real-time ad hoc enterprise reporting.




Source: http://ezinearticles.com/?Data-Mining-in-the-21st-Century:-Business-Intelligence-Solutions-Extract-and-Visualize&id=7504537

The A B C D of Data Mining Services

If you are very new to the term 'data mining', let the meaning be explained to you. It is form of back office support services that are being offered by many call centers to analyze data from numerous resources and amalgamate them for some useful task. The business establishments in the present generation need to develop a strategy that helps them to cooperate with the market trends and allow them to perform well. The process of data mining is actually the retrieval process of essential and informative data that helps an organization to analyze the business perspectives and can further generate better interests in cutting cost, developing revenue and to acquire valuable data on business services/products.

It is a powerful analytical tool that permits the user to customize a wide range of data in different formats and categories as per their necessity. The data mining process is an integral part of a business plan for companies that need to undertake a diverse research on the customer building process. These analytical skills are generally performed by skilled industrial experts who assist the firms to accelerate their growth through the critical business activities. With a vast applicability in the present time, the back office support services with the data mining process is helping the businesses in understanding and predicting valuable information. Some of them include:

    Profiles of customers
    Customer buying behavior
    Customer buying trends
    Industry analysis

For a layman it is somewhat the process of processing some statistical data or methods. These processes are implemented with some specific tools that preform the following:

    Automated model scoring
    Business templates
    Computing target columns
    Database integration
    Exporting models to other applications
    Incorporating financial information

There are some benefits of Data Mining. Few of them are as follows:

    To understand the requirements of the customers which can help in efficient planning.
    Helps in minimizing risk and improve ROI.
    Generate more business and target the relevant market.
    Risk free outsourcing experience
    Provide data access to business analysts
    A better understanding of the demand supply graph
    Improve profitability by detect unusual pattern in sales, claims, transactions
    To cut down the expenses of Direct Marketing

Data mining is generally a part of the offshore back office services and outsourced to business establishments that require diverse data base on customers and their particular approach towards any service or product. For example banks, telecommunication companies, insurance companies, etc. require huge data base to promote their new policies. If you represent a similar company that needs appropriate data mining process then it is better that you outsource back office support services from a third party and fulfill your business goals with excellent results.

Katie Cardwell works as a senior sales and marketing analyst for a multinational call center company, based in United States of America. She takes care of all the business operations and analysis the back office support services that power an organization. Her extensive knowledge and expertise on Non -voice call center services such as Data Mining Services, Back office support services, etc, have helped many business players to stand with a straight spine and thus making a foothold in the data processing industry.



Source: http://ezinearticles.com/?The-A-B-C-D-of-Data-Mining-Services&id=6503339

What Poker Data Mining Can Do for a Player

Anyone who wants to be more successful in many poker rooms online should take a look at what poker data mining can do. Poker data mining involves looking into all of the past hands in a series of poker games. This can be used to help with reviewing the ways how a player plays the game of poker. This will help to determine how well someone is working when trying to play this exciting game.

Poker data mining works in that a player will review all of the past hands that a player has gotten into. This includes taking a look at the individual hands that were involved. Every single card, bet and movement will be recorded in a hand.

All of the hands can be combined to help with figuring out the wins and losses in a game alongside all of the strategies that had been used throughout the course of a game. The analysis will be used to determine how well a player has gone in a game.

The review will be used to figure out the changes in one's winnings over the course of time. This can be used in conjunction with different types of things that are going on in a game and how the game is being played. This will be used to help figure out what is going on in a game and to see what should be done correctly and what should not be handled.

The data mining that is used is handled by a variety of different kinds of online poker sites. Many of these sites will allow its customers to buy information on various previous hands that they have gotten into. This is used by all of these places as a means of helping to figure out how well a player has done in a game.

Not all places are going to offer support for poker data mining. Some of these places will refuse to work with it due to how they might feel that poker data mining will give a player an unfair advantage over other players who are not willing to pay for it. The standards that these poker rooms will have are going to vary. It helps to review policies of different places when looking to use this service.

Poker data mining can prove to be a beneficial function for anyone to handle. Poker data mining can be smart because of how it can help to get anyone to figure out how one's hand histories are working in a poker room. It will be important to see that this is not accepted in all places though. Be sure to watch for this when playing the game of poker and looking to succeed in it.



Source: http://ezinearticles.com/?What-Poker-Data-Mining-Can-Do-for-a-Player&id=5563778

Digging Up Dollars With Data Mining - An Executive's Guide

Traditionally, organizations use data tactically - to manage operations. For a competitive edge, strong organizations use data strategically - to expand the business, to improve profitability, to reduce costs, and to market more effectively. Data mining (DM) creates information assets that an organization can leverage to achieve these strategic objectives.

In this article, we address some of the key questions executives have about data mining. These include:

    What is data mining?
    What can it do for my organization?
    How can my organization get started?

Business Definition of Data Mining

Data mining is a new component in an enterprise's decision support system (DSS) architecture. It complements and interlocks with other DSS capabilities such as query and reporting, on-line analytical processing (OLAP), data visualization, and traditional statistical analysis. These other DSS technologies are generally retrospective. They provide reports, tables, and graphs of what happened in the past. A user who knows what she's looking for can answer specific questions like: "How many new accounts were opened in the Midwest region last quarter," "Which stores had the largest change in revenues compared to the same month last year," or "Did we meet our goal of a ten-percent increase in holiday sales?"

We define data mining as "the data-driven discovery and modeling of hidden patterns in large volumes of data." Data mining differs from the retrospective technologies above because it produces models - models that capture and represent the hidden patterns in the data. With it, a user can discover patterns and build models automatically, without knowing exactly what she's looking for. The models are both descriptive and prospective. They address why things happened and what is likely to happen next. A user can pose "what-if" questions to a data-mining model that can not be queried directly from the database or warehouse. Examples include: "What is the expected lifetime value of every customer account," "Which customers are likely to open a money market account," or "Will this customer cancel our service if we introduce fees?"

The information technologies associated with DM are neural networks, genetic algorithms, fuzzy logic, and rule induction. It is outside the scope of this article to elaborate on all of these technologies. Instead, we will focus on business needs and how data mining solutions for these needs can translate into dollars.

Mapping Business Needs to Solutions and Profits

What can data mining do for your organization? In the introduction, we described several strategic opportunities for an organization to use data for advantage: business expansion, profitability, cost reduction, and sales and marketing. Let's consider these opportunities very concretely through several examples where companies successfully applied DM.

Expanding your business: Keystone Financial of Williamsport, PA, wanted to expand their customer base and attract new accounts through a LoanCheck offer. To initiate a loan, a recipient just had to go to a Keystone branch and cash the LoanCheck. Keystone introduced the $5000 LoanCheck by mailing a promotion to existing customers.

The Keystone database tracks about 300 characteristics for each customer. These characteristics include whether the person had already opened loans in the past two years, the number of active credit cards, the balance levels on those cards, and finally whether or not they responded to the $5000 LoanCheck offer. Keystone used data mining to sift through the 300 customer characteristics, find the most significant ones, and build a model of response to the LoanCheck offer. Then, they applied the model to a list of 400,000 prospects obtained from a credit bureau.

By selectively mailing to the best-rated prospects determined by the DM model, Keystone generated $1.6M in additional net income from 12,000 new customers.

Reducing costs: Empire Blue Cross/Blue Shield is New York State's largest health insurer. To compete with other healthcare companies, Empire must provide quality service and minimize costs. Attacking costs in the form of fraud and abuse is a cornerstone of Empire's strategy, and it requires considerable investigative skill as well as sophisticated information technology.

The latter includes a data mining application that profiles each physician in the Empire network based on patient claim records in their database. From the profile, the application detects subtle deviations in physician behavior relative to her/his peer group. These deviations are reported to fraud investigators as a "suspicion index." A physician who performs a high number of procedures per visit, charges 40% more per patient, or sees many patients on the weekend would be flagged immediately from the suspicion index score.

What has this DM effort returned to Empire? In the first three years, they realized fraud-and-abuse savings of $29M, $36M, and $39M respectively.

Improving sales effectiveness and profitability: Pharmaceutical sales representatives have a broad assortment of tools for promoting products to physicians. These tools include clinical literature, product samples, dinner meetings, teleconferences, golf outings, and more. Knowing which promotions will be most effective with which doctors is extremely valuable since wrong decisions can cost the company hundreds of dollars for the sales call and even more in lost revenue.

The reps for a large pharmaceutical company collectively make tens of thousands of sales calls. One drug maker linked six months of promotional activity with corresponding sales figures in a database, which they then used to build a predictive model for each doctor. The data-mining models revealed, for instance, that among six different promotional alternatives, only two had a significant impact on the prescribing behavior of physicians. Using all the knowledge embedded in the data-mining models, the promotional mix for each doctor was customized to maximize ROI.

Although this new program was rolled out just recently, early responses indicate that the drug maker will exceed the $1.4M sales increase originally projected. Given that this increase is generated with no new promotional spending, profits are expected to increase by a similar amount.

Looking back at this set of examples, we must ask, "Why was data mining necessary?" For Keystone, response to the loan offer did not exist in the new credit bureau database of 400,000 potential customers. The model predicted the response given the other available customer characteristics. For Empire, the suspicion index quantified the differences between physician practices and peer (model) behavior. Appropriate physician behavior was a multi-variable aggregate produced by data mining - once again, not available in the database. For the drug maker, the promotion and sales databases contained the historical record of activity. An automated data mining method was necessary to model each doctor and determine the best combination of promotions to increase future sales.

Getting Started

In each case presented above, data mining yielded significant benefits to the business. Some were top-line results that increased revenues or expanded the customer base. Others were bottom-line improvements resulting from cost-savings and enhanced productivity. The natural next question is, "How can my organization get started and begin to realize the competitive advantages of DM?"

In our experience, pilot projects are the most successful vehicles for introducing data mining. A pilot project is a short, well-planned effort to bring DM into an organization. Good pilot projects focus on one very specific business need, and they involve business users up front and throughout the project. The duration of a typical pilot project is one to three months, and it generally requires 4 to 10 people part-time.

The role of the executive in such pilot projects is two-pronged. At the outset, the executive participates in setting the strategic goals and objectives for the project. During the project and prior to roll out, the executive takes part by supervising the measurement and evaluation of results. Lack of executive sponsorship and failure to involve business users are two primary reasons DM initiatives stall or fall short.

In reading this article, perhaps you've developed a vision and want to proceed - to address a pressing business problem by sponsoring a data mining pilot project. Twisting the old adage, we say "just because you should doesn't mean you can." Be aware that a capability assessment needs to be an integral component of a DM pilot project. The assessment takes a critical look at data and data access, personnel and their skills, equipment, and software. Organizations typically underestimate the impact of data mining (and information technology in general) on their people, their processes, and their corporate culture. The pilot project provides a relatively high-reward, low-cost, and low-risk opportunity to quantify the potential impact of DM.

Another stumbling block for an organization is deciding to defer any data mining activity until a data warehouse is built. Our experience indicates that, oftentimes, DM could and should come first. The purpose of the data warehouse is to provide users the opportunity to study customer and market behavior both retrospectively and prospectively. A data mining pilot project can provide important insight into the fields and aggregates that need to be designed into the warehouse to make it really valuable. Further, the cost savings or revenue generation provided by DM can provide bootstrap funding for a data warehouse or related initiatives.

Recapping, in this article we addressed the key questions executives have about data mining - what it is, what the benefits are, and how to get started. Armed with this knowledge, begin with a pilot project. From there, you can continue building the data mining capability in your organization; to expand your business, improve profitability, reduce costs, and market your products more effectively.




Source: http://ezinearticles.com/?Digging-Up-Dollars-With-Data-Mining---An-Executives-Guide&id=6052872

Top Data Mining Tools

Data mining is important because it means pulling out critical information from vast amounts of data. The key is to find the right tools used for the expressed purposes of examining data from any number of viewpoints and effectively summarize it into a useful data set.

Many of the tools used to organize this data have become computer based and are typically referred to as knowledge discovery tools.

Listed below are the top data mining tools in the industry:

    Insightful Miner - This tool has the best selection of ETL functions of any data mining tool on the market. This allows the merging, appending, sorting and filtering of data.
    SQL Server 2005 Data Mining Add-ins for Office 2007 - These are great add-ins for taking advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007. The add-ins Allow you to go through the entire development lifecycle within Excel 2007 by using either a spreadsheet or external data accessible through your SQL Server 2005 Analysis Services instance.
    Rapidminder - Also known as YALE is a pretty comprehensive and arguably world-leading when it comes to an open-source data mining solution. it is widely used from a large number of companies an organizations. Even though it is open-source, this tool, out of the box provides a secure environment and provides enterprise capable support and services so you will not be left out in the cold.

The list is short but ever changing in order to meet the increasing demands of companies to provide useful information from years of data.



Source: http://ezinearticles.com/?Top-Data-Mining-Tools&id=1380551

Basics of Online Web Research, Web Mining & Data Extraction Services

The evolution of the World Wide Web and Search engines has brought the abundant and ever growing pile of data and information on our finger tips. It has now become a popular and important resource for doing information research and analysis.

Today, Web research services are becoming more and more complicated. It involves various factors such as business intelligence and web interaction to deliver desired results.

Web Researchers can retrieve web data using search engines (keyword queries) or browsing specific web resources. However, these methods are not effective. Keyword search gives a large chunk of irrelevant data. Since each webpage contains several outbound links it is difficult to extract data by browsing too.

Web mining is classified into web content mining, web usage mining and web structure mining. Content mining focuses on the search and retrieval of information from web. Usage mining extract and analyzes user behavior. Structure mining deals with the structure of hyperlinks.

Web mining services can be divided into three subtasks:

Information Retrieval (IR): The purpose of this subtask is to automatically find all relevant information and filter out irrelevant ones. It uses various Search engines such as Google, Yahoo, MSN, etc and other resources to find the required information.

Generalization: The goal of this subtask is to explore users' interest using data extraction methods such as clustering and association rules. Since web data are dynamic and inaccurate, it is difficult to apply traditional data mining techniques directly on the raw data.

Data Validation (DV): It tries to uncover knowledge from the data provided by former tasks. Researcher can test various models, simulate them and finally validate given web information for consistency.



Source: http://ezinearticles.com/?Basics-of-Online-Web-Research,-Web-Mining-and-Data-Extraction-Services&id=4511101

Beneficial Data Collection Services

Internet is becoming the biggest source for information gathering. Varieties of search engines are available over the World Wide Web which helps in searching any kind of information easily and quickly. Every business needs relevant data for their decision making for which market research plays a crucial role. One of the services booming very fast is the data collection services. This data mining service helps in gathering relevant data which is hugely needed for your business or personal use.

Traditionally, data collection has been done manually which is not very feasible in case of bulk data requirement. Although people still use manual copying and pasting of data from Web pages or download a complete Web site which is shear wastage of time and effort. Instead, a more reliable and convenient method is automated data collection technique. There is a web scraping techniques that crawls through thousands of web pages for the specified topic and simultaneously incorporates this information into a database, XML file, CSV file, or other custom format for future reference. Few of the most commonly used web data extraction processes are websites which provide you information about the competitor's pricing and featured data; spider is a government portal that helps in extracting the names of citizens for an investigation; websites which have variety of downloadable images.

Aside, there is a more sophisticated method of automated data collection service. Here, you can easily scrape the web site information on daily basis automatically. This method greatly helps you in discovering the latest market trends, customer behavior and the future trends. Few of the major examples of automated data collection solutions are price monitoring information; collection of data of various financial institutions on a daily basis; verification of different reports on a constant basis and use them for taking better and progressive business decisions.

While using these service make sure you use the right procedure. Like when you are retrieving data download it in a spreadsheet so that the analysts can do the comparison and analysis properly. This will also help in getting accurate results in a faster and more refined manner.



Source: http://ezinearticles.com/?Beneficial-Data-Collection-Services&id=5879822