About me - Hi, I'm Satyarth — a data and marketing professional, passionate about solving business problems with data governance, analytics, visualisation, and storytelling.
View My GitHub Profile
Data Analytics Portfolio
Technical Skills:
PowerBI, Python, SQL, BigQuery, Looker Studio, Jupyter Notebook, Spreadsheets, Tableau, Quicksight, Google Cloud Data Platform, DAX, Microsoft Excel.
Certifications
- Microsoft Certified: Power BI Data Analyst Associate (PL-300) (Apr 2025) Verify
- Microsoft Power BI Data Analyst Specialization (Apr 2025) Verify
- Google Cloud Data Analytics Professional Certificate (Dec 2024) Verify
- Google Business Intelligence Certificate (July 2024)Verify
- Google Advanced Data Analytics Certificate (JUNE 2024) Verify
- Google Data Analytics Professional Certificate (FEB 2024) Verify
- Agentic AI and AI Agents for Leaders (JUNE 2025 - Ongoing)
- Preparing for Google Cloud Certification: Machine Learning Engineer (MAY 2025 - Ongoing)
Projects
- Designed and automated an ETL pipeline in BigQuery to unify and clean CRM lead data across recurring sheets, reducing reporting errors by 25%, saving ~40 hrs monthly and enabling dynamic campaign attribution. This helps streamline data sources and maintain a single source of truth for advertising campaign analysis with a live dashboard, allowing access control and minimising errors.
- Tools & Skills involved - SQL, Google Spreadsheets, Excel, BigQuery, Google Data Cloud, Google Ads
- Guiding the client in setting up a Google Ads dashboard focused on pre-lead performance indicators such as spend, CTR, CPC, and CPL. These metrics were broken down by device type, ad type, gender, and age group. The objective was to track pre-lead trends and establish a clear connection between ad spend, individual keywords & clicks and lead generation & quality.
- Tools & Skills involved - SQL, Looker Studio, Looker, Excel, BigQuery, Google Data Cloud, Google Ads