Portfolio - Rohith Godeshi

Hello, I am

Rohith Godeshi

Data Aspirant

About Me.

I am an aspiring Data Analyst with expertise in Excel, Power BI, SQL, and Python, passionate about transforming data into meaningful insights. With a bachelor’s degree in Electrical and Electronics Engineering, I discovered my true potential in data analysis, where my analytical mindset and problem-solving skills naturally excel. Though I haven’t worked in a formal organizational role, I’ve completed several business-focused projects that showcase my ability to analyze complex datasets, create dynamic visualizations, and deliver actionable solutions. These projects, detailed in my portfolio below, reflect my commitment to learning and real-world application of data analytics. I am excited to contribute to innovative organizations, tackle challenging problems, and grow as a data professional while making a meaningful impact through data-driven strategies.

1

Excel Project

1

PowerBI Project

Skills.

Excel

Power BI

SQL

Python

Projects.

Awards & Certificate.

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Contact.

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 CV

[email protected]

Call Me

+91 9390407189

https://www.linkedin.com/in/rohith-godeshi-0634b5237/

GitHub

https://github.com/rohithgodeshi21

Excel Project

Sales Analytics

Domain/Function: (FMCG)

Created two Excel-based reports to help the sales team evaluate customer performance and track market performance against targets, enabling data-driven insights and better decision-making.

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 designed a sales report using Excel pivot tables to help businesses optimize their sales strategies. The report enables businesses to determine effective customer discounts, improve consumer negotiations, and identify expansion opportunities in promising markets. By delivering actionable insights, the report supports enhanced decision-making to boost customer satisfaction and maximize revenue.

I have learned and applied the following skills during this project:
1. Pivot Tables
2. Power Query
3. Basic DAX
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

This project equips businesses with tools and insights to monitor, evaluate, and enhance their sales activities. By analyzing sales data, businesses can unlock growth opportunities, drive competitive strategies, and achieve sustainable success in dynamic market environments.

PowerBI Project

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

Domain/Function: Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares is a rapidly expanding consumer electronics company struggling to compete as most of its reports still exist in Excel. My goal is to implement an advanced analytics solution using Power BI, enabling the company to gain real-time insights and make data-driven decisions. This solution

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

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal was to create a unified report that serves stakeholders from sales, marketing, finance, and the executive team. The focus was on:
1. Robust Data Modeling
2. User-Centric Report Design
3. Drillable Insights for detailed analysis

Throughout this project, I gained valuable experience in the following areas:
1. Power Query (Basic and Advanced Operations)
2. Complex and basic DAX formulas
3. Advanced data modeling with 10+ tables
4. Selecting appropriate visuals and formatting for clarity
5. Principles of effective dashboard design
6. Utilizing bookmarks for interactive reports
7. Deploying reports on Power BI Service
8. Implementing stakeholder feedback for continuous improvement
9. Integrating metrics across Sales, Marketing, Finance, and Supply Chain
This project strengthened my ability to create actionable reports that meet stakeholder needs and drive data-driven decisions across departments.