Milestone 4

Maintaining Existing Infrastructure

Remember that all business decisions should be compounding over the semester, and thus that you should ensure that all existing dashboards for past milestones remain functional and accurate to the data at hand. This may be as simple as not touching what was done before, and everything still works. But if you need to make architectural changes (which should be documented with an ADR!), it may require revisiting older milestones to ensure they still operate correctly. In general, you should plan on each business decision mapping to a single dashboard. You could reuse components of existing dashboards, but it should be clear in Grafana what business decision each dashboard maps to. Keep in mind that for these assessments, what matters is the accuracy and degree to which the provided dashboard helps inform the business decision. The technical means by which you compiled and created that dashboard is not considered here, but should be included in your documentation.

The Business Question

For this fourth milestone, we are looking closer at segment traffic now that we have connection information on how the stations are joined:

Decision 1

As Prague’s metro continues to grow in popularity, infrastructure wear and long-term maintenance have become central concerns for the operations team. While planners already track ridership volumes at individual stations, this provides only a partial picture. The real stress on the system often accumulates along specific segments of track—stretches between stations—where many passengers travel regardless of where they board or exit. Identifying these high-traffic segments is critical for planning targeted maintenance, reallocating rolling stock, and reducing strain on vulnerable parts of the network. Planners are particularly interested in which line segments are seeing the most traffic and how that traffic flows across the hours and days of the week, thereby identifying where future system upgrades will have the greatest impact on rider experience and operational resilience.

Changes Announcement

While you should be always be taking snapshots and deciding accordingly how to treat any slowly changing dimensions, to summarize a few of the changes that have been seen in the system:

• Individual’s continue to see a change in their fare type as they age
• New influxes of tourists (and some workers) have been making their way into the city
• Some station re-zoning has occurred
• Turnstile direction overrides continue to be added for new dates

Assessment

You will be assessed on the following for each dashboard/business decision:

Category	4 – Exemplary	3 – Proficient	2 – Developing	1 – Insufficient
Relevance to Business Question	Dashboard clearly and directly answers the question; all content is purposeful.	Dashboard mostly answers the question; minor gaps or tangents present.	Partially answers the question; some visuals are only loosely related.	Does not address the business question meaningfully.
Analytical Insight and Context	Provides thoughtful analysis and useful context; insights go beyond surface-level.	Provides some interpretation or context; insight is basic but present.	Interpretation is minimal; context is unclear or overly simplistic.	No analysis or meaningful interpretation provided.
Accuracy and Reproducibility	Data is accurate and internally consistent; results could be closely replicated.	Minor inaccuracies or unclear methods; mostly consistent and plausible.	Not clearly reproducible; errors or inconsistencies raise concerns.	Major inaccuracies or contradictions; cannot be trusted.
Design and Aesthetics	Visually appealing and easy to interpret; layout, labels, and colors enhance clarity.	Clear design with minor layout or labeling issues.	Layout or chart choices hinder interpretation; lacks polish.	Poorly designed; unclear or disorganized layout and labels.
Communication and Presentation	Titles, captions, and text are clear, professional, and aid interpretation.	Generally well-communicated; minor missing or unclear text elements.	Explanations are vague, sparse, or unhelpful.	No explanations or guiding text; confusing to the intended audience.