Skip to content
View Swayanshu-Jena's full-sized avatar
🎯
Focusing
🎯
Focusing
1 follower · 0 following

Block or report Swayanshu-Jena

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
Swayanshu-Jena/README.md

github-banner

Hi 👋, I'm Swayanshu Jena

Data Analyst | Transforming Raw Data into Actionable Insights

Profile Views

coding image

👨‍💻 About Me

  • 🎓 Final-year B.Tech CSE student driven by data and powered by curiosity.
  • ⚙️ Currently deepening my expertise in Data Warehousing architecture (using Snowflake), big data processing with PySpark, and advanced Python (Pandas, NumPy, Matplotlib).
  • 📊 Passionate about building robust data portfolios, designing efficient schemas, and uncovering hidden patterns in complex datasets.
  • ⚡ Fun fact: I get genuinely excited when a pivot table works on the first try.

🤝 Connect with me:

LinkedIn     Kaggle     Instagram

📄 View My Resume


🛠️ Languages & Tools

Python Pandas NumPy Matplotlib
MySQL PostgreSQL Snowflake PySpark
Excel Power BI Git Linux

🚀 Featured Projects

🏥 Hospital ER Analytics Pipeline

An end-to-end data pipeline analyzing emergency room operations. Extracted and transformed data using Python, loaded it into a Snowflake data warehouse, and visualized patient flow metrics in Power BI.

Python Snowflake Power BI

📱 Mobile Sales Performance Dashboard

An interactive Power BI dashboard analyzing mobile phone sales data. Leveraged dynamic filtering and DAX measures to uncover revenue trends, brand performance, and regional sales distribution.

Power BI Data Viz

🎬 Netflix Content Strategy Analysis

Comprehensive exploratory data analysis (EDA) of Netflix's catalog using complex SQL queries. Investigated content release trends, genre popularity, and rating distributions to extract actionable business insights.

SQL EDA

🚑 Healthcare ER Operational Dashboard

Advanced Excel dashboard tracking key hospital ER metrics. Utilized Pivot Tables, VLOOKUPs, and conditional formatting to monitor patient wait times, admission rates, and departmental efficiency.

Excel Data Cleaning

📈 GitHub Analytics

GitHub Stats GitHub Streak


Top Languages

Pinned Loading

  1. Hospital-ER-Analytics-Python-Snowflake-PowerBI Hospital-ER-Analytics-Python-Snowflake-PowerBI Public

    📌End-to-end healthcare data pipeline featuring PySpark ETL, Snowflake secure cloud warehousing (RBAC & Dynamic Masking), and real-time Power BI DAX modeling for ER analytics.

    Python

  2. Healthcare_Emergency_Room_Analysis_Excel Healthcare_Emergency_Room_Analysis_Excel Public

    🚑 An interactive Excel dashboard analyzing hospital ER performance. Tracks key metrics like patient wait times, admission rates, and satisfaction scores to identify operational efficiencies and imp…

  3. Mobile_Sales_Analysis_Power-BI Mobile_Sales_Analysis_Power-BI Public

    📊 A Power BI sales analytics dashboard visualizing ₹769M in mobile revenue across 19K units. Analyzes payment trends, geographic performance, and product-wise sales to drive inventory and strategic…

  4. Netflix_Content_Analysis_SQL Netflix_Content_Analysis_SQL Public

    📈 This project explores Netflix's movie and TV show dataset using SQL to uncover insights about content trends, ratings, genres, and release patterns. The analysis includes data cleaning, querying,…

  5. OXFORD_Book_Store_SQL OXFORD_Book_Store_SQL Public

    📚 A comprehensive SQL analysis of a relational database, querying books, customers, and orders. Uncovered key insights on sales trends, inventory status, and customer behavior. Demonstrates strong …