Solving Legacy BI Headaches for a Global Distributor

By – Merri Beckfield

From my vantage points, I have the privilege of observing organizations at varying points in their journey to data insights.   And for SAP customers who have been waiting for the right moment for SAP Datasphere, there is now a focus on starting the journey.

Today, I’d like to share a bit about the journey of a supply chain management and logistics solutions provider who went all in on modernizing their SAP BI solutions.

 

THE PROBLEM

When we first started together, they were an SAP ECC shop with an on-premises, legacy BW data warehouse solution with over 500 BEX queries.  Users were sourcing data from a variety of systems for reporting and decision making.  On the front end, SAP Business Objects and Tableau were in the mix.    This is certainly a very common scenario.

With their legacy BI solution, the organization was facing some common challenges. They were struggling to achieve the necessary speed and cost-effective storage needed for their operations. Additionally, the lack of integration resulted in the loss of SAP context for data stored in third-party databases, further complicating their data management efforts.

 

THE SOLUTION

To overcome the challenges, together we came up with a strategy and plan to seize-the-moment with an upcoming S/4 implementation.  Rather than rework the legacy BI solutions to fit S/4 into the picture, the team took the opportunity to replace the existing BI solution with an all-in move to SAP Datasphere.  To mitigate risk, a “joint success plan” was put into place which laid out a phased migration (with a pilot) approach.  This allowed the team to work in an agile fashion, apply learnings along the way, and reap some business benefits along the way.

This all involved fully implementing a 3-tier Datasphere landscape, along with BW bridge.  To be honest, we learned a few things about BW bridge (and its limitations) along the way! The data and data flows were fully migrated from BW to Datasphere in a manner that allowed us to take advantage of the work previously done in BW (why reinvent the wheel?).  Security was fully integrated into the new solution.  The queries for the front end were updated to the new solution. And a data lake solution was put into place for cost-effective data storage.

 

THE RESULTS

At the end of the day, the outcome was a solution that provided:

  • Enhanced agility and scalability vs. their prior solution.
  • Streamlined data access by integrating SAP and non-SAP data sources
  • Real-time integration implemented to S/4 Hana for faster time to insight.

Ready to move your data strategy forward and unlock the potential of SAP Datasphere? This client success story is just one example of how we help businesses modernize their data architectures, streamline operations, and drive faster decision-making.

Let us help you achieve the same success! Contact us today to discuss how we can support your migration to SAP Datasphere.   Contact TEK – Tek Digital Transformations

Tek AI

Tek AI

The AI/ML industry has witnessed significant advancements since its inception, primarily driven by the growth in computational power and the availability of vast datasets. Historically, the field has evolved from rule-based systems to complex algorithms capable of learning and making predictions.

The global AI market, currently valued at over $196 billion, is expanding rapidly with a projected CAGR of 38.1% between now and 2030, a potential significant increase in value over the next several years. (Grand View Research)

Please complete the form to access the whitepaper:

Data Fabric – A Game Changer

Data Fabric - A Game Changer 

Today, businesses have access to more data than ever before. It comes in all kinds of sizes, types, and locations. With all this data comes a challenge – how to manage it effectively to drive meaningful insights and results. That’s where data fabric
comes in. Data fabric is an emerging technology that enables businesses to manage their data in a more efficient and streamlined way. It’s essentially a unified data management platform that brings together data from multiple sources and makes it accessible in one place.

This game-changing technology is set to transform the way businesses operate, allowing them to make more informed decisions and ultimately, drive growth. In this article, we’ll explore what data fabric is, how it works, and its benefits for businesses of all sizes. Read on to discover how data fabric can help you achieve
your goals

Please complete the form to access the whitepaper:

A Look at Artificial Intelligence in SAP’s Business Technology Platform

A Look at Artificial Intelligence (AI) in SAP's Business Technology Platform (BTP) 

Looking to elevate your company’s performance? Aiming to enhance the speed and effectiveness of your operational processes? Or maybe seeking a superior method for forecasting? fI so, it’s time to explore the Artificial Intelligence solutions offered by SAP within the SAP Business Technology Platform. By harnessing the power of Al, your organization can significantly enhance performance, improve decision making, advance innovation, and boost customer satisfaction. As demonstrated by the quick rise of Al tools like ChatGPT, Al has now reached a level of maturity where it can offer significant benefits to businesses that utilize this technology. In this article, we will explore the role of Al in modern businesses, the key components of SAP BTP’s Al offerings, and real-world use cases that demonstrate how SAP’s Al solutions are transforming business.

Please complete the form to access the whitepaper:

Plan, Visualize, Manage Promotion and Incentive Program Budget

