Portfolio - Rajeswari kotha

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

The objective of this project is to offer in-depth analysis of the company's financial &Sales Performance and its standing in the market in the FMCG sector. It involves generating a range of reports for combination of fundamental and Acquired proficiency in ETL, Power Query, Power Pivot, DAX .

View Project
Engagement

View Project
on GitHUB

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

The Customer Performance Report displays the yearly net sales performance for each customer.

This report give insights about country's performance over multiple years and compare it to the established targets

Project Details

In this project, I crafted a sales report using Excel pivot tables and combination of powerful tools to transform raw sales data into actionable insights. Enabling businesses to pinpoint effective customer discounts, streamline negotiations, and uncover potential expansion opportunities in countries. empowering businesses to optimize sales strategies, elevate customer satisfaction, and maximize revenue.

Throughout this project, I have acquired expertise in the following areas:
1. Utilizing pivot tables
2. Harnessing the capabilities of Power Query
3. Grasping the fundamentals of DAX (Data Analysis Expressions)
4. Enhancing data presentation through conditional formatting
5. Improving the visual appeal of reports
6. Gaining insights into sales-related metrics

Overall this project, providing businesses with the necessary tools and insights to monitor, enhance their sales efforts Through the lens of sales data analysis, businesses can unlock fresh opportunities.

PowerBI Project

Business Insights 360

Strengthening AtliQ Hardware’s ,a growing consumer electronics firm, by implementing an advanced Power BI analytics solution. Overcoming Excel limitations, this initiative aims to unlock insights, fostering data-driven decisions for enhanced competitiveness and rapid expansion.

View Project
Engagement

View Project
on GitHUB

Dashboard's Home Page

Data Model

Project Details

In this project, I aimed to craft a comprehensive report for stakeholders in sales, marketing, finance, and the executive team.
My main goals encompassed:
1. Robust Data Model
2. Designing User-Centric Reports
3. Drillable Insights

I acquired the following skills and knowledge:
1. Power Query (Basic to Advanced Operations)
2. Mastery of basic and complex DAX formulas
3. Data Modelling involving 10+ tables
4. Choosing the right visuals and formattings
5. Dashboard designing principles
6. Skill in using bookmarks
7.Deployment on the Power BI service
8.Stakeholder Feedback Implementation
9. Analysis and reporting of metrics across sales,
marketing, finance, and supply chain domains.

Project video

Live Interactive Dashboard

PowerBI Project

Revenue Insights in Hospitality Domain

Probelm statement: Atliq Grands has experienced declining market share and revenue due to poor competition and management decisions. Project Goal: "To enhance Atliq Grands' market share and revenue in the luxury And business hotel segment by implementing data-driven strategies and business

View Project
Engagement

View Project
on GitHUB

Revenue Analysis of the Hospitality domain

Data Modeling

Project Details

Project Goal:
"To enhance Atliq Grands' market share and revenue in the luxury And business hotel segment by implementing data-driven strategies and business intelligence.

Conducted revenue analysis using Power BI and DAX measures to identify areas where Atliq Hotels lagged behind competitors.
Utilized Power BI to craft dynamic visualizations and dashboards, including line charts, bar graphs, and slicers, to present revenue performance and pricing strategy insights in an easily digestible format.
Revealed that the hotel had not implemented dynamic pricing strategies for optimal rate adjustments in response to fluctuating demand.
Discovered hotel had not employed differential pricing for weekends and weekdays, missing potential revenue optimization opportunities.
Recognized the underutilization of differential pricing and promotional offers on the hotel's direct online and offline channel.
Uncovered a strong correlation between Occupancy % and customer ratings.

Project video

Live Interactive Dashboard

SQL Project

Ad-Hoc Analysis

Atliq Hardwares, a fictional company, is a major computer hardware maker in India and abroad. Yet, they lack quick insights for smart decisions. So, a SQL challenge is on the horizon to fill this data gap.

View Project
Engagement

View Project
on GitHUB

Ad-Hoc Requests along with Output & Insights

Project Details

In the Sales Performance Enhancement project, our mission was to empower decision-makers with actionable insights. Focused on boosting sales, key priorities included:

1. Executing In-Depth Data Queries
2. Informing Decision-Making Strategies
3. Enhancing Overall Sales Performance

Throughout this project, I developed the following skills:

1. Proficiency in SQL data querying, covering diverse business questions.
2. Mastery of data interpretation and strategic decision support.
3. Selection of effective visualizations for clear data representation.
4. Successful implementation of SQL solutions in a business context.
5. Comprehensive analysis of key sales metrics for informed decision-making.

PowerBI Project

𝗧𝗲𝗹𝗮𝗻𝗴𝗮𝗻𝗮 𝗚𝗿𝗼𝘄𝘁𝗵 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀

𝗧𝗲𝗹𝗮𝗻𝗴𝗮𝗻𝗮 𝗚𝗿𝗼𝘄𝘁𝗵 ,The goal was to provide the government with 𝗮𝗰𝘁𝗶𝗼𝗻𝗮𝗯𝗹𝗲 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝘀 and summarize key 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗳𝗶𝗻𝗱𝗶𝗻𝗴𝘀 to enhance "𝗱𝗮𝘁𝗮-𝗱𝗿𝗶𝘃𝗲𝗻 𝗮𝗻𝗱 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻"

View Project
Engagement

View Project
on GitHUB

Analysis of Growth In Telangana

Insights And Recommendations for Sustained Growth In Telangana

Project Details

In the Telangana Growth Insights project, our primary goal was to provide comprehensive reports to government stakeholders for informed decision-making in three critical departments: Registration & Stamps, Transport, and Ts-Ipass. Key focuses included:

1. Building a Robust Data Analysis Framework
2. Crafting User-Centric Visualizations
3. Delivering Actionable Data Insights

𝐃𝐚𝐭𝐚𝐬𝐞𝐭 𝐮𝐬𝐞𝐝: Open data of Telangana.
𝐓𝐨𝐨𝐥𝐬 𝐮𝐬𝐞𝐝:
Power BI
Excel
PowerPoint Presentation

Throughout this project, I honed the following skills and expertise:

1. Proficiency in data analysis with Power BI, encompassing diverse data sources.
2. Mastery of data modeling, connecting and optimizing multiple datasets.
3. Selection of impactful visualizations for data representation.
4. Skill in interactive dashboards and drill-down functionalities.
5. Successful deployment on the Power BI service platform.
6. Iterative improvement based on stakeholder input.
7. Comprehensive metrics analysis

Hello, I am

Rajeswari kotha

1

3

1

About

Key

My

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

Business Insights 360

Revenue Insights in Hospitality Domain

Ad-Hoc Analysis

𝗧𝗲𝗹𝗮𝗻𝗴𝗮𝗻𝗮 𝗚𝗿𝗼𝘄𝘁𝗵 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀

Contact Me

Email

Github

Linkedin

Call

Rajeswari kotha

Download Resume