Eveready Industries achieves an ROI of over 500% with Tableau



Eveready Industries India, Ltd (EIIL), is India’s largest-selling brand of dry cell batteries and flashlights and is also the world’s third largest producer of carbon zinc batteries, selling more than a billion units a year. Using Tableau, Eveready Industries gained valuable visual insights that helped the company significantly boost sales and improve efficiency in supply chain management. Using Tableau, EIIL has been able to:

  • Drastically speed up decision-making
  • Achieve growth in sales volumes
  • Mine existing data for valuable business insights

Eveready Industries India, Ltd (EIIL) is the flagship company of the B.M. Khaitan Group. Eveready is India’s largest selling brand of dry cell batteries and flashlights (torches), with dominant market shares of about 46% and 85% respectively. It is also the world’s third largest producer of carbon zinc batteries, selling more than a billion units a year. Additionally, Eveready is a manufacturer of rechargeable and alkaline batteries, rechargeable lanterns, lighting solutions (CFL, Tubelight, LED), electrical appliances and packet tea.

Seeking better insight into 3 terabytes of data

The company already had a data warehouse in place to store data generated from its ERP system, which was installed in 2005. It also had supply chain management and Salesforce systems in place, which generated considerable data.

In total, the company had about three terabytes of data, most of it stored in an Oracle database. In addition, it also had some financial data stored in Microsoft Excel worksheets.

The company was keen to use its existing data to gain valuable insights, which would aid in better decision making. With this in mind, the company decided to invest in a tool that would analyze data from its existing data warehouse and provide insights in a visual format.

If not for Tableau, we would have been forced to stick with creating complex warehouses and churning data to produce reports and tabular spreadsheets. This would have hampered our ability to make quick decision using real-time insights.

After evaluating available data analysis tools in the market, Eveready zeroed in on Tableau because of its simplicity and ease of use. These features enabled business users within Eveready to interact with the software very easily.

The company’s IT team was also impressed with Tableau’s ability to provide simple visualization of complex data.

Eveready initially started using Tableau to primarily analyze its sales data. The company’s 52-member strong sales team began using Tableau to track sales data such as planned versus actual sales, Year on Year (YoY) growth rates, sales trends, profitability of each Line of Business, geographical distribution of sales, etc. Additionally, the team used Tableau to study trends relating to customer buying patterns, cash-credit ratios, and more.

Next, Eveready extended the use of Tableau software to its supply chain team, bringing the total user count to about 74. Using Tableau, the supply chain management team could get a real-time view into inventory trends, ensure adherence to stocking norms in storage areas, and track materials in transit.

The team could also track distribution plans (For example: studying planned versus actual shipments).

The company intends to now make the software available for analyzing operations and financial reporting as well. Once this is done, the operations teams will have a better view into machine downtime data, production data, breakdown maintenance etc. The finance team will also benefit from understanding trends in cash flows and product profitability.

526% ROI in 6 months

One of the biggest benefits of using Tableau has been that it promotes much faster decision making.

“If you look at data in a tabular form, it’s tough to understand it quickly, let alone get insights from the data. But using a visual tool, you can immediately see what action needs to be taken,” said Mr. Arup Choudhury, CIO, Eveready Industries India Ltd.

The other advantage is that since data can be shared right from the tool, more people within the team can have access to information. Eveready also uses the Tableau server to host data, which not only ensures security of data but also enables much faster processing.

Eveready has already seen a considerable jump in sales with an ROI of about 526 percent within the first six months of the Tableau implementation.

“Tableau is highly recommended since it helps companies derive very helpful visual insights from existing data,” said Mr. Choudhury.

The team at Eveready attended a day-long training on Tableau and also viewed online learning videos from the Tableau website to be able to use the software effectively.

“If not for Tableau, we would’ve been forced to stick with creating complex warehouses and churning data to produce reports and tabular spreadsheets,” said Mr. Choudhury. “This would have hampered our ability to make quick decision using real-time insights.”

Tableau is highly recommended since it helps companies derive very helpful visual insights from existing data.

You might also be interested in...