Agile BI - Public Transportation

Dynamic, real-time reports, scale as data grows; created for a major Government organisation using Power BI and SQL Azure.

パートナーに問い合わせる ビデオを見る

Problem

This government organisation required a more robust reporting solution due to the government’s transportation infrastructure upgrade. Traditionally the authority relied on Excel to produce KPIs in dashboard format. But with the exponential increase in the traffic data it soon became obvious that such manual process is no longer effective for keeping track of performances in time. The authority required a more effective mean to monitor and analyse their evolving traffic condition and performance.

Solution

We designed a Power BI reporting solution to meet the robust, scalable and real-time reporting need. The solution enables self-service capability to allow measuring Bus/Train performance along numerous different dimensions (here substituted with sample data). We started off with a dashboard-like report that provides descriptive overview to the top performance indicators. It then extends into a historical view where a trend analysis is possible to understand current versus past. Lastly we created a real-time network congestion map that indicates where worst traffic delays are occurring, allowing monitoring and decision making to co-occurs in real time without a delay.

Power BI パートナーになりたいですか?

認定パートナーは、チームにとって重要な存在です。 新しいビジネス チャンスを見つけ、つながりを作り、御社の才能と経験を世界中の Power BI ユーザーと共有してください。

サインアップ

サインアップでお困りですか?
お問い合せください pbiptnr@microsoft.com

Request demo