Innovation in Customer Analysis Platform via Amazon Redshift
Japan Tobacco Inc. (JT)
Applied Services: Amazon Redshift, Data Analytics
Japan Tobacco Inc., Japan's sole cigarette manufacturer, operates "JT Smoker ID" — a membership-based web service enabling personalized digital marketing to users under strict tobacco marketing regulations. After adopting Tableau Online in 2016 for data visualization, the company encountered performance and storage limitations that were limiting their ability to rapidly iterate on marketing strategies.
The Reform of Data Analysis Infrastructure to Improve Performance
JT initially analyzed data through Excel and basic BI tools. When Tableau Online was adopted to improve visualization capabilities, performance bottlenecks emerged as data volumes grew. The company partnered with Classmethod to migrate their data infrastructure to AWS, implementing Amazon Redshift as the central data warehouse powering Tableau.
System Architecture
Reducing Time from 10 Seconds to 1 Second
"The performance had improved dramatically...the calculation time was shortened to 1 second, making it possible for us to do more trials."
— Mr. Hiratani, Japan Tobacco Inc.
Results Achieved
- • Query performance improved from 10 seconds → 1 second
- • System deployed in just one month
- • Tableau analysis now fast enough to support rapid PDCA marketing cycles
- • More analytical trials possible within the same time window
This case study uses Amazon Redshift.
Classmethod's data warehouse practice migrates organizations from slow, limited BI infrastructure to Amazon Redshift — delivering the query performance needed to support data-driven decision making at the speed of business.