Portfolio - Astha Rai

Hello, I am

Astha Rai

Data Analyst

2

PowerBI
Projects

About

🚀 Welcome to My Professional Portfolio! 📊

I'm a data enthusiast proficient in Excel, SQL, Power BI, Tableau, and Python. Currently pursuing a degree in Computer Science with a specialization in AI and Machine Learning, I excel at translating complex data into impactful narratives.

🔍 While I'm in the early stages of my professional journey, my portfolio showcases hands-on projects that underscore my ability to derive actionable insights from data.

🌐 Driven by curiosity and a commitment to continuous learning, I am actively seeking opportunities to contribute to data-informed decision-making. A deep dive into my portfolio reveals projects that demonstrate the tangible value I can bring to your team.

💡 Let's collaborate and maximize the potential of data together!"

Technical

Skills

Excel

PowerBI

Machine learning

MySQL

Python

My

Projects

Business 360 - end to end data analysis

This Project is aimed to design a multi-view dashboard for sales, finance, supply chain and executive to understand the sales trend for AtliQ hardware.

Strategic Marketing Analysis for CodeX

CodeX is a German beverage company that is aiming to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India. As a marketing analyst I translated survey results into actionable insights, contributing to strategic decision-making for brand growth.

Awards

& Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 2.0

Data Analystics

Python Basics

Google data analytics

Contact Me

Email

[email protected]

Github

https://github.com/Astha230982

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

Call

+91 06262126921

Astha Rai

Data Analyst

Download Resume

Resume

PowerBI Project

Business 360 - end to end data analysis

This Project is aimed to design a multi-view dashboard for sales, finance, supply chain and executive to understand the sales trend for AtliQ hardware.

View Project
Engagement

View Project
on GitHUB

Finance view

Supply chain view

Project Details

- Designed a multi-view dashboard in Power BI for sales, finance, supply chain, executive of AtliQ, which aimed to scale
the business processes by 10%.
- Imported 2 different data sources(MySQL and Excel) with more than 1 million records and performed data modeling.
- Optimized the record using DAX studio, which saved 30% of storage and increased performance by 10%

Live Interactive Dashboard

PowerBI Project

Strategic Marketing Analysis for CodeX

View Project
Engagement

Crafted a comprehensive dashboard with key views: demographics, preferences, purchase behavior, competition, marketing, and performance.

Overall performance view, The Optimized strategies led to a 20% increase in brand engagement and a 15% rise in market share for CodeX.

Project Details

Overview:
CodeX boldly introduced its energy drink in 10 bustling Indian cities, and the strategic marketing analysis was instrumental in achieving remarkable outcomes. By dissecting survey responses from 10,000 participants, we not only heightened brand awareness but also secured a substantial market share.

Approach:
The project encompassed a range of tasks, from unraveling demographics and consumer preferences to competition analyses and meticulous optimization of marketing channels. Tools like Power BI, SQL Server Management Studio, and Python ensured a comprehensive exploration of the marketing landscape.

Impact:
The insights weren't just informative; they were transformative. Our data-driven strategies played a pivotal role in CodeX's success in the competitive Indian market.

Hello, I am

Astha Rai

2

About

Technical

My

Business 360 - end to end data analysis

Strategic Marketing Analysis for CodeX

Awards

Contact Me

Email

Github

Linkedin

Call

Astha Rai

Download Resume