Citizen Portal & Master Data Management Portal for City of Spokane

Master Data Management Portal and citizen portal for City of Spokane as they facing inefficiencies in sharing requested datasets for analytics.

Client Location

United States

Industry

Public & Non Profit

Solutions

Data Management & Data Engineering

Technologies

Power BI, React JS, Django, Synapsis, Python

Client Overview

The City of Spokane, through its Innovation and Technology Services Department, sought to enhance transparency, accountability, and public participation by creating a comprehensive Master Data Management (MDM) Portal. This portal would allow the city to provide valuable information and reports to citizens, promoting public engagement and feedback.

Challenges

The City of Spokane faced a significant challenge in efficiently managing and sharing frequently requested datasets. The absence of a centralized data repository led to inefficiencies in data sharing and hindered the ability to provide accurate and timely analytics and reports. Furthermore, the city's data landscape was complex, consisting of both structured and unstructured data, making it difficult to maintain a "single version of truth" across different systems.

Data Fragmentation

Data was spread across various departments, lacking a centralized location for access and management.

Data Complexity

The city had to manage both structured and unstructured data, requiring a comprehensive solution for merging, profiling, and maintaining data quality.

Government Transparency

The city needed a standard method for publishing and disseminating data to enhance government transparency and accountability.

Solution

Intellectyx collaborated with the City of Spokane to design, develop, implement, and maintain a Master Data Management Portal based on Microsoft Azure’s modern data warehouse architecture and Power BI.

Key Features of the Solution:

Data Ingestion and Integration: A wide variety of data sources, including Criminal Justice Information (CJI), Payment Card Industry (PCI), HIPAA, and Federal Energy Regulatory Commission (FERC) data, were ingested and integrated into a centralized data warehouse. Both structured and unstructured data were merged, profiled, and cleansed to ensure data quality.
Centralized Repository: A data warehouse was created where all Extract, Transform, Load (ETL) processes took place, resulting in a single, structured repository that provided a "single version of truth."
Data Pipelines and Workflows: Data-driven workflows (pipelines) were created and scheduled to ingest data from disparate sources, ensuring real-time updates and data consistency across departments.
Advanced Data Visualization: Interactive reports, dashboards, and drill-down capabilities were developed using Power BI and Azure Machine Learning, allowing city departments to gain valuable insights from the data.
Business Intelligence (BI) Applications: Output data was published to data stores, such as Azure SQL Data Warehouse, for consumption by BI applications, enabling advanced reporting and analysis.

Contact us today to explore the transformative possibilities data management for your business.

Let’s talk about it!

Results

Upon completion, the new mexico school achieved with the student information management system:

Single Version of Truth: The implementation of the Master Data Management Portal ensured that the City of Spokane had only one authoritative version of data, improving accuracy and trust in the data.
Enhanced City Applications: Improved applications and user interfaces allowed for better interaction with data across departments, enhancing overall efficiency.
Optimized Data Management: The solution reduced manual efforts required to manage data, improving efficiency across the city's departments.
Improved Business Intelligence and Reporting: The new platform enhanced the city's ability to perform analytics, reporting, and data-driven decision-making.
Secure and Accessible Data: Data was securely accessible across departments, reducing data quality errors and promoting easier data sharing.
Public Engagement Opportunities: With a centralized repository, the City of Spokane could engage more effectively with citizens and other stakeholders, promoting transparency and public involvement.