Toyota-Astra Motor Leveraged the Denodo Platform to Simplify its Data Landscape and Achieve a Single Version of the Truth
公司规模
Large Corporate
地区
- Asia
国家
- Indonesia
产品
- Denodo Platform
技术栈
- SQL Server Integration Services (SSIS)
- Power BI
- SQL Server
实施规模
- Enterprise-wide Deployment
影响指标
- Productivity Improvements
- Cost Savings
技术
- 平台即服务 (PaaS) - 数据管理平台
适用行业
- 汽车
适用功能
- 商业运营
服务
- 系统集成
关于客户
PT Toyota-Astra Motor (TAM) is a distributor of Toyota vehicles in Indonesia and currently the market leader in the Indonesian automotive industry. TAM is a joint venture company between Toyota Motor Corporation and PT Astra International, with a distribution of shares of 50% and 50% respectively. TAM is headquartered in Sunter, Jakarta. TAM wanted to simplify its complex data management landscape, reduce the time-to-data for its multiple operational reporting requirements, and eliminate the need for shadow IT.
挑战
TAM had a fragmented data architecture, with data trapped in different business silos. The company relied primarily on extract, transform, and load (ETL) processes to integrate data from its enterprise data warehouse and transactional databases on SQL Server. This process was extremely slow, manual in nature, and difficult to govern. Moreover, the ETL sessions increased the overall maintenance cost of the data architecture as data was replicated across layers. In addition, multiple operational teams within TAM performed their own analytics and generated business reports. In the absence of an enterprise semantic layer, this led to multiple connections to different data sources, complicating the data architecture, and making maintenance even more difficult. Data latency was also a challenge, as business users did not always receive the most recent data. These issues resulted in multiple inaccurate definitions of core business metrics. There was no single version of the truth, and top management did not get the most accurate picture of the business. All of these challenges overburdened the IT team and slowed down the adoption of new BI solutions.
解决方案
TAM implemented the Denodo Platform above the company's enterprise data warehouse and the transactional databases, seamlessly integrating several different source systems to create a logical data warehouse. This enabled multiple reporting tools to now connect only to the virtual layer, eliminating the need to individually connect with multiple data sources. The Denodo Platform is implemented as a unified data access layer between the data consumers and the data sources, and because it acts as a single point of entry to all enterprise data, it enables an enterprise-wide centralized implementation of data governance and security. The data catalog built into the Denodo Platform made data search and exploration extremely easy even for nontechnical users, and it also doubled down as an ad hoc query engine. The Denodo Platform enabled the democratization of the data in TAM’s data ecosystem, enabling different business user groups to find the right dataset and use it for their own analysis.
运营影响
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
相关案例.
Case Study
Integral Plant Maintenance
Mercedes-Benz and his partner GAZ chose Siemens to be its maintenance partner at a new engine plant in Yaroslavl, Russia. The new plant offers a capacity to manufacture diesel engines for the Russian market, for locally produced Sprinter Classic. In addition to engines for the local market, the Yaroslavl plant will also produce spare parts. Mercedes-Benz Russia and his partner needed a service partner in order to ensure the operation of these lines in a maintenance partnership arrangement. The challenges included coordinating the entire maintenance management operation, in particular inspections, corrective and predictive maintenance activities, and the optimizing spare parts management. Siemens developed a customized maintenance solution that includes all electronic and mechanical maintenance activities (Integral Plant Maintenance).
Case Study
Monitoring of Pressure Pumps in Automotive Industry
A large German/American producer of auto parts uses high-pressure pumps to deburr machined parts as a part of its production and quality check process. They decided to monitor these pumps to make sure they work properly and that they can see any indications leading to a potential failure before it affects their process.
