Archive

Archive for the ‘Featured Article’ Category

Systech & BI Insight at MicroStrategy World 2010

February 23rd, 2010

MicroStrategy’s 13th annual user conference 2010 kicked off with a bang at Las Vegas this year. MicroStrategy World has always presented us a great opportunity to spend time with our customers and partners to catch up and plan for the upcoming year, and this year was no different! There was record attendance of more than 1,500 customers and partners attending, signifying the beginning of what is looking to be a very strong year for BI.

Systech has been a regular at the MicroStrategy World for the past several years. This year we were a silver sponsor for the event. We were delighted to be on the exhibit floor along with our partner Pi Solutions to present our success strategies and experiences using BI to enhance business performance. Some of the exciting new attractions on this year’s Systech exhibit floor featured unique presentations and demonstrations highlighting “Discover the power of Analytics” solutions for various industries. Not only was our solution well received by our client base but was extremely well received by the audience who were exposed to Systech’s BI for the first time. At the event, we got a chance to re-connect with Systech alumni and it was gratifying to see them cheering and celebrating our success. Krish Lakshmi Narayan, summarized the sentiment when he said that it was great to see Systech’s growth in BI and the level of participation at the conference. Several Alumni also brought their entire team over to our booth and introduced Systech as the company which trained them of their BI expertise.

Adhering to their tradition, MicroStrategy world started off with a dashing performance – this year by Gwen Stefani (Or maybe a look alike…hey you never know in Las Vegas!)! The general session generated tons of energy and excitement – it included Sanju Bansal’s welcome, Mike Saylor’s keynote on Mobile Intelligence, Mark LaRow’s keynote on the Micro Strategy Technology Strategy, and Micro strategy customer panel.

The highlight was definitely the keynote from Mike Saylor, CEO, MicroStrategy. Mike declared in his keynote, “We are on the verge of a new era that will result in a new class of applications that will change the way we think about our business.” Saylor made the most compelling speech of why mobile may revolutionize BI. Saylor said, “Computing is entering its fifth generation in which desktop Internet applications are giving way to a new generation of Mobile Internet applications. In the Mobile Internet age, applications which were mildly successful when used at one’s desk suddenly become incredibly effective and valuable when consumed on the go, anywhere and anytime business is being conducted. A Mobile information access will likely eclipse desktop information access in the near future. This heightened level of usage, combined with the richness of the mobile interface, will change the way information is consumed and MicroStrategy intends to be at the forefront of this wave. MicroStrategy 9 is designed to outperform competitive BI architectures, and is well-suited to provide intelligence in the age of the Mobile Internet. Our goal is to enable our customers to deliver Mobile Intelligence ahead of their competition to their employees, their suppliers, and their customers.”

Mark LaRow’s keynote focused on the strategy and the launch of MicroStrategy 9 release 2. MicroStrategy boasted its in-memory solution last year in MicroStrategy 9. With MicroStrategy 9 Release 2, they have improved its cache load times, query processing times, and memory consumption. VP of Marketing Mark LaRow claimed that cubes consume 70% less memory in the latest release, making an already scalable solution more so. With the upgrade to 64-bit BI, empowered business people to conduct analysis quicker, leverage more BI functionality, and to create their own reports without IT help.

The event featured more than 100 educational sessions, and an update on MicroStrategy’s latest technology advances. MicroStrategy outlined their technology advancements and strategy to emphasize the important impact of advancements: speed of thought performance, mobile intelligence, enabling an information gateway, rapid time to value, lower cost of ownership, making BI pervasive and the future with predictive analytics and next generation user interfaces through navigation and visualization.

At the conference, MicroStrategy recognized companies for achieving outstanding business performance with their MicroStrategy-based business intelligence applications. These companies were recognized because of the way their dashboards and dashboard technology enhanced the way the business decisions were made. The winners from this year were AmerisourceBergen for extranet deployment, Con-way Freight for advanced analytics, Yahoo for data analytics, Lowes for user scalability, Ross Stores for enterprise deployment and Brian Fox from Citi for individual excellence in business intelligence.

