Back to Developers
Shivansh srivastava

Shivansh srivastava

Data Analyst

India 80 · Excellent

About

Data Analyst with hands-on experience building end-to-end analytics solutions across Excel, SQL, and Power BI. Proven track record of transforming large-scale raw datasets (1.4M+ records) into measurable business insights through interactive dashboards, KPI frameworks, and advanced DAX modeling. Skilled in data cleaning, ETL pipelines, and cross-functional reporting that reduces manual effort and accelerates decision-making.

Skills & Expertise (32)

DAX Advanced
8.5/10
5
Years Exp
Data Modelling Dashboard Design Data Storytelling Business Intelligence Reporting KPI development Exploratory data analysis Data Wrangling Pandas NumPy Drill-through Interactive Dashboards ETL KPIs Measures Calculated Columns Pivot Tables Query Optimization Aggregate Functions Window Functions CTEs Subqueries DML DDL Conditional Formatting VBA Macros Power Pivot Power Query XLOOKUP VLOOKUP Charts

Work Experience

Data Analyst

Blinkit

Present - Present

Built a self-service Excel dashboard using Pivot Tables and Slicers to track 4 core KPIs — Total Sales, Average Sales, Items Sold, and Customer Ratings — consolidating all metrics into 1 unified view. Cleaned and prepared 8,500+ transactional records through category standardization, null-value handling, and structural normalization — achieving 100% data consistency across all downstream visualizations. Designed 5+ interactive visualizations (donut, bar, line/area, and funnel charts) segmented across 5 dimensions — item type, fat content, outlet size, outlet type, and city tier — enabling targeted sales analysis. Replaced fragmented manual reporting with a single consolidated dashboard, reducing stakeholder analysis time from hours to under 10 minutes per reporting cycle.

Data Analyst

AtliQ Hardware

Present - Present

Replaced a legacy Excel-based reporting system for AtliQ Hardware by building a scalable Power BI solution integrating 2 data sources (Excel/CSV and SQL databases), modernizing analytics for 1,000+ SKUs. Developed 5 specialized dashboards — Finance, Sales, Marketing, Supply Chain, and Executive Overview — giving leadership a 360-degree operational view across all business functions in 1 platform. Applied advanced DAX functions including CALCULATE, FILTER, RELATED, and time-intelligence measures to build 20+ calculated columns and KPIs tracking sales performance across 1.4M+ records. Centralized multi-departmental data into a unified Power BI model, cutting cross-team reporting consolidation time by an estimated 60% and improving visibility for strategic planning.

Data Analyst

Spotify

Present - Present

Built a 2-dashboard Power BI solution (Overview + Listening Patterns) analyzing 150,000+ Spotify listening records across 10 years (2015–2024), surfacing long-term engagement trends and audience behavior shifts. Engineered dynamic Date/Calendar tables with 6+ time-intelligence measures including Year-over-Year (YoY) comparisons, latest vs. prior-year analysis, and weekday vs. weekend segmentation using advanced DAX. Implemented Top-N filters, cross-slicer edit interactions, and drill-through across 4 dimensions — albums, artists, tracks, and platforms — enabling granular self-service analysis without analyst intervention. Identified peak listening windows and top-performing artists across 10 years of data, producing platform-level insights to support content strategy and audience engagement recommendations.

Education

B.Tech — Information Technology - Chandigarh Engineering College

2022 - 2026 · Afghanistan

Senior Secondary (12th) - SVM Public School

2020 - 2021 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMay 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation