|
Big Data Analytics solution for a successful E-Business company in US.
The client is a large online retailer in USA.
Challenge
Internet retailer needed to get a detailed insight about consumer and transaction related activity at online shopping
marketplaces it hosts for numerous merchants and clients.
Solution
- iGlades analysis indicated that the OLAP tools would be required to conduct trend analysis on customer buying patters,
traffic flow, orders and transactions placed by consumers, promotional strategies, product mixes and merchant mix.
- iGlades designed a data warehousing application based on decision support system - DSS technology, to deliver
unprecedented analytical power to clients and merchants.
- iGlades succeeded in providing data and information analytics about consumer's demographics, web traffic and
transaction activity at more than hundreds of online stores.
Benefits
- Trend Analysis - Merchants and clients have gained insight in understanding customer
demographics. Who are our customers? What products appeal to what demographics? What products are profitable?
Which promotional offers on what products can increase sales and yield higher revenues?
- Customer Profitability - Data warehouse has facilitated reporting for merchants and
clients on details of composite product, customers and revenues helping to better analyze company's profit margins.
- Decisions support systems - By leveraging this DSS system, merchants and clients
can review data and analyze customer and promotional trends by the hour, daily, weekly and monthly. Products and
promotions making significant sales impact can be modified depending on consumer data on the effect of the promotions
on the customers.
- Business Drivers - Analyzing the data revealed the actual drivers behind sales and
revenues and helped merchants and clients gain a better understanding of the product mix, merchant mix or promotion
mix helping the company make timely business decisions that have resulted in significant financial impact.
Technologies used:
- Data Warehouse - Amazon Redshift
- Data Integration (ETL): Talend 3.x
- Business Intelligence - Apache Spark 3.x, Hadoop 3.x
|
