In 2006, online travel agency redBus introduced internet bus ticketing in India, unifying tens of thousands of bus schedules into a single booking operation. (Think of it as Expedia for bus booking.) Using BigQuery, redBus crunches terabytes of booking and inventory data in mere seconds and at a fraction of the cost of other big data services. BigQuery also helps engineers fix glitches quickly, minimize lost sales, and improve customer service.

Challenge

Executives at the Bangalore-based redBus needed a powerful tool to analyze booking and inventory data across their system of hundreds of bus operators serving more than 10,000 routes. They considered using clusters of Hadoop servers to process the data but decided the system would take too much time to set up and would require a specialized staff to maintain it. It also would not provide the lightning-fast analysis they needed.

“It would have taken at least a couple of hours to analyze anything,” says Pradeep Kumar, a technical architect at redBus. “Crunching very large data sets would have been a day’s job. We needed something more powerful to get the real-time analysis we were looking for.”

Solution

Kumar and his colleagues learned about BigQuery and realized it was the right match for their data processing needs. The web-based service, which enables companies to analyze massive datasets using Google’s data processing infrastructure, is easy to set up and manage since its simple, SQL-like query language doesn’t require complex technology or specialized personnel. It also has low overhead costs.

The redBus team uses BigQuery as part of an intricate data collection and analysis process. Applications hosted on a range of servers continually pump information related to customer searches, seat inventory, and bookings into a centralized data collection system. Engineers upload the data to BigQuery, which provides answers to complex queries within seconds. For example, BigQuery helps redBus staff:

• Learn how many times customers searched for seats and found none or very few available, indicating more seats should be added to a route
• Investigate decreases in bookings and notify engineers if a technical problem is the cause
• Identify server problems by quickly analyzing data related to server activity

Results

BigQuery provides near real-time data analysis capabilities at 20% of the cost of maintaining a complex Hadoop infrastructure. Queries that would have required a day to analyze on a Hadoop framework take less than 30 seconds using Google’s web-based service.

“We explored several data analytics solutions. Nothing comes remotely close to the sheer power of Google BigQuery,” Kumar says. “It made large-scale data collection and crunching possible with little effort, which has translated to a significant business advantage.”

Google Cloud Platform results

• Analyzes data sets as large as 2 terabytes in less than 30 seconds using a simple, SQL-like language
• Saves time analyzing technical problems and customer booking trends
• Spends 80% less than they would have on a Hadoop infrastructure and avoids setting up and maintaining a complex infrastructure in-house
• Strengthens the company by improving customer service and engineering quality

The fast insights gained through BigQuery are also making redBus a stronger company. By minimizing the time it takes staff members to solve technical problems, BigQuery has helped improve customer service and reduce lost sales.

“Getting to the root of problems used to be really time-consuming,” Kumar says. “By the time we figured it out, customers might have given up. Now if there are booking problems, BigQuery helps us understand the reason right away. Choosing Google BigQuery was the right decision for our company.”

Editor’s note: Prevision.io has built the first ever pay-as-you-go AI management platform that simplifies the machine learning project lifecycle while offering powerful analytics capabilities. Now available exclusively on Google Cloud Marketplace, users can experiment, build, deploy, and manage AI projects in the cloud in weeks—without having extensive data science knowledge.

Similar to the momentum that cloud technology has had in the business world, AI and machine learning are quickly becoming essential to the enterprise. 86% of companies now view AI as a “mainstream technology,” and corporate AI adoption rose 50% in 2021 from the year prior for initiatives such as service-operations optimization and product enhancement. But for companies that don’t fall into the Fortune 500, initiating AI projects can come with several challenges, ranging from one-size-fits-all subscription models to skills gaps and resource-heavy monitoring requirements.

My team of data scientists saw a real need for software that could democratize machine learning innovation by removing these common barriers. We knew that features like automation could make building and deploying AI much more doable for other data scientists, as well as citizen data scientists. So, we launched Prevision.io, a first-of-its-kind dedicated AI management platform built on Google Cloud and now available exclusively on Google Cloud Marketplace.

As a Google Cloud Partner Advantage Member, we knew the benefits of an elastic infrastructure, full integration with BigQuery, and access to a large library of complementary tools, such as Kubeflow on Google Cloud. As a result, it’s easier for our users to improve upon their robust AI projects.

