Portfolio - Archana Balasubramanian

Hello, I am

Archana Balasubramanian

Data Analyst

Resume

1

Excel
Project

1

PowerBI
Project

2

SQL
Projects

About

Welcome to my Portfolio Website. I'm Archana, and I'm all about making numbers interesting. I studied Computer Science and now I'm into the data world, using tools like Excel, Power BI, SQL,Tableau and Python to figure things out.

I’ve worked on several industry-related projects, which you can explore below. From Excel tricks to manipulating data with SQL , I'm your go-to person.

I'm not your typical serious graduate – I'm more of a hands-on learner who loves a good challenge. My skills are not just fancy words; they're like secret weapons for decoding data mysteries.

Come on, take a look at what I've cooked up in my portfolio. Let's have a chat about how I can bring some cool data vibes to your team.

Excited to connect!

Key

Skills

SQL

Python

Data Visualization

Tableau

My

Projects

Finance and Sales Analytics for AtliQ Hardware

Made reports for AtliQ Hardware, the computer supplier worldwide. Checked Profit and Loss statement and looked at how customers and the markets are doing.

Business Insights 360

Business Insights 360, a project aimed at enabling AtliQ Technologies to make informed decisions through insights into Finance, Sales, Marketing, Supply Chain, and an Executive View.

Consumer Goods Ad-hoc-Insights

Project Overview :
🔹 Atliq Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. Management noticed that they do not get sufficient insights to make quick and smart data-informed decisions.

Unlocking Retail Insights: AtliQ Mart's Festive Promotions Analysis

𝗔𝘁𝗹𝗶𝗤 𝗠𝗮𝗿𝘁 is a leading retail giant with 50 stores across 10 cities in Southern India. As a Data Analyst, I've analyzed the performance of 𝗗𝗶𝘄𝗮𝗹𝗶 2023 and 𝗦𝗮𝗻𝗸𝗿𝗮𝗻𝘁𝗶 2024 campaigns.

Contact Me

Email

[email protected]

Github

https://github.com/Archana1132

https://www.linkedin.com/in/archana-balasubramanian-094439291/

Call

+91 9688264239

Archana Balasubramanian

Data Analyst

Download Resume

Resume

Excel Project

Finance and Sales Analytics for AtliQ Hardware

Made reports for AtliQ Hardware, the computer supplier worldwide. Checked Profit and Loss statement and looked at how customers and the markets are doing.

View Project
Engagement

View Project
on GitHUB

Other Tools

Microsoft Excel

Pivot Table

Power Query

Power Pivot

Profit & Loss Statement of Markets in Fiscal Year 2021

Top 10 products in 2020,2021,2021 vs 2020

Project Details

Used Microsoft Excel, Pivot Tables, Power Query, Power Pivot, and Conditional Formatting.

𝐅𝐢𝐧𝐚𝐧𝐜𝐢𝐚𝐥 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬:
Profit and Loss (P&L) Report:
- Monthly and quarterly breakdowns.
- Key indicators:Net Sales,COGS,Gross Margin,GM %
- Year-over-Year Comparison to identify trends,variations and areas for improvement.

𝐒𝐚𝐥𝐞𝐬 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬:
- Customer, Market and Target Performance:
- Segmentation for Customer metrics, Market penetration, and Target achievement.
- Insights for strategic decision-making and resource allocation.

𝐓𝐨𝐩 𝟏𝟎 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐬:
-Identify and analyze top-performing products.
-Assess sales volume, revenue, and profit margins.

𝐍𝐞𝐰 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐬:
- Evaluate the impact of new products.
- Comparative analysis of sales, market reception, and profitability.

𝐓𝐨𝐩 𝐚𝐧𝐝 𝐁𝐨𝐭𝐭𝐨𝐦 𝟓 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐬:

-Identify strategic insights for product focus and marketing efforts.

PowerBI Project

Business Insights 360

Business Insights 360, a project aimed at enabling AtliQ Technologies to make informed decisions through insights into Finance, Sales, Marketing, Supply Chain, and an Executive View.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

Power Query

MySQL

Excel

Data Modelling involves 11+ Tables

Strategic dashboard for high-level insights, performance summaries, and critical KPIs to guide top-level decision-making.

Project Details

𝐏𝐫𝐨𝐛𝐥𝐞𝐦 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭: AtliQ Technologies, a thriving hardware company specializing in peripherals, faced a significant challenge in LATIN AMERICA. Their quest? To rectify the issue through data-driven decision-making.

𝐅𝐢𝐧𝐚𝐧𝐜𝐞 𝐕𝐢𝐞𝐰: Analyzed crucial KPI indicators such as Net Sales, Gross Margin %, and Net Profit %. Created a comprehensive P & L Statement with YOY growth.

𝐒𝐚𝐥𝐞𝐬 𝐕𝐢𝐞𝐰: Explored Customer Performance based on Net Sales and Gross Margin.

