Tag Archives: Business Intelligence & DW Services

Worst Practices while deploying a Predictive Model Contd..

27 Jul

In my previous article we saw what are all the worst approaches followed by organizations while deploying a Predictive analytic project. This article will provide you information on how to deploy successful predictive analytics model.

Successful Predictive Analytics Deployment

Now that we’ve discussed the wrong approach to predictive analytics, let’s look at some of the critical steps that must be taken to ensure its success.

Understanding the Business Need

As mentioned earlier, it is crucial for companies to identify the drivers behind the predictive analytics project in the early planning stages. Once an organization defines what new information it is trying to uncover, what new facts it wants to learn, or what business initiatives need to be enhanced, it can build models and deploy results accordingly.

 Understanding the Data

A thorough collection and exploration of the data should be performed. This enables those who are building the application to get familiar with the information at hand, so they can identify quality issues, glean initial insight, or detect relevant subsets that can be used to form hypotheses suggested by the experts for hidden information. This also ensures that the available data will address the business objective.

 Preparing the Data

To get data ready, IT organizations must select tables, records, and attributes from various sources across the business. Data must be transformed, merged, aggregated, derived, sampled, and weighed. It is then cleansed and enhanced to optimize results. These steps may need to be performed multiple times in order to make data truly ready for the modeling tool.


Once information has been prepared, various modeling techniques should be selected and applied, and their parameters calibrated to optimal values. Choice of the modeling technique is determined by the underlying data characteristics or by the desired form of the model for scoring. In other words, some techniques may explain the underlying patterns in data better than others, and therefore, the outcomes of various modeling methods must be compared. A decision tree would also be used if it were deemed important to have a set of rules as the scoring model, which is very easy to interpret. Several techniques can be applied to the same scenario to produce results from multiple perspectives.


Thorough assessments should be conducted from two unique perspectives: a technical/data approach often performed by statisticians, and a business approach, which gathers feedback from the business issue owners and end users. This often leads to changes in the model; but while the technical/data evaluation is important, it should not be so stringent that it significantly delays implementation and use of the model. The model’s business value should be the primary test.


Deployment, the final step, can mean one of two things: the generation of a single report for analysis, or the implementation of a repeatable data mining or scoring application. The goal here is to create a reusable application that can be used to generate predictions for large volumes of current data. The results are then distributed to front-line workers; in a format they are comfortable with – reports, dashboards, maps, or graphics – to enable proactive decision-making.

Avoiding common worst practices and adopting best ones, are the key to successfully implementing and using predictive analytics. By knowing what pitfalls to avoid, and what important steps need to be taken, companies can accelerate implementation, maximize user adoption, and realize substantial ROI.

About the Author

Shaughn is an industry analyst for business intelligence. For over ten years, he has assisted clients in business systems analysis, software selection and implementation of enterprise applications. Shaughn is the channel expert for BI for the small and Mid-Market segments at ZSL and conducts research of leading technologies, products and vendors in business intelligence, marketing performance management, master data management, and unstructured data. He can be reached at shaughnk@zslinc.com. And please visit Shaughn’s blog atzslbiservices.wordpress.com


Worst Practices while deploying a Predictive Model

23 Jul

With the inception of predictive analytics the reactive decision making has been proven unsuccessful. Organizations have started to take more proactive approach by using predictive analytics to make critical decisions to uncover a problem or an opportunity. Predictive analytics not only enables the organization to determine the forecast of the problems and opportunities but also keeping the bad alternatives futures from happening. Hence companies can foresee their problems well in advance and neutralize them at a preliminary level. According to research from IDC, organizations using predictive analytics solutions generate an average return on investment of 145 percent. Regrettably, many companies don’t implement it correctly and fail to achieve these desired results

Common Worst Practices while deploying a Predictive Model

As beneficial as predictive analytics can be to an organization, implementation and deployment projects often fall apart or fail to get underway due to common poor practices, procedures, and decisions, such as:

  •  Failing to focus on a specific business initiative that predictive analytics can enhance
  • Ignoring crucial steps, such as data preparation and access, or deployment of results
  • Spending too much time evaluating models
  • Investing in tools that yield little or no returns
  • Failing to operationalize findings

