Data Analyst Power Bi

PRATIK SHINDE

Pune, MH ****** +91-951******* ******.********@*****.*** Portfolio GitHub www.linkedin.com/in/pratik-shinde SUMMARY

Data Analyst with 1 year of experience in deriving actionable insights through data visualization, SQL, Power BI, Tableau and Python. Proven track record of building dashboards, automating reporting, and supporting strategic decision-making. Adept in data modeling, statistical analysis, and data cleaning with strong problem-solving, attention to detail, and adaptability skills. Skilled in predictive analytics, KPI development, and dashboard optimization. TECHNICAL SKILLS

• BI & Visualization: Power BI (DAX, RLS, Drill-through), Tableau, Business Intelligence, Dashboard Optimization

• Excel: Advanced Excel (Pivot Tables, Power Query), Data Validation

• Data & Programming: SQL (Joins, CTEs, Window Functions), Python (Pandas, NumPy), A/B Testing, Data Warehousing

• ETL (Extract, Transform, Load), Data Cleaning, Statistical Analysis, Report Automation, Performance Optimization

• Others: Business Requirements Gathering, Data Governance, KPI Development, Predictive Analytic EXPERIENCE

AI Variant Pune

Data Analyst Intern October 2024 to July 2025

Bank Analytics Report Dashboard GitHub

• Processed 65K+ loan records using Power BI, Tableau, Excel & SQL; tracked 733M funded, 808M collected, 155M interest.

• Detected 3% anomalous transactions via data validation; built KPI benchmarks for 6 loan types across 12 states.

• Optimized dashboards with DAX and SQL views, cutting report time by 60% and raising usage by 25% through better UX.

• Enhanced interactivity with drill-through filters and slicers for easier navigation and decision-making.

• Partnered with analysts and managers to refine loan segment views and align outputs with business goals. Employee Retention Report Dashboard GitHub

• Built a dashboard on 50K+ employee records using Power BI, Excel, and SQL; uncovered 4.2M in potential attrition costs.

• Detected 17% higher attrition in low-satisfaction employees with <3 years tenure using segment-level drill-downs.

• Achieved 35% reduction in HR follow-up time through drill-through reports; improved dashboard performance by 40%.

• Integrated data governance filters for demographic compliance and actionable department-level insights. Crowdfunding Analytics Report Dashboard GitHub

• Analyzed 440K+ campaigns using Excel, Power BI, Tableau & SQL; revealed $3.85B pledged and 44.5M backers.

• Flagged 39.3% success in low-goal projects and 2.4x boost for staff picks via drillable views by year, location, and category.

• Improved dashboard load time by 40% through DAX tuning, SQL optimization, and efficient data modeling.

• Cleaned and structured raw data for consistent, insight-ready analysis. PROJECTS

Hr Analytics Report Dashboard

• Built an HR Dashboard using Power BI, Excel, and SQL analyzing 1,473 employee records across departments.

• Identified that 72% of total attrition came from two departments, demonstrating analytical thinking and strategic insight.

• Mapped salary trends using predictive analytics to highlight future retention risk groups, supporting data-driven decision-making.

• Enabled HR to target interventions by integrating interactive filters, showing initiative and creativity in dashboard design. Superstore Sales Dashboard (USA) Dashboard

• Developed an end-to-end dashboard in Power BI to analyze 2.3M+ revenue across categories, segments, and regions.

• Flagged 8 underperforming products contributing to 60% of total returns, applying accountability in root-cause analysis.

• Used KPI development to monitor profit margin (12.47%) and return rate (5.91%), enhancing decision-making effectiveness.

• Integrated slicers for region, product, and time, showcasing time management and user-focused thinking. EDUCATION

• Master of Arts in Clinical Psychology- Dr. D. Y. Patil Arts, Commerce & Science College, Pimpri — 2022

• Bachelor of Arts in Psychology- Dr. D. Y. Patil Arts, Commerce & Science College, Pimpri — 2020 CERTIFICATIONS

Data Analyst Certification by ExcelR Solution

Contact this candidate