Client: Locally.com is a leading US based company that owns a comprehensive online platform for online - to – offline shopping connecting hundreds of premium brands and thousands of retailers to shoppers with real-time local inventory. The platform further enables online purchases for nearby in-store pickup or same-day delivery.

Challenge: Locally required a dedicated development team to extend the existing locally platform with an analytics module for inventory and user impressions to help assist Locally’s clients (brands and retailers) with insights coming from large amounts of raw, scattered data generated from the Locally platform. Strategic Systems International has a track record of delivering data driven projects to clients all across the world. We were hired based on our competency and unsurpassed dedication to deliver according to the client's requirements. 

Solution: Our experts extended the existing Locally system. The system periodically takes snapshot of products, brands, stores and inventory data from MySQL database and user impressions from elastic search and stores it in temporary tables automatically. The data is transformed for all analytics and stored in the analytics specific tables. The existing web application has been extended with the addition of new modules to show new analytics in the form of charts /tables. New controls were provided to select time span and filters to see different aspects of analytics. The system allows users to drill down analytics to see more details.

Result: Brands and Retailers are now able to analyze

  • Inventory:
    • By Stores
    • By regions
    • By Products categories.
  • End User Impressions/engagements:
    • By Region
    • By Impression types
    • By Product

Similar Studies

  • SnapFlow

    A robust Workflow Management system that transformed a purely paper based ordering system into a fully automated SaaS solution for a tech startup

    • Startup
    • .NET
    • Web
    • SAAS
  • Social Market Analytics

    A social media analytics application to capture market sentiment for the finance industry using qualitative and quantitative methods

    • Financial
    • Startup
    • Advanced Analytics
    • Open Source
    • Web
    • SAAS
    • AWS
  • The Optimé Group

    A machine learning and advanced analytics mobile and SaaS platform developed using Amazon Web Services (AWS) platform for solving healthcare workforce challenges

    • Startup
    • Healthcare
    • Advanced Analytics
    • .NET
    • Mobile
    • Cloud
    • SAAS
    • Machine Learning
    • AWS
  • Agency Crafting eCommerce Campaigns for a Prominent Online Retailer

    Advanced analytics platform for analyzing Amazon ad campaigns and publishing online catalogs

    • .NET
    • Startup
    • Advanced Analytics
    • Cloud
    • AWS