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)
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
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
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
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
- Responsive design (Mobile + Desktop)
- Interactive skill cards
- Flip-card project showcase
- Dark / Light theme toggle
- Resume download option
- Contact form integration
- SEO-optimized metadata
📁 Portfolio ┣ 📁 assets ┃ ┣ 📁 images ┃ ┗ 📁 resume ┣ 📁 css ┣ 📁 js ┣ 📄 index.html ┗ 📄 README.md
- 📧 Email: shajithkhanprof@gmail.com
- 💼 LinkedIn: https://www.linkedin.com/in/mohammed-shajith-khan-196918292
- 🧑💻 GitHub: https://github.com/shajithkhan-dev
⭐ If you found this portfolio helpful or interesting, feel free to star the repository!