Skip to content
View Dairanji's full-sized avatar

Block or report Dairanji

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 is supported. This note will only be visible to you.
Report abuse

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

Report abuse
Dairanji/README.md

Shayantan Mitra - Data Analyst Portfolio

🙋‍♂️ About

Hi, I'm Shayantan Mitra 👋

Aspiring Data Analyst with a B.Sc. in Computer Science and 2.5+ years of experience in business operations, SAP-based reporting, and data management at RCF Ltd. Passionate about transforming raw data into actionable insights using Excel, SQL, Power BI, and Python. Currently on track to completing my Professional Certification in Data Analytics with GenAI by IITM Pravartak from Coding Ninjas.

  • Skilled in Data Analysis, Data Visualization, Business Reporting, and Dashboard Development
  • Experienced with Excel, SQL, Power BI, SAP SD, Python, and Data Cleaning
  • Interested in Business Intelligence, Financial Analytics, and Data-Driven Decision Making

"Turning data into insights and insights into decisions."

📄 Download CV

📚 Table of Contents

📊 Data Analysis

Project LinkCompletion DateToolsProject Description
JobMarket-InsightsJuly 2026Python, SerpAPI, MySQL, SQL (aggregation, GROUP BY), Power BIBuilt an end-to-end pipeline scraping 11,000+ IT job postings across 42 Indian cities via SerpAPI, cleaning and loading the data into MySQL, then querying it in SQL to surface skill demand, top hiring companies, and employment trends, visualized in a Power BI dashboard.

📗 Excel

Project LinkCompletion DateFunctions & FeaturesProject Description
Weekly Stock Comparison TrackerMarch 2026SUM, SUMIFS, GETPIVOTDATA, PIVOT TABLE, SLICER, CHARTS, DASHBOARDDeveloped and maintained an aging stock tracker for fertilizer dealers across West Bengal. The workbook involved structuring dealer-wise data across district sheets, applying multi-criteria lookup formulas for aggregation, building Pivot Tables and Slicers for filtering, and creating a dashboard with an automated email outreach feature.

📈 Power BI

Project LinkCompletion DateProject DescriptionDashboard
24-25 VS 25-26 Financial-Year-Sales-AnalysisApril 2026Developed a Power BI dashboard comparing RCF's sales performance across two financial years. The report combined data into a single fact table, applied DAX measures to isolate and compare period-specific volumes, and presented findings across five pages covering trends, districts, product mix, and plant-level analysis.Download

🤝 Connect With Me

Popular repositories Loading

  1. Dairanji DairanjiPublic

    This is a repository for showcasing my skills, share projects and track my progress in Data Analytics related topics.

    1

  2. populate_mongoDB populate_mongoDBPublic

    Open Source webapp to demonstrate how populate works in MongoDB. TO-DO: Please add your personal mongo id/pass in server.js ,line: 32.

    EJS

  3. auth_Login_jwt auth_Login_jwtPublic

    Open source webapp Login/Register system with Jwt-Token npm.

    JavaScript

  4. crud_fileUpload crud_fileUploadPublic

    Open source MERN STACK based back end CRUD method with the ability to upload images.

    JavaScript

  5. role_management role_managementPublic

    Open source webapp to Demonstrates the roles of User and Admin in an webapp.

    EJS

  6. jwtAuth_Api jwtAuth_ApiPublic

    Open Source webapp with login/register system with jwtToken. Api has been tested with Postman API.

    HTML