Archive

Archive for January, 2009

Editorial – Jan 2009

January 29th, 2009

Welcome to the January 2009 edition of our newsletter- BI Insight!

In this month’s newsletter we have highlighted a research paper that talks about the key factors in “Supply chain usage in BI”. The paper also analyzes the role of supply chain to reduce operating costs and how it affects other business outcomes.The second article for this issue is “Systech Corner” which features an informal conversation with our own people at Systech about “Where is BI heading in 2009?”

And apart from these we also have included BI news articles from reputed sources. We hope you find the newsletter interesting and informative. Please invite your peers to visit us and subscribe to us.

Before you go ahead let me take a moment to wish you all a rewarding and joyous new year on behalf of our team at BI Insight.

Enjoy reading!

Warm regards,

Editor

Editor's Note

Industry News – Jan 2009

January 29th, 2009

Talend and Systech come together to present “Talend Open Studio Discovery Roadshow”

Systech Solutions Inc. hosted “Talend Open Studio discovery show”, a training session in Los Angeles at their Head Office in Glendale on Tuesday, January 27th 2009. Talend clients along with few of the consultants from Systech attended this training. During the 3 hours the trainees received a complimentary training on Talend Open Studio. The technical training session demonstrated how to use Talend’s technology and provided hands on training on Talend. The Talend Representatives were Jonathan Andry and Scott Ruby. This is a part of Systech’s commitment to build strong partnerships. Systech is a platinum partner of Talend. The Talend Roadshow is a series of free technical workshops which are taking place in a number of cities in the US.

eHarmony and Netezza get matched for business analytics

Netezza Corporation (NYSE Arca: NZ), the global leader in data warehouse and analytic appliances, today announced that eHarmony has deployed Netezza as its enterprise data warehouse to analyze large volumes of member data to better understand how its customers interact with its site. The Company chose Netezza for its scalability, low cost of ownership, proven track record with online businesses and fast time to value on key business intelligence (BI) initiatives.

eHarmony needed a data warehouse environment that could scale as its business and user base expand quickly, both domestically and internationally. Its previous system had trouble keeping pace with the Company’s rapidly growing volumes of data. With Netezza, eHarmony can extract and analyze user data much faster, more easily, and more economically than before.

“Sophisticated online organizations like eHarmony are increasingly leveraging terabyte-scale data analysis to maximize user engagement and create competitive advantage,” said Brad Terrell, vice president of digital media at Netezza. “By marrying user behavior and demographic data with additional outcomes, experience and third-party data, eHarmony gains a strategic advantage that will provide them with unprecedented web analytics flexibility and insight.”

The Netezza data warehouse appliance is built specifically to analyze terabytes of detailed data significantly faster than existing data warehouse options, at a much lower total cost of ownership. It stores, filters and processes terabytes of records within a single unit, analyzing only the relevant information for each query. Netezza has placed the CPU power next to the data, allowing its appliances to speed through processes that would occupy most data warehouse systems for hours, or even days, thereby enabling dramatic increases in productivity across organizations like eHarmony.

Netezza Corporation has been positioned by Gartner, Inc. in the Leaders’ quadrant in the 2008 Data Warehouse Database Management Systems Magic Quadrant report released on December 23, 2008 and authored by Donald Feinberg and Mark A. Beyer. Netezza was also awarded the Editor’s Choice Award by the InformationWeek Business Technology Network’s Intelligent Enterprise and one of Netezza’s customers, Ross Stores, was honored as part of the InfoWorld 100 for its joint data warehouse solution with Netezza and MicroStrategy.

Talend Secures $12 Million in Funding to Fuel Continued Worldwide Growth and Momentum

Talend, the first provider of open source data integration software, today announced it has secured $12 million in Series C financing to help fuel further worldwide growth and company expansion. The funding round is being led by Balderton Capital, an early investor in MySQL, and existing investor AGF Private Equity bringing Talend’s total funding to more than $20 million.

Balderton General Partner Bernard Liautaud, the founder, CEO and Chairman of Business Objects for 18 years up until its eventual sale to SAP for $6.7 billion, will join Talend’s board of directors.

