REPORT/RECOMMENDATION TO THE BOARD OF SUPERVISORS
OF SAN BERNARDINO COUNTY
AND RECORD OF ACTION
October 24, 2023
FROM
LYNN FYHRLUND, Chief Information Officer, Innovation and Technology Department
SUBJECT
Title
Terms for Business Intelligence Reporting and Data Visualization Software
End
RECOMMENDATION(S)
Recommendation
1. Approve non-financial Standard Visualization License Terms with Microsoft Corporation, including non-standard terms, for the use of business intelligence reporting and data visualization software tools, for the period commencing on the date of first use of the software and continuing until terminated.
2. Approve the Standard Contract updated February 2023, including non-standard terms, to license services, websites, solutions, platforms, and products that are made available by third parties through either Microsoft AppSource or Azure Marketplace for future licensing needs, which may or may not have a cost.
3. Approve non-financial End User License Agreement - Custom Visualizations with CloudScope, LLC, including non-standard terms, for the use of Power Business Intelligence Custom Visualization software, for the period commencing on the date of first use of the software and continuing until terminated.
4. Designate the Chief Information Officer, Assistant Chief Information Officer, or IT Division Chief to electronically accept the Standard Visualization License Terms and End User License Agreement - Custom Visualizations in Recommendation Nos. 1 and 3, with Microsoft Corporation and CloudScope, LLC, respectively, and any future updates, as they pertain to changes to the use of software, subject to review by County Counsel, provided that such updated terms do not substantively modify the terms of the original agreements.
5. Authorize the Purchasing Agent to electronically accept the Standard Contract in Recommendation No. 2 for purchases within the limits set by County Policy, subject to review by County Counsel.
6. Direct the Chief Information Officer, Assistant Chief Information Officer, or IT Division Chief to transmit printed copies of any updated terms to the Standard Visualization License Terms and End User License Agreement - Custom Visualizations in Recommendation Nos. 1 and 3 related to the use of software that are electronically accepted to the Clerk of the Board of Supervisors within 30 days of execution.
(Presenter: Lynn Fyhrlund, Chief Information Officer, 388-5501)
Body
COUNTY AND CHIEF EXECUTIVE OFFICER GOALS & OBJECTIVES
Operate in a Fiscally-Responsible and Business-Like Manner.
FINANCIAL IMPACT
Approval of this item will not result in the use of Discretionary General Funding (Net County Cost). The Standard Visualization License Terms (SVLT), Standard Contract, and End User License Agreement - Custom Visualizations (EULA) are for the use of custom visualizations in the Microsoft Corporation (Microsoft) Power Business Intelligence (Power BI) Platform and do not commit the County to make any purchases. The SVLT and EULA are non-financial in nature. Depending on the third party providing the future license, the Standard Contract may or may not have a cost. If future purchases are made under these agreements, the Innovation and Technology Department (ITD) will adhere to County purchasing policies and return to the Board of Supervisors (Board) for approval, if necessary.
BACKGROUND INFORMATION
The ITD Business Solutions Development Division (Division) develops, maintains, supports, and enhances business applications for hardware and software platforms used by County departments. The Division also consults with County departments to identify ways to increase efficiency through technology, including services such as process reviews, cost analysis, and overall recommendations for the acquisition and integration of new systems. Various departments utilize business intelligence reporting and data visualization software from Microsoft called Power BI, which is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Enhanced visualization tools are available through CloudScope LLC (CloudScope) and will benefit County departments to utilize Power BI to obtain clear messaging and striking visuals.
On June 13, 2023 (Item No. 44), the Board approved Agreement No. 23-554, including non-standard terms, with Microsoft, for access to and use of online marketplaces referred to as Azure Marketplace and AppSource, effective upon acceptance of the online terms and continuing until the online marketplaces are no longer in use by the County. The Microsoft Azure Marketplace and AppSource are online stores that features a broad range of information technology software applications and services from Microsoft and various third-party publishers (Publisher), including basic visualization tools in the Microsoft Power BI platform.
Approval of Recommendation Nos. 1 and 2 with Microsoft SVLT and the Standard Contract, for use with Microsoft AppSource or Azure Marketplace for the visualization software, will provide County departments with enhanced visualization tools that have been developed to provide clear messaging and striking visuals for reports and dashboards in Power BI. Specifically, these will allow County Power BI report makers additional options for their reports and dashboards. Many of these visualization tools have non-standard terms which are included as part of the SVLT and Standard Contract in Recommendation Nos. 1 and 2. The Standard Contract has been created by Microsoft to facilitate a transaction between Publishers and customers.
CloudScope’s visuals focus on enhancing the presentation of reports and dashboards. Users can add relevant images to enhance the impact of reports to generate more engagement with their audience. Approval of CloudScope’s EULA referenced in Recommendation No. 3 will allow the Division to provide enhanced visualization options to County departments for Power BI reports and dashboards through CloudScope. Currently, ITD is partnering with the Project and Facilities Management Department (PFMD) to develop a Capital Improvement Program dashboard that informs departments of the status, available budget, and other important items regarding their projects, giving departments and the public visibility into County projects. As part of this project, the departments selected CloudScope based on the available functionality of the software.
The SVLT is Microsoft’s standard commercial contract, which includes terms that differ from the Standard County contract and omits certain County standard contract terms. The SVLT is a non-negotiable clickwrap agreement accepted when downloading the software. The non-standard and missing terms include the following:
1. Governing law of the SVLT is the State of Washington.
• The County standard contract requires California governing law.
• Potential Impact: The SVLT will be interpreted under Washington law. Any questions, issues or claims arising under the SVLT will require the County to hire outside counsel competent to advise on Washington law, which may result in fees that exceed the total SVLT amount.
2. Microsoft may assign the SVLT without notice to the County and without the County’s approval.
• The County standard contract requires that the County must approve any assignment of the contract.
• Potential Impact: Microsoft could assign the SVLT to a third party or business with which the County is legally prohibited from doing business due to issues of Federal debarment or suspension and conflict of interest, without the County’s knowledge. Should this occur, the County could be out of compliance with the law until it becomes aware of the assignment and terminates the SVLT. County Counsel cannot advise on whether and to what extent Washington law may permit or restrict a party’s right to assign without an express provision in the SVLT.
3. There is no provision in the SVLT addressing each party’s responsibility for paying attorneys’ fees.
• The County standard contract requires each party to bear its own costs and attorney fees, regardless of who is the prevailing party.
• Potential Impact: County Counsel cannot advise on, whether, and to what extent, Washington law may affect a party’s requirement to pay the prevailing party’s attorneys’ fees and costs in a legal action where no specific provision is provided in the SVLT.
4. The SVLT does not require Microsoft to indemnify the County, as required by County Policies 11-05 and 11-07, including for intellectual property infringement claims.
• The County standard contract indemnity provision requires the contractor to indemnify, defend, and hold the County harmless from third party claims arising out of the acts, errors, or omissions of any person. The standard contract provision for intellectual property indemnity is: Contractor will indemnify, defend, and hold harmless County and its officers, employees, agents and volunteers, from any and all third party claims, costs (including without limitation reasonable attorneys’ fees), and losses for infringement of any United States patent, copyright, trademark or trade secret (Intellectual Property Rights) by any goods or services.
• Potential Impact: Microsoft is not required to defend, indemnify, or hold the County harmless from any claims, including indemnification for claims arising from Microsoft’s negligent or intentional acts and intellectual property infringement. If the County is sued for any claim, including intellectual property infringement based on its use of Microsoft’s software or services, the County may be solely liable for the costs of defense and damages, which could exceed the total SVLT amount. County Counsel cannot advise on whether and to what extent Washington law may allow the County to require Microsoft to defend or indemnify it absent an express provision in the SVLT.
5. The SVLT does not require Microsoft to meet the County’s insurance standards as required pursuant to County Policies, 11-05, 11-07 and 11-07SP.
• County policy requires contractors to carry appropriate insurance at limits and under conditions determined by the County’s Risk Management Department and as set forth in County policy and in the County standard contract.
• Potential Impact: The County has no assurance that Microsoft will be financially responsible for claims that may arise under the SVLT, which could result in expenses to the County that exceed the total SVLT amount.
6. Microsoft limits its maximum liability under the SVLT to direct damages up to the amount the County paid for the visualization or $1.00, whichever is greater, without exclusion.
• The County standard contract does not include a limitation of liability.
• Potential Impact: Claims could exceed the liability cap and the SVLT amount leaving the County financially liable for the excess. County Counsel cannot advise on, whether and to what extent, Washington law may limit or expand the exclusion of limits to the extent prohibited by applicable law.
7. There is no stated venue in the SVLT.
• County Policy 11-05 requires venue for disputes in Superior Court of California, County of San Bernardino, San Bernardino District.
• Potential Impact: Microsoft is located in King County, Washington. Having no express venue in the SVLT means that King County, Washington venue could be applied to disputes arising under this SVLT, which may result in additional expenses that exceed the amount of the SVLT.
8. Microsoft provides the software “AS-IS”, “with all faults”, and “as available” with all risk of loss on the County.
• County Policy 11-05 requires a contractor to fully warrant its services and products.
• Potential Impact: The County’s use of the software is solely at its own risk. County Counsel cannot advise on whether and to what extent Washington law may limit or expand the disclaimers of warranty to the extent prohibited by applicable law.
The Standard Contract has been created by Microsoft to facilitate a transaction between the Publishers and customers. Microsoft is not a party to the Standard Contract. It is between the County and the Publisher.
1. The Publisher may assign the Standard Contract in connection with a merger, reorganization, acquisition or other transfer of all or substantially all of its assets without notice to the County and without the County’s approval.
• The County standard contract requires that the County must approve any assignment of the contract.
• Potential Impact: Publisher could assign the Standard Contract to a third party or business with which the County is legally prohibited from doing business due to issues of Federal debarment or suspension and conflict of interest, without the County’s knowledge. Should this occur, the County could be out of compliance with the law until it becomes aware of the assignment and terminates the Standard Contract with the Publisher.
2. Under the Standard Contract, the County is required to indemnify a Publisher against all third party claims arising from the County’s or its authorized user’s violation of the Standard Contract or user terms, including all reasonable attorney’s fees, damages, and other costs finally awarded against Publisher or under a settlement.
• The County standard contract does not include any indemnification or defense by the County of a contractor.
• Potential Impact: By agreeing to indemnify Publishers, the County could be contractually waiving the protection of sovereign immunity. Claims that may otherwise be barred against the County, time limited, or expense limited could be brought against the Publishers without such limitations and the County could be responsible to reimburse Publishers for costs, expenses, and damages, which could exceed the total contract amount.
3. The Standard Contract does not require a Publisher to meet the County’s insurance standards as required pursuant to County Policies 11-05, 11-07 and 11-07SP.
• County policy requires contractors to carry appropriate insurance at limits and under conditions determined by the County’s Risk Management Department and as set forth in County policy and in the County standard contract.
• Potential Impact: The County has no assurance that any Publisher will be financially responsible for claims that may arise under the Standard Contract, which could result in expenses to the County that exceed the total contract amount.
4. For offerings orders on a subscription basis, a Publisher’s liability under the Standard Contract is limited to the amount paid by the County for the offering during the 12 months before the incident or $500,000, whichever is greater, and for any unauthorized access, use, or disclosure of County data due to a breach of a Publisher’s security obligations two times the amount the County paid for the Offering during the 12 month before the incident or $2,000,000, whichever is greater. For free offerings, a Publisher’s maximum liability is $5,000. These limits exclude Publisher’s confidentiality obligations, defense obligations, violation of County’s intellectual property rights, and gross negligence, willful misconduct, or fraud.
• The County standard contract does not include a limitation of liability.
• Potential Impact: Claims could exceed the liability cap and the contract amount leaving the County financially liable for the excess.
5. There is no stated venue in the Standard Contract.
• County Policy 11-05 requires venue for disputes in Superior Court of California, County of San Bernardino, San Bernardino District.
• Potential Impact: Having no express venue in the Standard Contract means that venue could be applied to disputes arising under the Standard Contract to any jurisdiction where the Publisher has significant contacts, which may result in additional expenses that exceed the amount of the Standard Contract.
The EULA is CloudScope’s standard commercial contract, which includes terms that differ from the Standard County contract and omits certain County standard contract terms. The EULA is a non-negotiable clickwrap agreement accepted when downloading the software. The non-standard and missing terms include the following:
1. CloudScope may assign the EULA without notice to the County and without the County’s approval.
• The County standard contract requires that the County must approve any assignment of the contract.
• Potential Impact: CloudScope could assign the EULA to a third party or business with which the County is legally prohibited from doing business due to issues of Federal debarment or suspension and conflict of interest, without the County’s knowledge. Should this occur, the County could be out of compliance with the law until it becomes aware of the assignment and terminates the EULA.
2. The EULA does not require CloudScope to indemnify the County, as required by County Policies 11-05 and 11-07, including for intellectual property infringement claims.
• The County standard contract indemnity provision requires the contractor to indemnify, defend, and hold the County harmless from third party claims arising out of the acts, errors, or omissions of any person. The standard contract provision for intellectual property indemnity is: Contractor will indemnify, defend, and hold harmless County and its officers, employees, agents and volunteers, from any and all third party claims, costs (including without limitation reasonable attorneys’ fees), and losses for infringement of any United States patent, copyright, trademark or trade secret (Intellectual Property Rights) by any goods or services.
• Potential Impact: CloudScope is not required to defend, indemnify or hold the County harmless from any claims, including indemnification for claims arising from CloudScope’s negligent or intentional acts and intellectual property infringement. If the County is sued for any claim, including intellectual property infringement based on its use of CloudScope’s software or services, the County may be solely liable for the costs of defense and damages, which could exceed the total EULA amount.
3. The EULA does not require CloudScope to meet the County’s insurance standards as required pursuant to County Policies 11-05, 11-07 and 11-07SP.
• County policy requires contractors to carry appropriate insurance at limits and under conditions determined by the County’s Risk Management Department and as set forth in County policy and in the County standard contract.
• Potential Impact: The County has no assurance that CloudScope will be financially responsible for claims that may arise under the EULA, which could result in expenses to the County that exceed the total EULA amount.
ITD recommends approval of the SVLT, the Standard Contract, and the EULA including the non-standard terms, to provide County departments with the tools necessary to enhance their online reports and dashboards for both internal and external customers.
PROCUREMENT
All the visualization tools in the SVLT and EULA are free to use, with some offering premium features for a fee. The visualization tools under the Standard Contract may or may not have costs associated, depending on the third party providing a future license as needed. The SVLT, Standard Contract, and EULA, including non-standard terms, will be used to accompany future purchase orders to be approved, as necessary, per County Policy 11-04, Procurement of Goods, Supplies, Equipment, and Services, provided that Microsoft, the Publisher and CloudScope do not substantively modify the terms.
Microsoft, and the Standard Contract were selected as they provide options to various visualization tools under one SVLT, or Standard Contract without the need to sign various agreements with numerous business intelligence software producers. CloudScope was selected as it offers several visualization options to County departments under one standard agreement.
Purchasing agrees with the non-competitive selection process utilized by ITD and acknowledges that ITD will conform to Policy 11-04, as noted above, for any purchases that may result from utilization of enhanced application programs.
REVIEW BY OTHERS
This item has been reviewed by County Counsel (Bonnie Uphold, Supervising Deputy County Counsel, 387-5455) on September 13, 2023; Purchasing (Tevan Stremel, Buyer III, 387-2098) on August 21, 2023; Risk Management (Victor Tordesillas, Director, 386-8623) on August 30, 2023; Finance (Ivan Ramirez, 387-4020, and Abigail Grant, 387-4603, Administrative Analysts) on October 2, 2023; and County Finance and Administration (Paloma Hernandez-Barker, Deputy Executive Officer, 387-5423) on October 5, 2023.