Kondapalli Pani Chander Rao

I build interactive Power BI dashboards for sales and loan analysis, turning MySQL and Microsoft SQL Server data into clear reporting for business decisions.

Through ExcelR data analyst projects, I developed the Furniture Pro & Co Sales Dashboard to track $2M in sales, profits, returns, customer segments, and product performance. I used predictive analytics, RFM scoring, what-if discount analysis, and interactive visuals to reduce manual reporting effort by over 20% and support profitability decisions.

I also designed a Bank Loan Analysis Dashboard with an optimized star-schema model, dynamic parameters, bookmarks, guided navigation, Row-Level Security, and automated Power BI Service refreshes. This work improved risk visibility by 25%, dashboard performance by 30%, and reporting efficiency by 25%.

My foundation also includes Tableau, Excel-based data cleaning, financial analysis, and an EY Articleship internship covering financial accounting, audit documentation, and client reporting. I enjoy transforming complex data into data stories that help teams make informed decisions.