Marketplace Queries:

This is an example project where I have used postgreSQL queries to analyze the given data. The postgreSQL queries were run on psql (Version 9.5.1.0) on a MacBook Pro (15-inch, non-retina Mid 2012, 16 GB DDR3 RAM) running OS X El Capitan (Version 10.11.3)

Click here to read the PDF file that contains the questions that I am trying to answer, from the given data set. The data is provided in the form of three CSV files. Here are the csv files containing the data:
jobs.csv
categories.csv
bids.csv
Here are the postgreSQL scripts that analyze the data and provide insights:
loadData.sql
sqlMarketplaceProject.sql
And here are the results from running the postgreSQL queries:
kpiQueriesJobs_1.csv
kpiQueriesJobs_2.csv
analysisQueries_jobs+categories_1.csv
analysisQueries_jobs+categories_2.csv
analysisQueries_jobs+categories_3.csv
analysisQueries_jobs+categories_4.csv
advancedSQLQueries_bid_1.csv
advancedSQLQueries_bid_2.csv
advancedSQLQueries_bid_3.csv