Failing to Focus on a Specific Business Initiative

Mostly, companies begin building their predictive application with loose goals in mind and trying to discover something critical that they don’t know. Substantially they end up in trying various analytical models and forces developers into a never-ending cycle of definition, evaluation, and fine-tuning. The best approach and successful predictive analytics endeavor for an organization is to define the project objectives and requirements that will satisfy their business needs. Predictive analytics will be more effective when it is used to identify expected cases and to apply insight from specific patterns and trends existing in the data to these new cases.

Ignoring Critical Steps

One of the frequently confronted failures in deploying predictive analytics is ignoring critical steps. Many companies while deploying the predictive model many organizations take major efforts to look only at the important steps and often ignores the data preparation and access process. In reality, this should be the activity to which the most effort is devoted. In fact, data preparation typically accounts for approximately 60 to 80 percent of the cost of a predictive modeling initiative.

Spending Too Much Time on Model Evaluation

Predictive models must be evaluated to determine how accurately they predict patterns. Primarily, they must be measured from a data perspective and then they must be assessed from a business perspective to ensure they will meet end-user expectations and requirements. Accuracy comes at a cost, and companies must decide how precise they need their models to be. Companies often tend to over-evaluate. They add new variables to the models to increase their accuracy, which often requires rebuilding. They test and retest the models endlessly, spending tremendous amounts of time making continuous refinements because they are not quite perfect. This delays deployment, and prevents the organization from recognizing the substantial advantages that predictive analytics can offer.

There is a tradeoff to be made between time to market, usefulness, and accuracy. Companies must sacrifice some precision in order to accelerate deployment. Or they must halt implementation and rollout – and delay the realization of benefits – to achieve higher levels of accuracy. The truth is, if a model is better than the current approach to forward-looking decision-making (and it likely is), then it should be considered ready for deployment. No model will ever be perfect, because shifting business strategies and evolving end-user needs require continuous modifications.

Investing Heavily in Analytic Tools With Little or No Return

There are various common mistakes made when it comes to investing in predictive analytics tools. Companies frequently end up in buying expensive, complex analytical tools that is way too sophisticated for their needs. These solutions not only come with very high price tags, but also they are typically hard to deploy and difficult to use by anyone other than statisticians and experienced analysts. As a result, they likely contain features and functions that will never be used. All of these factors will significantly lessen the ROI of an organization.

Failing to Operationalize

 For predictive analytics to succeed, it must be embedded into applications that are leveraged whenever users need to make decisions. If an application is not built and deployed, the effort devoted to creating a model will do nothing to enhance forward-looking decision-making. The results will remain in a document that few people will refer to in support of their daily activities. However, when a model is incorporated into a dashboard or reporting environment, the results will be readily accessible to end users, whenever they need them. This will help to create an analytics-driven culture across the entire business.

How to avoiding Worst Practices

The worst practices we have highlighted don’t have to derail a predictive analytics initiative. In fact, they can all be easily avoided by:

Driving ROI

When planning a predictive application, companies must consider total cost of ownership and anticipated return, to ensure that maximum value is achieved.

Focusing on Bottom-Line Initiatives

Create models that will provide forward-looking intelligence to help solve specific problems (i.e., minimizing customer churn by uncovering the factors that contribute to it) or help to achieve certain goals (i.e., increasing up-sell and cross-sell revenue by understanding what new products customers are most likely to buy).

 Preparing Data

Guarantee the most accurate possible results by ensuring that disparate data is easily and properly accessed and cleansed before the models are created and applied.

 Evaluate the Model, Without Over-Evaluating

The model must be tested to ensure that it provides better decision-making capabilities over current analysis methods. But over-evaluation can delay deployment and hinder ROI. It simply needs to be assessed until it is determined that it will provide value. At that point, it can be implemented. The statistical properties of the finished model are secondary to the value it brings to the business.

 Deploying the Results

The insight provided by predictive analysis efforts must be shared with key stakeholders across and beyond the organization. For example, a bank that has predicted which customers are most likely to churn should disseminate that information to all those who interact with those clients, including call center staff and branch personnel. That way, everyone can contribute to correcting the problem and ensure that countermeasures are being implemented.

 We will see how to adopt best practices and the key to successfully implementing and using predictive analytics in the next article

