Skip to content

Personal data analytics portfolio featuring Python, Excel, and Power BI projects.

Notifications You must be signed in to change notification settings

shajithkhan-dev/shajithkhan-dev.github.io

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

20 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“Š Shajith Khan – Data Analyst Portfolio

Welcome to my personal Data Analyst & Business Intelligence Portfolio website.
This portfolio showcases my technical skills, analytics projects, and hands-on experience in transforming raw data into meaningful business insights.

πŸ”— Live Portfolio: (Add your GitHub Pages link here)


πŸ‘¨β€πŸ’» About Me

Aspiring Data Analyst / Business Intelligence Analyst with practical experience in:

  • Python data analysis
  • Excel data cleaning & feature engineering
  • SQL querying & data extraction
  • Power BI dashboard development

I enjoy turning complex datasets into clear visual stories that support data-driven decision-making.

Tools & Technologies:
Python | Power BI | SQL | Excel | Matplotlib | Pandas


πŸš€ Featured Projects

πŸ›’ Sales & Retail Data Analysis

Analyzed a retail superstore dataset (6,000+ records) to uncover sales trends, regional performance, and profit drivers.

Key Contributions:

  • Cleaned and preprocessed raw retail sales data using Python
  • Conducted exploratory data analysis (EDA)
  • Built visualizations comparing sales, profit, and discount patterns
  • Evaluated regional and category-level performance

πŸ“ˆ Impact:
Identified high-discount driven losses and low-profit product categories, enabling better pricing and product strategy decisions.

Tech Stack: Python, Pandas, Matplotlib


πŸ‘©β€πŸ’Ό Employee Salary & Compensation Dashboard

Designed an interactive HR analytics dashboard to analyze salary distribution and experience-based compensation trends.

Key Contributions:

  • Cleaned and structured HR data using Excel
  • Engineered experience and salary-based metrics
  • Built Power BI data model and DAX measures
  • Designed a storytelling-focused dashboard layout

πŸ“Š Impact:
Created a reusable dashboard for tracking salary trends, pay gaps, and experience-level compensation growth to support workforce planning.

Tech Stack: Excel, Power BI, DAX


πŸ’Ό Experience

Data Operations Intern β€” Omandurar Medical College (6 Months)

  • Built operational reports and dashboards using Advanced Excel
  • Cleaned and validated large hospital datasets
  • Prepared performance reports for management review
  • Improved reporting clarity and data organization

πŸ› οΈ Portfolio Website Features

  • Responsive design (Mobile + Desktop)
  • Interactive skill cards
  • Flip-card project showcase
  • Dark / Light theme toggle
  • Resume download option
  • Contact form integration
  • SEO-optimized metadata

πŸ“‚ Project Structure

πŸ“ Portfolio ┣ πŸ“ assets ┃ ┣ πŸ“ images ┃ β”— πŸ“ resume ┣ πŸ“ css ┣ πŸ“ js ┣ πŸ“„ index.html β”— πŸ“„ README.md


πŸ“¬ Contact


⭐ If you found this portfolio helpful or interesting, feel free to star the repository!

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •