192
users gained secure access to data
400+
data tables refreshed daily or weekly
26
dynamic Power BI reports created
Challenge
Before partnering with SDG Group, the Town of Gilbert lacked a centralized data strategy or platform. Each of the town’s 17 departments managed their data in silos. This led to varying levels of data literacy, manual reporting processes, and inaccessible data locked in different systems.
Solution
SDG Group developed a centralized data governance strategy for Gilbert, incorporating Matillion ETL for data ingestion, transformation, and orchestration. The solution connected 20+ data sources, automated workflows, and consolidated data into a single data lakehouse that all departments could access.
Results
With the new centralized platform, over 192 users across various departments gained secure access to real-time data, allowing them to make more informed decisions. Data from over 20 sources can now be ingested, transformed, and orchestrated automatically, with 400+ data tables being refreshed daily or weekly for data accuracy and accessibility.
We can empower the town to take the data while having good faith that it's quality data that’ll lead to successful outcomes, and then create these dashboards for the departments to start utilizing the data.
Sarah VanSlyke
Deputy Chief Technology Officer
Town of Gilbert
Challenge: Manual data processes and siloed systems hindered efficiency for Town of GIlbert
The Town of Gilbert, Arizona, has grown into one of the fastest-expanding communities in the U.S., evolving from its agricultural roots to become a thriving, economically diverse suburb just southeast of Phoenix.
As part of its ambitious mission to become the "City of the Future," the town sought to harness data to streamline operations, enhance transparency, and improve decision-making across its many departments. However, before partnering with SDG Group, the town faced several challenges that made it difficult to fully leverage its data resources.
At the heart of the problem was a lack of a centralized data strategy. Each of the town’s 17 departments were working in silos that couldn’t effectively communicate with one another. This made collaboration challenging and slowed down the reporting processes.
The lack of a unified approach also led to varying levels of data literacy across the departments, with some teams struggling to access and use their data effectively. Many reports were manually generated, meaning they were outdated by the time anyone could use them.
Recognizing the challenges of connecting to and retrieving data from various source systems—many of which had complex API connections or were stored in SharePoint locations—the town saw an opportunity to improve its data management processes. They understood that without a clear data governance strategy, these challenges would persist, so they actively sought out solutions to harness their data more efficiently and effectively.
We have data dispersed across different systems and departments, which presents a great opportunity for us to streamline and centralize our data management. By bringing everything together, we’re positioning ourselves to leverage this data more effectively for better decision-making and innovation.
Sarah VanSlyke
Deputy Chief Technology Officer
Town of Gilbert
Solution: Transform data management with a centralized data governance strategy
To solve these challenges, the Town of Gilbert partnered with SDG Group to roll out a centralized data governance strategy that completely transformed how the town managed its data.
SDG Group implemented a unified technology stack, with Matillion ETL at the core, to handle data ingestion, transformation, and orchestration. This allowed the town to consolidate data from 17 different departments into a single platform, making it much easier for everyone to access and use the information they needed.
Matillion’s user-friendly, low-code interface made it simple for teams to build and automate data pipelines, even if they didn’t have a technical background.
SDG also set up a multi-layer data lakehouse that enabled the departments to securely access their specific datasets while keeping everything well-organized. They created custom solution accelerators to quickly connect data sources that were previously difficult to reach, like complex API connections or files trapped in SharePoint. This shift automated the previously manual processes, with the town’s 400+ data tables refreshing daily or weekly, providing real-time, accurate data for better decision-making.
Beyond the tech setup, SDG worked closely with Gilbert’s teams to improve data literacy and make sure all departments could actively participate in the new system. They offered training and easy-to-follow documentation, so people could quickly start using tools like Power BI to create dynamic reports.
Now, instead of working in silos, departments can collaborate more easily, share insights, and make decisions based on fresh, accurate data. It’s been a game-changer for how the Town of Gilbert runs its operations daily.
We've been able to refine and enhance data from across town departments, making it more accurate and actionable as we integrate it across systems. Now, we can consistently share these insights with the public through the advanced tools we've implemented.
Eugene Mejia
Chief AI Strategy and Transformation Officer
Town of Gilbert
Benefits: Improved data access, efficiency, and collaboration.
After rolling out SDG Group's data governance strategy, the Town of Gilbert started seeing some big wins. One of the most noticeable changes was how over 192 users could securely access real-time data from a centralized platform. With everything in one place, departments could easily pull the data they needed, without jumping through hoops. Before, data was scattered across different sources, making it hard to get a clear picture.
The town also went from manually refreshing reports to having over 400 data tables automatically updated on a daily or weekly basis. This meant no more working with outdated information. Everyone had access to the latest numbers, leading to faster, more informed decisions.
A great example of this improvement is how the Gilbert Police Department used data to reduce shoplifting across the town. By pinpointing hotspots from their performance reports, they increased proactive business checks in key areas, which cut thefts by more than 20 incidents a month. That kind of quick, data-driven action wasn’t possible with the old system.
But it wasn’t just about efficiency. The centralized platform boosted collaboration between departments, allowing them to work together more seamlessly. The town’s data literacy also took a leap forward, thanks to SDG’s training and intuitive tools like Matillion and Power BI.
Now, teams aren’t just gathering data; they’re using it to make real improvements, whether that’s streamlining operations or enhancing public services. With a solid data foundation in place, the Town of Gilbert is set up for bigger and better things, pushing forward on its mission to become the “City of the Future.”
We're moving far beyond the old siloed approach, seamlessly connecting our town and its citizens through a modern, cloud-based solution. This transformation is key to driving our vision of becoming the City of the Future, where innovation and connectivity thrive.
Kevin Shaw
Town of Gilbert
What's next?
Looking ahead, the Town of Gilbert has exciting plans to continue building on the success of its centralized data platform. Now that they’ve streamlined data access across departments, the next step is to bring even more teams on board. SDG Group will work closely with the Town of Gilbert to realize this vision and help them integrate their data into the centralized platform. The goal is for every department in the town to use data as a valuable resource, much like the police and public works departments have already done.
The Town of Gilbert is also planning to create performance management reports for all departments, so each team can use data to enhance their services and day-to-day tasks. They’ve already seen the benefits in areas like crime prevention, and they’re eager to apply that same data-driven approach across the board to keep improving how they serve the community.
Additionally, the town is looking to incorporate more advanced technologies into its data platform. They’re exploring a proof of concept (POC) for Matillion Data Productivity Cloud (DPC) to tap into AI capabilities. With AI, the town hopes to further streamline its processes, become more efficient, and uncover new ways to innovate.
All of this is part of their vision to be the “City of the Future,” with a forward-thinking approach that continues to anticipate change, create solutions, and serve its growing community in the best possible way.
About the Town of Gilbert
The Town of Gilbert, located just southeast of Phoenix, is one of the most vibrant communities in the U.S. With nearly 350,000 residents. It’s evolved from its agricultural roots into a thriving, economically diverse suburban hub. Even though it’s still called a “town,” Gilbert operates with the services and infrastructure of a big city.
The town is focused on innovation and growth, always looking for ways to improve life for its residents and businesses. Gilbert is on a mission to become the “City of the Future,” by staying ahead of the curve and embracing innovation.
About Matillion
Matillion is a leading data transformation platform built for cloud data warehouses with AI capabilities. It helps companies extract, transform, and load their data easily, and gives them the insights they need to make smart, data-driven decisions.
With tons of pre-built connectors and robust integration features, Matillion empowers businesses to get the most out of their data so they can boost efficiency, spark innovation, and drive growth. By simplifying data integration, Matillion has become a go-to partner for companies looking to streamline their data processes.
About SDG
SDG Group is a global consulting firm specialized in AI, Data & Analytics, with offices in Italy, Spain, USA, UK, Middle East, Portugal, and the Netherlands.
Business agility is the ability of an organization to adapt quickly to market changes, both internally and externally. This cannot exist without becoming a truly data-driven company. SDG Group achieves this by co-creating optimal solutions with its customers, leveraging Data & Analytics services through a unique combination of business domain expertise and state-of-the-art technologies delivered by an industry-leading team of more than 2,000 people.
We are pioneers in AI, Data & Analytics consulting and we are committed to unlocking organizations’ hidden potential by offering in-depth analytics expertise.