Skip to content
View dakshbhatnagar's full-sized avatar
πŸ“ˆ
Crunching Numbers
πŸ“ˆ
Crunching Numbers

Organizations

@Swupel-PMS

Block or report dakshbhatnagar

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
dakshbhatnagar/README.md

πŸ•΅πŸΌ Daksh Bhatnagar

Data Analyst | Reporting Analyst | BI Analyst

πŸ” About Me

  • 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


πŸ› οΈ Skills

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)

πŸ† Achievement

Earned the prestigious notebooks master medal on Kaggle

image


GitHub Stats

Daksh's GitHub Stats


πŸ‘¨β€πŸ’» Experience

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.

πŸ“ˆ Recent Personal Projects

  1. Olympics Data Analysis and more using Python: Find projects on in-depth ARIMA Modelling, Olympics Data Analysis, and more! Check it out here.

  2. 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.

  3. Maximizing Sales Conversions: A Looker Studio Dashboard that goes in-depth on how a travel company can maximize their Sales Conversion - Link.

  4. Tableau Tales: Explore insights on COVID-19, Digital Payment Trends in India, and more with Tableau - Take a peek here.

  5. 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.

πŸ“‡ Contact Details

πŸ”— LinkedIn
πŸ“§: [email protected]


Thanks for stopping by!

Pinned Loading

  1. SQLProjects SQLProjects Public

    Personal SQL Projects Repository

    Jupyter Notebook

  2. projects projects Public

    All Python Projects

    Jupyter Notebook