Powered by
Codebasics DA Bootcamp

Nakka Rohitha

Data Analyst

+91 9100696250 [email protected]

Resume

Hello, I am

Nakka Rohitha.

2

PowerBI Projects

1

SQL 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.

To analyze data, I use various tools and technologies to collect, clean, preprocess, organize, and analyze data to make better decisions.

In this portfolio, I have included a variety of projects that showcase my data analytics skills. You will find links to my dashboards and reports created using various tools. These projects demonstrate my ability to analyze and present data in a clear and visually appealing way, making it easy for decision-makers to understand the insights and take action.

I hope my portfolio is not only informative but also truly engaging. I eagerly welcome any opportunity to further discuss my qualifications with you.

Let's ensure we stay connected to delve deeper into the discussion about data.

Key Skills

SQL

Tableau

Python

Statistics

My Projects

Awards & Certificate

Microsoft Power BI Data Analyst

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.

[email protected]

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

+ 91 9100696250

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.

Hospitality-Dialysis of Patients

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

Hospitality-Dialysis of Patients

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

Shield Insurance

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

Shield Insurance

⚡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.