During 2008, Talend moved from being a disruptive innovator to an open source data integration leader. The popularity of Talend Open Studio, the Company’s flagship open source data integration solution, has risen sharply since its introduction more than two years ago with more than 3.3 million lifetime downloads. In the past twelve months alone, Talend’s paying customer base increased by more than 300 percent, steadily taking market share away from proprietary data integration tools such as Informatica PowerCenter or IBM WebSphere DataStage, and confirming the suitability and scalability of its solutions for enterprise projects of large and well-known companies.

Leveraging the additional funding, Talend will expand global operations into key markets in the Americas, EMEA and Asia-Pacific, targeting large enterprises and partners that are looking at cost-effective alternatives to proprietary integration suites in a time of shrinking budgets and slimming services margins. The company will accelerate its growth, reinforcing its position as a key player in a market still dominated by a handful of proprietary vendors. Talend will also unveil new products in 2009 to help solve emerging integration requirements stemming from merger and acquisition activity as struggling companies are acquired.

“Over the past 12 months we have seen hundreds of new customers and dozens of new partners embrace our open source data integration and data quality technologies as the foundation for enterprise projects,” said Fabrice Bonan, COO and co-founder of Talend. “The open source model is a unique driver of innovation, enabling Talend to rely on a fast-expanding and vibrant community to accelerate its development cycles. The additional funding will allow us to expand our development teams, broaden the functional coverage of our technologies and provide more advanced products and features to our community and customers.”

Jaspersoft and Hyperic Provide First Systems Intelligence Platform for Business-Level Analysis

Jaspersoft, provider of the world’s most widely used business intelligence (BI) software, today announced that JasperServer Professional Edition is being embedded in the new Hyperic Operations IQ.

Hyperic Operations IQ, announced today, provides advanced business intelligence for IT and web operations teams using Jaspersoft’s BI software. This partnership, for the first time, provides a business user view into critical application performance metrics and service levels.

Jaspersoft and Hyperic, the leading provider of web application performance monitoring software for the datacenter and the cloud, have worked closely together since 2007 when Hyperic originally delivered integrated reporting capabilities in Hyperic HQ using the Community Edition of Jaspersoft’s JasperReports embeddable reporting product.

Today’s news represents the natural evolution of Jaspersoft’s strategic partnerships with the technology industry’s leading companies. The deeper functionality available in Jaspersoft’s Professional Edition enables companies like Hyperic to deliver yet another level of analysis to their customers.

“Hyperic’s advanced web application performance monitoring capabilities demand simple but powerful analysis functionality that can only be achieved with the customization and ease-of-use available in the professional version of our server-based, BI software,” said Brian Gentile, CEO of Jaspersoft. “Extending our partnership beyond our original collaboration – to a commercial relationship that provides Hyperic’s customers with access to the full suite of Jaspersoft’s BI software – will help meet the new demands of today’s besieged CIO.”

“Our choice to use Jaspersoft for Hyperic Operations IQ was an easy one. Jaspersoft’s BI software is used by millions of organizations worldwide. This is a proven technology with a loyal following that delivers the depth of visibility and analytics capabilities that our customers require,” said Javier Soltero, CEO of Hyperic.

Hyperic Operations IQ uses JasperServer Pro to provide customers with advanced reporting and analysis infrastructure instead of a limited handful of reports. The JasperServer Pro architecture allows Hyperic to customize and replace functionality as needed, and to create a new data source. These important features bring a new level of data integration and security to Hyperic’s solution. Furthermore, the new Systems Intelligence Platform brings customization and automation to business executives through easy-to-navigate dashboard integration and ad-hoc report creation using Web 2.0 tools available from Jaspersoft.

Industry News , , , , , ,

Where is BI heading in 2009?

January 29th, 2009

“When our economy is in a recession and most companies are looking to contain costs and run businesses effectively BI would definitely provides competitive edge. At the same time companies are desperate to cut back their investments in IT. This has created an interesting dynamic as to whether Bi will grow or shrink in this environment.”

No Nostradamus could give a pristine answer to a question like this one. But, at the wake of deepening recession, the time has arrived for Business Intelligence to share its services, to bring together all the resources, eliminate waste and increase the flow of information.

If you had been inspecting BI under a microscope in the recent past you would have noticed that the BI sector has been bustling with activity. On one side you see the substantial BI pure-play vendors like Hyperion, Business Objects, and Cognos being taken over by larger, non-BI vendors indicating that BI has become a strategic application and complementary to ERP implementations. On the other side you notice emerging trends in BI, like the development of new DW appliances, upcoming real time BI, Operational BI, MDM etc.

We at BI Insight thought it would be interesting to see what our own people at Systech thought about the future of BI in 2009 and their perspective of BI’s survival in times of economic doom-gloom. People that we spoke to were cautiously optimistic about BI and its potential in helping business under current market conditions. Only time can tell, how much of this optimism is proven right in 2009.

Aditya Gollapudi, Sr. Technical Lead.

Analytics is here to stay in business. Better reporting and analysis are indispensable in today’s business for finding hidden profits and increasing revenue. However, at times like this, businesses try to cut costs and do their analysis manually. A manual approach eventually leads to failure, as it is more expensive and cumbersome. This could be one of the fatal mistakes that businesses could make. The maturity of the BI industry is put to test now, as companies decide what to keep and what to discard so that they remain competitive. The fact that companies are running BI with improvements in speed and efficiency in real time is a testament to BI’s capability. So to answer your question, assuming that companies are wise – BI is here to stay and grow.

Anbu Swaminathan, Engagement Lead.

I see BI moving towards real-time data warehousing. Most businesses depend on analytics reporting at corporate level to make business decisions. Real time BI will co-exist with traditional data warehousing model in Financial Sector and Banking. In banking, transactions happen 24/7, and there is a constant challenge on how to report these live transactions. Traditional data warehousing would not satisfy these challenges.

Ashish Parikh, Chief Financial Officer.

I see BI go upwards and onwards. Industry specific BI solutions will emerge. New laws and new technology will arise. The US has to revamp Health Care and Financial Services industries, as stated by our President. And I believe BI would play a major role in this process. I also see lots of changes in BI technology as demanded by business. We need the best information to understand “what-if” scenarios for the events that have not occurred in the last 70 years. We should be capable of giving answers fast. Time has arrived for US to embrace Open Source Technology as it would make technology affordable and reachable to small and mid-cap companies.

Ramki Ranganathan, Sr. Architect.

Since its beginning, the role of BI was to provide information to the management so that they can get a clear insight into their business. I don’t think there is going to be any change in the core purpose of BI. But the way we implement BI might change in 2009. For example, before we had DW appliances like Netezza, executives were ready to wait for a couple of weeks or even more for an analyst to provide them with useful information from the huge amounts of data. All that is changing now. Real-time operational reporting has changed the face of BI. We have hardware appliances and new software technologies that help the BI team to provide meaningful information to the management at a faster pace. So the speed at which we provide information might change in 2009.

Systech for example has been there in the BI field for past 16 years. If we compare data warehousing 16 years back and right now, there isn’t a tremendous difference in its basics. Having said that, today every organization knows what BI is and what its role is in the business. How it’s going to improve the economy really depends on what kind of information the executives are looking for. If you know what you want, you can get it from BI. On the other hand, if you don’t know what you want no matter how fast your implementation is or how advanced your technology is, it is not going to matter. I believe the way business uses BI might change however, the fundamentals of BI will remain the same.

Shabnam, Sales Executive.

With today’s economic recession, a lot of companies look at cutting costs to save on multiple fronts. All the businesses are postponing spending money in Supply Chain, inventories, in IT etc. But on the other hand, in order to stay competitive and profitable you need BI to give you insight into your business and competitive edge. So in that way you need to invest in BI more than ever to know where your profit centers are. Solutions like Profit/SKU from Pi Solutions or say Smart I, that gives you an entire BI appliance running natively on an IBM machine help you save money and increase profits. Those are such viable options now because you get to invest in BI without spending huge amounts of money. The companies that support their business initiatives with appropriate BI solutions will definitely come out ahead in this economy.