Set up in minutes, deploy a machine learning model in weeks

Users can start building and deploying models in Prevision.io immediately after subscribing through Google Cloud Marketplace. Instead of taking weeks to onboard and months to launch a real-world model into production, Prevision.io’s intuitive interface and powerful predictive analytics capability makes it possible to set up in minutes–and have models up and running in three to four weeks. Since we believe in cost-efficient scaling, our platform operates on a pay-as-you-go model with no long-term contracts, licensing, or per-user fees.

Simply connect Prevision.io with your data–whether it exists in buckets or in an SQL data source like BigQuery. No matter your data source, set up is quick. There are even tutorials to help if you’re using APIs. Follow this tutorial for step-by-step set up details in Google Cloud.

Once historical data is imported, you can start applying your own models inside Prevision.io, or use Prevision.io to build a bespoke model. There’s more good news: expenditures on Prevision.io’s platform are applied toward customers’ Google Cloud spend commitments.

Full lifecycle AI project management made easy

By automating the complexity of AI project management with a no-code approach, businesses do not have to add more data scientists to their teams, risk data drift or outdated models, spend hundreds of thousands on unused software, or massively expand IT budgets. By connecting BigQuery or other datastores to Prevision.io, you can launch high-performing machine learning projects and manage them across the entire lifecycle. With Prevision.io you can:

• Experiment with iteration and optimization to get an effective model into production from the start. Track performance and compare versions to identify the most reliable model. Because there is no infrastructure to manage, users can focus only on the project and see ROI sooner.
• Automate training and prediction tasks to improve collaboration, reduce time-consuming manual operations, and boost results. Users can implement automation across the production pipeline with built-in features like AutoML and a scheduler for recurring tasks. Retrain automations and integrate custom code to keep processes aligned and relevant.
• Deploy scalable working models securely and reliably in one-click. Tailor deployments using REST APIs or as a component to generate batch predictions. Create dashboards to share with stakeholders, and swiftly update your model without worrying about service interruptions or breakages.
• Monitor infrastructure and model behavior to understand resource utilization and how data changes over time—without requiring more of IT. Put an end to endless maintenance meetings with reliable, real-time monitoring applications around drift, data in-and-out, and prediction distribution. If an issue arises, Prevision.io provides detailed alerts and analysis to understand the root of a problem.

Any business can benefit

Regardless of industry or department, we’ve seen Prevision.io help businesses solve some of their biggest challenges. Utilities companies are relying on better forecasts of the energy consumption (gas or electricity).. Transportation companies have deployed machine learning models that can inform logistical operations based on fluctuating supply and demand. Doing more with data not only improves what a business can offer their customers but can also yield significant savings. Here are a few real-life examples:

La Poste: delivery data saves the day
Global delivery company La Poste was having trouble meeting customers’ demand for speed and visibility, and inaccurate estimated arrival times for packages was costing them money. The team wanted to put its tracking and tracing data to work, and turned to Prevision.io to select technical metrics, set up personalized machine learning models for delivery rounds of all personnel, and speed up the iteration and training process. After deploying its model in four weeks, La Poste achieved an 89% accuracy rate for delivery times and saw a 10x improvement in IT infrastructure and operational costs. And of course, happier customers who keep coming back.

BPCE: machine learning helps us help our clients
An arm of BPCE Group, the second largest banking group in France, was feeling the effects of the pandemic’s impact on customers. It needed a more efficient way of determining who would need what type of help—and when–to reduce the number of customers entering the collections process. Using its wealth of data to create and deploy a machine learning model in Prevision.io, the firm was able to rapidly identify the most at-risk customers and better understand the root causes behind potential debt default—some of which are easily fixable. As a result, the firm has seen a fifteen-fold increase in the sums they have been able to recover, and decreased the number of collection cases by 50%.

Pharmaceutical company: marketing medicine with MLOps
The marketing department at a healthcare company serving pharmacies was able to reduce customer churn and improve growth by using Prevision.io to compute market segmentation based on anticipated customer revenue. This helped the company determine the best way to engage with each pharmacy—and when. Being able to make strategic decisions based on automated predictions and more targeted data saved the company $1.3M Euros in two fiscal quarters.

See how AI project management and MLOps made easy can transform your business. Access Prevision.io on Google Cloud Marketplace and take advantage of the 14-day free trial.