Monika Shanmugam

Data Aspirant

Resume

Hello, I am

Monika Shanmugam.

1

Excel
Project

1

PowerBI
Project

About Me

Welcome to my portfolio!

I’m an aspiring Data Analyst passionate about turning raw data into meaningful insights that support smarter business decisions.

With a Bachelor’s degree in Electronics and Communication Engineering and a background in IT infrastructure, I bring an analytical mindset and a problem-solving approach to data analytics.

While I may not yet have corporate experience in a Data Analyst role, my portfolio showcases practical projects that demonstrate my analytical thinking, problem-solving skills, and commitment to continuous learning.

Using Excel, Power BI, and SQL, I analyze data, identify trends, and uncover actionable insights to solve real-world business problems.

Explore my projects to discover how I turn data into meaningful insights and business decisions!

Key Skills

Microsoft Excel

Power BI

SQL

My Projects

Sales and Finance Analytics Report

Domain/Function: Sales & Finance Analytics

AtliQ Hardware – Business Insights 360

Domain/Function: Sales, Finance, Marketing, Supply Chain & Executive Analytics

My Experience

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 4.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.

https://www.linkedin.com/in/monika-shanmugam/

GitHub

https://github.com/monikashanmugam

Excel Project

Sales and Finance Analytics Report

Domain/Function: Sales & Finance Analytics

Developed a Sales and Finance Analytics Report using Advanced Excel to analyze sales performance, customer trends, product growth, and profitability. Used Power Query, Power Pivot, and DAX to clean data, calculate key financial metrics, and generate actionable business insights.

View Project
on GitHUB

Analyzes customer-wise net sales, sales growth, and overall performance to identify top customers, track trends, and uncover opportunities to improve revenue and customer relationships.

Highlights market-wise sales target achievement and performance gaps, helping identify markets requiring focused sales strategies and better resource allocation to improve target attainment and revenue growth.

Project Details

This project analyzed AtliQ Hardwares' sales and financial performance to identify growth opportunities. It focused on customer sales, product performance, profitability, gross margins, and market targets, highlighting top-performing products, missed targets, and margin improvement opportunities.

Key Learnings:
1. Used PivotTables to summarize and analyze data.
2. Applied Power Query for data cleaning and transformation.
3. Used Power Pivot and DAX for data modeling and calculations.
4. Implemented conditional formatting to highlight key insights.
5. Analyzed sales, customer performance, and financial metrics.

The analysis demonstrates how Excel-based reporting can support data-driven decisions, improve sales strategies, and identify opportunities to increase profitability.

PowerBI Project

AtliQ Hardware – Business Insights 360

Domain/Function: Sales, Finance, Marketing, Supply Chain & Executive Analytics

AtliQ Hardware is a global computer hardware business. This Power BI project aims to track KPIs, analyze sales and profitability, evaluate marketing performance, monitor supply chain forecasts, and provide actionable insights to improve business decisions across departments.

🏠 Business Insights 360 home page providing navigation to Finance, Sales, Marketing, Supply Chain, and Executive dashboards, along with project information and support access for comprehensive business performance analysis.

📊 Power BI data model showing interconnected fact and dimension tables, including sales, forecasts, customers, products, finance, and market data, with relationships designed to support accurate analysis across business functions.

Project Details

📌 Project: Business Insights 360 – AtliQ Hardware

🎯 Objective: Understand how to build a unified Power BI reporting solution for stakeholders across Finance, Sales, Marketing, and Supply Chain to support data-driven business decisions.

📊 Key Focus Areas:
• Robust data modeling with 10+ interconnected tables.
• Interactive, user-friendly dashboards with drill-down insights.
• Analysis of Net Sales, Gross Margin, Profit & Loss, and Forecast Accuracy.
• Department-wise performance tracking using business KPIs.

🛠️ Skills & Learnings:
• Power Query for data transformation and cleaning.
• DAX for basic and advanced calculations.
• Data modeling and relationship management.
• Effective visualization and dashboard design.
• Bookmarks, interactive filters, and drill-through functionality.
• Power BI Service deployment and stakeholder-focused reporting.

Live Interactive Dashboard

Already have an account? Sign in