In my previous post I wrote about the process that lead me to build a dashboard but first I want to talk a bit about the structure of the data in the Google Sheet where the whole process started. I first started by looking to quickly create a few charts to visualize some of our KPI‘s. To source the data I created a text file containing the SQL statements and used psql to fetch Postgres data which I dumped it to data into .CSV files for import into separate “data” only tabs in Google Sheets.
<br /> psql -h pgserver -d mydb -U myuser -w -t -A -F $'\t' -f ~/Campaigns.sql &gt; campaign.csv
Continue reading Using Google Sheets, Pivot Tables and Charts as a Startup Dashboard – Part II