Portfolio - Nowra Ahmed

Excel Project

Sales and Finance Analytics of AtliQ Hardwares

AtliQ Hardware, company that sells computer peripherals is embarking on a data-driven journey by integrating sales and finance analytics. Recognizing the need for strategic insights, AtliQ aims to optimize sales strategies, identify growth opportunities, and enhance financial decision-making.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Analytics of AtliQ Hardwares

A market performance vs the actual target report for the year 2021 and the percentage variance.

A P&L report with the monthly breakdown that summarizes AtliQ Hardware's revenues, costs, and expenses during the year 2019, 2020 and 2021.

Project Details

My role involved creating sales and financial reports to analyze its market performance, net sales, P & L reports, and identifying Top products for the years 2019, 2020, and 2021.

SQL Project

Finance & Supply Chain Analytics using SQL

Dive into Finance and Supply chain Analytics of AtliQ hardware, which supplies computer hardware and peripherals to different parts of the world. Wrote SQL queries utilizing the concepts of joins, view, stored procedures etc.

View Project
Engagement

View Project
on GitHUB

Finance & Supply Chain Analytics using SQL

Yearly Gross Sales Report for a customer

Stored Procedure that returns the market badge (Gold or Silver) for a given market on total sold quantity

Project Details

Finance Analytics will guide the organization in strategic decisions, optimizing pricing, and product development, propelling long-term profitability and market dominance. Companies can enhance forecast accuracy, mitigate risks, and optimize operations by having robust supply chain analytics. Uncover valuable insights and enhance decision-making through a practical application of SQL in this dynamic project.

PowerBI Project

Business Insights 360

A comprehensive dashboard that enables data driven decision making covering five major views, Finance, Sales, Marketing, Supply chain and Executive to translate insights from data.

View Project
Engagement

The homepage features essential information at the bottom while offering effortless navigation to other views.

The Executive View is tailored for C-level executives, providing insights into divisions, channels, revenue, net profit, market share, and more.

Project Details

This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.
💼Finance View: shows profit and loss statement like GM,NP,NS etc. and performance over time chart w.r.t to key metrices.
💰Sales View: Shows customers and product performance, unit economics, and performance matrix by NS and GM%
📣 Marketing View: Shows region and product performance, unit economics, and performance matrix by NS and GM%
🚚 Supply Chain View: shows forecast accuracy, Net Error, trends, and key metrics by customers and product.
👨‍🎓 Executive View: shows market share of competitors, trends, revenue by division and channel, top 5 customer

Live Interactive Dashboard

PowerBI Project

Telengana Growth Analysis

Analysis of three key departments -( Stamps, Transportation & TS IPASS) of Telangana (state in India) government using the dataset from Open Data Telangana.

View Project
Engagement

Insight about revenue from stamps department of Telangana

Screenshot of dashboard for transportation department analysis

Project Details

Project objective is to analyse Telangana’s growth among different sectors quantitatively and provide useful Insights to the Telangana government that would help them to make data-informed decisions that would further support the growth of the state.

Live Interactive Dashboard

PowerBI Project

AtliQ Mart Sales Campaign Analysis

AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. Now the sales director wants to understand which promotions did well

View Project
Engagement

View Project
on GitHUB

SQL queries used to answer Ad-hoc questions

Skyrocketed values in Grocery & staples category during Sankranti Sales

Project Details

50 stores of AtliQ Mart in South India hosted Diwali 2023 and Sankranti 2024 sales campaign. 15 AtliQ branded products were featured in 5 promo types - 25% OFF, 33% OFF, 50% OFF, Buy One Get One Free, and 500 Cashback. Analyzed the performance of each promo type and category. Provided tangible insights to the Sales Director to revise the design of promotion campaigns.

Hello, I am

Nowra Ahmed

1

3

1

About

Key

My

Sales and Finance Analytics of AtliQ Hardwares

Finance & Supply Chain Analytics using SQL

Business Insights 360

Telengana Growth Analysis

AtliQ Mart Sales Campaign Analysis

Contact Me

Email

Github

Linkedin

Call

Nowra Ahmed

Download Resume