Set up our analytics foundation in bigquery
Budget: $250 – $750 USD
We have a Postgresql database in google cloud containing ~10 tables with transactions, master data etc. We would like to achieve the following to start consume this data:
1. Set up a new instance of bigqueery
2. Secure that all tables from our database are streamed live (or close to live) to bigqueery
3. Create one new table that joints some of the tables loaded
4. Create a connector to big queery and:
- allow us to access the tables through powerquery in excel
- same as above for import to Google sheets
- spin up some simple report in Data Studio for us to continue to build from
5. Secure a handover of the above so that we can maintain the solution and develop further and advice on how we can go ahead to import data sources to our DW
1. Set up a new instance of bigqueery
2. Secure that all tables from our database are streamed live (or close to live) to bigqueery
3. Create one new table that joints some of the tables loaded
4. Create a connector to big queery and:
- allow us to access the tables through powerquery in excel
- same as above for import to Google sheets
- spin up some simple report in Data Studio for us to continue to build from
5. Secure a handover of the above so that we can maintain the solution and develop further and advice on how we can go ahead to import data sources to our DW