Welcome to my portfolio. I am Pranithkumar Dupuguntla, a Business and Data Analyst passionate about cleaning datasets, building metrics, and enabling data-driven decision-making.
Aspiring Data Analyst and Digital Analytics Enthusiast skilled in Excel, SQL, Power BI, Python, and Web Analytics (GA4, GTM). Experienced in data validation, interactive dashboards, and identifying operational trends to solve business problems.
ACE Engineering College, Hyderabad
Sep 2023 – 2026
SVS Polytechnic College, Warangal
Sep 2020 – 2023
Objective: Track patient demographics, admission trends, and billing metrics.
Methods: Built custom DAX metrics, cleaned unstructured logs in Power Query, and configured drill-through visual pages.
Power BIDAXPower QueryObjective: Monitor employee productivity, attendance, and department targets.
Methods: Applied dynamic lookup functions (XLOOKUP, INDEX-MATCH) and built interactive Pivot Tables to isolate operational bottlenecks.
Advanced ExcelPivot TablesObjective: Identify health risk patterns across demographics.
Methods: Modeled physical health indicators (BMI, BP, Cholesterol) in Power BI using DAX expressions and trend visualizations.
Power BIData Modeling View ProjectObjective: Evaluate student academic scores, pass percentages, and subject trends.
Methods: Automated reporting queries in Power Query and provided sliceable reports by class, gender, and subject.
Power BIExcelEnsuring your raw data is accurate, audited, structured, and consistent for reporting.
Uncovering operational trends and monitoring business KPIs using statistical analysis.
Developing interactive visual reporting solutions to convey business metrics clearly.
Creating automated Power BI and Excel dashboards for real-time decision-making.
For inquiries and collaborations, feel free to reach out through any of the following channels:
Email: praneeth.dupukuntla@gmail.com
Phone: +91 6300905921
Location: Hyderabad, Telangana, India