Expanding the Power of Tableau and Data for The City of Charlotte
February 25, 2022
Putting Data to Work for The City of Charlotte
Charlotte, North Carolina, is the country’s 16th largest city and home to nearly 900,000 residents. It consistently ranks as one of the top growing cities and includes more than 10 Fortune 1000 companies. The City’s focus areas include great neighborhoods, safe communities, mobility, economic development and the environment.
Robert Cerrato, Data Program Manager of Shared Data Services for the City of Charlotte, and his team are longstanding users of Tableau Software, leveraging the platform to build and share rich data visualizations throughout its internal network. As the City continued to grow, so did the desire to grow Tableau’s applicability to the public.
“When it comes to data, we are trying to create that single source of truth both for our internal agencies but also with our community. In doing so we can drive new insights and informed decision making for all”, stated Cerrato.
Since 2013, the City of Charlotte had a very robust open-data presence, pushing the public-facing data through an open-data portal, which allowed them to create mapping apps and map products. However, pushing this information publicly did not offer a mechanism of security and control. This was a time-consuming task as data needed to be manually extracted and monitored for each publication. With only one Tableau core license, the City operated on one production server, one development server and one test server. Due to fiscal constraints, purchasing an additional core license for the external environment was not a realistic option.
The City of Charlotte enlisted the help of Cherry Bekaert Digital Advisory to help responsibly and successfully shift their internal Tableau environment to an external public-facing environment, a more economical alternative solution.
The vision was to create an environment that kept the City of Charlotte’s internal contact intact with its fellow agencies while giving them an automatic mechanism to push their content for anonymous access to the public. In doing so, the City controls and governs the sharing of Tableau visualizations, which significantly lessened their dependency on Tableau Public.
Cerrato points out, “the ability to safely and responsibly connect and mutually share valuable data internally and with the public enables a deeper connection between the inter-departments of the City and its residents opening a window for deeper insights, knowledge sharing and unlocking new opportunities.”
Expanding the Power of Tableau and Data for The City of Charlotte
Building the external environment has allowed Cerrato’s team and the greater agencies within the City to ideate on future Tableau projects and opportunities, such as the public transportation system, Charlotte Area Transit (CATS). CATS operates bus and rail transit services in Mecklenburg County and surrounding areas to over 320,000 riders on a weekly basis. Multiple vending machines are located throughout the City enabling riders to purchase tickets. Maintenance personnel are responsible for servicing the machines and keeping them operable. However, given the servers’ ages and system applications, the machines were becoming increasingly unreliable. Seeing the power and application of Tableau, CATS and the Shared Data Services team partnered together with Cherry Bekaert to leverage Tableau as the new application face for those servicing the ticket vending machines. This enabled maintenance personnel to see the location and status of machine operability in real-time, allowing for quick maintenance turnaround and a significant decrease in machine downtime and lost revenue.
We now have the ability to govern what’s facing the public. And so, we spend less time policing the people sharing the data in these visualizations, and more time collaborating with other City agencies, creating opportunity and shared value. Tableau and the team of Cherry Bekaert Digital Advisory have enabled this, which continues to be a win-win for the City and our greater community.” – Robert Cerrato