Portfolio - Rakshith

Rakshith

Data Analyst and Business Analyst

Resume

1

Excel Project

1

PowerBI Project

1

SQL Project

1

Python Project

About Me

Hello! I'm Rakshith H K, a dedicated and enthusiastic Data Analyst eager to make a mark in the world of data-driven decision-making. With a solid foundation in Automobile Engineering and a comprehensive Data Analyst Master Program, I have developed a robust skill set in Power BI, SQL, Advanced Excel, and Python, Tableau.

Key Skills

Python

SQL (Structured Query Language)

MySQL

Advanced Excel

Tableau

data visulization

Machine learning

stakeholder mangement

Effective Commnucation

Microsoft Power BI

My Projects

Advanced Sales Analytics

Domain/Function: sales Analysis

Business 360 - Brick & Mortar and E-commerce

Domain/Function: Brick & Mortar and E-commerce

Finance and Supply Chain Analytics

Domain/Function: Finance and Supply Chain Analytics

AtliQ Hotels Data Analysis Project | Python for Business Intelligence

Domain/Function: Hospitality industry

My Experience

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

Python: Beginner to Advanced For Data Professionals

DATA ANALYST MASTERS PROGRAM

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/hkrakshith42/

Call Me

+91 8088700139

GitHub

https://github.com/Rakshith7077

Excel Project

Advanced Sales Analytics

Domain/Function: sales Analysis

Generated a comprehensive P&L report for AtliQ Hardware FY 2022, utilizing advanced features in Excel such as Pivot Tables and DAX to provide granular insights into revenue streams and expense categories.

View Project
Engagement

View Project
on GitHUB

View Project
on Excel

AtliQ Hardware's' 2021 P&L report highlights India's highest net sales at $161.26M. The USA and South Korea also show strong performance.

The report shows GM% trends by region from 2019-2021. SE and ROA lead, while India sees a decline.

Project Details

For FY 2022, I developed a comprehensive Profit & Loss (P&L) report for AtliQ Hardware, utilizing advanced Excel features like Pivot Tables and DAX to deliver in-depth insights into revenue streams and expense categories. I automated the data cleaning process using Power Query, which saved approximately 4 hours of manual work per reporting cycle and ensured consistent data accuracy. The integration of DAX measures provided a flexible and interactive user experience, allowing stakeholders to perform dynamic analyses and access detailed financial information efficiently. This project significantly enhanced reporting accuracy, streamlined data processing, and supported strategic decision-making by offering a clear, detailed view of the company's financial performance.

PowerBI Project

Business 360 - Brick & Mortar and E-commerce

Domain/Function: Brick & Mortar and E-commerce

I developed a multi-functional Power BI dashboard that analyzes global sales trends for AtliQ Hardware. This project integrated data from Excel/CSV files and a SQL database, using advanced tools like Power BI, SQL, Excel, and DAX Studio to create impactful visualizations.

View Project
Engagement

View Project
on GitHUB

A dynamic Power BI dashboard analyzing global sales trends, offering insights by region, product, and customer to drive data-driven decisions.

A detailed Power BI dashboard showcasing customer and product performance, regional sales trends, and P&L insights to drive business growth.

Project Details

I developed a comprehensive Power BI dashboard for AtliQ Hardware to analyze global sales trends across both brick-and-mortar stores and e-commerce channels. This project integrated data from multiple sources, including Excel/CSV files and a SQL database. Using Power BI, SQL, Excel, and DAX Studio, I created dynamic visualizations and delivered actionable insights that empowered AtliQ Hardware to make data-driven decisions. The result was improved business performance, with measurable growth in sales and operational efficiency.
The primary goal of this project was to create a comprehensive dashboard that offers insightful visualizations and data analysis, enabling AtliQ Hardware to monitor sales performance across different regions, products, and time periods. By leveraging advanced data modeling and optimization techniques, the dashboard not only provides a detailed view of current sales metrics but also identifies emerging trends, opportunities, and potential challenges.

Live Interactive Dashboard

SQL Project

Finance and Supply Chain Analytics

Domain/Function: Finance and Supply Chain Analytics

This project exemplifies my proficiency in SQL through a comprehensive analysis of finance and supply chain data. Using MySQL Workbench, I performed an in-depth examination of complex datasets to extract critical insights, empowering businesses to make data-driven strategic decisions.

View Project
Engagement

View Project
on GitHUB

View Project
on sql

Identifying the key customers who drive the majority of sales is crucial for targeted marketing and customer retention strategies.

Pricing strategy is a critical component of profitability. This query examines the gross price per item, enabling an evaluation of product.

Project Details

This Finance and Supply Chain Analytics project underscores my ability to transform raw data into actionable insights. By leveraging advanced SQL techniques, I have extracted valuable information that can guide strategic decision-making in areas such as customer relationship management, pricing strategy, and inventory optimization.

Python Project

AtliQ Hotels Data Analysis Project | Python for Business Intelligence

Domain/Function: Hospitality industry

"Analyzed AtliQ Hotels' operations and financials using Python, Pandas, NumPy, and Matplotlib. Transformed raw data into actionable insights, supporting management in making data-driven decisions to improve efficiency, profitability, and overall performance."

View Project
Engagement

View Project
on GitHUB

View Project
on python

"Performed outlier detection and removal on revenue data using mean, median, and standard deviation to define upper and lower limits in Python."

"Calculated the upper limit for 'revenue realized' using mean and standard deviation, then identified bookings exceeding the threshold in Python."

Project Details

In this project, I conducted a comprehensive data analysis for AtliQ Hotels, focusing on improving their operational and financial performance. Using Python and libraries like Pandas, NumPy, and Matplotlib, I turned raw data into actionable insights, helping the management make data-driven decisions to optimize efficiency and profitability.

📊 Project Overview:
AtliQ Hotels aimed to improve their strategy by analyzing revenue, occupancy rates, customer demographics, and resource allocation. I applied data analysis techniques to transform complex datasets into valuable insights, enabling the company to enhance business performance.