Piyush Anshal

Data Analyst

Noida, Uttar Pradesh 4+ yrs exp 89 · Excellent

About

Experienced Data Analyst with 3+ years of expertise in data analysis, visualization, and BI reporting. Proficient in SQL, Python, and Power BI (DAX, modeling, star-schema), delivering dashboards and reporting that improved efficiency by up to 34%. Experience in KPI reporting, financial analytics, ETL, and translating data to stakeholder insights.

Skills & Expertise (32)

Power BI Advanced

8.5/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Python Intermediate

7.5/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

Data Modeling Intermediate

7.5/10

Years Exp

Business Intelligence Intermediate

7.5/10

Years Exp

Data Analysis Intermediate

7.5/10

Years Exp

relational databases Intermediate

7.0/10

Years Exp

Reporting Automation Intermediate

7.0/10

Years Exp

Financial Reporting Intermediate

7.0/10

Years Exp

Trend Analysis Intermediate

7.0/10

Years Exp

Variance Analysis Intermediate

7.0/10

Years Exp

KPI Reporting Intermediate

7.0/10

Years Exp

Data Transformation Intermediate

7.0/10

Years Exp

ETL Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Advanced Excel Intermediate

7.0/10

Years Exp

Star Schema Intermediate

7.0/10

Years Exp

Pandas Intermediate

7.0/10

Years Exp

Power Query Intermediate

6.5/10

Years Exp

Stakeholder Management Intermediate

6.5/10

Years Exp

Data Storytelling Intermediate

6.5/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

Cross-Functional Collaboration Intermediate

6.0/10

Years Exp

Google Sheets Intermediate

6.0/10

Years Exp

scikit-learn Intermediate

6.0/10

Years Exp

Google Docs Intermediate

5.5/10

Years Exp

Microsoft Fabric Intermediate

5.5/10

Years Exp

Google Colab Intermediate

5.0/10

Years Exp

Azure Intermediate

5.0/10

Years Exp

MTD Looker Studio

Work Experience

Data Analyst

Indigrid Technology Pvt. Ltd.

Dec 2025 - Jul 2026

Developed and maintained Power BI reports and dashboards for operational and financial reporting, improving reporting efficiency by ~34% using advanced DAX and star-schema data modeling for KPI tracking, variance analysis, and MTD/YTD calculations. Extracted, cleaned, transformed, and analyzed large relational databases using SQL, improving reporting accuracy using optimized queries and efficient data modeling, including a 12 GB inventory database. Automated COGS, Sales, and MIS reporting by transforming SAP and business data into analytical dashboards, reducing manual reporting effort by ~24%. Built financial analytics solutions for revenue, receivables, payables, cash flow, and profitability reporting, enabling stakeholders to monitor key business metrics using interactive Power BI dashboards.

Data Analyst

Freelance / Upskilling / Independent Consultant

Sep 2023 - Nov 2025

Translated business requirements into data-driven solutions using SQL and Python for cross-industry clients. Performed ad-hoc data analysis to identify trends, solve business problems, and support operational decision-making. Built dashboards and automated reporting workflows, reducing manual effort and improving turnaround efficiency. Collaborated directly with stakeholders to scope requirements and deliver insights aligned to business objectives.

Assistant Engineer – Powerplant & Technical Records

SpiceJet Limited

Nov 2021 - Aug 2023

Analyzed aircraft engine performance data and cost trends using Excel to support data-backed maintenance planning. Built automated Excel dashboards, reducing data retrieval and reporting time by 32%. Collaborated with finance and engineering teams to track compliance and cost optimization. Awarded Spice Star Award (Q2 2023) for driving analytics-based reporting efficiency.