Suresh Kumar, Manager, Finance.

BI is one of the key factors in finding profits for any industry. Today companies have realized the importance of analytics in the measurement and improvement of their performance. BI has made it easier to analyze figures at the core of the business and take guesswork out of decision making. At bad economic times like these, it could help turn companies around and help an industry grow positively. I see BI heading towards greater acceptance. If I owed a business I would count on BI to find me profits.

Systech Corner ,

BI Usage in Supply Chain

January 29th, 2009

Abstract

This paper considers the key factors regarding Supply Chain Usage in Business Intelligence. The paper analyses the role of Supply chain to reduce operating costs and be more responsive to customers. The goal of Supply Chain Intelligence is to enhance an executive’s ability to reason through business outcomes. The paper outlines the conceptual frame work, needs, challenges and software requirements of a Supply Chain Model.

Introduction

A supply chain is a system of organizations, people, technology, activities, information and resources involved in moving a product or service from supplier to customer. It is also known as, logistics network, or supply network. Supply chain activities transform natural resources, raw materials and components into a finished product that is eventually delivered to the end customer. In sophisticated supply chain systems, used products may re-enter the supply chain at any point where residual value is recyclable. Supply chains link value chains.

A supply chain can also be used to show how several processes supply to one another. Thus the term supply chain can also be applied to Internet technology, finance, and many other industries. A supply chain strategy defines how the supply chain operates in order to compete in the market. The strategy evaluates the benefits and costs relating to the operation. While a business strategy focuses on the overall direction a company wishes to pursue, supply chain strategy focuses on the actual operations of the organization. It also focuses on supporting and meeting a specific business goal.

A supply chain has three main parts:

  • Supply: This mainly focuses on how, when and from where are the raw materials supplied for manufacturing,
  • Manufacturing: It focuses on the conversion of these raw materials into finished products.
  • Distribution: It focuses on ensuring these products reach the consumers through an organized network of distributors, warehouses, and retailers.

Supply chain is among the most complex and crucial functions. To measure the supply chain effectively, one should identify metrics that are appropriate for the organization and that will improve business performance. One cannot manage what one cannot measure. And the supply chain being one of the most important functions to manage it is important to measure it.

Supply Chain Management (SCM)

Another term associated with a supply chain is Supply Chain Management (SCM). It is the oversight of materials, information, and finances as they are distributed from supplier to consumer. The supply chain also includes all the necessary stops between the supplier and the consumer. Supply chain management involves coordinating this flow of materials within a company and to the end consumer.

The term Supply Chain Management arose in the late 1980s and came into widespread use in the 1990s. Prior to that time businesses used terms such as “logistics” and “Operations Management” instead.

Supply Chain Management can be divided into three main flows:

Product Flow: This includes moving the goods from a supplier to a consumer. It also deals with customer service needs.

Information Flow: This includes order information and delivery status.

Financial Flow: This includes payment schedules, credit terms, and additional arrangements.

Supply Chain Management (SCM) remains a high priority for manufacturers. This is because it helps to improve margins and retain and increase market share.

“Supply chain management remains at the top of the agenda for many enterprises today as a way to reduce operating costs and be more responsive to customers,” reports Jeff Woods, senior analyst at Gartner Inc., Stamford, Conn.

The success of supply chain management at this strategic level requires considerably more integration with other enterprise systems. Since many business targets and performance indicators are established in the budgeting process, efficiency demands that the planning, budgeting, sales and marketing, and SCM systems talk with one another.

Supply Chain Intelligence (SCI)

Today, more than ever, managers need tools to hat generate insights which would help them to make smarter decisions efficiently. To do so, they need to learn to ensure that Supply Chain performance supports their business goals. This very need of managers gave space to the evolution of Supply Chain Intelligence (SCI), a successful blend of Supply Chain Management and Business Intelligence.

