Hello, I am

Prathamesh Kadam.

ExcelProject

Power BIProjects

SQLProjects

PythonProjects

About Me

I am a Microsoft Certified: Power BI Data Analyst Associate with hands-on experience cleaning, analyzing, and visualizing data using SQL, Python, Excel, and Power BI. I turn raw datasets into actionable insights that support data-driven decision-making.

My training spans Pharmacy, Business Intelligence, and Generative AI frameworks. I focus on eliminating manual reporting overhead, building interactive dashboards, and translating numbers into clear stories that business teams can act on.

Across internships and personal projects, I've standardized 100K+ row datasets, profiled thousands of customer records, and shipped Power BI dashboards used by analysts and managers — and I'm eager to apply these skills in fast-paced, analytical environments.

Key Skills

SQLPythonPostgreSQLPower BIAdvanced MS ExcelData CleaningEDAInsight GenerationDescriptive StatisticsProblem Solving

My Projects

Bank Loan Analysis

Domain/Function: Banking / Lending Analytics

Built an interactive Power BI dashboard on 38.6K loan applications — analyzed $435.8M funded vs $473.1M repayments and surfaced 86.2% Good vs 13.8% Charged-Off loans for risk-driven decisions.

Power BISQL

See My Work

Customer Behavior Analysis

Domain/Function: E-Commerce / Consumer Insights

Analyzed 3,900 customer transactions; engineered 10+ SQL queries (histograms, box plots, heatmaps) and shipped an 8+ KPI Power BI dashboard.

PythonPostgreSQLPower BI

See My Work

Customer Churn Analysis

Domain/Function: Telecom / Retention Strategy

Profiled 7,043 telecom subscribers; built tenure bands revealing 38% of churned users left within their first 3 months.

PythonEDA

See My Work

Sales Data Analysis

Domain/Function: Sales Operations / Performance

Tracked 33K+ orders ($157K+ revenue) with DAX KPIs measuring 32%+ MoM growth and identifying 25% higher weekend sales.

Power BIDAX

See My Work

My Experience

Data Analyst Intern | SkillFied Mentor | Sep 2025 – Nov 2025

Excel · SQL · Power BI

Processed and standardized 100,000+ rows from multiple regions, enabling business teams to track KPIs across geography and time.
Designed smart Excel templates with lookup functions and pivot logic, saving 40% of reporting time across 4 departments.
Developed and maintained Power BI dashboards visualizing revenue trends, customer mix, and monthly performance — used by managers and analysts across business units.
Collaborated with 4 analysts and 2 senior managers to define and validate 6 KPIs, improving report reliability and strategic alignment.

SQL Intern | CODTECH IT Solutions | Oct 2025 – Dec 2025

SQL

Queried and analyzed 3,900+ customer transactions, uncovering insights into revenue trends, customer behavior, and product performance.
Developed and optimized 10+ SQL queries for customer segmentation, subscription trends, and sales performance.
Performed data cleaning and validation across 18+ data fields, improving accuracy and reporting quality.
Supported dashboard reporting by preparing clean datasets and tracking 8+ key business KPIs.