Indian based distributor management organization which provides one-step solution to all management and sales-end requirements for various companies and its brands to check their supply chain and other logistic functionalities.
To establish an analytics platform to analyse sales of competitive products ,its average sales,bill value,bills per outlets with monthly & quarterly sales comparison
Analyze time of day,days of week sales of same category products in urban, rural area
Analyze basket size and associate brands sold in market
How Did We Help
CloudJournee’s team fully understood the complexities of existing analytic application and quickly provided advice on recreating the same dashboard in server-less AWS QuickSight
Connected database with AWS QuickSight in a private environment, joined ,processed and Prepared data as per the requirement by ensuring row ,column, SPICE capacity limit
Added bar charts for same category brands and products average sales,bill value,bills per outlets and added monthly & quarterly drill down. Categorized basket size as 3 main sizes using calculated fields and visualized it with purchase time and day analysis to gather purchase trend
Enabled colour code for brands in bar charts as per brand and its company’s standard
Enabled interactive filter by enabling field mapping to datasets and charted brand association
Overall TCO reduction by 35% – 40% compared to running the applications on-premise vs after recreating in Server-less QuickSight
Migrating old data from database to AWS storage services as CSV’s saves database cost by 50%
Able to figure out leading competitive products and their market sales
Efficiency has been increased 30% by fully automated data management which saves time and efforts of analyst
CloudJournee is an end-to-end Cloud Services Company enabling organizations to succeed in their digital transformation initiatives by helping them successfully adopt and run their applications in the Cloud at a lower TCO. With a team of experienced and cloud consultants, CloudJournee is aiding customers across the globe with scalable and reliable solutions to help them overcome their business problems using DevOps, Microservices, Docker, Cybersecurity and Log Analytics.
CloudJournee specializes in Amazon Web Services, Microsoft Azure & Google Cloud Platform and has designed a wide range of solutions and services to facilitate organizations achieve their business objectives.