Power BI Template

Power BI Template

Power BI is a powerful business intelligence (BI) tool developed by Microsoft. It transforms raw data into meaningful insights through interactive visualizations and reports. BoviSync has developed Power BI templates for accessing the BoviSync Performance Data Link in the Snowflake Marketplace. The Power BI templates are meant to get developers a head start with context and relationships of the data available in the BoviSync Performance Datalink. Enhancements are provided to showcase different features and patterns in Power BI. Unconditional permission is provided to users of these templates to modify, change, and utilize for their own intended purposes. 

Prerequisites

  1. BoviSync Team
  2. Snowflake Account
  3. Permission Grant to teams from farms
  4. Power BI Desktop
  5. Power BI Pro (recommended)

Instructions

Download and Install Power BI Desktop
Open the template
Fill out parameters (must match Snowflake info):
      Snowflake Role:  SYSADMIN
      Warehouse:  COMPUTE_WH
      Database: BOVISYNC_PERFORMANCE_DATA_LINK
      Server: company-account.snowflakecomputing.com
Authenticate to Snowflake

Info
Several options exist for secure authentication to Snowflake from Power BI. Snowflake accounts are encouraged to setup SSO. For more information: Power BI SSO to Snowflake | Snowflake Documentation

The Power BI templates will load data through the Snowflake Account with the correct parameters and successful authentication. If there is an error review the parameters including access by role and the users access to that role. 

Filtering data is recommended to reduce the size, speed, and cost of queries. Data queries may be filtered directly in Power Query to exclude extra columns, dates, et cetera. 

Power BI Desktop is all that is needed to access the template. However, the best experience for users will be in the Power BI service. 

Templates

Performance_Data_Link_Template_2024-11-04.pbit
  1. Instructions: Fill out parameters per the instructions above and connect to Snowflake
  2. Versions
    1. 2024-10-29 - added navigation menu and sliding drawers
    2. 2024-11-04 - added event drill through, genetics summary, and updated navigation

Alert
The data provided via the BoviSync Performance Data Link are snapshots of farm data. It is provided as a service to companies for serving our mutual customers. Companies are only able to access information to animals located or owned by BoviSync Farm Accounts that have granted team permission. Removal of the team permission will end access to information beyond the date revoked. 
Warning
The templates are provided AS-IS. No warranties or guarantees are provided for the calculations in Power BI. Paid support is offered for supporting the Power BI and the BoviSync Performance Datalink. 

    • Related Articles

    • BoviSync Performance Data Link

      BoviSync provides insights for dairies and the companies that serve them. Team Accounts are the portal for companies to access their customer information. As a feature, we are interested in providing more powerful connections to BoviSync such as the ...

    • Connect R to the BoviSync Performance Data Link in Windows

      What is the R-Project? R is a free, open-source programming language and software environment designed specifically for statistical computing and graphics. It was created by statisticians and is widely used by data analysts, data scientists, and ...

    • Import Milk Weights (FTECH)

      To import milk weights only into BoviSync follow the instructions below: Written Instructions: If you are using FTECH, this command will get the same file as steps 1-4: SETUP\5RHERDCODE.CSV!EVENTS\4HS20!SETUP\5P!SETUP\4 If you do this command, you ...

    • Select Sires Pedigree Rank Import

      This guide will walk through the process of importing a Select Sires Pedigree Rank file. Once you have the file it is pretty straightforward to import it. The file must be a .CSV file and have the following headers (shown below). There is an example ...

    • Importing Mating Files (Genex, Alta, Select Sires, Semex, ST Genetics)

      Manual import of Mating Files: 1. Log in to BoviSync 2. Navigate to BoviSync Import page (Setup > Import) 3. Select the appropriate mating file type from the list (Figure: 1) 4. Click 'Choose File' and browse for the mating file (Figure: 2) 5. Click ...