Ayush Srivastava

Data Analyst

Transforming complex datasets into strategic business insights using SQL, Python, and Power BI.

Get in Touch

Work Experience

Self-Directed Learning & Project Portfolio

Data Analyst (Portfolio Development)

Jan 2024 — Present

Completed 3 industry-recognized certifications including Google Data Analytics, Microsoft Power BI, and Advanced MySQL.
Solved 50+ SQL problems on LeetCode demonstrating strong database querying and optimization skills.
Built 6 production-ready data projects analyzing datasets from 10K to 100K+ records.
Developed automated ETL pipelines and interactive dashboards for business intelligence.

Skills

Data & SQL

• SQL (PostgreSQL, DuckDB, MySQL)
• JOINs, CTEs, Window Functions
• ETL Pipeline Development

Analytics & Visualization

• Power BI & DAX
• Tableau
• Data Storytelling

Programming

• Python (Pandas, NumPy)
• Data Cleaning & Automation

Tools

• GitHub
• Jupyter Notebook
• Excel
• Google Analytics

Featured Projects

Hotel Booking Margin Leakage Analysis

Analyzed 50K+ booking records using SQL and Power BI to uncover pricing inefficiencies and identify $2.3M in potential revenue leakage.

Source →

Customer Churn Prediction Analysis

Analyzed 10K+ customer records using SQL and Python to identify churn risk segments and support proactive retention strategies.

Source →

Job Market Intelligence Dashboard

Scraped and analyzed 1K+ job listings to track salary benchmarks and skill demand using SQL, Python, and Power BI.

Source →

Amazon Price Tracker ETL Pipeline

Built automated Python ETL pipeline tracking 10+ products with daily monitoring and price trend visualization.

Source →

Pricing Sensitivity & Profitability Model

Developed SQL + Python model analyzing price elasticity and revenue optimization scenarios for data-driven pricing decisions.

Source →

Pricing Sensitivity & Profitability Model

Credit Card BI Dashboard

Designed enterprise-style dashboard analyzing 100K+ transactions for segmentation, spending behavior, and risk insights.

Source →

Achievements

50+ LeetCode SQL Problems Solved

Problem Solver

Solved complex SQL problems involving JOINs, window functions, CTEs, and query optimization.

View Profile →

3 Industry Certifications

Certified Professional

Certified in Google Data Analytics, Microsoft Power BI, and Advanced MySQL.

6 Production Data Projects

Project Developer

Built real-world analytics projects with automated pipelines and interactive dashboards.

Certifications

🏅 Google Data Analytics Professional Certificate

Google

Issued: Nov 2025

Comprehensive certification covering data cleaning, analysis, visualization, and SQL fundamentals using real-world business datasets.

Skills: SQL, Excel, Tableau, Data Analysis

🔗 Verify Credential (V73F8XXNR5F4) 📄 View Certificate

🏅 Microsoft Power BI Data Visualization

Microsoft

Issued: Jan 2026

Focused on building interactive dashboards, DAX calculations, and business intelligence reporting using Microsoft Power BI.

Skills: Power BI, DAX, Dashboard Design

📄 View Certificate

🏅 Advanced MySQL Topics

Articles

The Data Analyst Revolution — AI + Power BI + MCP

Exploring how AI and modern analytics platforms are reshaping the data analyst role.

Top 7 Dashboards Every Data Analyst Should Build

Essential dashboard patterns covering sales analytics, KPI monitoring, and financial reporting.

About Me

I'm a data analyst focused on transforming raw data into actionable business insights using SQL, Python, and Power BI. With 6 production projects, 50+ SQL problems solved, and certifications from Google, Microsoft, and Meta, I combine strong technical foundations with real-world analytical execution. I’m passionate about optimizing data workflows and enabling smarter, data-driven decision-making.