3

How Does Market Basket Analysis Produce ROI?

Numerous articles, journals, books, and experts agree that Market Basket Analysis is a good idea. Data mining books include Market Basket Analysis. Podcasts explain the need for Market Basket Analysis. Marketing textbooks explain Market Basket Analysis as an analytic method. So, all in all, everyone agrees that Market Basket Analysis adds value to an enterprise. But, when the budget meeting occurs and the decision is about to be made whether to invest in a new market expansion or Market Basket Analysis, broad generalities of approval of Market Basket Analysis just do not quite carry the day. So, before we suggest the expenditures and investments required to make Market Basket Analysis happen, we need to consider some of the specific benefits of Market Basket Analysis.

Analytic Structure

Market Basket Analysis is perceived as being difficult, as an advanced branch of analytics. For that reason, many analysts who need Market Basket Analysis feel they don’t have the oversized database or the high-powered analysis engine that is misunderstood to be key to Market Basket Analysis. Misconceptions such as these indicate the first obstacle to success is a lack of structure. Only when an analysis effort has a structure can knowledge and experience be attached to that effort via the structure.

The first ROI of the Market Basket Analysis solution design outlined in the following chapters is that it breaks this cycle. The solution design in the following chapters is based on generally available technologies and methods. The table definitions and join strategies in the solution design leverage structures and techniques that are already standard fare in the information systems industry. The information that is new is a set of concepts that can be applied to any enterprise. As such these concepts provide a structure to the analysis. The structure created by these concepts is well defined and can, therefore, be repeated; and, when repeated, the concepts can be applied to various subject areas and hierarchical levels within the enterprise.

The second ROI of analytics is the by-products of analytics. Market Basket Analysis is a search. Every search reveals more than the intended answer. When searching for a report or document, invariably you find reports and documents other than what you were looking for. In the process of searching for one document, you find ten others in addition to the one. There is an old saying about searching: “You find it in the last place you look.” That is of course true because once you find what you’re looking for, you stop looking. So, of course you find what you’re looking for in the last place you look. Implicitly, that means that you also looked in other places and found other things. This also happens with Market Basket Analysis. You find other patterns and affinities you weren’t looking for. In this way, an analysis effort such as Market Basket Analysis will discover knowledge about the enterprise, knowledge that extends beyond the answer to the question at hand. These are the hidden gems and jewels that are the by-product of analysis.

Analytic Skills

Sir Francis Bacon stated that “knowledge is power.” The ability to generate knowledge is even more powerful. The third ROI of the solution design in the following chapters is that it renders available analytic skills, which were previously unavailable to analysts. The original genesis of the Market Basket Analysis solution design in this book was the unavailability of such analytic skills. The knowledge generation process in the Market Basket Analysis solution design is oriented first around the need for an analytic method. This Market Basket Analysis solution design allows an analyst to manage the knowledge and the process and skills that created them.

Ownership of the analytic process and skills leads to the fourth ROI. Thinking is a difficult activity. The scientific process provides a structure that renders thinking a tangible process. A hypothesis is expressed in terms of Affinity. A permutation of Driver and Correlation Objects is hypothesized to achieve a level of affinity. Then, through multiple sets of Itemsets that hypothesis is tested and refined. At the end, a hypothesis that has been tested and validated through the scientific process becomes knowledge. If that knowledge is actionable, the enterprise can implement the actions implicit in that knowledge.

Actionable Knowledge

The ROI of analytic skills is a valuable addition to any enterprise. However, it will not carry the day without the ROI we all came to see. The knowledge-generating processes, the by-products of those processes, and the metaknowledge underlying that knowledge represent an investment in the future of the enterprise. Wonderful as that may be, the bills have to be paid today. Otherwise the investment in tomorrow will never be allowed to mature.

The ROI of Market Basket Analysis is actionable knowledge. That actionable knowledge comes in three forms—Complements, Substitutes, and Independents. Each of these three forms of actionable knowledge can also provide KPIs that can be used to monitor the enterprise. By acting on the actionable knowledge provided by Market Basket Analysis the enterprise is able to engage in activities that increase revenues or decrease expenses, or the reverse, that is, avoid activities that reduce revenues or increase expenses. These activities may include business processes that are already occurring, missed opportunities that have yet to be leveraged, or business processes that are currently occurring and disadvantageous to the enterprise.

Complements

Complements are two objects in an Itemset that have a strong affinity for each other. They tend to occur simultaneously in the same Itemset. The knowledge that two objects have a strong tendency to occur simultaneously is a golden opportunity for any enterprise. If the simultaneous occurrence of the two objects is advantageous to the enterprise, then the enterprise need only expend resources to cause one of the two objects. The enterprise does not need to expend the resources to cause both to occur. If the second object is going to simultaneously occur with the first object, then any incremental expense or opportunity missed to cause the second object to occur is unnecessary. Instead, the enterprise should expend its resources to make the first object occur, and then let the second object occur simultaneously with the first object. In other words, if it’s good, and it will happen, let it happen.