AmerisourceBergen was recognized in the Extranet Deployment category for its InSite system. The InSite system supports AmerisourceBergen’s community pharmacy clients across the U.S. with powerful dashboards and scorecards that provide rich analytics and tailored information. The extranet allows pharmacy owners to quickly identify suspect claims that may contribute to profit leakage, and uncover opportunities to expand their business and reduce unnecessary costs. AmerisourceBergen is one of the world’s largest pharmaceutical services companies, with operations primarily in the United States and Canada. Chuck Reed, from ABDC acknowledged the Systech team for its integral role in the project at the award ceremony, thus recognizing Systech’s contribution in skill and resources for the project.

MicroStrategy World 2010 was a jam packed event filled with learning and networking! We had a chance to personally experience MicroStrategy, examine the new product technology, collaborate with customers and review their progress. On the whole it was clearly evident that we would be seeing a seismic shift in the way business is conducted. And most of all it was exciting and rewarding to connect with everybody in Systech’s BI/DW ecosystem – our client base, our partners and our alumni friends!

Here’s to a productive 2010!

Vaishnavi Gollapudi
The Editor, BI Insight

Systech has been weaving MicroStrategy’s award winning BI platform into its proven methodology for creating sophisticated Business Intelligence environments since 1998.

View Systech’s MicroStrategy Technology Practice
http://www.systechusa.com/microstrategy/

Featured Article , , , ,

Global Credit Management Reporting

December 17th, 2009

Background

In this case study we describe how a leading provider of financial advisory services and international banking services benefitted from Systech’s innovative solution and also saved more than $7 million in logistical costs.

Our client provided a variety of products and services, including the Credit Card, the Optima Card and other consumer and corporate lending products, stored value products, corporate and consumer travel products and services, magazine publishing and merchant transaction processing, point of sale and back office products and services.

The client was looking to enhance their customer satisfaction. They wanted to act as a Global Credit Management source and needed a reporting system to manage this efficiently and cost effectively.

Solution

Systech initially established security access for web and created a data collection process. The data collection process included the gathering of report profile information and corresponding MIS data as requested

Systech then enabled a web based reporting system that helped their clients gain easier access. This proved to be a comprehensive method of viewing their statements. The data from current reports such as Industry Reports, Card member Reports and Client Hierarchy Reports was made available. The solution gave their clients the functionality and accessibility to view their corporate accounts in the categories of air, hotel and rental. This allowed for more cost effective methods of negotiating travel patterns for companies. It helped companies track their expenses world-wide.

It thereby, provided the client with a tool to leverage customer data for more complex analysis through the use of filters and interactive access to detailed information. The system also gave a highly summarized report on items such as global spending, and where and how money is being spent. This provided a value-added service to their customer. The modification of the data warehouse allowed for access of reporting on the web with guaranteed, data level security – an important issue for the users. The system could also report on multiple currencies.

Benefits

The web based reporting system provided the benefits of:

  • Improved timeliness of the Corporate Purchasing Card data
  • Reduced purchase order costs
  • Better strategic procurement decisions through increased analytical capabilities
  • Enhanced Customer Satisfaction

Featured Article ,

Store and Merchandising Analysis

November 4th, 2009

Background

In this case study we describe how a leading provider of specialty retailer of premium pet food and supply stores, achieved enhanced sales, improved margins and better tracking of products and services and through Systech’s Business analytical solution for Retail Industry – Store Analysis, Merchandising Analysis, Promotion Analysis, Market Basket Analysis and Vendor Management .

The client needed a solution that would make it possible for them to obtain company information in a quick and accurate manner. They needed a store analysis to get an in-depth look at the sales & margins section among store contribution and the base stores performance for a two year period. They also wanted to access inventory levels at all times in order to accommodate customers with the appropriate products and services offered.

Challenges

Identification of store uniqueness was needed to allow for pricing and store assortment for proper product placement and sale. A suitable solution needed to be put into practice in order to properly target their market and track down customers to evaluate their specific buying habits. Promotional, product and vendor divisions also needed to be analyzed to gain full interpretation of the business.

Solution

Systech delivered an enterprise Business Intelligence solution, which aided ad-hoc detail merchandising and allowed reporting of data based on specific merchandising units and also in overall store analysis across all reporting components. The primary platform and framework was built for the data warehouse to completely function.

Another important solution that Systech implemented was Market Basket Analysis which helped the client understand their customer’s buying habits and enabled them to implement suitable cross-sell and up-sell to their customers.

