Kuldeep Thakkar - Data Analyst Portfolio

About Me

Data Analyst skilled in Python, SQL, Power BI, Tableau, and Excel with experience in building dashboards, performing end-to-end data analysis, and generating actionable business insights. Strong at DAX, data modeling, and storytelling through visuals. Seeking data analyst roles where I can contribute analytical thinking and business-focused insights.

Experience

Freelance Data Analyst | June 2024 – Present | Ahmedabad

Designed Tableau dashboards to analyze accident data and identify high-risk zones.
Built logistic regression model (Titanic dataset) achieving 78% accuracy.
Performed end-to-end analysis using Python, SQL, Power BI, and Tableau.
Executed complete workflow: data cleaning, modeling, visualization, insight reporting.

Projects

Reliance Business Performance Dashboard (Power BI, DAX)

Developed multi-page dashboard comparing Retail (FMCG) and Fuel division performance.
Structured synthetic dataset with seasonality; performed Power Query transformations.
Built star-schema model with Date Table and relationships.
Created DAX measures: Total Sales, Profit, Margin %, MoM Growth, YoY Trends.
Insights: seasonal demand patterns, top regions, margin inconsistencies, revenue gaps.

Cleaning Services Performance Dashboard (Power BI)

Built operational + financial performance dashboard for cleaning services company.
KPIs tracked: Total Revenue, Avg. Hours Worked, Customer Rating, Productivity Score.
Visualized revenue by suburb, service type, and monthly trends.
Added slicers for Date, Suburb, Service Type, Payment Status.
Insights: high-performing suburbs, strong service categories, seasonal changes.

Global Trends Explorer (Power BI)

Built an interactive global socioeconomic dashboard.
Analyzed GDP, unemployment, income, and population trends.
Used maps, KPI cards, and time-series visuals.
Enabled country, region, and year-based filtering.
Insights on regional disparities and long-term growth patterns.

Road Safety Insights Dashboard (Power BI)

Developed an interactive Power BI dashboard to analyze road accident and casualty data.
Analyzed accidents by road condition, day of week, vehicle type, and severity.
Modeled data with structured relationships and calculated measures.
Visualized casualties by age group and gender.
Analyzed driver experience vs accident frequency.
Added slicers for day, severity, and vehicle type.
Delivered insights on high-risk conditions and accident patterns.

Workforce Lens: Employee Insights Dashboard (Power BI)

Built an interactive HR analytics dashboard to analyze workforce and compensation data.
Analyzed salary components including Base Salary, HRA, Overtime Bonus, and Leave Balance.
Performed salary disparity analysis across departments and job roles.
Visualized employee distribution by education level, designation, gender, and department.
Analyzed total salary trends based on employee experience.
Included insights on life insurance coverage, marital status, and demographics.
Used KPI cards, donut charts, treemaps, word cloud, and bar charts for storytelling.

Skills

Python (Pandas, NumPy, Matplotlib) SQL Power BI DAX Tableau Excel Data Modeling EDA Dashboarding Visualization

Education

MCA – SVGU (2023–2025)

BCA – Gujarat University (2020–2023)

Certifications & Languages

Certifications

GRRAS Solutions – Data Science

Languages

English, Gujarati, Hindi

Contact

kuldeepthakkar301@gmail.com

+91 8511548308

linkedin.com/in/kuldeep-thakkar-ab220523b

GitHub

Download Resume

Download My Resume (PDF)