If, however, the simultaneous occurrence of the two objects in an Itemset is disadvantageous to the enterprise, the enterprise is equipped with the knowledge that a disadvantageous scenario has a strong tendency to occur. The enterprise can then choose to either prevent the simultaneous occurrence of objects or leverage the simultaneous occurrence of objects. If the enterprise is able to prevent the second object from occurring, but at an incremental cost, then the enterprise can choose to either expend the resources necessary to prevent the second object from occurring simultaneously with the first object or the enterprise can choose to absorb the simultaneous occurrence of the second object. The question is, Which has the higher cost, the prevention or the problem? Problems do exist that cost more than their prevention. So, in the case of a disadvantageous Complement, an action can be to either tolerate the co-occurrence of the objects in an Itemset or prevent the co-occurrence of the objects in an Itemset.

Another action to be taken in the case of a disadvantageous Complement is to leverage one of the two objects. An example of the leverage of a disadvantageous Complement is a tariff, that is, a tax on imported products. A tariff is levied on imported products to increase the price of those products when they sell in a retail store. In this situation, the two objects are (1) imported products and (2) reduced sales of domestic products and the Itemset is a fiscal period (e.g., fiscal quarter, fiscal year), which is measured by the GDP of the fiscal period. The disadvantageous Complement is caused when an imported, rather than domestic, product sells in the retail market. The domestic government prefers that domestic products sell as much as possible. A tariff works to prevent the presence of imported product in retail stores, which is expected to cause the sale of domestic products to increase. The use of a tariff also has the added benefit of increasing the revenues of the domestic government.

In an enterprise disadvantageous Complements will occur. If the disadvantageous Complement cannot be prevented, and the cost is intolerably high, then it should be leveraged. Like the tariff, the enterprise can respond to the disadvantageous Complement by modifying the situation to generate, or minimize the disadvantage, as much as possible. Finding the leverage to apply in such a situation may require creativity and ingenuity. The actionable knowledge is the awareness that the Complement is disadvantageous to the enterprise, and that the cost of preventing it is too high, and that it should be leveraged in some way.

Substitutes

Substitutes are two objects in an Itemset that have a strong affinity to not occur in the same Itemset, that is, they avoid each other. The knowledge that the two objects have a strong tendency to avoid each other is another opportunity for the enterprise. Knowing that two objects avoid each other, the enterprise can choose to let the two objects always remain separate, or try to join them together in an Itemset.

If the co-occurrence of two objects is advantageous to the enterprise, yet expensive to facilitate, then the question is, Which is more expensive, the missed opportunity when the two objects avoid each other or the cost of facilitating the co-occurrence of the two objects? This may be a quantitative question that can be answered in fiscal numbers, or this may be a value judgment that can only be measured in the intangible asset of the enterprise. Either way, the awareness of the two objects that are Substitutes, and the opportunity it creates, is an actionable knowledge delivered by Market Basket Analysis.

The more ubiquitously understood manifestation of Substitutes is cannibalism. This occurs when an action that increases the occurrence of object A also decreases the occurrence of object B. This is called cannibalism because the enterprise eats away from one part of itself to feed another part of itself. The eating away is the decreased occurrence of object B. The feeding is the increased occurrence of object A. The awareness of two Substitutes (e.g., objects A and B) helps the enterprise understand the consequences of its own actions. This awareness is the opportunity to choose between the two options. If the advantage of increased occurrences of object A compensates for the decreased occurrences of object B, then the enterprise can tolerate the increased occurrence of object A. If, however, the advantage of increased occurrences of object A is not sufficient to compensate for the decreased occurrences of object B, then the enterprise can choose to take no actions on objects A and B, allowing them to achieve their natural equilibrium.

Independents

An Independent object is a single object that has no strong affinity to co-occur or avoid any other object in an Itemset. An Independent object occurs in an equilibrium proportion of Itemsets, regardless of what else is in the Itemsets. An Independent object is going to occur as often as it occurs because, for some reason that may or may not be known, it is natural for that Independent object to occur. The knowledge that an object naturally occurs in Itemsets with, and without, the intervention of the enterprise is yet one more opportunity discovered by Market Basket Analysis. If an Independent object is advantageous to the enterprise, the enterprise cannot increase the occurrence of the Independent object by increasing the occurrence of a correlating object because there is no correlating object. The enterprise can, however, increase the opportunity for the Independent object to occur.

