- Hi, My Name is Daksh Bhatnagar. A Finance Post Graduate and a Data Analyst with 2 Years Of Experience based out of New Delhi currently working as Technology Associate in ZS Associates, Gurgaon.
- Iβm passionate about empowering businesses with data-driven insights through effective analysis and comprehensive reporting.
- My core focus is on transforming complex data into actionable strategies that drive decision-making, along with implementing automated solutions that enhance efficiency and cut costs.
- With a sound understanding of analytics tools, Iβve dedicated my efforts to streamlining processes, boosting data accessibility, and continuously improving operational performance.
π View my resume
πΌ Portfolio Website
Databases: | MySQL, SQLite3 |
Spreadsheets: | Advanced MS Excel, Advanced Google Sheets |
Programming: | Python, Pandas, Numpy, Matplotlib Google AppScript |
BI Tools: | Looker Studio, Tableau |
Cloud: | Google Cloud Platform (GCP) |
Earned the prestigious notebooks master medal on Kaggle
In my current role as a Data Analyst, I have:
- Developed real-time data pipelines using Google Sheets, which increased data availability and decision-making efficiency by 20%.
- Enhanced stakeholder data comprehension by 15% by creating engaging visualizations using Looker Studio.
- Addressed rising subscription costs by identifying inefficiencies after monitoring job portal usage, leading to a reduction of 68,000 INR per month, saving the company 816,000 INR annually.
- Improved operational efficiency and reporting frequency by 30% by automating reporting processes using Google AppScript and Python, reducing an hour worth of daily manual work.
- Streamlined the appraisal document creation process by implementing an automated solution using AppScript, ensuring timely and organized document distribution for the team.
- Reduced 10-12 hours a week worth of workload and improved accuracy in incentive calculations by automating monthly and quarterly computations for Recruiters, Team Leaders, and Account Managers using SQL within Python, integrated with the Google Sheets API.
- Centralized and updated scattered service agreement data in Google Sheets, highlighted expired records with Conditional Formatting, and automated follow-up alerts and mail reports using Google AppScript, resulting in 60% improved data accessibility and proactive management.
- Olympics Data Analysis and more using Python: Find projects on in-depth ARIMA Modelling, Olympics Data Analysis, and more! Check it out here.
- SQL Projects on HR Data, Restaurant Data, and more: The repository contains SQL Projects in various industries such as HR, Food, and Data Jobs to uncover valuable insights.
- Maximizing Sales Conversions: A Looker Studio Dashboard that goes in-depth on how a travel company can maximize their Sales Conversion - Link.
- Tableau Tales: Explore insights on COVID-19, Digital Payment Trends in India, and more with Tableau - Take a peek here.
- Finding Interesting Insights about Super Store: Dive deep into the world of retail store analysis done using Google Sheets and Looker Studio - Check it out here.
π LinkedIn
π§: [email protected]
Thanks for stopping by!