January 24, 2024 — OWOX BI BigQuery Reports extension: Save up to 91% on your monthly data processing cost with our new cost-efficient scheduler


Today, we unveil our enhanced and refined data auto-refresh scheduler, a tool that strikes the perfect balance between timely data updates and resource efficiency.

What’s the problem?

In the fast-paced world of marketing and business management, having access to fresh data is crucial for making informed, strategic decisions. However, data analysts are equally aware of the importance of managing this need in a resource-efficient manner. At OWOX BI, we align with our users' needs and understand the delicate balance between frequent data updates and cost savings.

Our updated scheduler introduces nuanced control over your data refresh timings, helping you eliminate unnecessary executions and thereby reduce your data processing costs. Let’s dive into the new features and their benefits.

Enhanced frequency options and time settings

The scheduler retains its versatile frequency options: Hourly, Daily, Weekly, and Monthly. We've refined the Hourly option, adding an adjustable interval setting. Now, you can set data refreshes at 1, 2, 3, 4, 6, 8, or 12-hour intervals. Additionally, we've included a timezone display in the scheduler settings, ensuring clarity on when exactly your data will be updated.

Let's look at the example below for Hourly updates:


Multi-selection capability in time periods

The Daily, Weekly, and Monthly update settings continue to offer choices for Days and Time periods. In this update, we've added a multi-selection feature. For instance, you can now easily select Monday, Wednesday, and Friday for Weekly updates, scheduling them for both morning and evening slots (e.g., 4 AM - 5 AM and 8 PM - 9 PM). This new multi-selection functionality opens up broader possibilities for customizing your data refresh schedule, allowing precise adjustments to avoid unnecessary executions that can consume a portion of your Google BigQuery costs.

Below is an example for Daily updates:


An example for Weekly updates:


And finally, look at the example for Monthly updates:


Scenarios for cost-efficient data refreshing

Let's explore some scenarios where our new scheduler can lead to significant cost savings in data processing:

  • Data refresh 2 times per day: Previously, setting up hourly data refreshes resulted in 24 updates per day. Now, refreshing every 12 hours reduces this to just 2 updates per day, saving 91% of your monthly data processing costs.
  • Morning updates on weekdays: Before, choosing the “Everyday” option meant 7 updates per week. With the new scheduler, you can set updates for just the weekdays, reducing to 5 updates per week and saving 28% of your monthly costs.

For any queries about data refreshing, feel free to contact our Support team at bi@owox.com. We're here to help you make the most of these new features.

Happy scheduling with OWOX BI!

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.