SCI is fundamentally a predictive discipline that helps planners foresee events and anticipate trends. It is addresses numerous Supply Chain challenges. Analytical modeling techniques and optimization are at the core of Supply Chain intelligence. It is a new initiative that provides the capability to extract sense and analyze information about a Supply Chain. It has a broad mandate and provides a BI layer that compliments the SCM initiatives. SCI enhances an executive’s ability to reason through business outcomes. It prescribes the best course of action and helps the executive focus on the highest impact activities.

SCI in all regards is geared up to using SCM and ERP data as the basis for informed decisions.

SCI takes broader, multidimensional view of supply chain in which, using patterns, rules and meaningful information about the data can be discovered. The Supply Chain Intelligence provides accurate forecasts to improve the demand planning process thus giving a clear view of the future. It also reveals opportunities to reduce costs and stimulate revenue growth. It enables companies to understand the entire supply chain from the customer’s perspective. Before examining the supply chain of a particular business, it may be advantageous to understand the motivations behind supply chain improvements.

Difference between SCM and SCI

Supply Chain Management

  • Largely about managing the procurement and production links of the supply chain.
  • Transactional
  • Tactical decision making
  • Helps reduce costs through improved operational efficiency
  • Records one state of data representing “now”
  • Assists in material and production planning
  • Quantifies cost of some materials.
  • Can show today’s yield but cannot explain influences on it, so offers no help in improving it.
  • Simple reporting

Supply Chain Intelligence

  • Provides a broad view of an entire supply chain to reveal full product and component life cycle
  • Analytic
  • Strategic decision making
  • Reveals opportunities for cost reduction, but also stimulates revenue growth
  • Keeps a historic record.
  • “What-if” forecasting based on historic data
  • Enables an understanding of total cost
  • Can drill into yield figures to show what caused the performance level, so you can improve it
  • Collaborative environment with personalized monitoring of metrics

Levels of BI application in Supply Chain

With the advancement of technology at an exponential rate and the ferocious competition in the rapidly changing market, Business Intelligence has moved to the core of Supply Chain Management.

Most Organizations have different BI functions in IT department, Marketing Research and independent department. Timely information about market, customers and competitors stand crucial to meet the Supply Chain challenges. Business Intelligence value chain is an interrelated process of suppliers, manufacturers, distributors and customers. It uses the information and knowledge to pilot a company towards competitive success.

Business Intelligence is grounded in various supply chain activities and processes that serve as the sources of BI data and information. Vital components of value chain management are networking, enhanced intelligence analysis, awareness of the latest developments in data collection, and information analysis,

There are mainly four levels of Business Intelligence application in a Supply Chain Management, which are:

  1. Strategic Level: Strategic decisions are made at the top management level. To drive decisions Chief executives often require long term, historical, integrated information on environmental changes and industry trends that are combined with business performance. Insightful business decisions can create unprecedented success through adjusting Supply Chain direction.
  2. Tactic Level: At Tactic level, collective information is needed to provide visibility across multiple processes within a Supply chain. This facilitates actionable changes. Decision support systems are commonly used by the mangers at this level. Aggregated data across business units assist managers to make informed decisions, analyze business trends, and deliver promised services or products with a consistent quality.
  3. Operational Level: Operational Level Decisions require daily and real time data to satisfy customer demand on time. The line-manager is responsible for day-to-day business of a certain business process. Line managers use real time monitoring tools to access data and make timely decisions.
  4. R&D and Marketing Research Level: At R & D and data analysis level, professional staff members collect, organize and analyze data through data modeling and simulation. This to extracts supply chain information and uncovers knowledge of customers and competitors that are embedded in the supply chain process. They play a crucial role though they are not directly involved in daily decision making.

Thus, the presence of Business Intelligence not only enhances the efficiency of the Supply Chain but also aids in powerful decision making. Today, it has become a vital part of Decision-making at each and every level of Supply Chain Processes.

Need of Supply Chain Intelligence

There is a great need for Supply Chain Intelligence in the areas of strategic sourcing, production quality, warranty analysis, optimal distribution and demand management in an organization.

