Reporting options in BoviSync: features and limitations

Reporting options in BoviSync: features and limitations

Introduction

BoviSync is a leading herd management platform designed to streamline dairy farm operations. It not only supports daily management and compliance but also offers powerful reporting capabilities to drive informed decisions on your farm. 
Unlike many other herd management systems, BoviSync goes beyond static standard reports by offering highly customizable reporting features, enabling dairy farms to tailor insights into their specific goals. BoviSync Reporting features:
  1. Create reports filtered by herd groups, event types, reproductive status, and management metrics.
  2. Reports can be saved at the user, farm, or team level.
  3. Export any report to csv for further custom analysis, pivot tables, or integration into other tools like Excel. 
  4. Export to Pdf for printing and sharing reports.
  5. Schedule any BoviSync reports to run and download to local computer
Web reports are limited to 1,000,000 cells maximum and 5-minute time-out in web reports. Some calculated values will reduce the cell limits i.e. BV_305 items.
It is important to understand how reporting works within BoviSync, why some limitations exist in standard reports, and how BoviSync’s customizable tools empower you to overcome these limitations.

Why Are There Reporting Limitations?

  1. Operational Focus: BoviSync’s primary design is for efficient herd data entry, event tracking, and compliance management. Reporting is optimized to provide the most common metrics needed for day-to-day herd and reproductive management.
  2. Data Integrity and Depth: BoviSync standardizes raw data and then enables deep and complex querying of the raw data.  Additionally, it allows time travel to see the current state on historical dates. These key functions increase compute time and cost.
  3. Performance Considerations: Running large or highly complex queries synchronously can result in web/api request timeouts. Standard reports are designed to maintain optimal performance.
  4. Standardization and Flexibility: Standard reports ensure consistent definitions and calculations across herds and users, reducing confusion and ensuring benchmarks are accurate. All reports and requests can be modified to include much greater volumes of data and complexity of queries.

How BoviSync Overcomes These Limitations

BoviSync provides multiple avenues for accessing information

Custom Report – Auto Downloads

Reports generated asynchronously (e.g. auto-downloads) are not limited per se, but BoviSync only supports reports up  20-minute generation time. Note that limits will be imposed on individuals and companies on total server usage. Auto downloads can be scheduled to any Windows computer or available through the web interface. Here are some recommended practices for working with Auto downloads.

API Access and Integrations

For farms utilizing other business software, API enables integration with:
  1. Farm financial systems
  2. Feeding software
  3. Parlor software
  4. Activity monitoring software
Limitations of API:
  1. API usage requires building and maintaining interfaces 
  2. Rate-Limiting is API usage. Frequent and intensive queries are discouraged
Cloud based activity monitoring systems utilize the api on demand to update to the current status of animals. This is the best tool for getting the current status of animals with a limited data scope. 

Private Snowflake Data Share 

BoviSync offers a private Snowflake data share, giving your organization direct access to your full dataset in a secure and scalable cloud data warehouse environment.
Benefits include:
  1. Near real-time data availability without manual exports
  2. Ability to run complex queries and analytics without impacting BoviSync operational performance
  3. Integration with your existing BI tools (e.g. Power BI, Tableau) for automated dashboards
  4. Merging BoviSync data with financial, feed, and environmental data for comprehensive farm business analysis
Requirements/limitations:
  1. Requires BoviSync Team Account and Snowflake account
  2. Users are responsible for Snowflake charges
  3. Limited built-in reporting tools
This option is ideal for enterprise groups seeking seamless data pipelines for advanced reporting, machine learning, or multi-farm benchmarking. Snowflake provides analytical data warehouses to feed tools like Power BI. This is the best solution for querying historical information in a repeatable fashion. Snowflake is updated to the previous day.

Final Thoughts

BoviSync standard reports deliver reliable and consistent metrics essential for daily management. However, its powerful custom reporting capabilities, private Snowflake data share, and integrations allow progressive dairy farms to go beyond limitations, unlocking deep insights to improve herd performance, profitability, and sustainability.
If you need assistance setting up advanced reports, Snowflake access, or API integrations to maximize your farm’s data, contact your BoviSync support team for tailored solutions.

    • Related Articles

    • BoviSync API Best Practices

      Before starting to consume the BoviSync API, it is recommended you create a user account and get familiar with the Bovi-Insights reporting that is the reporting UI that is fed by the BoviSync API. In doing this you will be able to answer your own ...
    • Download Size Limits

      BoviSync provides the ability to schedule automated report downloading to specific directories on your computer. This functionality can be very helpful for doing data analysis with other software programs. Sometimes there is a need for merging larger ...
    • Add variables to auto downloaded report names

      As of 7/8/19 there is a new feature which allows you to add certain variables to auto downloaded reports. This can be helpful when looking at many reports with the same name. This will provide some differentiation for users looking at these reports. ...
    • Download Report without Installing a Data Client

      This KB article will walk through the process of downloading any report on farm to your local computer. You do not need to have the BoviSync data service installed on your computer but you will need to have a linked computer setup. Setup a Linked ...
    • Using Report Manager to auto download reports

      Report Manager can be used to categorize your reports and to manage your auto downloads. Please see the video below as an example.