Plan, Visualize, Manage Promotion and Incentive Program Budgets

In the modern digital world customers with information at finger tips are making more informed decisions in buying or leasing products.

Manufacturers can now connect with customers directly, transform the traditional selling practices by offering customized incentive programs. Using advanced analytics manufacturers can get deeper insights into customer sentiments and influencing factors for closing a deal with the customer.

With dynamically changing ownership models and competitive incentives landscapes, manufactures and retailers need more tools to manage incentive programs and budgets to swiftly modify programs by gaining insights into customer’s preferences to win deals.

TekAnalytics offers a flexible and easy to customize solution for Trade Promotion and Incentive Programs Management. The end-to-end Incentive Planning and Trade Promotion management solutions covers process steps for a series of activities aimed at successful product sales. Sales promotions and program activities, retailer incentives, promotional campaigns and many other tasks can be accurately planned, budgeted, executed and audited using TEK-TPIM®.  Get your complimentary whitepaper copy today!! 👉👉

Please complete the form to access the whitepaper:

Optimized inventory with Improved Product Flow and Turn

About the Client: Major US Manufacturer and Distributor

The Client is a manufacturer and distributor of food packaging and foodservice products, supplying packers, processors, supermarkets, restaurants, institutions, and foodservice outlets across North America.

 

Business Challenge:

  • The current setup has no Integrated supply chain consolidated reports
  • For manufacturers, not only is it difficult to predict the maintenance needs of equipment but also to determine the necessary inventory of spare parts for potential repairs.
  • Increase availability of spare parts for servicing and repairing of machinery and manufacturing assets and reduce the cost of maintaining inventory

 

The Solution:

  • Gather data from supply chain history for drilling, rigging, pipeline materials, other inputs, part failure, and part usage history, lead time history (for reorders), history of disruptions to supply chain, planned and the actual history of ramping of capacity.
  • Establish an optimal freight cost model that can ensure on-time delivery.
  • Characterize statistical properties (distributions and correlations) in parts demand and lead times.
  • Understand and account for historical disruptions by leveraging data from SAP BW and flat files to leverage SAP Analytics Cloud (Analytics, Planning, and Predictive ).
  • Link data sources with an analytics engine.
  • Using the current state of inventory and chosen economic scenario, automatically set optimal inventory levels for all parts.   

 

Results and Benefits:

  • Develop a flexible framework for using inputs of historical data, economic and manufacturing capacity scenarios, and predictive models to set optimal inventory levels by using SAC predictive tools
  • Optimized inventory level-setting with fully quantified operating characteristics of expected cost and probability of stocking out

Need additional Assistance?  Contact us today!

Maximize Auto Parts fill rate with SAC Predictive reporting

About the Client: Fortune 100 Automotive Customer

The Fortune 100 Automotive Customer is one of the world’s largest and most important car manufacturers with 6 million market capture. It has 50 production locations across the five continents with 200000 employees across the globe. To be a leading, profitable volume manufacturer as well as playing a leading role in the new world of the automobility industry in the long term.

 

Business Challenge:

Maximizing the Dealer orders Fill percent or Fill Rate is always a key focus in the automotive after-sales stream. Increasing fill rate without piling excessive inventory at a plant requires not only a deep dive into fill rate and supply chain metrics across multiple dimensions but also deep learnings into data patterns and identify influencers impacting the fill rates.

 

The Solution:

A complete cloud-based reporting solution for tracking fill rate from Plant to the part level. Our consultants in partnership with the business developed a regression-based predictive model by taking the last 3 years’ dealer order history and fill rates into the account. The Model predicts future fill rates for the dealer odder demand data in the planning system.

  • Gather data from supply chain history for drilling, rigging, pipeline materials, other inputs, part failure, and part usage history, lead time history (for reorders), history of disruptions to supply chain, planned and the actual history of ramping of capacity.
  • Unified Historical and planning data along with master data within BW/4HANA
  • Reporting Model which enables multiple drill-down levels and secured at region leve
  • An easy-to-use yet very effective SAC-based visualization to track Fill rates historically and also drill down to material level with multiple end-user level capabilities including Ranking, Ad-hoc exploring.
  • Considering 3 years dealer order history, created a regression model which predicts fill rate and quantities at a part level for demand planning data
 

 

Results and Benefits:

  • The SAC story completely replaced excel based fill rate tracking. Users no longer need to perform any manual excel calculations to derive KPI’s which tremendously save time in analyzing.
  • A very user friendly yet robust UI design
  • A deeper insights into the fill rate data across multiple dimensions and
  • 95% confident regression model trained from 3 years historical data which predicts the future fill rates, this will help users to maintain optimal inventory

Get our case study