Portfolio - Venkata Sai Prameela

Venkata Sai Prameela

Data Analyst

Resume

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

My name is Venkata Sai Prameela. I am a B.Tech graduate in Computer Science Engineering with a diverse career journey. I initially worked as an HR Generalist at Studio Interlace, an architecture firm and family business, where I supported HR functions, administrative tasks, recruitment, and financial operations. Seeking to transition into the field of data analytics, I completed the Codebasics Data Analytics Boot Camp and earned the Google Data Analytics Certification. I have also done a data analyst internship with Codebasics. Additionally, I worked on projects in our office data, focusing on HR analytics and finance analytics, which helped me start my data analyst career. Currently, I am leveraging my skills and knowledge as a freelance data analyst, providing valuable insights and data-driven solutions to clients.

Key Skills

sql

python

problem solving

critical thinking

communication

My Projects

Customer & Market Performance Reports

Domain/Function: Sales

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Finance,sales,Marketing and Executive

HR Analytics - Presence Insights

Domain/Function: HR Domain

Mitron Bank Credit Card Features!

Domain/Function: Banking Domain

Consumer Goods ad-hoc analysis

Domain/Function: Consumer goods

Hotel Data analytics

Awards & Certificate

Google Data analytics Certification

Codebasics Data analyst Internship

KPMG Data analyst virtual Internship

Hacker ranks -SQL basics

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/venkatasaiprameela/

Call Me

+91 6361216372

GitHub

https://github.com/venkatasaiprameela/venkatasaiprameela

Excel Project

Customer & Market Performance Reports

Domain/Function: Sales

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.
I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics
Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Project video

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Finance,sales,Marketing and Executive

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Live Interactive Dashboard

PowerBI Project

HR Analytics - Presence Insights

Domain/Function: HR Domain

Transformed raw HR data from multiple Excel sheets into actionable insights! Integrated data using Power Query, applied advanced transformations, and loaded it into Power BI

View Project
Engagement

View Project
on GitHUB

Transformed raw HR data with Power BI, revealing attendance and leave metrics, and designed a dashboard to optimize scheduling and resource allocation

unveiling critical metrics such as Total Employee Presence Attendance %, Sick Leave %, and Work from Home %.

Project Details

The HR department needed a comprehensive solution to analyze trends, patterns, and potential productivity obstacles and analyze the presence percentage, work-from-home percentage, and sick leave percentage to understand trends in employee performance and attendance.
🚀 Insights:
📉 Observed a slight decline in overall attendance, balanced by a surge in remote work adoption.
🤒 Noted an uptick in sick leave usage over time, signaling potential areas for employee well-being initiatives.
📅 Identified peak attendance on Tuesdays, emphasizing the importance of mid-week engagement strategies.
🏡 Fridays emerged as the preferred day for remote work, aligning with flexible work arrangements.
⏰ Mondays witnessed the highest incidence of sick leave, highlighting potential areas for operational adjustments.

Project video

Live Interactive Dashboard

PowerBI Project

Mitron Bank Credit Card Features!

Domain/Function: Banking Domain

Mitron Bank aims to introduce a new line of credit cards, expanding its product offerings and market reach. The project's goal is to tailor credit card offerings to match customer needs and market trends, ensuring adaptability to dynamic market shifts.

View Project
Engagement

View Project
on GitHUB

Analyzed 4000 customers' data to develop a Power BI dashboard, revealing insights on income utilization, spending patterns, and city-wise behavior to

Created a Power BI dashboard for Mitron Bank analyzing 4000 customers' data, revealing insights into credit card usage, spending patterns, and demogra

Project Details

🔍 Problem Statement: Mitron Bank seeks to revolutionize its credit card offerings and expand market reach.

🎯 The Challenge: Crafting insightful credit card features using data-driven insights.

✨ Task: Examined data from 4000 customers in five cities, analyzing spending patterns, income levels, and demographics. Developed dynamic Power BI dashboards and a comprehensive PowerPoint presentation.

🔑 Key Insights:

Spending Pattern: Bills, groceries, and electronics are the top categories.
Demographic Insights: Married females aged 25-35, particularly in government jobs, spend more on travel. Consistent usage observed in bills and electronics.
City-wise Behavior: Mumbai is a significant spending hub.
🚀 Strategic Targeting: Specialized credit cards for these segments promise mutual benefits.

🌐 Impact: This targeted approach enhances business growth for both customers and Mitron Bank, across India.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods ad-hoc analysis

Domain/Function: Consumer goods

Atliq Hardwares, a leading computer hardware producer in India expanding globally, aims to enhance data-driven decision-making. They're conducting a SQL challenge to recruit junior data analysts and boost their analytics capabilities.

View Project
Engagement

View Project
on GitHUB

In 2021, Atliq Hardwares grew unique products by 36.32%, focusing on Notebooks and Accessories. Highest cost: "All-in-1 Gen 2" at 240.53,

Top 5 customers get 30.8%-29.3% discounts. Highest sales: October 2020. 2021 sales up except November. Revenue: 1219M from retailers. Top sellers: Pen

Project Details

Atliq Hardwares proposes a structured approach to derive insights from ten ad-hoc data requests to enhance decision-making:

Data Extraction: SQL queries will retrieve relevant data from databases.

Data Visualization: Extracted data will be visualized for clarity and actionable insights.

Insight Generation: Visualizations will inform top management decisions.

Key Insights:

Sales Growth: Unique product sales increased by 36.33% in FY 2021.

Product Performance: Notebooks were top sellers, while Networking products had the lowest sales.

Manufacturing Costs: Desktops incurred the highest costs, with mice being the lowest.

Retailer Contribution: Flipkart led with 30.83% customer contribution, while Amazon had 29.33%.

Sales Trends: March 2020 had the lowest sales (2.8 million units), while November 2021 peaked (32.2 million units).

This approach aims to leverage data analytics for informed decision-making and strategic growth.

Project video

Python Project

Hotel Data analytics

Optimizing Revenue and Occupancy: Data-driven insights for Atliq Grands hotels in Delhi, Mumbai, Bangalore, and Hyderabad to enhance market competitiveness and revenue streams.

View Project
Engagement

View Project
on GitHUB

Average Occupancy Rate by Room Category and per City using property ID. Weekday vs. Weekend occupancy comparison. June's monthly more occupancy

Revenue per city, monthly trends, hotel type breakdown, city ratings, and pie chart of booking platform revenue showcase AtliQ Grands' hospitality.

Project Details

Exploring Data for Atliq Grands: A comprehensive data analytics project in hospitality focusing on revenue and occupancy. Using Python and Pandas, analyzed booking data from Delhi, Mumbai, Bangalore, and Hyderabad hotels (AtliQ Seasons, Exotica, Bay, Palace) via Atliq Grands' and third-party sites. Cleaned, transformed, and explored data to reveal occupancy rates, revenue trends, and platform-specific insights. Recommendations include enhancing revenue strategies and optimizing occupancy for sustained market growth.