Result

The solution enabled the client to perform effective store and merchandising analysis. This resulted in better tracking of products and services. The vendor management helped to evaluate vendor performances and helped them to identify vendors who gave better and faster service. This also allowed the client to have all the necessary products in stock to provide better customer service. Promotional Analysis effectively helped the client enhance their sales and improve their margins.

Featured Article , , , , , , , , , , , , ,

Productivity Analysis and Reporting for Prescription Claims

September 4th, 2009

Background

In this case study we describe how a leading provider of pharmacy benefit management services achieved improved pricing and design strategy through Systech’s comprehensive, cost effective solution and analytics solution.

The client needed a powerful Business Intelligence system to cut costs to analyze spending patterns across the country. An improvement in physician compliance to utilize and better manage the pharmacy dollar was needed in order to lower healthcare costs and provide better services for customers. They needed to find a cost effective, complete and comprehensive solution which would perform complex analysis quickly and efficiently.

Challenges

The principal challenge was the analysis of claims costs, profits, sales comparisons, product comparisons and overall productivity. The customer wanted a robust system that would be easy for their IT department to maintain after it was implemented and also, one that would be scalable and reliable.

Solution

As a strategic consultant Systech’s first evaluated client’s infrastructure and environment, and recommended a datawarehouse infrastructure for implementing the solution. Systech was responsible for building and maintaining a robust Business Intelligence solution. The data warehouse is used to report on a variety of information for a multitude of clients. This helped to identify the key metrics such as top prescribers, members, and drugs by medical groups among many other functions required for prescription claims analysis and fraudulent claims detection. The data warehouse also enabled accurate forecasts of the industry’s leading trends, utilization trends & patterns. It enhanced the quality and reliability of the information gathered.

Result

The solution helped our client perform accurate forecasts of pharmacy trends leading to improvements in benefit plan design and pricing, resulting in better financial decisions. It helped physicians be better informed and helped provide quality health care for patients. Fraudulent claim detection also helped save revenue leakage for the company.

Featured Article , , , , , , , , ,

Increasing Operational Efficiency using Profit Analysis

June 30th, 2009

Background

In this case study you would see how a leading wholesale drug distribution company achieved improved operational efficiency through Systech’s innovative and cost effective solution and analysis.

The client had to consolidate data from multiple transactional systems into a single enterprise data warehouse. The data consolidation would provide a single view across the entire enterprise and permit Integrated Reporting, Analysis and Decision-making, across the organization. This would provide a single Customer view/definition across the enterprise – eliminating the disconnect in processes such as sales, fulfillment and customer service & satisfaction.

The Challenge in the Details

The client had disparate source systems and multiple decision support systems where data could not be merged or consolidated. These data sources/elements did not map to the definitions in the financial systems either. They were able to generate reports at an invoice level and the reports were taking exceedingly long execution times. The challenges for Systech were:

  • To build a single repository for information – integrating data from the disparate systems.
  • To design a cost effective solution utilizing the existing hardware and software.
  • To deliver within the extremely tight timelines defined by the customer(s).
  • To enable flexible & detailed data analysis.
  • To implement the front-end application such that it could support existing requirements and possible future developments.
  • To provide visibility and insights into costs, revenues, capacity and assets, providing insight into past, present and future information.
  • To measure historical performance, profits of incoming orders, initiate trend analysis, predict and optimize costs, profit, capacity; for return on invested capital of your future business.
  • To ensure the delivery of undeniably accurate, actionable and widely accessible cost (direct and indirect), resource and capacity information enabling the client to operate more efficiently and in turn reduce cost.

The Solution

At the very beginning, it was determined that the sheer size of the workload combined with the complexity of the organizational and data issues would require a project team with strong leadership & high level executive sponsorship from the client. The tight schedule and budget constraints worked against the traditional approach of organizing a big onsite project team with the resources necessary to accomplish those goals.

Systech team decided to split the project into manageable parts – each of which would be tackled by a small team split into an On-site project lead and an Off-site project team. The Onsite-Offshore teams adopted a fast, responsive and iterative approach to fashion a solution for their part of the puzzle. Iterations of model-build-test-fix-retest resulted in a better componentized build for the Data Warehouse.