About the Author

Shaughn is an industry analyst for business intelligence. For over ten years, he has assisted clients in business systems analysis, software selection and implementation of enterprise applications. Shaughn is the channel expert for BI for the small and Mid-Market segments at ZSL and conducts research of leading technologies, products and vendors in business intelligence, marketing performance management, master data management, and unstructured data. He can be reached at shaughnk@zslinc.com. And please visit Shaughn’s blog at zslbiservices.wordpress.com

How Healthcare Organizations gets profited by BI?

7 Mar

How Healthcare Organizations gets benefited by BII have seen many hospital administrators who have been using the Healthcare analytics for creating quality reports and capture better revenue. These administrators are working in teams with their IT department and other hospital staff in determining what to spend, and where to spend it, as BI takes on a greater role in health care. Like many industries, health care seeks ways to improve efficiency and reduce costs. Hospitals are turning to analytical tools to help accomplish these goals and to create better clinical outcomes for patients. On the other hand hospitals equally are just getting started or are planning to implement data analytics.

Healthcare industry as such is full of modern challenges in data quality and its distribution and hence indeed, BI is so important to this industry for not only analyzing the data but also to know how the results of these analyses are related to everyday business decision.

 Issues faced by Healthcare Industry with respect to BI

  • Analyses that often leads to organizational confusions and loss of business opportunities due to inconsistent data definitions across multiple and heterogeneous data systems
  • Individual departments not receiving timely analytic support create their own internal databases and approaches, exacerbating the issue across healthcare systems. These shadow systems generate unnecessary costs and the outputs lack data quality, security, and consistency, thus the need for a dependable source of experienced support.
  • There is a no common understanding or agreement on definitions or consistent data flow. Different data bases display information based on different sets of qualification criteria, highlighting the fact that there is no consistent definition or standard for how information is extracted, viewed and analyzed.
  • Lack of common agreement on the value of each data field because each data element is defined and used differently in each area of the organization
  • Inconsistent outputs and highly variable interpretations due to data reconciliation is another primary issue. There is no central group chartered to pull the data when requested. Planning, Finance, Quality, Marketing, Med Staff, or others may be contacted
  • The experience set of the analysts that receive business requests and pull the data do not have the deep insight required to interpret business drivers behind the data requests.

BI and Lowered Healthcare Cost

  • Helps you to meet the rising demand for achieving competitive advantage
  • Healthcare organizations improve patient care by driving better decision making throughout the organization.
  • Helps you to have a clear insight into clinical data and hence clinical decisions will be evidence based.
  • Helps to supervise and endeavor over inflating costs and operational processes, and increase the quality of care and the financial health of the organization.
  • Helps to improve patient safety and clinical quality by providing reports and analytics to give insights into business operations.

Use of Key Performance Indicators (KPIs) in Healthcare

With the use of the KPIs, Hospital Performance can be monitored and analyzed. KPIs on accounts receivable, operating profit and expenditure involved in development of latest medicines and amenities help in evaluating the fiscal advancement and performance of the health care facilities. It helps to mine patient data for clinical patterns and treatment protocols and track the cost of supplies to the cost of procedures. It helps to generate clinical and service line reporting and analyze potential contracts while negotiating with payers. Thus using KPIs BI permits management to have a luculent idea of events occurring in a hospital or in multiple group hospitals.

Improved Business Intelligence efficiency on Workflow Automation

  • To avoid repetition of errors in medical field, workflow management must have integrity.
  • Supreme compliance must be attained to a great extent so that progress and good management will go hand in hand.
  • This will bring to a successful conclusion that should be confirmed.
  • It also assists flexibility in the business process by advancing with customer needs and competitions.
  • Medical Assistants are heavily involved in making sure data is properly recorded and utilized.
  • Patients would ensure their confidence in a medical institution when they see that they have the right medical assistants who can give them satisfaction.

Is your organization looking for a BI vendor? Have your organization chosen the right tool? Just a BI add-on to be integrated to your existing EHR?

Email me your interests Shaughn Knight, AVP – Business Development and Inside Sales Operations.

“If you wish to avail my blog article please click the follow button at the bottom of this blog”