Portfolio - Madasu Sai Siva Sowjanya

Madasu Sai Siva Sowjanya

Data Aspirant

Resume

1

Excel Project

1

PowerBI Project

About Me

I am an aspiring Data Analyst with a background in Computer Science and a strong interest in transforming data into meaningful insights. I work with Excel and Power BI to analyze datasets, build dashboards, and support data-driven decision-making.

After a career break to focus on family responsibilities, I have consciously restarted my professional journey with a clear goal of growing in Data Analytics. I am currently strengthening my SQL skills and working on hands-on projects to enhance my practical expertise.

Though at the beginning of my formal career path, I bring structured thinking, consistency, and a strong commitment to continuous learning. I am eager to contribute, grow, and create value through data-driven solutions.

Key Skills

Power BI

Microsoft Excel

My Projects

AtliQ Hardwares-Sales & Financial Analytics

Domain/Function: Sales & Financial Analytics

BI 360: End -to -End Business Intelligence Dashboard

Domain/Function: Business Intelligence & Performance Analytics

My Experience

Data Analyst – Project Experience

Hands-on Projects | 2025 – Present

Excel Data Analysis Project

Cleaned and structured raw sales data using Excel data formatting and validation techniques.
Performed analysis using Pivot Tables, SUMIFS, IF, and lookup functions.
Created interactive dashboards to track KPIs and monthly performance trends.
Derived actionable insights to identify high-performing products and regions.

Power BI 360 – Business Performance Dashboard

Imported and transformed multiple datasets using Power Query.
Built a relational data model by establishing relationships between tables.
Created DAX measures to calculate key metrics such as Revenue, Profit, and Growth.
Designed interactive dashboards using slicers, filters, and drill-through features.
Delivered data-driven insights through clear and structured visual storytelling.

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/sai-siva-sowjanya-madasu

Call Me

+91 9491759484

GitHub

https://github.com/sowjanya-jidugu

Excel Project

AtliQ Hardwares-Sales & Financial Analytics

Domain/Function: Sales & Financial Analytics

Performed sales and financial analytics for AtliQ Hardwares using Excel. Applied ETL process, built Pivot Table reports, and analyzed customer, market, and product performance to derive business insights on revenue, gross margin, and growth trends.

View Project
Engagement

View Project
on GitHUB

View Project
on Microsoft Excel

Customer Performance Report: Provides Net Sales Performance 0f each customer across years.

Market Performance Vs Target: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

This project focused on performing sales and financial analytics for AtliQ Hardware using Microsoft Excel. The ETL (Extract, Transform, Load) process was applied to clean and structure raw business data for analysis. Multiple reports were created using Pivot Tables to evaluate customer performance, market vs target achievement, top and bottom products, division-level growth, and newly launched products.

Features used in this analysis:
1.Pivot Table
2.Power Query
3.DAX (Basics)
4.Conditional Formatting

Using the above- mentioned features, a detailed Profit & Loss analysis was conducted by across fiscal periods to assess Net Sales, COGS, Gross Margin, and GM%. Country-level and market-level performance insights were generated to understand revenue distribution and business growth trends. The final outcome was an interactive analytical report that transformed raw data into meaningful business insights to support data-driven decision-making.

PowerBI Project

BI 360: End -to -End Business Intelligence Dashboard

Domain/Function: Business Intelligence & Performance Analytics

AtliQ Hardware, a rapidly growing consumer electronics company, struggled to compete due to reliance on Excel-based reporting. This project implements an advanced Power BI analytics solution to deliver actionable insights and enable data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

User- empathetic landing page as a part of dashboard design.

Data Model containing more than 10 tables.

Project Details

Business Insights 360 (BI 360) is a comprehensive Business Intelligence solution developed using Power BI to monitor and analyze organizational performance across multiple departments. The dashboard includes dedicated views for Sales, Finance, Marketing, Supply Chain, and Executive reporting.

Key performance indicators such as Net Sales, Gross Margin, Profitability, Customer Trends, and Operational Metrics were calculated using advanced DAX measures. Data modeling techniques were applied to establish relationships between multiple datasets, ensuring accurate and efficient analysis.

The interactive dashboard enables stakeholders to drill down into regional performance, product categories, and time-based trends, supporting data-driven strategic decision-making at an enterprise level.