Sunday 5 April 2015

An Overview into Business Analytics Process

Business Analytics Process:

The complete business analytic process involves the three major component steps applied sequentially to a source of data (see Figure). The outcome of the business analytic process must relate to business and seek to improve business performance in some way.



                               Figure  Business analytic process




The logic of the BA process in Figure 1.1 is initially based on a question: What valuable or problem-solving information is locked up in the sources of data that an organization has available?

At each of the three steps that make up the BA process,
additional questions need to be answered, as shown in Figure above Answering all these questions requires mining the information out of the data via the three steps of analysis that comprise the BA process.

The analogy of digging in a mine is appropriate for the BA process because finding new, unique, and valuable information that can lead to a successful strategy is just as good as finding gold in a mine.

SAS, a major analytic BUSINESS ANALYTICS PRINCIPLES, CONCEPTS, AND APPLICATIONS corporation (www.sas.com), actually has a step in its BA process, Query Drilldown, which refers to the mining effort of questioning and finding answers to pull up useful information in the BA analysis.


Many firms routinely undertake BA to solve specific problems, while other firms undertake BA to explore and discover new knowledge to guide organizational planning and decision-making to improve business performance.


The size of some data sources can be unmanageable, overly complex, and generally confusing. Sorting out data and trying to make sense of its informational value requires the application of descriptive analytics as a first step in the BA process.

One might begin simply by sorting the data into groups using the four possible classifications presented in Table below. Also, incorporating some of the data into spreadsheets like Excel and preparing cross tabulations and contingency tables are means of restricting the data into a more manageable data structure.

Simple measures of central tendency and dispersion might be computed to try to capture possible opportunities for business improvement. Other descriptive analytic summarization methods, including charting, plotting, and graphing, can help decision makers visualize the data to better
understand content opportunities.

Types of Data Measurement Classification Scales

From Step 1 in the Descriptive Analytic analysis (see Figure 1.1), some patterns or variables of business behavior should be identified representing targets of business opportunities and possible (but not yet defined) future trend behavior.

Additional effort (more mining) might be required, such as the generation of detailed statistical reports narrowly focused on the data related to targets of business opportunities to explain what is taking place in the data (what happened in the past).

This is like a statistical search for predictive variables in data that may lead to patterns of behavior a firm might take advantage of if the patterns of behavior occur in the future.
                   
                            For example, a firm might find in its general sales information that during economic downtimes, certain products are sold to customers of a particular income level if certain advertising is undertaken. The sales, customers, and advertising variables may be in the form of any
of the measurable scales for data in Table 1.4, but they have to meet the three conditions of BA previously mentioned: clear relevancy to business, an implementable resulting insight, and performance and value measurement capabilities.


To determine whether observed trends and behavior found in the relationships of the descriptive analysis of Step 1 actually exist or hold true and can be used to forecast or predict the future, more advanced analysis is undertaken in Step 2, Predictive Analytic analysis, of the BA process.

There are many methods that can be used in this step
of the BA process. A commonly used methodology is multiple regression.  This methodology is ideal for establishing whether a statistical relationship exists between the predictive variables found in the descriptive
analysis.

The relationship might be to show that a dependent variable is predictively
associated with business value or performance of some kind.

For example, a firm might want to determine which of several promotion efforts (independent variables measured and represented in the model by dollars in TV ads, radio ads, personal selling, and/or magazine ads) is most efficient in generating customer sale dollars (the dependent variable and a measure of business performance).

Care would have to be taken to ensure the multiple regression model was used in a valid and reliable way,which is why ANOVA and other statistical confirmatory analyses are used to support the model development. Exploring a database using advanced statistical procedures to verify and confirm the best predictive variables is an important part of this step in
the BA process. This answers the questions of what is currently happening and why it happened between the variables in the model.


A single or multiple regression model can often forecast a trend line into the future. When regression is not practical, other forecasting methods (exponential smoothing, smoothing averages) can be applied as predictive analytics to develop needed forecasts of business trends.


The identification of future trends is the main output of Step 2 and the predictive analytics used to find them. This helps answer the question of what will happen.

If a firm knows where the future lies by forecasting trends as they would in Step 2 of the BA process, it can then take advantage of any possible opportunities predicted in that future state.

In Step 3, Prescriptive Analytics analysis, operations research
methodologies can be used to optimally allocate a firm’s limited resources to take best advantage of the opportunities it found in the predicted future trends. Limits on human, technology, and financial resources prevent any firm from going after allopportunities they may have available at any one time. Using prescriptive analytics allows the firm to allocate limited resources to optimally achieve objectives as fullyas possible.


For example, linear programming (a constrained optimization method-
ology) has been used to maximize the profit in the design of supply chains

This third step in the BA process answers the question of how best to allocate and manage decision-making in the future.

In summary, the three major components of descriptive, predictive, and prescriptive analytics arranged as steps in the BA process can help a firm find opportunities in data, predict trends that forecast future opportunities, and aid in selecting a course of action that optimizes the firm’s allocation of resources to maximize value and performance.

3 comments:

  1. A business manager because of data overwhelmed reported to the Board of Directors without reviewing its historical sales for the past five years that the business will eventually hits its return of investment in three years. What would be the consequences of his action?

    ReplyDelete