Portfolio - Rohan Savala | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Rohan Savala

Data Aspirant

Resume

1

Excel
Project

2

PowerBI
Projects

About

Me

I'm an aspiring Data Analyst with a Bachelor's degree in Mechanical Engineering. My journey led me to discover a natural talent for data analytics. Proficient in Power BI, SQL, and Python, I excel at transforming data into actionable insights. My unique background in mechanical engineering equips me with a fresh perspective, fostering innovation in data analysis. I'm committed to continuous learning and thrive on deciphering complex datasets. Eager to apply my skills and passion to contribute to your organization's success. Explore my portfolio to see the potential I bring to the world of data analytics."

Key

Skills

effective communication

My

Projects

customer sales performance

customer sales performance

Develop an Analytical system to monitor sales performance , analyze data and generate reports for effective customer discounts and business expansion opportunities.

BUSINESS INSIGHTS 360

BUSINESS INSIGHTS 360

To enhance AtliQ Hardware's competitive edge, I aim to replace Excel-based data with advanced analytics using Power BI for informed and strategic decision-making.

Sales Data Anlaysis

Sales Data Anlaysis

In this project, I dug into a big sales dataset to figure out some really useful stuff. I looked at how sales changed over time, found out what products sold the best, and worked out important money metrics like total sales and profit margins. I also made cool charts and graphs to show off what I fo

Awards

& Certificate

SQL(Basic)

SQL(Intermediate)

SQL(Intermediate)

Contact Me

Email

[email protected]

Github

https://github.com/Rohansavala

Linkedin

http://linkedin.com/in/rohan-savala-b618b8220

Call

+91 9657443073

Rohan Savala

Data Aspirant

Download Resume

Resume

Excel Project

customer sales performance

Develop an Analytical system to monitor sales performance , analyze data and generate reports for effective customer discounts and business expansion opportunities.

View Project
Engagement

customer sales performance

This project is designed to provide a comprehensive assessment of customer performance for Atliq Hardware Company across different countries and years

customer sales performance

This project aims to analyze customer performance data, specifically focusing on profit and loss, organized by fiscal years for Atliq hardware company

Project Details

Project: Sales & Finance Analytics

Steps followed:
▪ ETL using Power Query.
▪ Data Cleaning and preparation using Power Query.
▪ Data modeling using Power Pivot.
▪ Creating Reports using Pivot Tables.

◼ Sales & Finance Reporting:
📊 Create a comprehensive Customer Performance Report and compare Market Performance vs Sales Targets.
📊 Develop Profit and Loss (P&L) reports categorized by Fiscal Year, Months and Markets.

📌 To:
1️⃣ Evaluate Sales Activity and Financial Performance.
2️⃣ Track KPIs.
3️⃣ Support Decision Making.
4️⃣ Explore Business Expansion Opportunities.

🔸 Skills Gained:
▪ Proficiency in ETL methodology
▪ Power Query
▪ Power Pivot
▪ Pivot Tables
▪ DAX
▪ Advanced Functions
▪ Report generation using Pivot tables.

Soft Skills: Great Business Knowledge of Sales and Finance, optimization, and user report design.

PowerBI Project

BUSINESS INSIGHTS 360

To enhance AtliQ Hardware's competitive edge, I aim to replace Excel-based data with advanced analytics using Power BI for informed and strategic decision-making.

BUSINESS INSIGHTS 360

The home page serves as the central hub, offering easy access to a variety of views and comprehensive support resources for seamless navigation

BUSINESS INSIGHTS 360

Data Model

Project Details

Explored the AtliQ Hardware Project:

Orchestrated the design of an interactive and comprehensive dashboard, seamlessly integrating sales, marketing, and financial data.
Facilitated data-driven decision-making processes, elevating the strategic prowess of the organization.
✨ The Power BI learning journey has significantly enriched my experience in making data-driven decisions.
🎯 Utilized Tools:
Proficient in Excel and Power Query for meticulous data handling.
Leveraged Power BI and mastered DAX expressions.
Executed optimization techniques using DAX Studio.
🎯 Key Business Metrics:
Skillfully managed and analyzed metrics such as Gross Sales, Net Invoice Sales, Net Sales, Gross Margin, Net Profit, Deductions, COGS, YTD, YTG, and Market Share.
🎯 Essential Proficiencies:
Developed and implemented KPI indicators for comprehensive performance assessment.
Applied advanced data modeling techniques for nuanced insights.

Live Interactive Dashboard

PowerBI Project

Sales Data Anlaysis

In this project, I dug into a big sales dataset to figure out some really useful stuff. I looked at how sales changed over time, found out what products sold the best, and worked out important money metrics like total sales and profit margins. I also made cool charts and graphs to show off what I fo

View Project
Engagement

Sales Data Anlaysis

Transformed data by identifying headers, splitting datetime, and detecting types. Visualized trends, best-sellers, and revenue metrics using charts an

Sales Data Anlaysis

Transformed data by identifying headers, splitting datetime, and detecting types. Visualized trends, best-sellers, and revenue metrics using charts an

Project Details

unleashing valuable insights from a vast sales dataset. Started by downloading and uploading data, followed by meticulous transformations:

Identified and promoted column headers.
Detected data types automatically.
Split datetime into date and timestamp.
Next, visualized the data for a comprehensive view:

Explored sales trends over time with a line chart.
Identified best-selling products using a tree map.
Utilized a stacked bar chart for the top 5 products.
Mapped the top 5 cities by sales.
Visualized weekly sales distribution by weekday with a column chart.
Implemented a slicer for interactive visuals.
Calculated revenue metrics like total profit, sales quantity, and profit margin using cards.
This project demonstrates my expertise in data manipulation, insightful visualization, and deriving actionable recommendations for optimized sales strategies.

Project video

Live Interactive Dashboard