• >
  • >
  • >
  • >
  • >
Microsoft Azure (Microsoft) > 实例探究 > San Francisco Municipal Transportation Agency boosts citizen services with Microsoft Azure

San Francisco Municipal Transportation Agency boosts citizen services with Microsoft Azure

Microsoft Azure (Microsoft) Logo
公司规模
Large Corporate
地区
  • America
国家
  • United States
产品
  • Azure Synapse Analytics
  • Azure Data Lake Storage
  • Azure Event Hubs
  • Power BI
  • Azure Logic Apps
技术栈
  • Azure Synapse Analytics
  • Azure Data Lake Storage
  • Azure Event Hubs
  • Power BI
  • Azure Logic Apps
实施规模
  • Enterprise-wide Deployment
影响指标
  • Productivity Improvements
  • Cost Savings
  • Customer Satisfaction
  • Digital Expertise
技术
  • 分析与建模 - 大数据分析
  • 平台即服务 (PaaS) - 数据管理平台
  • 分析与建模 - 预测分析
适用行业
  • 城市与自治市
  • 运输
适用功能
  • 商业运营
  • 物流运输
用例
  • 智慧城市运营
  • 车队管理
  • 交通监控
  • 预测性维护
服务
  • 云规划/设计/实施服务
  • 系统集成
关于客户
The San Francisco Municipal Transportation Agency (SFMTA) is a large government organization responsible for managing all ground transportation in San Francisco, including buses, trains, light rail, cable cars, taxis, and emerging forms of transportation like bikes and scooters. Established by voter mandate in 1999, the agency serves the city's 874,000 residents and 26 million annual visitors, ensuring safe, equitable, and sustainable transportation. The SFMTA operates as a single entity, allowing it to centralize data from various transportation modes, such as bus routes, parking frequency, and pedestrian density. This centralized approach provides the agency with a unique opportunity to leverage data for improving transportation services and optimizing operational efficiency. With a workforce of 1,000 to 9,999 employees, the SFMTA is committed to enhancing the accessibility and quality of transportation services for the people of San Francisco.
挑战
The San Francisco Municipal Transportation Agency (SFMTA) faced significant challenges in managing and analyzing the vast amounts of data generated by its operations. The agency's traditional reliance on relational databases and middleware was proving inefficient and resource-intensive. The existing systems required extensive manual processing, such as pulling data from CSV files into Excel for analysis, which was time-consuming and labor-intensive. Additionally, the on-premises infrastructure demanded costly engineering hours for maintenance and upgrades, making it difficult to scale and adapt to the growing data needs. The SFMTA recognized the need for a centralized data management solution that could streamline processes, reduce administrative bottlenecks, and enable data-driven decision-making to improve transportation services and optimize revenue.
解决方案
To address its data management challenges, the SFMTA partnered with Microsoft to implement a serverless data solution centered on Azure Synapse Analytics. This comprehensive cloud solution allowed the agency to unify its disparate data sources into a common data entity, streamlining processes and enabling rapid data analysis. Azure Synapse Analytics was used for data warehousing and orchestration, efficiently handling the massive daily data generated by the Muni railway, taxis, buses, and parking meters. The data was stored in Azure Data Lake Storage and cataloged with Azure Purview Preview. Azure Event Hubs and Azure Logic Apps were employed to build a unified platform for gathering data from various vendors managing parking meters, bus routes, and special events. Power BI was integrated into the Azure Synapse Analytics workspace to create streamlined reporting, facilitating data-driven business decisions. This architecture empowered the SFMTA to focus on data analysis rather than infrastructure management, enhancing its ability to serve the community effectively.
运营影响
  • The SFMTA's new data architecture has streamlined processes, allowing team members to focus on data analysis rather than infrastructure management.
  • The agency no longer has to worry about downtime, as Azure services provide high availability and reliability.
  • The SFMTA can now scale its data processing capabilities with ease, addressing previously expensive and challenging problems.
  • The unified system has created new efficiencies, such as optimizing street parking management to reduce traffic congestion.
  • The SFMTA plans to build a comprehensive view of the city from every possible data point, enabling a 360-degree view of street traffic and enhancing its mission to provide accessible transit.
数量效益
  • The SFMTA's serverless data solution allows for the processing of 5 million rows of data daily from the Muni railway alone.
  • The unified data platform enables the SFMTA to manage data from every taxi, bus, and parking meter in San Francisco efficiently.
  • The implementation of Azure Synapse Analytics has significantly reduced the time and resources required for data analysis and decision-making.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 Asia Growth Partners 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 Asia Growth Partners 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。