Analytics & AI Transformation: Real-World Success Stories
Discover how NeenOpal empowers businesses with AI & Data-driven transformation.
93 case studies


PlanetScale MySQL to BigQuery: 170M+ Rows Migrated With Zero Data Loss
Years of user-engagement history were locked inside the production databases behind a leading dental-industry media company's websites. Every page view, article and course impression, video play and webinar interaction sat across three separate PlanetScale (MySQL) databases. There was no safe way to analyze it without slowing down the live sites. NeenOpal built a custom replication pipeline on Google Cloud Run that moved the full 170M+ row history into Google BigQuery with zero data loss, then switched to a continuous incremental sync across 12 engagement tables. The live websites never felt it: every read was routed to a read replica, away from customer traffic. A single five-minute incremental run has synced as many as 3.5M new rows.
Read case study

Moodle LMS to BigQuery: Replacing Thousands of Nested API Calls With One Pipeline
A leading dental-industry media company runs its continuing-education programs on a Moodle-based learning management system. Its 1.4M+ enrollment records held the answers to which courses drew learners, who finished them, and how completion trended over time, but none of it reached the company's analytics warehouse. The only route out was course-by-course API calls that could not run at that scale. NeenOpal designed and deployed a Python pipeline on Google Cloud Run that loaded every historical enrollment into Google BigQuery and now refreshes automatically each month. The full monthly run finishes in about 12 minutes, with no manual effort from the client's team.
Read case study

Zoom Events to BigQuery: Capturing the Attendee Data Standard Zoom APIs Miss
A leading dental-industry media company hosts hundreds of webinars a year on Zoom Events. Its reporting showed how many people attended each one, but not who they were. Without attendee-level data, the team couldn't follow up with the right people or connect webinar engagement to the rest of its marketing and CRM data. NeenOpal traced the problem to how Zoom Events is built and found an API route that returns the attendee records the client's own registrants generate. A Google Cloud Run pipeline now loads those records into Google BigQuery and refreshes them every month. The initial load covered more than 200 webinars and identified over 13,000 unique attendees.
Read case study

HubSpot to BigQuery: A Complete CRM History With SCD Type 2 Deal Tracking
A leading dental-industry media company runs its sales and marketing on HubSpot. More than 200,000 activity records sat across contacts, companies, deals, calls, emails, meetings, tasks, notes and SMS, with no automated way to bring them together for analysis. The team also had no way to analyze how deals moved through the pipeline over time. NeenOpal built ingestion pipelines across every major HubSpot object, linked them with 15 association tables and added SCD Type 2 tracking so deal stage history is preserved in Google BigQuery. The pipelines refresh weekly with no manual intervention.
Read case study

Automating Daily Sales and Coil Count Reporting with Tableau Prep and Google Drive
Our client, a steel distributor, started every working day by building its sales and coil reports by hand in Excel. The routine took between thirty and forty five minutes, it had to be repeated each morning, and because the business kept a separate file for each month, there was no single place to look at performance over time. NeenOpal delivered two Tableau Cloud dashboards, one covering daily sales and one covering coil counts, together with a Tableau Prep workflow connected to the client's Google Drive data for an automated daily refresh. Daily reporting now takes about ten minutes instead of roughly thirty seven, a reduction of 73 percent that returns around ten hours to the team every month, and every month of history sits in one view rather than in a file of its own.
Read case study

Building a Validated Conversational Sales Analyst on Amazon Quick for a Managed IT Provider
Our client, a managed IT services provider delivering all-inclusive computer, internet and help desk support to small and mid-sized businesses, already monitored sales opportunities across eight funnel stages in an established Power BI dashboard. Answering deeper questions about stage duration, win rates and trends still meant stacking filters and interpreting the resulting measures. NeenOpal extended that environment with a conversational AI Analyst Agent built on Amazon Quick, connected to the client's opportunity stage funnel dataset in Amazon RDS. Teams now ask questions in plain language and receive summaries, charts and the supporting SQL, cutting the time to a routine answer by 75% and the number of analysis steps by 60%. The depth sits in the foundation: a curated opportunity-stage data model, documented business rules, and answers reconciled with the existing Power BI dashboard month by month and filter by filter, which matched on every indicator tested. Power BI stays exactly where it was.
Read case study

Building a Multi-Capability Retail Customer Support Assistant on Amazon Connect
Our client, a large retail group selling consumer goods, approached NeenOpal for a customer support assistant for its website, along the lines of the conversational shopping assistants the major online marketplaces now offer. The brief arrived as an exhaustive list of capabilities the assistant had to cover, spanning product research, cart building, order tracking, warranty and complaint handling, post-purchase care, and escalation to a human agent. NeenOpal built the assistant as a working proof of concept on Amazon Connect, the first time the team had taken Connect into a customer engagement. A conversational layer handles the dialogue, a governed tool layer gives the assistant controlled access to customer and product information, verified sign-in gates anything account specific, and a handover path passes the full conversation to a live agent when a person is needed. The build went from brief to working demonstration in four weeks.
Read case study