Systech teams worked in collaboration with the client to engage, understand the business requirements, craft the technical components and deliver a cost effective analysis for key business areas including:

  • CUSTOMER
    • Customer & Channel Profitability
    • Segmentation profitability
    • Sales Optimization
    • Strategic Cross-Sell
  • OPERATIONS
    • Distribution Optimization
    • Reducing Operating Expenses
    • Reengineering & Process Redesign
    • Supply Chain Measurement and Optimization
    • Resource & Capacity Planning & Utilization
  • PRODUCT
    • Product Profitability
    • Line of Business/Segment
    • SKU Rationalization
    • Brand Analysis
  • CORPORATE
    • Corporate Performance Management
    • Business Process Measurement & Analysis
    • Optimized Return on Capital
    • Continuous Improvement Monitoring

Result

  • The solution delivered by Systech not only addressed the pain areas but also provided additional benefits to the client.
  • Datawarehouse delivered to the client resulted in improved process efficiencies, faster query response times, reduced data load windows, a flexible data model to permit a wide range of analysis.
  • Systech’s solution empowered decision makers by allowing them to drill down into their data for detailed analysis.
  • Additional types of analysis facilitated by the solution include profitability analysis based on segment, insight into wholesale acquisition cost and better insights of the historical data.
  • Forecasting was a key functionality in the delivered solution. This function provided the scoring and tracking tools for business operations.
  • Systech helped pinpoint client’s unprofitable products, customers and vendors that might require renegotiation, re-pricing or obsolescence
  • Systech’s solution identified profitable products and customers and helped identify opportunities for profit improvement

Featured Article , ,

Falken Tire Corporation – Data Mart Development and Reporting

April 30th, 2009

Statistics

falken

Industry: Manufacturing & Distribution

Application: Informatica 8.5, Microstrategy 8.1.1

Database: SQL Server 2005

Number of Users: 40

Deployment Type: Intranet/Extranet

Background

Falken Tire is a brand of tires by Japanese Sumitomo Rubber Industries with branches across Asia, America and Europe. Their first tire was produced in 1983 and it wasn’t until two years later that they began exporting their tires outside Japan and entered the US market only in 1990.

As the organization grew, so did the need for accurate and immediate information. The company lacked an effective way to consolidate, manage and distribute business data. Data resided in many different sources and in different formats, limiting its ability to analyze and deliver it within a single platform. To evaluate performance in the market, Falken Tire compared their Sales data with the Market data. Falken Tire wanted to perform Market Share Analysis and also forecast demand. However, they were faced with complications involving multi-source data analysis.

These issues needed to be addressed by Systech Solutions, Inc.

Challenges

Diversity of sources:

The fundamental problem that Falken Tire faced was that their Sales data was in the Operation System, Objective was in a flat file and Market data was in a SQL database. It was not only time consuming to create a report but also not flexible to do further analysis.

Tracking and forecasting:

Traditionally, Falken Tire could not track or forecast actual sales. Therefore, it was essential to configure a reporting tool to access information in the data mart with ease. They needed to get a deeper insight into their key sales performance to better forecast the market.

Solution

After studying the data from different sources, Systech came up with a model of how the information fit together. To enable this, the development team needed to understand the existing information and find the correlated pieces. Systech’s development team then created a common format for the data mart in a SQL Server 2005 database. Later, Informatica 8.5 was decided on as the most appropriate ETL platform for this BI implementation at Falken Tire. The ETL platform was configured to support reporting and complex data analysis with maximum efficiency. It was also structured to provide enough flexibility to accommodate future trade volume and business growth. Subsequently, Microstrategy 8.1.1 was configured to access information in the data mart to deliver customer friendly reports, templates and dashboards.

Result

Centralized data in BI data mart:

  • Users could easily access the data. Also allowed them to compare Falken Tire sales with their competitor and do market analysis.
  • The robust architecture of the new ETL platform provided flexibility and scalability.
  • The new ETL process fetched data to reports based on real time which was impossible earlier.

