Consumer Price Index – Charts and Dashboard

In this article we will build the following consumer price index dashboard The data used in this dashboard is from the Inflation Trends website (source , compiled from various government sites such as To begin with we have the following spreadsheet The raw excel file has multiple sheets but the data of our … Read more

Create Pivot or crosstab data from flat table – Consumer price index dashboard

In the previous section we built a simple dashboard using the CPI data. In this part, we will use some pivot SQL queries to facilitate comparison of multiple categories on the same chart. The charts require the data to be in certain format. It expects the first column to be the x-axis and the following … Read more