HomeMy WebLinkAbout2024-07-23; City Council; ; Annual Subscription Renewal of Tableau SoftwareCA Review AZ
Meeting Date: July 23, 2024
To: Mayor and City Council
From: Scott Chadwick, City Manager
Staff Contact: Maria Callander, Information Technology Director
maria.callander@carlsbadca.gov, 442-339-2454
David van Gilluwe, Data Science and Business Intelligence Manager
david.vangilluwe@carlsbadca.gov, 442-339-5992
Subject: Annual Subscription Renewal of Tableau Software
Districts: All
Recommended Action
Adopt a resolution authorizing the City Manager or designee to purchase the Tableau software
subscription renewal from Solutions Simplified, Inc. for an amount not to exceed $232,789 for
a one-year term ending July 31, 2025.
Executive Summary
Tableau analytics software enables city staff across the organization to access and build
analysis products, extract valuable insights and understand operational patterns and trends.
Use of Tableau has grown within the organization in the past two years due to an increased
demand for data-driven decision-making. With Tableau, non-technical staff members can
perform their own analyses and create data-rich dashboards. The renewal of the existing
Tableau contract includes an increase in licensing that provides additional capacity to publish
real-time data insights and create public-facing dashboards. This will allow for greater
transparency and public understanding of city operations.
Solutions Simplified, Inc. provides for the procurement of licenses and subscription services for
both the Tableau internal and public-facing portal solutions. The subscription is an annual
renewal, with a cost of $232,789. The current licensing is set to expire on July 31, and with this
renewal, the term will end on July 31, 2025. The renewal includes an increase of more than 20
new Tableau licenses.
In keeping with Carlsbad Municipal Code Section 3.28.060(D)(5) relating to the procurement of
professional services and services, City Council approval is required because the subscription
renewal will cost more than $100,000 per agreement year.
July 23, 2024 Item #2 Page 1 of 10
Explanation & Analysis
Data-driven decision-making allows organizations to move away from traditional intuition-
based decision-making and instead rely on empirical evidence and statistical analysis. By
analyzing data, organizations can uncover hidden patterns, detect anomalies, and make
predictions with a higher level of accuracy. This, in turn, helps to reduce risks, optimize
processes and improve overall business performance.
Tableau is a powerful and widely used data visualization and business intelligence software
that allows city staff to transform complex datasets into interactive and visually appealing
dashboards, reports, and charts. It provides an easy to learn interface that enables individuals,
regardless of their technical expertise, to explore and analyze data intuitively and effectively
communicate their findings to a broader audience. Tableau has become an essential tool for
city staff to unlock the value of the city’s data and drive meaningful outcomes.
The city has been using Tableau internally for several years and in early fiscal year 2023-24, it
expanded to an enterprise-wide subscription license. The city is also piloting the further
expansion of the software to provide access to community members with a public-facing
portal subscription.
The addition of a public-facing portal will help provide data analytics and visualization for
external users. The additional licensing and functionality are necessary to efficiently publish
information about key city priorities associated with the City Council’s 5-Year Strategic Plan
and departmental activities. With the existing subscription, there are technological issues and
inefficiencies that hinder regularly publishing data from existing Tableau products for external
use.
Solutions Simplified is the current reseller through which the city has purchased its two
Tableau subscriptions. Renewal of the Tableau subscriptions from Solution Simplified would be
purchased through a cooperative purchasing agreement, in compliance with Carlsbad
Municipal Code, Chapter 3.28.100 - Cooperative Purchasing.1 Solutions Simplified is an
authorized reseller and provides products and technology services under the California
Software Licensing Program Agreement No. SLP-20-70-0181J, Amendment No. 1.2
The cost of this purchase was quoted from that contract. Carlsbad Municipal Code Section
3.28.100, Cooperative Purchasing, gives the city purchasing officer the authority to join with
other public or quasi-public agencies in cooperative purchasing plans or programs for the
purchase of goods or services when determined by the purchasing officer to be in the city’s
best interest. The purchasing officer may buy directly from a vendor at a price established by
another public agency when the other agency has made its purchase in a competitive manner.
The Purchasing Officer’s memo authorizing this renewal under the cooperative purchasing
agreement is attached as Exhibit 2.
1 Cooperative purchasing is when an agency uses an existing procurement contract from another agency as the
justification and documentation to create its own contract to purchase the same or similar items or services.
Government agencies often use such cooperative purchasing agreements to reduce the costs of procurement.
2 The Software Licensing Program is a State of California program that provides extensive software discounts
through negotiations with major software publishers that are then passed on to the state, through SLP contracts
established with authorized participating re-sellers. These contracts are available to California's state, county,
city, special district, education, and other government entities to buy directly from the supplier.
July 23, 2024 Item #2 Page 2 of 10
Fiscal Analysis
The annual cost of the Tableau subscriptions and additional licenses with Solutions Simplified
is not to exceed of $232,789 for the term ending on July 31, 2025.
Funding for the annual payment for the internal licenses is included in the fiscal year 2024-25
Information Technology Department’s operating budget in the amount of $232,789.
Additional funds were added to fiscal year 2024-25 Information Technology Department’s
operating budget during the budget process as part of the continuing effort to expand data-
driven decision-making throughout the city and to meet increased internal demand with
additional licensing.
Fiscal Year 2024-25
Information Technology Dept. Operating Budget
Existing internal licensing $215,475
Additional 20 licenses to expand data-driven decision-making $17,314
Total licensing costs $232,789
Staff recommend adoption of the resolution authorizing the City Manager to purchase Tableau
at a cost of $232,789 for fiscal year 2024-25.
Next Steps
With the City Council’s approval, staff will execute the necessary documents to purchase the
Tableau subscription renewal from Solutions Simplified, Inc.
Environmental Evaluation
This action does not constitute a project within the meaning of the California Environmental
Quality Act under California Public Resources Code Section 21065 in that it has no potential to
cause either a direct physical change in the environment or a reasonably foreseeable indirect
physical change in the environment and therefore does not require environmental review.
Exhibits
1. City Council resolution
2. City Purchasing Officer’s memo
July 23, 2024 Item #2 Page 3 of 10
Exhibit 1
RESOLUTION NO. .
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CARLSBAD,
CALIFORNIA, AUTHORIZING THE CITY MANAGER OR DESIGNEE TO
PURCHASE THE TABLEAU SOFTWARE SUBSCRIPTION RENEWAL FROM
SOLUTIONS SIMPLIFIED, INC. FOR AN AMOUNT NOT TO EXCEED $232,789
FOR A ONE-YEAR TERM ENDING JULY 31, 2025
WHEREAS, the City of Carlsbad uses Tableau to access and analyze data; and
WHEREAS, the City of Carlsbad desires to renew the Tableau subscription for a one-year term
ending July 31, 2025; and
WHEREAS, Solutions Simplified, Inc. is an authorized Tableau reseller and provides products and
technology services under the California Software Licensing Program Agreement SLP No. SLP-20-70-
0181J, Amendment No. 1; and
WHEREAS, Solutions Simplified has provided a quote (Attachment A) of $232,789, for a one-
year renewal of the Tableau subscription; and
WHEREAS, under Carlsbad Municipal Code Section 3.28.100, Cooperative Purchasing, the
Purchasing Officer has the authority to join with other public agencies for the purchase of goods or
services when it is in the best interest of the city; and
WHEREAS, the Purchasing Officer has reviewed the quote for the one-year renewal of the
Tableau subscription and determined purchasing the subscription renewal from Solutions Simplified is
in the best interest of the city; and
WHEREAS, the budget to procure the subscription renewal is available in the Information
Technology Department’s fiscal year 2024-25 Operating Fund; and
WHEREAS, the funding for the Tableau subscription’s future years will be considered on an
annual basis in the Information Technology Department’s annual budget requests.
NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Carlsbad, California, as
follows:
1. That the above recitations are true and correct.
2. That the City Manager or a designee is authorized to purchase the Tableau subscription renewal
from Solutions Simplified, Inc., for an amount not to exceed $232,789 for a one-year term
ending July 31, 2025, and to execute all required documents necessary for the purchase.
July 23, 2024 Item #2 Page 4 of 10
PASSED, APPROVED AND ADOPTED at a Regular Meeting of the City Council of the City of
Carlsbad on the __ day of ________, 2024, by the following vote, to wit:
AYES:
NAYS:
ABSTAIN:
ABSENT:
______________________________________
KEITH BLACKBURN, Mayor
______________________________________
SHERRY FREISINGER, City Clerk
(SEAL)
July 23, 2024 Item #2 Page 5 of 10
Solutions Simplified
3626 Fair Oaks Blvd. Suite 100
Sacramento, CA 95864
www.solutionssimplified.net Date:
A Certified Women-Owned Business Quote #:
Valid Until:
Prepared By: Rachel DaValle FEIN:47-5088841
Phone: 530-521-0576 Seller's Permit:102-806808
Fax: 916-244-0351 DUNS:80004788
Email: rachel.davalle@solutionssimplified.net CAGE:7GNN0
CUSTOMER
David Van Gilluwe Delivery:Electronic
City of Carlsbad-Information Technology FOB:Destination, Freight PPD
1635 Faraday Ave Payment Terms:Net 45
Carlsbad, CA 92008-7314 Contract #:SLP-20-70-0181J
renewals@carlsbadca.gov
(760) 602-2467
ITEM #PART #DESCRIPTION QTY UNIT PRICE EXT PRICE TAXED
1 200001773 1 $830.00 $830.00 N
2 200002287 1 $11,950.00 $11,950.00 N
3 200001785 4 $2,570.00 $10,280.00 N
4 200002292 1 $7,175.00 $7,175.00 N
5 200001788 1 $830.00 $830.00 N
6 200001800 1 $57,725.00 $57,725.00 N
7 200002297 1 $9,000.00 $9,000.00 N
Tableau - Creator (Server)
Salesforce.com, Inc. - 200001773
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Data Mgmt - Core (Server)
25% of Net Price
Salesforce.com, Inc. - 200002287
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Data Mgmt - Resource Core (Server)
Salesforce.com, Inc. - 200001785
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Advanced Mgmt - Core (Server)
15% of Net Price
Salesforce.com, Inc. - 200002292
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Embedded Analytics - Creator (Server)
Salesforce.com, Inc. - 200001788
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Embedded Analytics - 8 Core Base
(Server)
Salesforce.com, Inc. - 200001800
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Embedded Analytics - Data Mgmt - Core
(Server) 25% of Net Price
Salesforce.com, Inc. - 200002297
Start Date: 07/31/2024
End Date: 07/30/2025
QUOTE
4/15/2024
12898-C
7/30/2024
Attachment A
July 23, 2024 Item #2 Page 6 of 10
8 200001795 4 $1,815.00 $7,260.00 N
9 200002306 1 $5,400.00 $5,400.00 N
10 200001773 35 $646.00 $22,610.00 N
11 200007689 1 $5,604.00 $5,604.00 N
12 200007670 1 $3,365.00 $3,365.00 N
13 200001798 1 $76,920.00 $76,920.00 N
14 200001773 20 $692.00 $13,840.00 N
Subtotal $232,789.00
NOTES:Tax Rate 8.75%
1. This quote is valid for 30 days from original quote date Tax $0.00
unless otherwise specified above.Total $232,789.00
2. We accept Purchase Order, Visa, Mastercard, & AMEX.
3. Orders placed on a credit card are subject to a 3% fee.
4. Our product return window is 30 days from receipt of order.
Tableau - Embedded Analytics - Data Mgmt -
Resource Core (Server)
Salesforce.com, Inc. - 200001795
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Embedded Analytics - Advanced Mgmt -
Core (Server) 15% of Net Price
Salesforce.com, Inc. - 200002306
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Creator (Server)
Salesforce.com, Inc. - 200001773
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Data Mgmt (Server) 25% of Net Price
Salesforce.com, Inc. - 200007689
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Advanced Mgmt (Server)
15% of Net Price
Salesforce.com, Inc. - 200007670
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - 8 Core Base (Server)
Salesforce.com, Inc. - 200001798
Start Date: 07/31/2024
End Date: 07/30/2025
Tableau - Creator (Server)
Salesforce.com, Inc. - 200001773
July 23, 2024 Item #2 Page 7 of 10
THANK YOU FOR YOUR BUSINESS!
Please contact us if you have any questions or need further information.
Unless otherwise provided in the applicable Agreement, any increase in subscription pricing for the first renewal term will not exceed
5% over the subscription pricing in the immediately preceding term, provided that (a) for each renewal Customer renews its entire
then-current subscription volume under this Order Form combined with any associated add-on Order Forms, and (b) each renewal
term is the same duration as the Order Term of this Order Form or one year (whichever is longer). Thereafter, or upon a renewal
that does not meet the aforementioned criteria for Customer to benefit from the above price cap, any increase in subscription and
support pricing will be in accordance with SFDC’s pricing and policies in effect at the time of the renewal or as otherwise agreed to
by the parties. Notwithstanding the foregoing, any consumption-based Services which are subject to a rate card as set forth in the
product terms for the applicable Services and any support or resource-based Services are not subject to any price increase
limitations
Product Special Terms
CQ: 40135028
Tableau Software and/or Tableau Services are subject to the Order Form Supplement for Tableau Products available at
www.tableau.com/ofs which is hereby made part of this Quote
Any increase in subscription pricing (excluding support and resource-based Services) for the first renewal term will be in accordance
with SFDC's pricing and policies in effect at the time of the renewal or as otherwise agreed to by the parties or noted in these quote
terms or contract Licensee agrees that any order for Salesforce Services will be governed by the terms and conditions of the
Carahsoft Salesforce Service Terms, copies of which are found at https://carah.io/SFDC-TOU and all Schedules and Documentation
referenced by the Terms are made a part hereof. The parties agree that any term or condition stated in a Customer purchase order
or in any other Customer order documentation (excluding Quotes) is void. In the event of any conflict or inconsistency among the
following documents, the order of precedence shall be: (1) the applicable Quotes (and their Contract Vehicle), (2) the TOU, and (3)
the Documentation. Licensee acknowledges it has had the opportunity to review the Terms, prior to executing an order.
Product Terms Directory: http://carah.io/Product-Terms-Directory
Help & Training: http://carah.io/Help
Government Cloud Plus: http://www.carahsoft.com/government-cloud-terms
A list of currently available FedRAMP/IL4 Authorized Salesforce products can be found here:
https://help.salesforce.com/articleView?id=000270080&language=en_US&type=1
July 23, 2024 Item #2 Page 8 of 10
Exhibit 2
Information Technology Department
1635 Faraday Ave ï Carlsbad, CA 92008 ï 760-602-2450 t
Memorandum
July 7, 2024
To: Roxanne Muhlmeister, Assistant Finance Director/Purchasing Officer
From: Doug Kappel, IT Applications Manager
David van Gilluwe, Chief Data Officer
Via: Maria Callander, Information Technology Director
Re: Authorization to Participate in a Cooperative Purchasing Agreement for the
Subscription Renewal of the Tableau Enterprise Public Facing Portal
The Information Technology Department requests approval to cooperatively use the California
Software Licensing Program (SLP) agreement SLP No. SLP-20-70-0181J contract with Solutions
Simplified, Inc. to provide for the annual licensing and subscription service of the Tableau
internal and public-facing portal solutions at a cost of $232,789.
The city currently uses Tableau products for internal data analytics and visualization. In fiscal
year 2022-23 this was expanded to be an enterprise-wide solution and to incorporate the use
of a public facing portal. The primary purpose of the new purchase is to provide new technical
capabilities to enable the city to have a new public facing data portal. The portal will allow staff
to meet city goals of publishing data to the public in a technically advantageous manner that is
user-friendly to external viewers. Solutions Simplified, Inc.provides for the procurement
licenses and subscription services for the Tableau public facing portal solution.
This renewal and additional 20 licenses will assist in data analytics and visualization for internal
and public facing users. These products and additional licensing are necessary to assist the city
with publishing information about key city priorities associated with the newly approved
Strategic Plan, citizen-centric data, and other departmental activities. The combination of
internal and public facing technological resolves issues and inefficiencies that are barriers to
regularly publishing data through Tableau products. This renewal helps the city to make data-
driven decisions internally and to engage the public using data from the public facing portal.
As per Carlsbad Municipal Code Section 3.28.100 – Cooperative purchasing, “The purchasing
officer shall have the authority to join with other public or quasi-public agencies in cooperative
purchasing plans or programs for the purchase of goods and/or services by contract,
arrangement or agreement as allowed by law and as determined by the purchasing officer to be
in the city’s best interest. The purchasing officer may buy directly from a vendor at a price
established by another public agency when the other agency has made their purchase in a
competitive manner.”
July 23, 2024 Item #2 Page 9 of 10
Tableau cooperative purchase
July 7, 2024
Page 2
With Finance Department authorization, staff will recommend the City Council adopt a
resolution authorizing the purchase of the annual renewal for the Tableau software
subscription from Solutions Simplified, Inc. in an amount not to exceed $232,789 at the July 23,
2024 City Council Meeting.
Authorization to participate in cooperative purchasing agreement
______________________________________ ______________
Roxanne Muhlmeister, Date
Assistant Finance Director/Purchasing Officer
CC:
Maria Callander, IT Department Director
Cindie McMahon, City Attorney
Brent Gerber, Senior Management Analyst
Shea Sainz, Senior Contract Administrator
7/16/2024
July 23, 2024 Item #2 Page 10 of 10