Empowered to report and analyze data to make improved decisions:

  • The new and improved dashboard consisted of multiple parameters/metrics that helped track all Key Performance Indicators in Sales and Inventory.
  • The dashboard enabled Falken Tire to view the performance of the company based on their objectives.
  • It helped create a Daily Sales Report for the previous working day and also helped to view Sales by drilling down to the zip level of the state.
  • The solution enabled business users to drill into the key trends to do an online analysis with just a click without coming back to the developer asking for a separate report.
  • The reporting tool automated the comparative market share analysis of the Sales. This process which was a multi-step process earlier was now an automated process.
  • They could report sales figures, forecast projection, estimate competitive sales and gauge the state of business.
  • Based on the forecasting demand they could manage the inventory.

The Systech team thus helped the end users view critical performance information in a matter of seconds and quickly make decisions that seek to optimize market share.

Featured Article , , , ,

Guitar Center – MicroStrategy Implementation

February 27th, 2009

Statistics

guitar_center

Industry: Retail

Application: DataStage 7.5.1, MicroStrategy 8.1.1

Database: Netezza 4.0.2

Database Size: 1 Terabyte

Number of Users: Nearly 300 active dashboard subscribers through e-mail, 200 indirect users through portal and 145 active MicroStrategy users

Deployment Type: Intranet

Background

Guitar Center is the largest chain of musical instrument retailers in the world with 214 locations throughout the United States.

To accommodate their expanding business they were seeking a platform to support complex data analysis that is user friendly. Formerly they depended on time consuming and less efficient POS System.

After evaluating several Business Intelligence vendors, they chose Systech Solutions Inc. to meet their needs for identifying the key trends and make informed decisions. Systech Solutions, Inc. was assigned to design an Enterprise Data Warehouse (EDW) for them in this regard.

Challenges

Guitar Center required a detailed access into a variety of business data to allow the business community to analyze their data in greater depth. To offer a simplified and integrated solution for a profitable growth Systech had to address certain challenges.

  • To track trends and identify opportunities. Since the data was spread across disparate systems it was a laborious process.
  • To manage overwhelming amounts of data from various sources—and turning it into reliable business intelligence that enabled better business outcomes.
  • To effectively design EDW for consolidated reporting both from DRUM, JDA and PeopleSoft.
  • To configure and implement a commodious tool to query the EDW and to create reports.
  • To compile a system that would distribute reports with in a 24 hour window every month.
  • To provide a platform that could keep up with constantly evolving user requirements.

Solution

Systech Solutions fashioned a business intelligence environment that comprised of a Netezza 4.0.2 data warehousing infrastructure, a DataStage 7.5.1 ETL environment and a MicroStrategy 8.1.1 reporting environment.

The Systech team successfully achieved the extraction, transformation and loading of the source data into a data mart schema through an ETL process. The team made sure that the information was accurate, consistent, and optimally organized for complex analysis. The EDW was effectively designed for consolidated reporting both from DRUM, JDA and PeopleSoft. Since the source data was stored in individual schemas, the transform strategy included consolidation of information which was common to all source systems. A user-friendly OLAP data model was successfully created to store pre-aggregated data for fast ad-hoc query performance.

MicroStrategy reporting tool was configured to query the EDW and to create reports. The Systech team developed dashboards that included scorecards to allow any type of key performance indicators (KPI’s) to be rolled up into a score for a particular application area, overall IT performance, or anywhere in-between. More than 32 to 40 reports were run apart from the templates during the course of the project.

The sales data (KPI’s) was analyzed to:

  • Anticipate the sales margin
  • Analyze the SKU to aggregate (or roll-up) metrics into single overall “score” for IT and the inventory data
  • Visualize store and warehouse inventory
  • Calculate profitability evaluation ratio that analyzes the firm’s ability to turn inventory into cash above the cost of the inventory
  • Study purchase orders and transfers

Result

The Microstrategy implementation at Guitar Center by Systech team provided them a greater insight into Key performance and Sales metrics. Systech developed an easy to use BI application to support their data from the users. The data warehouse was architected to support production reporting, making the database more intuitive to query than the operational database.

Multiple areas of their business used the data to manage inventory, identify sales opportunity, recognize key performers and review products. Systech made it possible to provide customizable user experience to provide executive summary reports, analyze sales promotion and study products sales. The robust architecture and a flexible platform enabled the team to combine right level of access with right functionality to create a positive user experience.

Featured Article , , , , , , , ,

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 ,