Charts/Dashboards

Here, I build on the example laid out on the Power Query Tab.

Although our 28M records of data have been consolidated into a single pivot table via Power Query, we can utilize pivot charts for a more visual representation of the data.

Below are a few simple examples of charts/dashboards that can be built quickly despite the size of our data set. These are the same charts/dashboards but one built using Power Query and one with PowerBI. One can imagine how this could be extremely useful for infinitely different data sets including looking at sales or units by any number of times frames (days/weeks/years).

Charts/Dashboards using Power Query

This dashboard allows the user to see easily that the total passenger count by year has steadily decreased. As we have more years (i.e. 2021, 2022) this dashboard will update with a 1-click refresh.

This is the same data but represented as a pie chart reflecting each available year's contribution to total passengers.

Again as we have more data this chart can be updated with just a few clicks

This is the same passenger count data shown above, this time with added information. This double-axis chart allows the user to see how the sum of fare amounts (in dollars) correlates to the passenger counts by year.

Charts/Dashboards using PowerBI

This the same charts as above but using PowerBI. Since Power Query is a precursor to PowerBI it provides similar charting functionality. The advantage of PowerBI is that these charts/dashboards would be synced allowed for more 'point and click' drills downs.