The client is a large multi billion-dollar automobile manufacturing company in the Japan.

Challenge

The automobile manufacturer needed to better understand changing market trends and the behavior of its customers.

Solution

• Initial analysis indicated that a cloud-based Data Warehouse would be designed to gain insights into the company's operational data, finances, and profits.
• iGlades designed a Data Warehouse to deliver unprecedented analytical power to managers over a web interface.
• iGlades succeeded in providing access to thousands of branch and field personnel across the Business Markets units interactive, Web-based, historical views on data such as call traffic, call type, data circuits, revenue, expense information, customers, and product mixes.

Benefits

• Inventory Management - Data warehouse facilitated reporting at senior management levels on details of composite financial information to better analyze company's contributions and profit margins. Inventory management to optimize carrying costs by reduce excess inventory on hand
• Customer Trends - Brio Enterprise BI tools will give the employees clear snapshots of the product sales and customer buying habits.
• Data Analytics - Managers could access the system for reports on its customers, such as Top 100 gainers or decliners by product or geography, divided by domestic vs. international mix.
• Anomalies - Managers can also track and analyze "gaps," which are period-to-period changes in operational trends.
• Management Decisions - How has the total utilization or the total sales or mix of a business changed over this period of time?" "Who are the customers who have the greatest gaps? What is driving this gap - a domestic or international mix change? A product change? A rate per minute change?" With verifiable answers to these kinds of questions, managers can make informed decisions.
• Decisions support systems - By leveraging this Data Warehouse over the cloud, managers can detect subtle problems earlier, or detect a material change in the behavior of a customer or an event in the marketplace. These abilities enabled the company to make timely business decisions that have resulted in significant financial impact.
• Business Drivers - Analyzing the data revealed the actual drivers behind events and helped discover situations that previously may have been overlooked, and acquiring a finer, more subtle understanding of customer utilization of the company's products
• Quality Standards - Increased efficiency via supply chain collaboration through CPFR and other automated replenishment strategies
• Trend Analysis - ability to monitor our key brands very closely at all levels of the organization, but in the near future will also provide our suppliers and customers the ability to securely track sales trends for their brands on a daily basis."

Technologies used:

• Data Warehouse and Data Repository - Amazon Redshift
• Data Integration (ETL): Talend 3.x
• Business Intelligence - Apache Spark 3.x, Hadoop 3.x