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 http://www.inflationtrends.com/ , compiled from various government sites such as http://bls.gov/data/#prices) 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

How to upload flat files like CSV and Excel data into SQL tables

InfoCaptor Enterprise now comes packaged with in-built mini datawarehouse that you can use it to upload flat files and convert them into SQL tables. Once your flat files are in SQL then you can perform join operations between multiple flat files and perform advanced analytical queries using SQL. NOTE: InfoCaptor provides the ability to directly … Read more