Spend Analysis – Procurement specialists can analyze trends over time, such as corporate spend history, budget performance, usage patterns and changes in supplier dependencies. SCI can highlight the way the commodities are purchased across affiliated suppliers, distributed to end consumers and affected by quality issues and warranty claims. It can thus leverage itself all through the contract negotiations,

Supplier Ranking – Ranking endows with an objective, repeatable and adaptable measuring system. It can reliably identify the best suppliers for the organization and respond effectively to changing business conditions. By using dynamic, weighted averages to add balance and flexibility, SCI can objectively narrow, measure and rank suppliers based on your specific needs.

Organizational Performance – SCI can introduce customer-specific business rules and models to emphasize exceptions to the agreed processes. It can drive organizational performance towards predefined business goals and strategies.

Trend Monitoring – Using SCI, procurement professionals can monitor key supply chain processes in real time. For direct goods, it may consist of quality and on-time delivery, whereas for indirect goods, it may consist of service-level factors. It can highlight the trends in an explicit supplier criterion that matter to specific audiences. It can thus help minimize every negative impact on the supply chain process.

Proactive Investigation – Automated analytical “filters” can alert one to the changing trends like – at-risk suppliers or emerging warranty issues These practical alerts will include e-mailed reports or graphs, a changed indicator in the scorecard, or even notification through a mobile device such as a phone or pager. It can thus provide visibility and lucidity.

Score carding – To visually present time-based key performance indicators (KPIs), SCI can provide a concise “dashboard”. A scorecard contains measures that can assist in describing external performance ant internal performance at all levels of the supply chain process.

Optimization – Optimization in the supply chain takes into account the “total cost to supply,” It comprises of, namely, quality/warranty issues, distribution from post-manufacturing to the consumer, inventory/service levels and trade promotions. Ranking considers each supplier in isolation and optimization examines suppliers in the cumulative way. This can thus reduce risk exposure and purchase costs and can increase negotiating leverage.

Product Profitability – This can support category management by item basis. It does so by looking at the impact of changes in product mix, distribution channels, shelf storage and other factors through multi-supplier networks…

Scenario Planning – It can assess all the options through “what-if” situations and can help find opportunities. It can also identify the potential for new and more efficient processes.

Demand Prediction – High-performance forecasting capabilities can provide accurate demand and promotions planning. The forecasts are based on data from ERP, SCM systems. It also considers a multitude of other internal and external information sources, with highest degree of data quality. It can

  • Reduce inventory levels
  • Monitor and improve service levels
  • Predict purchase patterns
  • Provide flow projections

Benefits of Supply Chain Intelligence

For several years Supply Chain Management and Business Intelligence have been top-of-mind concepts. With clear advantages offered by Supply Chain Intelligence the integration of SCM and BI tools are gaining acceptance across the globe. Through their union, companies can begin to benefit by identifying opportunities to enhance business performance.

It offers an array of advantages:

  • SCI gives complete visibility into all orders, shipments, status, inventories, and production output and consumption rates across the extended supply chain. Visibility includes visibility of processes (collaborative planning, demand forecasting, inventory control, balancing of resources with requirements, product tracing) and visibility of relationships (CRM, contractual compliance).
  • With SCI, information can arrive before the goods, allowing the recipient to prepare for their arrival. Moreover, communication can be multipoint and can leap-frog members in chain.
  • SCI allows measurement and analysis of specific supply chain activities that create profitability for the chain. For example, measures of the value of excess inventory, total cycle time, defect-free goods to total goods, and demand forecasting accuracy can lead to performance improvements and cost savings.
  • SCI provides single window for all data reporting and analysis which ensures that the reports or figures accessed from anywhere are uniform and provide the same data.
  • It also provides a consolidated view of the company including its supply chain. This helps reduce the traditional limited view of the supply side of operations.
  • Through this approach BI system also acts as an intermediary between the organization’s SCM and CRM systems. This move helps the company manage its supply to match the customer demands. It can also help the company tailor product attributes to match changing customer needs.
  • While the BI can help business managers evolve a new product line, the SCM helps coordinate with the suppliers to meet the changed production requirements.

Other than the above mentioned benefits SCI also has several specific advantages in:

