Find Jobs
Hire Freelancers

Set up our analytics foundation in bigquery

$250-750 USD

Closed
Posted almost 2 years ago

$250-750 USD

Paid on delivery
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
Project ID: 33770927

About the project

13 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
13 freelancers are bidding on average $573 USD for this job
User Avatar
I CAN COMPLETE YOUR PROJECT EASILY Hello, I am programmer with enough experiences on Java/JavaFX for 10+ years. Java/JavaFX is nice programming language and I am majoring on it for long years so I have confident to complete your project by Java/JavaFX. I can work by full time for your project and trying to satisfy the requirements. I am designing the project from scratch and structure it well. I am following the project's design process exactly, and if any error is found, fix it within 24 hours and provide maintenance free of charge for a month. Client's idea + Programmer's good coding is the perfect result, this is my idea. I want to keep long-term relationship for customer so I want to give the nice result. If you want the perfect result, please contact with me.
$500 USD in 7 days
5.0 (1 review)
5.2
5.2
User Avatar
Hello, How r u doing? I have gone through the project and i believe that i can handle it well having experience related to SQL, Data Warehousing, Google Data Studio, Database Administration and PostgreSQL. Please have a look at my profile to have an idea of my previous work: https://www.freelancer.com/u/ayesha0124 Regards, Ayesha
$750 USD in 7 days
5.0 (2 reviews)
3.4
3.4
User Avatar
Hi, I have gone through the project description. I have 5+ years of experience in Data Analytics and Data Warehousing. I would like to discuss the following points 1. Secure that all tables from our database are streamed live (or close to live) to bigqueery - You would like to create a custom code or use an ETL tool to achieve this. I would recommend using an ETL tool because it would be easier to implement and maintain. Writing custom code will take time to implement and require handover to maintain it. 2. Create a connector to big queery and: - allow us to access the tables through powerquery in excel - I would create views on Google Data Studio from where you can download the data into Excel. As far as I know, there are no direct connectors for Excel to Google BigQuery. Rest of the points are clear to me. I would provide you assitance during and after completion of the project. Thanks for your time. In case of any queries or suggestion, feel free to contact me. Thanks and regards, Ekagra SIngh
$300 USD in 7 days
5.0 (1 review)
3.2
3.2
User Avatar
Hello, I am dealing with backend development. And I have deep understanding in Database Design. Regarding the project, I want to ask more on chat. I will be able to support you to maintain the solution and go ahead to import data sources. Thank you so much. Regards. Imran
$700 USD in 7 days
4.2 (1 review)
3.1
3.1
User Avatar
Hi there, I am Rashid, Hope you are doing great. Firstly about the Set up our analytics foundation in bigquery that I have a great experience in it. I am very confident to pull it off once awarded. I am a Full stack developer with a team of experienced developers and designers on my side, together we have 5+ years of experience in Data Warehousing, Google Data Studio, PostgreSQL, SQL and Database Administration I aim to establish a long term working relationship with my clients. It would be my honor to have you on board with us. Please let me know what is needed to secure the bid! Thanks for your consideration. Rashid Amjad.
$650 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I am a professional SQL Developer with more than 3 years of rich experience in .SQL and I am 100% confident that I am perfectly fit for this job. Please send me a message in chat so we can discuss your project further. Regards, Azhar
$550 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWEDEN
Stockholm, Sweden
0.0
0
Payment method verified
Member since May 25, 2022

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.