I'm a passionate and results-driven Data Analyst with hands-on experience in SQL, Python, Power BI, Tableau, and Excel. I specialize in delivering end-to-end analytics solutions, transforming raw data into actionable insights across diverse domains, including retail, healthcare, and environmental sectors.
My expertise lies in cleaning, transforming, analyzing, and visualizing large datasets to support critical business decisions, optimize operational reporting, and meet stakeholder requirements. I'm adept at KPI reporting, executive dashboard creation, and leveraging data to drive strategic outcomes.
Currently, I'm pursuing my Master of Computer Applications (MCA) at Vellore Institute of Technology (VIT), further deepening my knowledge in Data Science, Machine Learning, AI, and Big Data Analytics.
Data Analysis & BI:
- Exploratory Data Analysis (EDA)
- Statistical Analysis
- Hypothesis Testing
- KPI Tracking
- RFM Segmentation
- Cohort Analysis
- Customer Lifetime Value (CLV)
- Data Storytelling
- Data Visualization
Tools & Technologies:
- Databases: SQL (PostgreSQL, MySQL)
- Programming: Python (Pandas, NumPy, Matplotlib, Seaborn)
- BI Tools: Power BI (DAX, Power Query), Tableau
- Spreadsheets: Microsoft Excel (Advanced: VBA/Macros, Pivot Tables, VLOOKUP)
- Other: Jupyter Notebook, Git/GitHub
Data Engineering & Processing:
- Data Cleaning
- Data Transformation
- ETL Pipelines
- Data Modeling
- Feature Engineering
- Data Validation
- Data Quality Assurance
Business & Delivery Skills:
- Requirement Gathering
- Stakeholder Communication
- Executive Reporting
- Business Analysis
- Process Improvement
- Agile Methodology
- Data-Driven Decision Making
- Cross-functional Collaboration
Here are some of the projects that highlight my analytical capabilities and impact:
- Technologies: SQL, Python, Power BI
- Description: Delivered a complete Business Intelligence solution from data cleaning and feature engineering in Python to SQL-based analysis and Power BI dashboards for a massive ₹217M+ retail dataset.
- Impact: Developed 16+ business-driven SQL queries for KPI tracking and segmentation, performed RFM segmentation identifying a high-value customer group generating 82% of total revenue. Assessed promotional performance, identifying ₹46.4M margin leakage due to discount overuse, and recommended process improvements via loyalty programs. Built interactive Power BI dashboards for self-service reporting.
- [(https://github.com/Dakshta-Dhanker/customer-shopping-behavior-analysis)]
- Technologies: SQL, Tableau
- Description: Integrated and standardized 15,351 records across 7 countries into PostgreSQL, resolving data quality issues. Conducted analytical queries to identify unseasonal climate events and quantify their $766B economic impact over two years.
- Impact: Built a 2-page Tableau dashboard with dynamic filters and KPI comparisons, translating analytical findings into clear business and policy insights for non-technical stakeholders.
- [(https://github.com/Dakshta-Dhanker/climate-change-analysis)]
- Technologies: Microsoft Excel
- Description: Analyzed 55,500 healthcare records ($1.41B billing) across a multi-hospital network using advanced Excel analytics.
- Impact: Created executive dashboards with Pivot Tables, charts, and slicers for operational and demographic analysis. Identified high emergency admission rates (66.4%) and abnormal test result patterns, supporting staffing and follow-up process decisions. Ensured data quality and validation.
- [(https://github.com/Dakshta-Dhanker/Healthcare-Business-Analysis)]
- Master of Computer Applications (MCA) | Vellore Institute of Technology (VIT) (2024-2026)
- Coursework: DBMS, Python, Statistics for Data Science, Machine Learning, AI, Data Mining, Big Data Analytics
- Bachelor of Vocation - Software Development & IT | Ramanujan College, University of Delhi (2019-2022)
- Graduated 1st in Class | P.K. Kaul Memorial Scholarship
- Verified SQL Specialist (Basic, Intermediate & Advanced) - HackerRank
- Data Visualization: Empowering Business with Effective Insights Job Simulation - Tata Group / Forage
- Data Analytics Job Simulation - Deloitte / Forage
I'm always eager to learn, collaborate, and contribute to impactful data-driven projects. Feel free to reach out!
- LinkedIn: https://www.linkedin.com/in/dakshta-dhanker/
- Email: dakshtadhanker14@gmail.com
- My GitHub: You are here! :)