All Operations of the Supply Chain

  • Reduces total cycle time from supplier to consumer
  • Provides supply chain visibility
  • Caters product traceability
  • Balances resources with requirements
  • Enhances communication, collaboration, planning and forecasting
  • Analyzes supply chain performance

Procurement

  • Measures supplier performance and negotiates performance-related contracts
  • Provides sourcing of new suppliers globally
  • Simplifies and streamlines of procurement operations
  • Shares master production schedule with suppliers so that suppliers can meet production needs
  • Reduces purchase price of raw materials

Production

  • Administers just-In-Time scheduling of jobs and production
  • Accommodates order prioritization
  • Detects critical events using alerts
  • Improves product quality by tracing defective goods
  • Develops collaborative new products.

Warehousing

  • Reduces raw material inventory levels
  • Reduces finished goods inventory levels
  • Prepares vendor managed inventory
  • Arranges cross-docking of shipments to allow goods to move along the supply chain without the need for warehousing

Logistics

  • Measures of delivery performance
  • Provides sourcing of new logistics providers competitively
  • Gives room to just-In-Time deliveries
  • Predicts of delivery outcomes for each transport segment
  • Fulfillment
  • Forecasts customer needs
  • Provides real time response to customer demand and feedback
  • Proactively replenishes before stocks runs out
  • Reduces price markdowns and returns
  • Measures product performance by retail location

Bringing supply chain management and business intelligence together across the enterprise is challenging. But it enables far more significant benefits than the sum of the parts. Supply chain management and business intelligence have been promoted so far in namely FMCG, retail, resources, manufacturing or financial services industry. But it has been done so in isolation.

“In isolation, these two concepts can only affect that part of a business at which they are directed”, says Katzen, Senior Executive, Accenture.

An integrated supply chain intelligence system will bring a marked increase in the visibility of each link in the supply chain. Therefore success and failures will become equally visible to all parts of the business in a rapid interval of time.

Challenges of Supply Chain Intelligence Implementation

Implementing SCI is a multifarious process. There are a number of challenges implicated in integrating information, systems and partners across the supply chain.

Data Integration

The assimilation of data from legacy systems, varied platforms and different database technologies that do not “speak the same language” makes data integrity tricky. Therefore data integrity can arise as a major issue.

Supply chains are made up of associates who do business in incongruent ways. This greatly affects the complexity of SCI projects. Moreover several factors must be integrated into the data warehouse. They are

  • The usual structured data from transactional systems
  • The unstructured data from supplier and customer relationships
  • Third-party research data such as market trend

Data integration is the number one challenge in SCI implementations. Integrating data from multiple sources is very complex and the cost of the extract-transform-load (ETL) process is often underestimated.

Increased Quantity of Data

Apart from the company data, data from the extended supply chain has to be fed into the data warehouse. . The consequence of this comes out as a tremendous increase in the amount of data that needs to be incorporated and stored.

Business Alignment

Trust and commitment as well as open channels of communication between all the partners are a must for an SCI implementation to be successful. These factors are critical as both the flow of information and the flow of materials must be optimized to reduce the total cycle time from raw material to sale of goods. This requires partners in the supply chain to “think and act as one”. Changes to business thinking and re-engineering of business processes to ensure uniformity across the chain must also include smaller partners.

Supply Chain Volatility

Supply Chains are turning out to be increasingly unstable in a dynamic global environment. SCI actually contributes to this by allowing companies to observe the performance of partners and switch to added profitable relationships. SCI implementations have to deal with constantly changing sources of data from new supply chain partners as well as new business cultures.

Security Issues

SCI needs partners across the supply chain to have easy access to information. This situation creates a security dilemma. The data in the enterprise data warehouse is often valuable, highly sensitive and t must be shared in order to create efficiencies across the chain.

The need for better supply chain intelligence has created challenges for established vendors of BI platforms and SCM applications. Some have made progress. Business Objects, Cognos, Oracle (PeopleSoft EPM) and SAP are now incorporating prepackaged supply chain-centric analytical applications.

