Portfolio - Meghana Andhavarapu

Meghana Andhavarapu

Data Aspirant

Resume

2

Excel Projects

2

PowerBI Projects

1

SQL Project

About Me

Hi, I'm Meghana — a curious mind who loves exploring the stories hidden in data. With a strong foundation in tools like Excel, SQL, Power BI, and Python, I enjoy turning raw data into clear, impactful insights that help solve real-world problems.

Over time, I've built dashboards, cleaned messy datasets, and even developed a few fun data projects that you'll find right here in my portfolio. Whether it's analyzing trends, visualizing data, or building end-to-end solutions, I thrive on learning and making data useful.

Take a look around — and if something interests you, don’t hesitate to connect!

Key Skills

Excel

Power BI

Python

EDA

DAX

Communication skills

Stakeholder Management

Machine Learning

Problem-solving

SQL

My Projects

P & L Report

Domain/Function: Finance Data Analysis

Sales Analysis Dashboard – Unlocking Business Insights!

Domain/Function: Sales Analysis

Business Insights 360

Domain/Function: Brick & Motor and Ecommerce

Admission and Placement Analysis

Domain/Function: College Data Analysis

Music Store Data Analysis using SQL

Domain/Function: Music Store Data Analysis

Awards & Certificate

Excel: Mother of Business Intelligence

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

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/meghana-andhavarapu/

GitHub

https://github.com/Meghana2844

Excel Project

P & L Report

Domain/Function: Finance Data Analysis

The Customer-wise Net Sales Analysis visualized yearly growth, revealing key clients like Amazon and AltiQ Exclusive contributing significantly to the 2021 revenue surge, with overall growth reaching 324% YoY.

View Project
Engagement

Customer Net Sales Performance refers to the analysis of total sales revenue generated from each customer over a specific period, highlighting growth

Market Performance vs Target compares actual sales against the predefined sales targets, helping identify underperforming or overperforming regions

Project Details

Tracked Net Sales growth from 2019 to 2021 by customer and highlighted top-performing clients like Amazon and Flipkart.
Evaluated Market Performance vs Target in 2021 across global markets, identifying underperforming regions like USA and Germany with a total shortfall of $54.9M.
Analyzed Profit & Loss (P&L) across fiscal months for FY2019, covering key metrics such as Net Sales, COGS, Gross Margin, and GM%, with an average GM% of 41.4%.
Utilized conditional formatting and slicers to enhance interactivity and deliver business insights quickly.

Excel Project

Sales Analysis Dashboard – Unlocking Business Insights!

Domain/Function: Sales Analysis

This Excel dashboard project focuses on analyzing sales data for Ferns N Petals (FNP) to uncover customer behavior and business performance trends. The dashboard provides a comprehensive overview of key metrics.

View Project
Engagement

View Project
on GitHUB

Sales Analysis Dashboard

Pivot tables

Project Details

Built an interactive Excel dashboard to analyze sales data for Ferns N Petals (FNP), covering key performance metrics such as:
Total Orders: 126
Total Revenue: ₹5.86 Lakhs
Average Order Value: ₹4,652.19
Average Delivery Time: 5.72 Days

The dashboard includes visualizations for:
Revenue by Occasion (e.g., Raksha Bandhan, Diwali, Valentine’s Day)
Revenue by Category (e.g., Soft Toys, Sweets, Mugs)
Revenue by Month and Hour to identify seasonal and hourly sales trends
Top Products by Revenue and Top Cities by Orders for targeted marketing insights

Filters for order date, delivery date, and occasion allow dynamic exploration. This project demonstrates effective use of Tableau for sales analysis, customer behavior insights, and decision-making support.

Let me know if you want a shorter version for LinkedIn or a STAR-format summary.

PowerBI Project

Business Insights 360

Domain/Function: Brick & Motor and Ecommerce

AtliQ Hardware , A Fast Growing Electronics Company, Facing an Issues to draw valuable data driven Insights, To help AtliQ Store in their lack of Analytics, I've made an Business Dashboard which tailored to provide invaluable, data-driven insights across all departments.

View Project
Engagement

Evaluating departmental performance at a glance by plotting Yearly Trends of KPI’s (GM %,NP%, Market share%), Market Share Trends

Data Modelling - Snowflake Schema

Project Details

Struggled with outdated Excel-based analytics, AtliQ Hardwares aimed to modernize operations using data-driven
methods.
Built a detailed operational performance report using Power BI and 2 data sources (Excel/CSV files and SQL databases).
Developed 5 distinct dashboards, each for Finance, Sales, Marketing, Supply Chain, and Executive insights.
Enabled AtliQ Hardwares to analyze different departments sales trends and discovered Peripherals, PCs, and
Networking as
top divisions, with Asia-Pacific leading in Net Sales($125.4Mil) and Europe in Gross Margin % (33.88%).

Live Interactive Dashboard

PowerBI Project

Admission and Placement Analysis

Domain/Function: College Data Analysis

Built an interactive Power BI dashboard with dynamic filtering, drilldowns, and KPIs to visualize placement statistics, salary trends, and departmental analysis.

Seat Allotment / Admission Analysis

Department Wise Student Placement Analysis

Project Details

Extracted structured placement data from college website sources; performed data cleaning,
transformation, and EDA using Python and Power BI.
Built an interactive Power BI dashboard with dynamic filtering, drilldowns, and KPIs to visualize
placement statistics, salary trends, and departmental analysis.

Live Interactive Dashboard

SQL Project

Music Store Data Analysis using SQL

Domain/Function: Music Store Data Analysis

This project contains SQL queries for analyzing data from a music store database. The queries extract valuable insights about sales, customers, artists, and tracks.

View Project
Engagement

View Project
on GitHUB

Discovering insights with business questions

Project Details

Finding the top-selling tracks, albums, and artists.
Analyzing customer purchase behavior.
Identifying the most popular genres.
Sales performance analysis by country.
Employee sales contributions.