A good example of the increased opportunity of an Independent object to naturally occur is all the “impulse buy” products conspicuously displayed immediately in front of every cash register in every grocery store. Impulse buying activity occurs because...well, because the impulse to buy candy bars and soft drinks naturally occurs. Usually the impulse buyer is a child. A parent has been shopping for groceries with a child in the grocery cart. Throughout the entire store the child has been asking for one thing, wanting another thing, grabbing something else, and on and on it goes...until they get to the cash register. At the cash register the child finds a cornucopia of candy and goes berserk. At that moment, the parent can buy two minutes of peace and quiet for the price of a candy bar. Neither the parent nor the child equates the candy bar with the contents of the grocery cart. No, instead the candy bar is purchased simply to appease the child. That is a naturally occurring Independent object.

If, however, the occurrence of an Independent object is disadvantageous to the enterprise, then the enterprise can attempt to reduce the opportunities for that Independent object to occur. A good example of reduced opportunities is safety equipment. Accidents naturally occur. Rather than present a naturally occurring accident with a soft piece of human flesh to rip, cut, smash, or tear, we wear safety equipment. A carpenter wears safety goggles to reduce the opportunity for wood chips to fly into an eyeball and cause blindness. Wood chips occur regardless of the kind of wood being cut, and the equipment performing the cut, and the environment surrounding the cut, and...well, wood chips just have a natural tendency to fly. Rather than present two eyeballs as an opportunity for an accident, a carpenter wears safety goggles. A butcher wears safety gloves to reduce the opportunities to cut off a finger. A construction worker wears a hard hat to reduce the opportunities to catch a falling bolt with a skull. These examples show how an enterprise can respond to an Independent object by reducing the opportunity for that Independent object to occur.

An enterprise cannot discourage the occurrence of a disadvantageous Independent by inhibiting a strongly correlated object from occurring because no strongly correlated object exists. In such cases the enterprise is left to deal directly with the Independent object. The enterprise can choose to either discourage the occurrence of the Independent object by removing the opportunities for it to occur, or the enterprise can attempt to shield itself from the effects of the Independent object. Despite how bad this may seem, the ROI in this situation is the awareness that the enterprise is dealing directly with an Independent object, that only a direct approach will work because there is no correlating object to attack. Instead, the enterprise can be aware that an end-run gambit is a waste of time and resources, and that a direct approach is necessary.

KPIs

Complement objects, Substitute objects, and Independent objects are the actionable knowledge most frequently associated with Market Basket Analysis. The discovery of such objects and their affinities provides insight into the equilibriums within and around the enterprise. These affinities demonstrate the equilibrium between objects. For example, four quarts of motor oil and one oil filter would be a natural Itemset for an oil change. For that Itemset, the equilibrium between quarts of motor oil and oil filters is four to one—that is, four quarts of oil to one oil filter.

Some of the object affinities will probably be key indicators of the life and health of the enterprise. Such indicators may be able to predict the upcoming health of the enterprise. Others may only confirm the current state of the enterprise. Either way, the KPIs can be predefined and executed daily in a batch environment. That way, the KPIs can be monitored passively by reviewing the output when an analyst is available to review the results of the Market Basket Reporting.

Market Basket Reporting operates in a batch environment so that it can monitor KPIs with no manual intervention. The KPIs can themselves be monitored to raise awareness when the affinity, or lack of affinity, of an object or group of objects changes. The problem may be caused by misplaced product or incorrectly labeled product, expired product or too much product, or any of any almost infinite number of causes that could influence affinities within the enterprise. The causes of a fluctuation in the affinities of an enterprise, however, will never be found unless someone knows to look for them. No one will know to look for those affinities within and around the enterprise until an automated KPI notices that something has changed.

That is the final ROI of Market Basket Analysis—affinity KPIs in Market Basket Reporting. Even if no actions arise from the Market Basket Analysis, the enterprise will be able to monitor via automated jobs the affinities between objects inside and outside the enterprise.

ROI

Market Basket Analysis provides business analysts the opportunity to dig into the data of the enterprise, to get data under their fingernails, to really get hands-on and hands-in the data. The problem with many BI Reporting tools is that they are well packaged and GUI-operated. The BI Reporting tool actually insulates a business analyst from the data. Market Basket Analysis, however, draws a business analyst into the data to experience the data.

Market Basket Analysis also discovers affinities and relationships between the elements of the enterprise. The actions of the enterprise occur in units of work known as Itemsets. The elements of the enterprise appear within those units of work, that is, the Itemsets. The proportions and affinities for those enterprise elements to co-occur, never occur, or independently occur within an Itemset are found via Market Basket Analysis. Each of these relationships presents an opportunity to the enterprise. Some of these relationships may be so key to the success of the enterprise that Market Basket Reporting may monitor them via automation.

These are the deliverables of Market Basket Analysis. Together they constitute the ROI of Market Basket Analysis and Market Basket Reporting.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.220.254.4