Rethi Venkatesh

Aspiring Data Analyst

[email protected] +44 7780948514

Resume

Hello, I am

Rethi Venkatesh.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Hello! I'm Rethi Venkatesh, an aspiring Data Analyst with a strong foundation in data analysis tools and techniques. I hold a Master’s in Computer Science and a Bachelor’s in Software Systems, which have fostered my analytical mindset.
Proficient in Power BI, SQL, Python, and Excel, I have applied these tools in various projects and coursework. My passion for data analysis drives my desire to uncover insights and make data-driven decisions.
While I haven't worked as a Data Analyst in a corporate setting, I've completed several courses and hands-on projects. Additionally, I gained practical experience through a virtual internship, tackling real-world data problems.
My academic background and project experience have equipped me with a versatile skill set. Please explore my projects below to see how I’ve applied my skills. I look forward to discussing how I can contribute to your team.

Key Skills

SQL

Python

My Projects

Sales Analytics

Domain/Function: Sales Analytics for AtliQ Hardwares

Business Insights 360

Domain/Function: Business Insights 360 for AtliQ Hardware

Shield Insurance

Domain/Function: Insurance

Credit Card Market Analysis for Mitron Bank

Domain/Function: Banking

Consumer Goods Ad_Hoc Insights

Domain/Function: Consumer Goods / Hardware

Data Analysis for AtliQ Grands

Domain/Function: AtliQ Grands/Hospitality

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/rethivenkatesh/

Call Me

+44 7780948514

Excel Project

Sales Analytics

Domain/Function: Sales Analytics for AtliQ Hardwares

In this project, the Customer Performance Report and Market Analysis Report were developed for the Sales Team of AtliQ Hardwares. These reports help assess customer performance over the years and gauge market success against targets, providing valuable insights for strategic decision-making.

View Project
Engagement

Customer Performance Report: Displays sales trends for customers from 2019 to 2021, with filters for region, country, and division at AtliQ Hardwares.

Market performance vs Target report : Compares country-specific market performance against targets for strategic decision-making and optimization.

Project Details

In this project, I developed sophisticated Customer Performance and Market Analysis reports for AtliQ Hardwares' Sales Team. These reports evaluate customer performance trends, measure success against sales targets, and support informed decision-making during customer discount negotiations. They also identify key regions and countries for market expansion.
The insights from these reports help the sales team refine strategies, improve customer satisfaction, and drive revenue growth. They play a crucial role in negotiating customer discounts effectively, ensuring profitability while maintaining competitiveness in the market.

Key Skills and Tools Used:
• ETL
• Power Query
• Power Pivot
• Data Modelling
• Pivot Tables
• DAX (Data Analysis Expressions)
• User-Focused Report Design
• Conditional Formatting

Utilizing these tools, I created dynamic, insightful reports that provide actionable data for strategic planning, achieving sales targets, and optimizing business outcomes.

PowerBI Project

Business Insights 360

Domain/Function: Business Insights 360 for AtliQ Hardware

AtliQ Hardware, a consumer goods electronics company, competes globally amidst advanced rivals. Despite relying on Excel for data management inefficiencies, I introduced Power BI dashboards to enhance decision-making and operational agility, driving actionable insights and improving competitiveness.

View Project
Engagement

A screenshot of the landing page of the 'Business Insights 360' Power BI dashboard, with links to finance, sales, marketing, and supply chain views.

A screenshot of the data modelling page showcasing the 'Business Insights 360' star schema with fact and dimension tables.

Project Details

The purpose of this project was to create a comprehensive Power BI dashboard, 'Business Insights 360,' for AtliQ Hardware to provide actionable insights for finance, sales, marketing, supply chain, and executive management. This dashboard enables users to visualize key performance metrics, track trends, and make data-driven decisions.
Key Terms Learned:
• KPI (Key Performance Indicator)
• OLTP vs OLAP
• Data Exploration Using SQL
• Star Schema, Fact vs Dimension Tables
• Data Transformation with Power Query
• Data Modelling in Power BI
• DAX (Data Analysis Expressions)
• Calculated Columns and Measures
• Filter Context and Visualization Techniques
• Dashboard Design for Various Business Functions
The dashboard integrates data from multiple sources and presents it in an intuitive and interactive format, enhancing AtliQ Hardware's ability to monitor performance and identify areas for improvement across different departments.

Project video

Live Interactive Dashboard

PowerBI Project

Shield Insurance

Domain/Function: Insurance

Shield Insurance protects homes, vehicles, health, and finances in five cities with four sales modes and nine policy types. As a data analyst, I uncovered insights into customer behaviour and revenue trends, supporting strategic decisions, enhancing engagement, and identifying growth opportunities.

View Project
Engagement

Landing page showcases interactive dashboard links for detailed insights by age, city, and sales mode analysis.

Custom data model with 5 tables and over 10 measures for detailed analysis and insights for Shield Insurance.

