Available for data analysis & BI projects
Excel · VBA · Power BI · Reporting

Hi, I’m Upendar
Data analyst & Power BI developer

I help businesses move from raw Excel files and scattered data to clear dashboards, automated reports, and decision‑ready insights. My focus is practical, business‑friendly solutions using Excel, VBA, Power BI, and SQL.

📊 Discuss a dashboard 👀 View sample use‑cases
Experience
Reporting & automation
Management reports, KPI tracking, interactive dashboards.
Tools
Excel · VBA · Power BI · SQL
Data cleaning, modeling, DAX, Power Query.
What I deliver
Dashboards & data workflows
Automated refresh, documented logic, easy to use.
Core skills
How I work with your data
Advanced Excel (formulas, pivots, dashboards)
VBA automation & custom tools
Power BI (DAX, data modeling, Power Query)
ETL from Excel / CSV / SQL
KPI and performance dashboards
Sales, finance & operations reporting
Data cleaning & standardization
Storytelling with data & insights

I design reports that answer specific business questions, not just “pretty charts”: who, what, where, and why performance is changing over time.

Depending on your environment, I can keep everything in Excel, build a Power BI model, or combine both so your team adopts it quickly.

Selected work

Data projects & dashboards

More examples on request
Power BI · Dashboard
Sales performance cockpit
End‑to‑end model combining Excel, SQL and Power BI: margin analysis, top products, regional trends, and sales funnel with interactive filters.
DAX · Power Query Monthly vs target KPIs
Excel · VBA automation
One‑click management pack
Macro‑driven Excel template that refreshes data, updates pivot tables and charts, and exports a PDF pack for email in a single button click.
VBA · dynamic ranges PDF export workflow
Analytics · Insights
Inventory & operations view
Dashboard highlighting stock aging, slow movers, reorder alerts and category‑wise trends to reduce blocked capital and avoid stock‑outs.
Excel · Power BI Inventory KPIs
Have messy Excel files, manual reports, or a dashboard idea in mind? Share a short description and I’ll suggest a practical Excel / VBA / Power BI solution.
WhatsApp me ✉️ hello@upendar.in