Skip to content
View Shikha1699's full-sized avatar
1 follower · 2 following

Block or report Shikha1699

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.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. 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
Shikha1699/Readme.md

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

⚙️ 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 |

Popular repositories Loading

  1. Walmart-Sales-Analysis-SQL Walmart-Sales-Analysis-SQL Public

    SQL project analyzing Walmart sales data to identify performance trends and customer insights.

    1

  2. Shikha1699 Shikha1699 Public

    Hi there 👋 , I'm Shikha

  3. sql-portfolio sql-portfolio Public

    SQL portfolio with 7-day structured practice on the Chinook database