top of page
Transportation Metrics
Below are charts and graphics created using Power Bi that reveal interesting trends and metrics of bus ridership data.
The first image below is a screenshot of a PowerBI session that contain two charts. The first is over a two year period and the second is the same data but displayed as a combo-chart of the two years. Clearly, there is a trend but the combo-chart clearly identifies the yearly trend.
PowerBI has an interesting and somewhat new visual called Q&A. You can form a question and get an answer. Certainly, you can't ask anything but it's somewhat customizable. I used it to calculate the date of the lowest monthly ridership..
The screenshot below of a PowerBI session that show the monthly average of ridership for the two fiscal years. The first graphic is user-built and below that is an example of the Q&A feature.
CALCULATING VARIATION.
Calculating variance of ridership from month to month is not a easy task. There are several ways to accomplish this but first we should ask if we want to identify the highest variance or the percentage of variance. I think the later is more important because it normalizes the variance so one can compare the routes that have very different ridership numbers. The statistic used is called the coefficient of variation. This can be calculated in Excel or Dax and the chart can be created in PowerBI as shown below (as an embedded PowerBI object).
bottom of page