Portfolio - Swapna Morusu | Codebasics

Powered by
Codebasics DA Bootcamp

Swapna Morusu

Data Analyst

EMAIL

[email protected]

PHONE

+91 7993704715

Download CV

About Me

Welcome to my portfolio! I'm a Data Analyst who enjoys uncovering insights and transforming raw data into meaningful, easy-to-understand stories. With strong skills in Power BI, SQL, and Microsoft Excel, I focus on creating impactful dashboards, performing data-driven analysis, and delivering clear business solutions.

Through various hands-on projects, I have developed expertise in trend analysis, KPI reporting, interactive dashboard design, and database querying. Whether it's building visually compelling Power BI reports, writing efficient SQL queries, or conducting detailed Excel analysis, I thrive on helping businesses make informed decisions backed by data.

This portfolio highlights my commitment to continuous learning, creativity in data visualization, and drive to solve real-world problems. I'm excited about collaborating on new projects and contributing to data-driven success.

Thank you for visiting—I look forward to connecting with you!

1

Excel Project

1

PowerBI Project

Key Skills

Power BI

Advanced Excel

SQL

Effective Communication

Stakeholder Management

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Power BI Data Analyst Associate

Let's Work Together!

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.

EMAIL

[email protected]

Call Me

+91 7993704715

LinkedIn

https://www.linkedin.com/in/swapna-morusu-3aa774215/

GitHub

https://github.com/Swapna3008

Excel Project

Sales Analytics(FMCG)

Domain/Function: Sales & Finance

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Sales Analytics(FMCG)

Customer Performance Report: Analyzed customer-wise net sales from 2019 to 2021 and evaluated 2021 vs 2020 growth to identify high-performing accounts, fast-growing customers, and potential revenue opportunities for strategic focus

Sales Analytics(FMCG)

Market Performance vs Target Report: Evaluated country-wise net sales from 2019 to 2021 against 2021 targets, highlighting performance gaps and target achievement percentages to support data-driven strategic decision-making.

Project Details

In this project, I developed a dynamic sales report using Excel pivot tables to help businesses gain meaningful insights into customer discounts, negotiation strategies, and potential market expansion opportunities. The report enables organizations to analyze sales performance, identify high-potential regions, and make informed decisions that support strategic growth. The insights generated from this analysis help businesses optimize pricing strategies, strengthen customer relationships, and maximize revenue.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project empowers businesses with data-driven tools to monitor, evaluate, and enhance their sales performance. By leveraging structured sales analysis, organizations can uncover new opportunities, adapt to changing market trends, and remain competitive in a dynamic business environment.

PowerBI Project

Business Insights 360 Dashboard

Domain/Function: FMCG

AtliQ Hardware, a fast-growing consumer electronics company, lags behind competitors due to reliance on Excel-based reporting. This project aims to build an intelligent analytics solution using Power BI to enable smarter, data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

Business Insights 360 Dashboard

User-empathetic and intuitive landing page designed for easy navigation, enabling stakeholders to quickly access insights and improve overall user experience.

Business Insights 360 Dashboard

Data model built using 10+ interconnected tables to support reliable analysis and reporting.

Project Details

The objective of this project was to create a unified, comprehensive report that can be effectively used by stakeholders across Sales, Marketing, Finance, and Executive teams. The focus of the project was on the following:

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Live Interactive Dashboard