Nakka Rohitha

Data Analyst

[email protected] +91 9100696250

Resume

Hello, I am

Nakka Rohitha.

3

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Welcome to my data analyst portfolio. I am Rohitha N. I have completed my bachelor's in computer science. Since day one, I have known that data is my passion.

I am a data analyst with strong expertise in SQL, Python, Excel, and BI tools such as Power BI and Tableau. I specialise in transforming raw data into meaningful insights that drive business decisions. My experience spans data cleaning, visualisation, and statistical analysis, with a focus on identifying trends, solving business problems, and improving operational efficiency.

I am particularly interested in analytics for technology, e-commerce, and financial services, where data-driven strategies create measurable impact. I enjoy working at the intersection of data, business, and decision-making, and I am continuously enhancing my skills in predictive modelling and advanced analytics to deliver end-to-end solutions.

Key Skills

SQL

Tableau

Python

Statistics

My Projects

Hospitality-Dialysis of Patients

Shield Insurance

"Analyzing Guest Trends and Revenue Patterns: A Comprehensive Hotel Management Analysis Project"

Domain/Function: E-Commerce

Banking Analytics Dashboard

Domain/Function: EDA Project

HR analytics -Employee Retention

Domain/Function: Tableau

Business Insights 360 – E-Commerce Project

Domain/Function: E-Commerce, Business Analytics

Awards & Certificate

Microsoft Power BI Data Analyst

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.

Mail Me

[email protected]

https://www.linkedin.com/in/rohitha-nakka-3124a1225/

Call Me

+91 9100696250

GitHub

https://github.com/Rohzi

PowerBI Project

Hospitality-Dialysis of Patients

The healthcare industry has a bunch of challenges to deal with, like improving patient care, managing resources efficiently, and handling finances well. To tackle these issues.

It involves the development of a main dashboard and six sub-dashboards, each focusing on specific key performance indicators (KPIs)

The project's goal is to address critical issues in the healthcare industry by utilizing data-driven approaches to make smarter decisions.

Project Details

we need data analytics solutions that can dig out useful insights from the huge amount of data available. The problem is that the data is super complex and there's just so much of it, which makes it tough for healthcare pros to find the info they need and make quick decisions.
The main and sub-dashboards in healthcare analytics offer a user-friendly platform for data exploration. Key benefits include enhanced understanding of crucial KPIs, improved decision-making through real-time visualizations, and continuous performance monitoring. The user-friendly interface ensures ease of use and accessibility for healthcare professionals.

Live Interactive Dashboard

PowerBI Project

Shield Insurance

Shield Insurance is a company that offers a variety of insurance products to individuals and businesses. They aim to protect clients from financial loss by providing reliable and accessible insurance solutions tailored to meet specific needs.

View Project
Engagement

⚡General View Page: - Monthly revenue display - Customer growth trends -Customer revenue trends -Filters are added in every page

⚡Sales Mode Page: Shows trends and the revenue impact of different sales modes.

Project Details

I used Power Query to clean and validate data for integrity. I added extra dimension tables to simplify calculations and relationships in the data model and created necessary measures.
Added extra dimension tables were included to simplify complex calculations and relationships within the data model, streamlining analysis.

📊Revenue Trends:
- Tracked and visualized revenue growth and patterns over time.
- Identified key areas of growth and potential revenue dips.
📈Customer Engagement:
- Analyzed metrics related to total active users and unsubscribed users.
- Examined trends in customer engagement and retention rates.
🔍 Sales Performance:
- Evaluated the performance of different insurance plans.
- Highlighted top-performing sales and identified those that needed reevaluation.
💡Actionable Insights:
- Offered strategic recommendations to enhance business outcomes.
- Suggested initiatives for improving customer satisfaction and retention.

Live Interactive Dashboard

SQL Project

"Analyzing Guest Trends and Revenue Patterns: A Comprehensive Hotel Management Analysis Project"

