下载PDF
Kyvos Insights > 实例探究 > Secure BI: Democratizing BI Access at a Pharmacy Chain
Kyvos Insights Logo

Secure BI: Democratizing BI Access at a Pharmacy Chain

技术
  • 分析与建模 - 大数据分析
  • 应用基础设施与中间件 - 数据交换与集成
适用行业
  • 零售
用例
  • 供应链可见性(SCV)
服务
  • 数据科学服务
挑战
The pharmacy store chain, with over 20,000 national and international suppliers, was struggling with the efficiency of its supply chain network. The company had billions of records from over 50 tables and sources, making analysis difficult. There was no single source of truth as data was decentralized and coming from different sources. Reporting was time-consuming as teams had to compile reports manually and could send them only once a month to top 200 suppliers. There was no way to provide secure, self-service access to massive volumes of supply chain data to external users/suppliers.
关于客户
The customer is a large pharmacy store chain with more than 20,000 national and international suppliers. The company's supply chain network is vital to its operations, ensuring that inventory reaches the stores in time. The performance of these suppliers plays a crucial role in the success of the business. The company wanted to improve the efficiency of its supply chain network by providing suppliers with access to their data through an automated system. This would allow suppliers to monitor their own performance and measure up to the Key Performance Indicators (KPIs) set for them.
解决方案
The company consolidated their data on Hadoop and used Kyvos to enable secure data lake access for both external and internal users. Kyvos created a BI acceleration layer on their data lake to ensure that their suppliers could query massive volumes of data and still get interactive responses. They created a Supplier Scorecard Dashboard on Tableau that provided information on details such as KPIs for the week-to-date and year-to-date performance comparisons for the current year and the previous year, KPI to PO drill down to line-item detail, and more. Once the scorecards were created, they allowed suppliers to access their KPIs directly and understand performance trends. To ensure that suppliers could only access their own data, rules were set up in Kyvos to filter vendor-level details. Kyvos integrated easily with their enterprise security infrastructure, and its row-level security ensured that suppliers could only see their own information and not that of other suppliers.
运营影响
  • Ability to meet the reporting needs of thousands of suppliers compared to only 200 in the past
  • Eliminated the time-consuming, manual process of creating reports for each supplier
  • Supplier performance improved as they could monitor their own performance and measure up to the preset metrics
数量效益
  • Enable suppliers to monitor their performance regularly and see how they measure against the KPI set for them
  • Instant access to scorecards for thousands of concurrent users as compared to sending manual reports to only a handful
  • Improve supplier performance against KPIs

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

Thank you for your message!
We will contact you soon.