Skip to content

Shikha1699/Shikha1699

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

3 Commits
Β 
Β 

Repository files navigation

πŸ‘‹ Hello, I'm Shikha Nautiyal!

Welcome to my Data Playground! 🌟
Here, numbers tell stories, data drives decisions, and insights shape the future. πŸ“Šβœ¨


😎 About Me: The Data Explorer

I’m a Data Analyst with a MSc in Mathematics and a passion for turning raw data into actionable insights.
I thrive on Python, SQL, Tableau, Power BI, and Excel, and I love solving complex problems with elegant, data-driven solutions.

  • πŸ“ Location: Dehradun, Uttarakhand, India
  • πŸ“§ Email: [email protected]
  • πŸ“± Phone: +91 9410162254
  • 🌐 LinkedIn |

βš™οΈ My Toolkit: Where the Magic Happens! βš™οΈ

Programming & Analysis:

Python 🐍 | SQL πŸ—„οΈ | MS Excel πŸ“Š

Data Visualization & BI:

Tableau πŸ“ˆ | Power BI πŸ“Š | Data Cleaning & EDA πŸ”

Statistical & Analytical Skills:

Regression Analysis | Probability & Statistics | KPI Tracking | Optimization Techniques | Critical Thinking

Tools & Platforms:

Visual Studio Code | Git | Reporting Automation | Dashboard Storytelling


✨ Projects in Action ✨

Optimizing Retail Insights – Walmart Case Study

  • Analyzed multi-branch sales using SQL, identifying 18.5% monthly growth in top-performing branch.
  • Discovered top 20% customers drive 55% of total sales β†’ informed targeted loyalty strategies.
  • Revealed peak sales periods (31% revenue on weekends) β†’ optimized staffing & promotions.
    View Project

Customer Segmentation & Sales Insights – KPMG (Excel Project)

  • Cleaned and analyzed customer demographics & transactions.
  • Built interactive Excel dashboards to present KPIs: retention, revenue, regional sales.
  • Conducted segmentation & EDA to drive actionable marketing strategies.
    View Project

Airline Performance Dashboard – Power BI Project

  • Collected & cleaned airline performance data to evaluate delays, cancellations, and satisfaction.
  • Built interactive Power BI dashboards with slicers and KPIs.
  • Delivered actionable insights to improve operational decisions.
    View Project

πŸŽ“ Education & Certifications

Master of Science in Mathematics – HNB Garhwal University, Uttarakhand, India
Relevant Coursework: Probability & Statistics, Regression Analysis, Data Visualization, Python for Mathematics

Bachelor of Science – HNB Garhwal University, Uttarakhand, India

Certifications:

  • Google Data Analytics Professional Certificate – Coursera
  • SQL for Data Science – Coursera
  • Training in Data Science – Internshala

πŸ’‘ Professional Interests

Business Analytics | Marketing Analytics | Financial Services | Data Automation | Reporting Optimization


πŸ“¬ Connect with Me

Let’s turn data into stories and insights into action!
LinkedIn |

About

Hi there πŸ‘‹ , I'm Shikha

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors