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
98 reviews
(95)
(3)
(0)
(0)
(0)
This project doesn't have any reviews.
SB
Saumya B.
Aug 14, 2026
Dashboard Automation and Reporting in BigQuery & Looker Studio
We had a great experience working with Shantanu his the entire development team on our sales dashboards in Google Data Studio. They took the time to understand our sales process, KPIs, and reporting needs, and translated them into dashboards that are clear, intuitive, and genuinely useful for the team.
They were responsive throughout the process, incorporated feedback quickly, and paid close attention to both functionality and usability. The final dashboards have made it much easier for us to track performance, understand the pipeline, and make decisions based on real-time data. They were open to our feedback, and ready to resolve any issues proactively.
Professional, collaborative, and very easy to work with. I would highly recommend the team to anyone looking for strong dashboard development and data visualization support. Special shoutout to Satya who was always available and incredibly helpful throughout the process.
They were responsive throughout the process, incorporated feedback quickly, and paid close attention to both functionality and usability. The final dashboards have made it much easier for us to track performance, understand the pipeline, and make decisions based on real-time data. They were open to our feedback, and ready to resolve any issues proactively.
Professional, collaborative, and very easy to work with. I would highly recommend the team to anyone looking for strong dashboard development and data visualization support. Special shoutout to Satya who was always available and incredibly helpful throughout the process.
AC
Alexis C.
Jul 27, 2026
Senior Business Analyst
RG
Ricardo G.
Jul 3, 2026
RCM Dashboard
Great worker
MN
Mitchell N.
Jul 2, 2026
Data Pipeline Engineer — Amazon → BigQuery (OpenBridge)
NA
Nick A.
May 1, 2026
Google Looker Dashboard Expert Needed
Great team. Pleasure to work with.
About Shantanu
Data Engineer & AI Agents Expert | BigQuery | Data Studio | Metabase
100%
Job Success
Indore, India - 7:45 am 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