Domain/Function: E-Commerce

Hotel Management Analysis Project Optimizing Guest Experience Through Data-Driven Insights* This project focuses on analyzing key metrics such as guest booking patterns, stay duration, and revenue generation to provide actionable insight

View Project
on GitHUB

This project showcases my ability to work with complex datasets, apply SQL to derive meaningful business insights.

It demonstrates the practical application of SQL for enhancing operational efficiency, customer satisfaction, and revenue growth in a hotel management

Project Details

he project leverages advanced SQL techniques, including complex joins, window functions, and conditional aggregations, to extract actionable insights from historical booking data.
Key Highlights:

Guest Behavior Analysis: Identified the most frequent guests and their booking habits, helping the hotel to tailor personalized marketing strategies and loyalty programs.
Revenue Optimization: Calculated the total revenue generated by each guest, taking into account their stay duration and amount spent per booking. This analysis supports better pricing strategies and upsell opportunities.
Average Stay Duration: Analyzed guest stay patterns to determine the average length of stay, enabling the hotel to improve room allocation efficiency and predict future booking trends.

Python Project

Banking Analytics Dashboard

Domain/Function: EDA Project

Analyzed a comprehensive banking dataset using SQL Server and Python (Pandas, NumPy, Matplotlib, Seaborn) to perform data cleaning and exploratory analysis. Built an interactive Power BI dashboard showcasing key insights on loan performance, deposits, and client engagement.

View Project
on GitHUB

💵 Deposit Analysis: Displays deposit trends across account types and regions, with European clients leading in deposits

Loan Analysis: Shows loan distribution by income band, nationality, and occupation, revealing that mid-income & European clients have the highest Loan

Project Details

🏦 Banking Analytics Dashboard
This project showcases end-to-end data analysis and visualization skills applied to a comprehensive banking dataset. Using SQL Server for data storage and Python (Pandas, NumPy, Matplotlib, Seaborn) for data cleaning and exploratory analysis, I uncovered key insights into customer behavior, loan distribution, and deposit patterns. The data was then visualized in an interactive Power BI dashboard featuring metrics like Total Clients, Total Loans, Deposits, Fees, and Engagement Duration. Insights revealed that mid-income clients hold the highest loan amounts, while European clients lead in both deposits and lending activity. This project demonstrates expertise in integrating SQL, Python, and Power BI to transform raw data into actionable financial intelligence.

HR analytics -Employee Retention

Domain/Function: Tableau

Department-wise Attrition Analysis Conducted detailed attrition analysis across all departments. Identified top 3 departments with highest attrition: e.g., Sales (18%), R&D (15%), Customer Support (20%).

View Project
on GitHUB

View Project
on Tableau Public

Attrition Rate vs Monthly Statistics Built a time-series dashboard to monitor monthly attrition trends. Identified seasonal attrition spikes,

. Average Working Hours by Department Analyzed working hours by department using system login data and manager feedback.

Project Details

Gender-based Attrition Trends (e.g., Research Scientists)

Analyzed attrition trends by gender within technical roles, especially Research Scientists.

Found female attrition rate at 12%, compared to 8% for male peers.

PowerBI Project

Business Insights 360 – E-Commerce Project

Domain/Function: E-Commerce, Business Analytics

In this project, I developed Business Insights 360, a comprehensive analytics platform tailored for e-commerce businesses. The platform delivers deep insights across multiple views.

Finance View: A detailed breakdown of revenue, costs, and profitability metrics. Sales View: Key performance indicators like sales trends, conversion.

Market View: Competitive analysis and market trends to inform strategic decisions. Supply Chain: Monitoring logistics, inventory levels.

Project Details

This initiative aims to provide comprehensive insights across various domains, including finance, sales, marketing, and supply chain. By leveraging PowerBi's robust analytics capabilities, the project intends to answer critical questions posed by stakeholders, thereby supporting informed decision-making and strategic planning.