vicky rana

I’m a results-driven Data Analyst and Power BI developer with 1.5+ years of experience turning business data into clear, decision-ready dashboards. I specialize in building Power BI solutions backed by SQL-based data pipelines, advanced DAX modeling, and reliable KPI logic—so stakeholders can act faster with confidence.

At Team Computers Pvt. Ltd., I delivered end-to-end sales analytics dashboards for 5+ business units, reducing manual reporting effort by ~40% and improving decision turnaround time. I developed optimized DAX measures for revenue, profitability, YoY growth, and variance analysis, and I built scalable data models using Power Query-based ETL pipelines from SQL Server sources. To strengthen data security and performance, I implemented Row-Level Security (RLS) and incremental refresh strategies, and I automated dataset refresh and report distribution using Power BI Service and Power Automate.

As a freelance Data Analyst, I’ve built interactive Power BI dashboards integrating SQL, Excel, and Python for sales, profit, and inventory analysis, including KPI creation and DAX optimization on 50K+ sales records. I also bring a strong analytical foundation from my Data Science & Machine Learning internship—where I performed EDA with Pandas/NumPy and built/evaluated regression and classification models—so my BI work connects insights to measurable outcomes.