You will get big data analysis done in BigQuery using SQL.
Top Rated
Top Rated
Project details
Hey there!
Thanks for stopping by. <3
If you have your raw data residing in BigQuery and you're looking for someone to write SQL queries and turn the data into a live, automated, interactive and intuitive dashboard filled with insightful KPIs, I bet you've come to the right place!!
I specialise in BigQuery, Standard SQL & Data Visualisation. In BigQuery I can help you with:
• setting up your BigQuery account
• writing cost-effective SQL queries
• making scheduled queries, saved queries, views, tables, etc.
• creating stored procedures
• using complex SQL commands like:
1. PARTITION BY
2. RANK
3. DENSE_RANK
4. ROW_NUMBER
5. LAG
6. LEAD
7. QUALIFY
8. PIVOT
9. HAVING
10. UNION ALL, etc.
Further,
• I can connect your Google Sheets to BigQuery and analyse the data using SQL.
• I can connect your Google Analytics 4 live data to BigQuery, etc.
Why me:
• I bring over 4 years of highly successful experience in SQL and BigQuery.
• More than 3 years of experience in making dashboards using BigQuery.
• I have top-notch communication & designing skills.
• I am someone who takes full ownership of the work and delivers great value.
Thanks for stopping by. <3
If you have your raw data residing in BigQuery and you're looking for someone to write SQL queries and turn the data into a live, automated, interactive and intuitive dashboard filled with insightful KPIs, I bet you've come to the right place!!
I specialise in BigQuery, Standard SQL & Data Visualisation. In BigQuery I can help you with:
• setting up your BigQuery account
• writing cost-effective SQL queries
• making scheduled queries, saved queries, views, tables, etc.
• creating stored procedures
• using complex SQL commands like:
1. PARTITION BY
2. RANK
3. DENSE_RANK
4. ROW_NUMBER
5. LAG
6. LEAD
7. QUALIFY
8. PIVOT
9. HAVING
10. UNION ALL, etc.
Further,
• I can connect your Google Sheets to BigQuery and analyse the data using SQL.
• I can connect your Google Analytics 4 live data to BigQuery, etc.
Why me:
• I bring over 4 years of highly successful experience in SQL and BigQuery.
• More than 3 years of experience in making dashboards using BigQuery.
• I have top-notch communication & designing skills.
• I am someone who takes full ownership of the work and delivers great value.
Data Tool
SQLWhat's included
| Service Tiers |
Starter
$200
|
Standard
$400
|
Advanced
$600
|
|---|---|---|---|
| Delivery Time | 5 days | 4 days | 3 days |
Number of Revisions | 2 | 2 | 3 |
Number of Graphs/Charts | 2 | 5 | 8 |
Number of Variations | 2 | 3 | 3 |
Data Source Connectivity | |||
Web Embedding | - | - | |
Interactive/Animated Visuals |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$50 - $100Frequently asked questions
94 reviews
(91)
(3)
(0)
(0)
(0)
This project doesn't have any reviews.
NA
Nick A.
May 1, 2026
Google Looker Dashboard Expert Needed
Great team. Pleasure to work with.
JK
Jiten K.
Apr 18, 2026
Shopify Pipeline - Data Engineer
JK
Jiten K.
Feb 26, 2026
Data Engineer for Scalable Python Pipelines Integration
EW
Emma W.
Feb 25, 2026
Marketing and Analytics Data Unification Specialist
Shantanu was excellent on this project. He provided strategic guidance and was also really quick at turning the project around. Definitely recommend! 10/10
NG
Neeraj G.
Feb 16, 2026
Metabase Integration with BigQuery for EdTech BI Reporting
About Shantanu
Data Engineer & AI Agents Expert | BigQuery | Data Studio | Metabase
100%
Job Success
Indore, India - 6:21 pm local time
💰 $600K+ earned | 16,000+ hours | 130+ clients served
I am a Sr Data Engineer with expertise in developing robust AI Agents & Analytics layer. I bring over 8 years of hands-on experience with:
- Building scalable ETL data pipelines that fetch raw data froms APIs and store it into data warehouses hosted over GCP/AWS (BigQuery | Snowflake | Redshift).
- Developing Business Intelligence reports and dashboards using Data Studio (formerly Looker Studio), Metabase, Looker, Tableau etc.
- Building powerful AI Agents using Gemini, Claude, OpenAI, Dialogflow.
- Track user behaviour data using GA4 and Google Tag Manager.
I’ve worked with 130+ clients across eCommerce (Shopify, WooCommerce), digital marketing & paid ads (Meta, Google Ads), mobile apps & gaming analytics, SaaS & web apps, and data-driven businesses in education, clean energy & media.
💡 What I do (End-to-End Ownership)
1. Data Engineering & Warehousing:
- Build scalable, reliable data pipelines using BigQuery, Snowflake, Redshift, Python and APIs of data sources
- Automated ETL (Airflow, APIs, Fivetran, custom Python scripts)
- Single source of truth across marketing + product + revenue
2. Analytics & BI (Decision Systems, not just dashboards):
- Executive dashboards (Looker, Data Studio (formerly Looker Studio), Metabase, Power BI, Tableau)
- KPI frameworks aligned to revenue
- Cohort, LTV, attribution & funnel analysis
3. Marketing & Web Tracking (Accuracy = $$$)
- GA4, Google Tag Manager, Server-side tracking
- Meta CAPI, Google Ads, TikTok tracking
- Fix broken attribution & data loss
4. Generative AI & Automation
- AI agents & workflows (OpenAI, Gemini, Claude)
- Automate reporting, insights, and ops
- Use AI where it actually improves ROI (not hype)
📈 Real Outcomes I’ve Delivered
✔ Built full marketing data warehouse → improved spend efficiency by 30%+
✔ Fixed tracking & attribution → recovered lost revenue visibility
✔ Automated reporting → saved 20+ hrs/week for teams
✔ Delivered exec dashboards → faster, data-backed decisions
🧠 Why Clients Choose Me
- I think like a business owner, not just an engineer
- I focus on revenue impact, not vanity metrics
- I handle end-to-end (tracking → pipelines → dashboards → insights)
- Strong communication + fast execution (no hand-holding needed)
📈 My Tech Stack:
- Business Intelligence & Data Visualisation: Google Data Studio (formerly Looker Studio) , Looker, Metabase, Power BI, Mode, Tableau, Databox, Zoho Analytics, DOMO, Google Sheets, etc.
- AI: LLMs like OpenAI, ChatGPT, Gemini, Claude, DeepSeek, and GCP's services like Document AI, DialogFlow, CCAI, etc.
- Engineering: SQL, Python, Airflow, APIs, Cloud Functions, Lambda Functions, Cloud Composer, Cloud Run
- Data Warehouses: BigQuery, Redshift, MS SQL, MySQL, PostgreSQL, Snowflake, and Azure.
- ETL & Webhook tools: n8n, Fivetran, Stitch, Windsor, Supermetrics, Power My Analytics, Saras Analytics, Zapier, Make, etc.
- Tracking: Google Tag Manager, Google Analytics 4, Meta Ads Conversion API, Google Ads Conversion tracking, Stape, Server-side tracking.
- Data Sources: Shopify, WooCommerce, BigCommerce, Meta Ads, Google Ads, TikTok Ads, Pinterest Ads, LinkedIn Ads, Apple Ads, Amazon Ads, Bing Ads, Google Analytics 4, Google Search Console, Google My Business, HubSpot, Active Campaign, PipeDrive, Facebook Page Insights, Instagram Insights, Stripe, SEMRush, MailChimp, Klaviyo, ClickUp, Ahref, etc.
👉 Let’s Work
If you’re looking for someone who can own your entire data stack and turn it into a revenue engine, let’s talk.
Click “Invite” and let’s discuss your use case 🚀
-----
🔍 𝗞𝗘𝗬𝗪𝗢𝗥𝗗𝗦
GA4, Google Analytics 4, Google Tag Manager (GTM), Server-side Tracking, Meta Conversion API (CAPI), Google Ads Conversion Tracking, Marketing Attribution, BigQuery, Snowflake, Redshift, Data Warehouse, Big Data, Data Engineering, ETL, ELT, Data Pipelines, Apache Airflow, Airflow DAGs, PySpark, Spark, Databricks, SQL, Python, Advanced SQL, Data Modeling, Data Transformation, Data Architecture, Data Lakes, Data Studio, Looker Studio, Power BI, Tableau, Data Visualization, Dashboard Development, Business Intelligence (BI), KPI Dashboard, Reporting Automation, Shopify Analytics, WooCommerce Analytics, Marketing Analytics, Product Analytics, Funnel Analysis, Cohort Analysis, LTV Analysis, Retention Analysis, Generative AI, OpenAI, ChatGPT, Gemini, Claude, AI Agents, AI Automation, AI Agents, LLM Applications, n8n, Workflow Automation, No-code Automation, Low-code Automation, Zapier, Make (Integromat), API Integrations, Webhooks, Stripe, HubSpot, Google Ads, Meta Ads, TikTok Ads, LinkedIn Ads, Cloud Platforms (GCP, AWS), Cloud Functions, AWS Lambda, Data Orchestration
Steps for completing your project
After purchasing the project, send requirements so Shantanu can start the project.
Delivery time starts when Shantanu receives requirements from you.
Shantanu works on your project following the steps below.
Revisions may occur after the delivery date.
Understanding the data
Coding using SQL