Portfolio - Ananya Tripathi | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

Ananya Tripathi

Data Aspirant

Resume

1

PowerBI
Project

1

Excel
Project

1

SQL
Project

About

Me

Welcome to My Portfolio!

I’m Ananya, a data analyst with a passion for turning data into actionable insights. With a background in Computer Science, I specialize in using tools like Excel, Power BI, SQL, Tableau, and Python to uncover patterns, solve problems, and make data-driven decisions. I’ve worked on various industry projects, from sales analysis to customer segmentation, combining technical skills with creativity to deliver meaningful results. I’m hands-on, curious, and always up for a challenge. Check out my projects below, and let’s chat about how I can bring fresh data-driven solutions to your team.

Excited to connect!

Key

Skills

Sql

Power BI

Data Visualiation

My

Projects

Business Insights 360

Business Insights 360

Domain/Function: Atliq Hardware

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.

HR Analytics Dashboard

HR Analytics Dashboard

Domain/Function: HR

Attrition, the turnover or departure of employees, is a crucial metric to monitor in any organization. It helps us gain insights into various aspects of our work environment, such as employee satisfaction, engagement, career growth, and overall company culture.

Food & Beverage

Food & Beverage

Domain/Function: Food & Beverages

The food and beverage industry encompasses the production, processing, and distribution of consumable goods. It includes a wide range of products, from fresh food and packaged items to beverages like soft drinks and alcohol.

Contact Me

Email

[email protected]

Linkedin

https://www.linkedin.com/in/ananya-tripathi-793b94262/

Call

+91 7905689506

Ananya Tripathi

Data Aspirant

Download Resume

Resume

PowerBI Project

Business Insights 360

Domain/Function: Atliq Hardware

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

Business Insights 360

Data Modelling involves 11+ Tables

Business Insights 360

This dashboard shows financial performance for 2022 estimates, comparing Net Sales and Net Profit to benchmarks. It highlights gross margin, regional

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

Excel Project

HR Analytics Dashboard

Domain/Function: HR

Attrition, the turnover or departure of employees, is a crucial metric to monitor in any organization. It helps us gain insights into various aspects of our work environment, such as employee satisfaction, engagement, career growth, and overall company culture.

View Project
Engagement

HR Analytics Dashboard

This HR Analytics Dashboard provides a comprehensive overview of employee metrics, including total headcount, attrition rate, department-wise trends,

HR Analytics Dashboard

The HR Analytics Dashboard visualizes critical employee data, showing total employees, attrition trends by department, education, and age, along with

Project Details

Understanding Attrition:
Attrition, the turnover or departure of employees, is a crucial metric to monitor in any organization. It helps us gain insights into various aspects of our work environment, such as employee satisfaction, engagement, career growth, and overall company culture. Reducing attrition is not only essential for maintaining a stable and skilled workforce but also for fostering a positive work atmosphere where employees feel valued and motivated.

Project video

SQL Project

Food & Beverage

Domain/Function: Food & Beverages

The food and beverage industry encompasses the production, processing, and distribution of consumable goods. It includes a wide range of products, from fresh food and packaged items to beverages like soft drinks and alcohol.

View Project
Engagement

Food & Beverage

This project analyzes marketing insights for Red Bull in the food and beverage industry using SQL, Power BI, and PowerPoint for data driven decision

Food & Beverage

Respondents prefer energy drink packaging as: Compact cans (3.98K), Innovative design (3.05K), Collectible (1.50K), Eco-friendly (0.98K), Other (0.49K

Project Details

A few months ago, the company CodeX launched their energy drink in 10 cities of India.
Their Marketing team is responsible for increasing brand awareness, market share, and product development.
They conducted a survey in those 10 cities and received results from 10k respondents.

Project video