Awanish Yadav

Power BI Developer

New Delhi, India 1+ yrs exp 84 · Excellent

About

Power BI Developer with 1.5+ years of experience designing, developing, and maintaining interactive Power BI dashboards and reports for business, operational, and financial reporting. Skilled in building optimized data models with relationships, writing complex DAX measures, and using Power Query (M) for data extraction, transformation, and cleansing. Experienced connecting Power BI to multiple data sources (SQL Server, PostgreSQL, MySQL, Excel, APIs), publishing and managing content in Power BI Service, scheduling data refreshes, and optimizing report performance. Strong SQL skills, analytical mindset, and a track record of gathering stakeholder KPI requirements and translating them into effective visualizations.

Skills & Expertise (32)

Power BI Service Intermediate

7.5/10

1.5

Years Exp

Power BI Desktop Intermediate

7.5/10

1.5

Years Exp

Advanced DAX Intermediate

7.0/10

1.5

Years Exp

Problem-solving skills Intermediate

7.0/10

1.5

Years Exp

analytical skills Intermediate

7.0/10

1.5

Years Exp

Communication Intermediate

6.5/10

1.5

Years Exp

Cross-Functional Collaboration Intermediate

6.5/10

1.5

Years Exp

Technical Documentation Intermediate

6.5/10

1.5

Years Exp

Stakeholder Requirement Gathering Intermediate

6.5/10

1.5

Years Exp

KPI Tracking Intermediate

6.5/10

1.5

Years Exp

Financial Reporting Intermediate

6.5/10

1.5

Years Exp

Operational Reporting Intermediate

6.5/10

1.5

Years Exp

Business Reporting Intermediate

6.5/10

1.5

Years Exp

SQL Intermediate

6.5/10

1.5

Years Exp

Data Cleansing Intermediate

6.0/10

1.5

Years Exp

ETL Intermediate

6.0/10

1.5

Years Exp

Data Transformation Intermediate

6.0/10

1.5

Years Exp

Postgresql Intermediate

5.5/10

1.5

Years Exp

MySql Intermediate

5.5/10

1.5

Years Exp

Row-Level Security Intermediate

5.5/10

1.5

Years Exp

User Access Management Intermediate

5.5/10

1.5

Years Exp

SQL Server Intermediate

5.5/10

1.5

Years Exp

Amazon S3 Intermediate

5.0/10

1.5

Years Exp

AWS Glue Intermediate

5.0/10

1.5

Years Exp

AWS Lambda Intermediate

5.0/10

1.5

Years Exp

EC2 Intermediate

5.0/10

1.5

Years Exp

AWS Cloud Services Intermediate

5.0/10

1.5

Years Exp

Python Intermediate

5.0/10

1.5

Years Exp

Pandas Intermediate

5.0/10

1.5

Years Exp

NumPy Intermediate

5.0/10

1.5

Years Exp

Data Modeling Power Query (M

Work Experience

Data Analyst

Techverse Origin

May 2025 - Present

Designed and developed 5+ interactive Power BI dashboards for business, operational, and financial reporting, building optimized data models with defined relationships and complex DAX measures for KPI tracking. Performed data extraction, transformation, and cleansing using Power Query (M) and SQL across 30M+ records, connecting Power BI to multiple sources (SQL databases, Excel, flat files) and improving query performance by 40%. Published and managed dashboards in Power BI Service with workspace organization and scheduled data refreshes, reducing manual reporting time by 60%; troubleshot refresh and connectivity issues. Gathered reporting requirements and KPIs from business stakeholders, converting them into effective visualizations, and maintained technical documentation for dashboards and data models.

MIS Executive

Sri Aurobindo Society

Nov 2024 - Apr 2025

Managed and maintained student and staff databases across multiple schools using Advanced Excel (VLOOKUP, XLOOKUP, Pivot Tables), ensuring data integrity. Generated accurate MIS reports to support administrative planning and strategic decision-making for leadership.