Optimizing Workflows: A Megaputer Case Study with Skyvia

Megaputer has been developing data and text mining software since 1993, and now it’s a leading developer, offering tools for predictive modeling and knowledge discovery on large volumes of structured data and text. While building customized solutions, Megaputer provides task and domain-specific solutions for a number of industries, including Pharmaceutical, Insurance, Healthcare, Finance, Manufacturing, and more.

Megaputer

Software Development

Data Integration

Challenge

One of Megaputer's clients, a leading discount home retailer in the US, strived to reclaim its heritage and position as America’s original discount home retailer through its strategic plan. To support this initiative, the company needed to gain a deeper understanding of:

  1. customer sentiments and preferences,
  2. trends from various textual data sources, including customer feedback, reviews, and social media interactions.

However, the company faced challenges such as diverse data sources, the need for advanced text analytics and NLP capabilities, robust visualization and narrative generation features, and seamless integration with existing systems. Addressing these challenges will empower the company to make data-driven decisions and solidify its position as the best destination for extreme bargains.

Megaputer, renowned for its advanced text analytics capabilities, has partnered with Skyvia to integrate robust ETL functionalities, offering a tailored solution to empower the client with advanced insights from textual data.

By seamlessly integrating customer feedback from social media, reviews, and surveys with our existing systems, we've gained a comprehensive understanding of market trends and customer preferences with greater convenience, all without compromising the quality of our insights. This has enabled us to strategically realign our store operations across the US and Canada.

Stacy Chou

Procurement Executive at Megaputer

Solution

The solution excels in leveraging Natural Language Processing (NLP) techniques to extract sentiments, themes, and trends from unstructured textual data. Megaputer's advanced analytics capabilities go beyond simple sentiment analysis, capturing nuanced insights into customer perceptions, preferences, and market trends.

Megaputer provides interactive visualizations, including charts, graphs, and customizable dashboards, that transform complex textual data into actionable insights. Stakeholders can visualize key metrics, monitor trends, and explore detailed reports to support informed decision-making and strategic planning.

Skyvia's flexible ETL capabilities ensure smooth data flow and compatibility with the client's existing systems, enhancing operational efficiency and data accessibility. The integrated solution seamlessly imports and integrates textual data from various sources such as online reviews, social media platforms (Twitter, Facebook, Instagram, LinkedIn), emails, and surveys into Salesforce.

Megaputer data integration use case schema

Skyvia facilitates near-real-time data acquisition and integration with easy connections to applications hosted on the client side. In the initial stage, this includes Salesforce, Hubspot, Marketo, Google Suite, and Mailchimp. The transformed data is then sent downstream to Megaputer's PolyAnalyst for analysis and visualization. Upon receiving data in usable format from Skyvia, PolyAnalyst uncovers underlying themes and emotional tones within the textual content using a combination of nodes and functionalities applied in a visual workflow.

Integrating our data to and from diverse platforms into PolyAnalyst through Skyvia was impressively smooth. The entire process required minimal manual intervention, and within days, we were up and running with a fully operational system that effortlessly synchronized our data sources, allowing us to dive straight into advanced analytics without any downtime.

Vinod Gupta

Technical Product Manager at Megaputer

Results

The collaboration between Megaputer and Skyvia delivers a powerful text analytics solution that empowers the client to leverage data-driven insights effectively. This insight guides the client to adapt to market demands and develop aligning strategies, ultimately leading to enhanced operational efficiency.

Now, the client is in a much better position to evaluate the sentiments and preferences of consumers from each outlet. The result is reflected in their enhanced inventory management, which is projected to save at least $300,000 annually, which is almost five times the cost of implementing the solution.

Additionally, the client is considering reorganizing its stores across the US and planning to shut down stores in some locations that do not show any positive signs of profitability based on the system's analysis. The cost-benefit of this move has yet to be evaluated.

Skyvia's near-real-time data acquisition, combined with Megaputer's PolyAnalyst, has empowered us to uncover critical themes and emotional tones within our customer interactions. This detailed analysis is now guiding our store reorganization plans, helping us focus on profitable locations and reconsider those that aren't meeting expectations.

Cage Linn

Customer Insights Manager at Megaputer

Explore Skyvia features nowGet started for free