Portfolio - Suraj Prajapati

Hello, I am

Suraj Prajapati

Data Aspirant

Resume

1

Excel
Project

3

PowerBI
Projects

About

👋 Meet Me! 👋

I'm a budding Data Analyst with a keen eye for making sense of numbers and a toolkit that includes Excel, PowerBI, SQL, and Python. While my college degree is in Electronics & Telecommunication Engineering, my true calling lies in the data world.

Here's the fun part: I might not have corporate stripes in this field yet, but I've been on some exciting data adventures through various business projects. You can check out the proof in my portfolio, just a scroll away!

I'm all about proving that passion and skills matter more than a formal job title. Ready to dive into the world of data with fresh enthusiasm and a track record of turning data into real, practical insights? If you're on the lookout for a Data Analyst with a knack for making data fun and useful, then let's connect and unleash the data magic! 🚀📊💡

Key

Skills

SQL

Problem Solving

Analytical Mindset

Python

Power Query

Data Visualisation

My

Projects

Sales Analytics using Excel, Power Query and Power Pivot

Purpose of Sales Analytics:
Empower businesses to monitor and evaluate their sales activities and performance. By analysing sales data, we can identify sales patterns and track essential key performance indicators (KPIs).

Business Insights 360 - AtliQ Hardware

In this project, I harnessed the power of Power BI to provide comprehensive data-driven solutions for Sales, Marketing, Finance, and Supply Chain teams, enabling them to make informed business decisions.

Revenues Insights - Hospitality Industry

In my this "Revenues Insights" project, I've harnessed the power of Power BI to unveil a treasure trove of data-driven insights in the dynamic Hospitality sector. 🏨

Call Center Trend Analysis: Uncovering Hidden Insights with Power BI

I delved into the world of call center data, unraveling hidden patterns and trends that could significantly impact business performance. Utilizing Power BI, I transformed a CSV dataset into a comprehensive dashboard, providing valuable insights into:
Call volume trends over time
Agent performance

Contact Me

Email

[email protected]

Github

https://github.com/suraj-praja?tab=repositories

https://www.linkedin.com/in/suraj-prajap/

Call

+91 7666488055

Suraj Prajapati

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics using Excel, Power Query and Power Pivot

Purpose of Sales Analytics: Empower businesses to monitor and evaluate their sales activities and performance. By analysing sales data, we can identify sales patterns and track essential key performance indicators (KPIs).

View Project
Engagement

View Project
on GitHUB

P&L Statement by FY

P&L

Project Details

📈 **Sales Report:**
Objective:
1. Created a customer performance report
2. Conducted a comprehensive comparison between market performance and sales targets

Purpose of Sales Analytics:
Empower businesses to monitor and evaluate their sales activities and performance. By analyzing sales data, we can identify sales patterns and track essential key performance indicators (KPIs).

PowerBI Project

Business Insights 360 - AtliQ Hardware

View Project
Engagement

View Project
on GitHUB

Home Page of Dashboard which navigates us to various views of the reports department wise.

Executive View of the projects where Top Executives of the company can view and take the informed decisions for the company.

Project Details

📊 Excited to share my latest project: Business Insights 360 - AtliQ Hardware 🚀
In this project, I harnessed the power of Power BI to provide comprehensive data-driven solutions for Sales, Marketing, Finance, and Supply Chain teams, enabling them to make informed business decisions. Here's a snapshot of what I accomplished:
✅ Data Sources: Integrated data from SQL Server and Excel datasets.
✅ Data Transformation: Cleaned and transformed data for meaningful insights.
✅ Data Modeling: Created essential tables and columns.
✅ Measures: Developed key performance indicators (KPIs) and measures for accurate analytics.
✅ Dashboard Design: Crafted professional, user-friendly dashboards.
✅ Visualizations: Utilized charts, matrices, and interactive filters.
✅ Actionable Insights: Enabled easy page navigation with actionable buttons.

Live Interactive Dashboard

PowerBI Project

Revenues Insights - Hospitality Industry

In my this "Revenues Insights" project, I've harnessed the power of Power BI to unveil a treasure trove of data-driven insights in the dynamic Hospitality sector. 🏨

View Project
Engagement

View Project
on GitHUB

Main Dashboard which provides us various key information about Hospitality Industry.

Revenue KPI which also includes tool tips in which revenue is shown on week on week basis.

Project Details

Project Highlights:
📈 Percentage of revenue by Room Category.
💼 Realization % & ADR by Booking Platforms.
📊 Matrix table visualizing key performance indicators such as Revenue, Total Bookings, Occupancy %, Cancellation %, Average Ratings, and more.
📅 Performance analysis by weekdays and weekends Our executive teams can make informed business decisions on the basis of this analysis.

Live Interactive Dashboard

PowerBI Project

Call Center Trend Analysis: Uncovering Hidden Insights with Power BI

View Project
Engagement

Dashboard Home Page

Homepage

Project Details

📊✨ Just wrapped up an exciting journey into Call Centre Trend Analysis using Power BI! 🚀 Leveraging the power of Excel and Canva, I transformed raw CSV data into a visual masterpiece. 📈

🔍 Explored insights like No. of Answered & Resolved Calls, Monthly Call Distribution, Agent Stats, and Average Customer Satisfaction. 📞📆

💡 The real game-changer? Crafting custom visualizations with pie charts, gauge meters, and more for that extra flair! 🎨

⏱️ Dive into the data: Unveiled the average seconds an agent takes to answer calls and the total talk duration. ⏳💬

📊 Created an aesthetically pleasing dashboard that speaks volumes! 🌈

👥 Let's connect and explore the world of analytics together! 🌐 Open to exciting opportunities in Data Analytics and Business Intelligence. 🚀

I have created this project by utilising learning from Codebasics Data Analytics - Bootcamp. Special Thanks to Hemanand Vadivel & Dhaval Patel for making such a great bootcamp & learning platform.

Hello, I am

Suraj Prajapati

1

3

About

Key

My

Sales Analytics using Excel, Power Query and Power Pivot

Business Insights 360 - AtliQ Hardware

Revenues Insights - Hospitality Industry

Call Center Trend Analysis: Uncovering Hidden Insights with Power BI

Contact Me

Email

Github

Linkedin

Call

Suraj Prajapati

Download Resume