Project Details

As a data analyst at Shield Insurance, I specialise in analysing customer behaviour and revenue trends to support strategic decision-making.

Objectives:
• Provide actionable insights into customer behaviour and revenue trends.
• Analyse customer demographics such as age, city, and sales mode.
• Enhance customer engagement and satisfaction through data-driven strategies.
• Identify growth opportunities and mitigate risks effectively.
• Evaluate company performance and operational efficiency.
• Develop comprehensive dashboard views (Home, General, Sales Mode, Age Group).
• Empower Shield Insurance with robust, data-driven tools for sustainable growth.

My insights enable Shield Insurance to proactively address customer needs, optimize sales channels, and enhance overall business performance.

Project video

Live Interactive Dashboard

PowerBI Project

Credit Card Market Analysis for Mitron Bank

Domain/Function: Banking

Analysed a dataset of 4000 customers across five cities to uncover spending patterns and customer demographics. Provided actionable insights to Mitron Bank's strategy team to guide the introduction of a new line of credit cards tailored to market needs.

View Project
Engagement

Mitron Bank Dashboard Landing Page: Explore customer demographics, income trends, spending insights, and payment preferences for informed decisions.

Payment Analysis: Visualize transaction trends, method preferences, and user behaviours for strategic insights.

Project Details

I conducted an extensive analysis of a dataset encompassing 4000 customers across five cities to deliver actionable insights to Mitron Bank's strategy team. The objective was to inform the development of a new line of credit cards that aligns closely with customer needs and prevailing market trends.

Tools Utilized:

• Power BI: Employed for dynamic data visualization and dashboard creation.
• CSV Files: Served as the primary data source for analysis.
• DAX (Data Analysis Expressions): Used to create advanced measures for deeper insights.
• Power Query: Applied for data transformation and preparation to ensure data integrity.

A comprehensive and intuitive dashboard was meticulously crafted to effectively present the findings. This dashboard is designed to empower top-level management and the product strategy team at Mitron Bank with critical insights, facilitating informed decision-making processes.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Ad_Hoc Insights

Domain/Function: Consumer Goods / Hardware

As a Junior Data Analyst applicant for Atliq Hardwares, I developed SQL queries for 10 ad hoc requests. Clarified requirements, optimized queries, and created visual charts for top management, providing actionable insights to enhance data-driven decision-making.

View Project
Engagement

SQL query and output showcasing data extraction for one of the 10 ad hoc requests, demonstrating query efficiency and clear result presentation.

Conversion of SQL output to visual representation, illustrating data insights for top management through clear and impactful charts and graphs.

Project Details

As a Junior Data Analyst applicant for Atliq Hardwares, a leading computer hardware producer in India with global operations, I developed SQL queries for 10 ad hoc requests to enhance data analytics capabilities. This project supported swift, data-driven decision-making by top management.

I began by thoroughly understanding each request, clarifying any ambiguities, and gathering additional information as needed. I then crafted efficient SQL queries to extract the required data, optimizing for performance. The skills and techniques used included:

- DML commands
- Calculated Columns
- SQL Joins
- Subqueries
- Common Table Expressions
- Window Functions
- Microsoft Excel Charts

The derived insights were presented using visually appealing charts and graphs designed for top management. These visualizations provided actionable insights, facilitating data-driven decisions and supporting Atliq Hardwares' strategic growth.

Project video

Python Project

Data Analysis for AtliQ Grands

Domain/Function: AtliQ Grands/Hospitality

As a data analyst at AtliQ Grands, I'm addressing revenue and booking declines due to fierce competition. By leveraging data analytics, I'll provide insights to guide strategies for enhancing customer engagement and revenue, positioning AtliQ Grands as an agile market leader.

View Project
Engagement

Screenshot showcasing data cleaning in Python for AtliQ Grands, managing missing values and identifying outliers to ensure data integrity.

Screenshot showcasing data transformation in Python for AtliQ Grands, merging data frames and creating new columns to prepare for analysis.

Project Details

AtliQ Grands, a renowned hotel group, is facing revenue and booking declines due to fierce competition. As a data analyst, I am leveraging insights from diverse datasets to formulate strategies aimed at revitalizing revenue streams and enhancing customer engagement. The hotel needs to adapt to what guests are looking for and compete better in the market.
My role is crucial in providing valuable insights into market trends, consumer behaviour, and competitive intelligence. By leveraging data-driven strategies, AtliQ Grands aims to regain lost ground and position itself as an agile and adaptive player in the market.
Skills and Techniques used in this project:
• Data Collection from CSV Files
• Data Cleaning
• Exploratory Data Analysis
• Data Manipulation Using Pandas and NumPy
• Data Visualization with Matplotlib
• Data Transformation
By employing these skills, I aim to provide actionable insights and strategic recommendations to help AtliQ Grands thrive in a competitive market.