𝐌𝐚𝐫𝐤𝐞𝐭𝐢𝐧𝐠 𝐕𝐢𝐞𝐰: Enhanced Marketing insights with segment performance and Net Profit metrics.

𝐒𝐮𝐩𝐩𝐥𝐲 𝐂𝐡𝐚𝐢𝐧 𝐕𝐢𝐞𝐰: Surveyed the variance of Actual Sales and Forecast accuracy.

𝐄𝐱𝐞𝐜𝐮𝐭𝐢𝐯𝐞 𝐕𝐢𝐞𝐰: Examined Yearly Trends by Revenue, GM %, NP % & Market Share %. Listed the TOP 5 Customers & Products by Revenue Contribution.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc-Insights

Project Overview : 🔹 Atliq Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. Management noticed that they do not get sufficient insights to make quick and smart data-informed decisions.

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

POWER BI

POWER POINT

Entity-Relationship (ER) Model

Gross Sales Line chart to find the Highest and Lowest sales month in FY 2020

Project Details

𝐂𝐥𝐢𝐞𝐧𝐭: Atliq Hardware, a leading computer hardware producer in India with a global presence.
𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞: Lack of sufficient insights for quick and informed decision-making at the top level of management.
𝐒𝐨𝐥𝐮𝐭𝐢𝐨𝐧:Conducted data analysis on nearly 2 million records in the consumer goods domain.
𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐂𝐨𝐦𝐩𝐚𝐫𝐢𝐬𝐨𝐧:Evaluated company performance against competitors.
𝐏𝐫𝐨𝐝𝐮𝐜𝐭 𝐒𝐞𝐠𝐦𝐞𝐧𝐭𝐬:Analyzed different product segments.
𝐒𝐚𝐥𝐞𝐬 𝐂𝐨𝐦𝐩𝐚𝐫𝐢𝐬𝐨𝐧 (𝟐𝟎𝟐𝟎 𝐯𝐬. 𝟐𝟎𝟐𝟏):Identified trends and changes in sales.
𝐂𝐨𝐬𝐭 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬:Identified highest and lowest cost products.
𝐏𝐫𝐞𝐬𝐞𝐧𝐭𝐚𝐭𝐢𝐨𝐧:Created a presentation to effectively communicate analysis and insights to top-level management.
Provided actionable insights for data-informed decision-making.Empowered management with a deeper understanding of the company's performance and market positioning.
𝐓𝐨𝐨𝐥𝐬 𝐔𝐬𝐞𝐝:
-SQL for data querying and analysis

Project video

SQL Project

Unlocking Retail Insights: AtliQ Mart's Festive Promotions Analysis

View Project
Engagement

View Project
on GitHUB

Other Tools

POWER BI

MICROSOFT POWERPOINT

Created a View to simplify the Query

500 Cashback & "BOGOF" promos have a major impact on Incremental Revenue

Project Details

𝗞𝗲𝘆 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀:

📌 Both Campaigns saw significant increases in Sales and Revenue, with 𝐒𝐚𝐧𝐤𝐫𝐚𝐧𝐭𝐢 𝐬𝐡𝐨𝐰𝐢𝐧𝐠 𝐬𝐥𝐢𝐠𝐡𝐭𝐥𝐲 𝐡𝐢𝐠𝐡𝐞𝐫 𝐩𝐞𝐫𝐜𝐞𝐧𝐭𝐚𝐠𝐞 𝐠𝐚𝐢𝐧𝐬.

📌 Top performers were 𝗠𝘆𝘀𝘂𝗿𝘂,𝗖𝗵𝗲𝗻𝗻𝗮𝗶 𝗮𝗻𝗱 𝗕𝗲𝗻𝗴𝗮𝗹𝘂𝗿𝘂 ,while areas for improvement included Coimbatore and Madurai stores.

📌 "𝗕𝗢𝗚𝗢𝗙" 𝗮𝗻𝗱 "500 𝗖𝗮𝘀𝗵𝗯𝗮𝗰𝗸" emerged as top-performing promotions, driving substantial sales and revenue growth.

𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜:

𝗦𝗮𝗹𝗲𝘀 𝗮𝗻𝗱 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Provides insights into overall Sales and Revenue trends for strategic decision-making.

𝗦𝘁𝗼𝗿𝗲 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 : Store performance metrics such as Revenue, Discounts, and Unit sales.

𝗣𝗿𝗼𝗺𝗼 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Highlighting Top performers and Areas of Improvement.

𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Sales Trends and Performance across various Product categories.

𝗟𝗶𝘃𝗲 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 :https://lnkd.in/gftJ7jYG

Hello, I am

Archana Balasubramanian

1

1

2

About

Key

My

Finance and Sales Analytics for AtliQ Hardware

Business Insights 360

Consumer Goods Ad-hoc-Insights

Unlocking Retail Insights: AtliQ Mart's Festive Promotions Analysis

Contact Me

Email

Github

Linkedin

Call

Archana Balasubramanian

Download Resume