ROHITH KALYAN KUMAR REDDY CHAMALA

Data Aspirant

[email protected] +91 9390802599

Resume

Hello, I am

ROHITH KALYAN KUMAR REDDY CHAMALA.

1

Excel
Project

1

PowerBI
Project

About Me

Welcome to my portfolio website! I'm Rohith kalyan, embarking on an exciting journey with data. I graduated with a bachelor's degree in Electronics and Communication Engineering from Sri Venkateshwara College Of Engineering, Bengaluru.

I discovered my passion for data analysis, fueled by my interest in Visualization. I've honed my skills in Excel, SQL, Power BI, and Python, evolving into an aspiring Data Analyst.

Picture revealing stories hidden in numbers, crafting insights to guide decisions—that's where my interests lie. Join me on this adventure as I blend engineering precision with a love for statistics, shaping narratives beyond mere data points. Let's dive into the world of data together, where every click uncovers a new story.

Key Skills

MySQL

Python

My Projects

P & L Report for Atliq Hardware FY 2022

Domain/Function: Sales

Business Insights 360

Domain/Function: E-Commerce

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/rohith-kalyan-chamala-292a0b215/

Call Me

+91 9390802599

GitHub

https://github.com/Rohithkalyanchamala

Excel Project

P & L Report for Atliq Hardware FY 2022

Domain/Function: Sales

Created a detailed Profit & Loss report for AtliQ Hardware's fiscal year 2022 using advanced Excel features like Pivot Tables and DAX. The report offers in-depth insights into revenue and expense categories. Data cleaning was automated with Power Query.

View Project
on GitHUB

This image shows a **Market Performance vs Target report** for AtliQ Hardware, comparing actual revenue against 2021 targets for various countries.

The image shows AtliQ Hardware's P&L report for FY 2021 across different countries, detailing Net Sales, COGS, Gross Margin, and GM%.

Project Details

"A comprehensive Profit & Loss (P&L) report for AtliQ Hardware's FY 2022 was developed using advanced Excel features such as Pivot Tables and DAX, providing detailed insights into revenue streams and expense categories. The data cleaning process was automated with Power Query to ensure seamless updates and improve reporting efficiency. DAX measures were utilized to allow greater flexibility in real-time data manipulation and customized analysis, enhancing the user experience and supporting better decision-making through more dynamic financial reporting."

PowerBI Project

Business Insights 360

Domain/Function: E-Commerce

Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by gathering data from 2 different sources

Interactive dashboard to Hover through the Insights of the Atliq's Business

One of the insights where we can see the Net sales performance Over time

Project Details

This is customized Power BI dashboard for AtliQ Hardware, designed to analyze global sales trends using data from multiple sources like Excel and a SQL database. A data model and visualizations were built in Power BI, and the performance of the report was optimized using DAX studio. The dashboard allowed AtliQ to gain insights into various department sales trends, leading to improved decision-making, increased revenue, and a significant reduction in data-related costs.