Cognos supports distributed decision-making with business event management alerts. Hyperion provides master data management services. However, no BI vendor supports trading partner visibility and detailed supply and demand scenario planning. This requires the integration of trading partner data and the mixing of planning information with transaction information. For these needs business users must turn to players like IBM, Kalido, SAQQARA and Tibco for trading partner MDM; Interlace, Kinaxis or SymphonyRPM for scenario planning; and RiverOne, see Commerce or Viewlocity for trading partner visibility.

Software Requirements for Supply Chain Intelligence

Software that supports SCI has several base requirements such as:

Packaged Analytic Application – Ideally, SCI is facilitated by a packaged analytic application through focused functionality for manufacturing specialists. This way, the prepackaged application delivers high value out of the box without need for undue amounts of development. This would also be the case with a general analytic platform. Furthermore, a packaged analytic application for SCI encapsulates best practices for manufacturers and others involved in supply chain issues, whereas basic critical platforms cannot. An analytic application for SCI should include functions for analyzing historic supply chain and manufacturing performance. It should also facilitate analysis that helps to forecast material and production line needs.

Professional Services – A packaged analytic application (for any purpose, not just SCI) can never be as firmly packaged as applications for ERP, CRM or SCM. This is because source data required for analysis varies greatly from one corporation to another. The data integration process is different for each deployment of a given analytic application. In addition, each corporation has a unique collection of business entities, so the data model that represents these in the analytic application must be customized for each deployment. Hence, a software vendor providing an analytic application for SCI must also provide a healthy mix of professional services to aid with customizing the application for each customer, as well as providing training, support and project management. The consultants should have experience and training in manufacturing, supply chain domains and technical areas such as data warehousing and analytic application development.

Domain Expertise – The primary value proposition of any analytic application for SCI is the domain expertise it encapsulates. Therefore, anyone evaluating an SCI application should look for proof of domain expertise in the product as well as in the vendor. For instance, the software vendor should have executives, developers and consultants who have demonstrable experience and successes in manufacturing (both process and discrete) and other supply chain-intense industries. The application should have functions designed specifically for SCI, such as data models, analytic algorithms for product life cycle information, shop floor data and parametric test equipment data (whether from the factory or the field).

Build versus Buy – A packaged analytic application for SCI is faster to install and customize (months instead of years) than built-from-scratch supply chain decision support solutions. Besides, many organizations decide to build their own applications because they cannot find commercially available ones that satisfy their requirements. However, the customization process of an SCI application ensures that most of the customer’s unique requirements are met.

Supply Chain BI modeling

The demands of our global economy are forcing companies and entire supply chain to adopt more flexible and responsive modes of operation. Interdependence of companies and economies, and the rapid and unexpected pace of events call for responses from companies that are faster and well thought out. In order to achieve SCI objectives we need a supply chain-wide business excellence model that will provide consistent framework for establishing, modeling, managing, measuring, and improving supply chain processes. SCI model is based on the global supply chain excellence which unifies:

  • Business domain (modeling, people, existing supply chain and business process models, best practices, and quality management models),
  • Functional domain (information technology infrastructure, modern object-oriented development methods, and patterns)
  • Methodology for supply chain process integration.

Conclusion

These days, it seems globalization touches every business. It is changing the way manufacturers and distributors operate their supply chains. Outsourcing, contract manufacturing, shorter lead times and more regulations are facts of life. Organizations must identify and define the requirements for the actionable information that are needed to manage and improve each process of the integrated supply chain.

Manufacturers are benefitting by using business intelligence to enhance the integrated supply chain. Business intelligence project teams should collaborate very closely with the supply chain management process design and operations teams. This ensures that their informational requirements are clearly understood and designed into the solution.

Companies that do use supply chain BI to enhance profits and coordinate promotions are able to improve sales planning and supplier performance, and, as a result, they gain flexibility to meet changes in demand.

The demands of our global economy are forcing companies and the entire supply chain to adopt more flexible and responsive modes of operation. Both the interdependence of companies and economies, and the rapid and unexpected pace of events call for responses from companies that are faster and also more well thought out than what was required in the past.

Featured Article ,