AI-Augmented ETL for Automating Multi-Portal Retail Reporting on AWS
A consumer beauty and personal care brand needed to bring its Walmart and Amazon supplier and performance data into a single AWS RDS PostgreSQL database. Walmart's data was split across a standard supplier API and three separate reporting portals (Retail Link, Scintilla, and Supplier One), each with its own authentication, file formats, and update cadence. NeenOpal designed a hybrid ETL platform with two ingestion paths running in parallel: an orchestrated API pipeline for the data Walmart exposes directly, and an AI-driven report retrieval pipeline for the data that fell outside the scope of the client's existing API access. Both paths converge on a shared Glue transformation layer, a common S3 staging area, and a single PostgreSQL database, with a separate one-time Spark job bringing in Amazon Vendor Central's historical data. The result is a single, config-driven system rather than a set of one-off integrations.
Read case study

Automating Signed Credit Application PDFs with HubSpot Webhooks and AWS Serverless
Our client, a managed technology services provider, partnered with NeenOpal to automate the business credit application its customers complete when applying for credit terms. Until then the whole process ran over email. The team sent the customer a Word form as an attachment, the customer filled in their details and emailed it back, and someone then filed the completed form against the right account in Salesforce. Every application involved a round of back and forth correspondence, manual handling at both ends, and a record that existed only as a document attached to an account. NeenOpal designed and delivered HubSpot form to PDF automation on AWS, a serverless document automation pipeline that replaced the email exchange with a single link on the client's website. A customer opens the form, enters their details, and signs, and a branded PDF is generated automatically, emailed to the address captured on the form and to the client's own team, and archived in encrypted Amazon S3, while the submission itself is recorded field by field in HubSpot. Nobody sends a form out, chases it back, or files it by hand.
Read case study

Tableau Dashboard Development for a US Insurance Organization: 4 Data Sources Unified
Our client, an insurance organization with field teams spread across every US state, partnered with NeenOpal to replace a manual, spreadsheet-driven reporting process with a consolidated Tableau dashboard environment governed by row-level security. Operational data lived in four separate systems covering Airtable, Salesforce, Google Analytics 4, and Google Search Console, and bringing them together meant exporting and stitching the data by hand, which left leadership without a single reliable view of performance. NeenOpal consolidated all four sources into an Azure SQL Server layer, reviewed and corrected the data quality issues that surfaced along the way, and delivered three Tableau dashboards across seven screens that refresh automatically every day. Row-level security was implemented across all fifty states and the independent districts, driven by an entitlement model the client maintains through a single Google Sheet, so every representative sees the states they are responsible for and nothing more.
Read case study

Pavel Motors Automates Vehicle Repair Estimation-to-Quote Process with Claude
For automotive service businesses, moving from a repair estimate to a customer-ready quote quickly is critical, yet the process typically means manually reviewing emails and attachments, extracting repair details, checking insurance eligibility, preparing the quote, and responding to the customer. Pavel Motors partnered with NeenOpal to transform this using Claude Cowork, building an AI automotive repair quote automation solution that connects intake, document understanding, business rules, quote generation, and customer communication: when an estimate arrives by email, Claude Cowork processes it along with its attachments, extracts the relevant vehicle, repair, cost, customer, and insurance information, applies Pavel Motors' business rules, and generates a customer-ready quote while giving customers greater transparency by identifying supported insurance providers and showing the estimated amount eligible for claim coverage. NeenOpal delivered the working automation in 5 days, giving Pavel Motors a scalable way to reduce repetitive administrative work, accelerate quote turnaround, and provide a more consistent customer experience.
Read case study

Unifying Multi-Region Sales Pipeline Analytics with Power BI and Power Query
Our client, a global healthcare company with commercial operations across Africa and Western Europe, partnered with NeenOpal to build a unified sales pipeline dashboard spanning more than six regional teams across two continents. Pipeline data was managed in isolation by each region, reported in inconsistent formats, and pulled from different systems including Salesforce and SAP, leaving leadership without a consolidated view of opportunities, orders, and revenue. NeenOpal designed and delivered a centralized sales pipeline dashboard in Power BI, powered by an automated Excel and Power Query ETL layer, that standardizes data from every region into one live view. The solution tracks each opportunity from lead to shipped order, benchmarks performance against multiple internal targets, forecasts revenue from existing customers, and lets non-technical users refresh the entire report in one to two clicks.
Read case study