Portfolio - Monika Kumari | Codebasics

Powered by
Codebasics DA Bootcamp

Monika Kumari

Data Aspirant

EMAIL

[email protected]

About Me

Hi! I am Monika Kumari, an electrical engineering graduate with a master's in high voltage and power system engineering.

My journey from lecturing at an engineering college to mastering advanced Excel, Power BI, and SQL reflects my passion for numbers and data.

As a math lover and data enthusiast, I've worked on real-end projects, uncovering insights that drive impactful decisions.

Let's explore the power of data together!

1

Excel Project

2

PowerBI Projects

1

SQL Project

Key Skills

SQL

Problem Solving

Stakeholder Management

ADVANCED EXCEL

POWER BI

PRESENTATION SKILL

My Projects

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

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]

LinkedIn

https://www.linkedin.com/in/monika-kumari-23213a300/

GitHub

https://github.com/monikakumari0709

Excel Project

Sales and Finance Analytics

Domain/Function: Technology Analytics

Using Excel I explored customer behavior and market trends, along with a thorough assessment of financial health to inform strategic decisions. Employing ETL processes, I effectively utilized Power Query, Power Pivot, and DAX to produce insightful and actionable reports.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Analytics

Market Performance Vs Target

Sales and Finance Analytics

Profit and Loss Statement for Markets based on Key Metrics

Project Details

Sales Report Insights:
• Customer Performance Report: Analyzed customer sales data and tracked growth rates over several years.
• Market Performance and Sales Targets Comparison: Performed a thorough analysis comparing market performance with sales objectives.

Finance Report Insights:
• P&L Reports by Fiscal Year and Month: Assessed financial performance across different periods.
• P&L Reports by Markets: Examined market-specific insights for benchmarking purposes.

Key Learnings:
• Implemented ETL processes to streamline data handling and transformation.
• Created date tables and calculated fiscal months and quarters using Power Query.
• Developed data models and integrated additional datasets with Power Pivot.
• Designed intuitive reports with a focus on user needs and clarity.
• Optimized the report creation workflow for improved efficiency.
• Structured a strategic approach to report development and presentation.

PowerBI Project

Business Insights 360

Domain/Function: FMCG

Business Insights 360 is a dynamic dashboard built with Microsoft Power BI. Tailored for AtliQ Hardware, this versatile tool delivers crucial insights across departments including Finance, Sales, Marketing ,Supply Chain and Executive.

View Project
Engagement

Business Insights 360

Top level dashboards for executives consolidating top insights from all department of business

Business Insights 360

Designed Data Model with 10+ tables creating connection between Facts and Dimension tables

Project Details

Project Overview: AtliQ Hardware experienced rapid growth in the electronics market but faced losses in Latin America due to decisions based on limited surveys and intuition. Our goal was to turn this around with data-driven insights.
What’s Inside?
1. Finance View: Deep dive into revenue, expenditures, and profitability.
2. Sales View: Highlights top-performing products and customers.
3. Marketing View: Analyzes marketing strategies and effectiveness.
4. Supply Chain View: Ensures product availability and optimizes logistics.
5. Executive View: Strategic overview for executives, spotlighting key products, customers, and performance benchmarks.
Project Achievements:
1. Created an intuitive dashboard for easy access to key insights.
2. Integrated data from multiple sources for comprehensive analysis.
3. Designed dynamic visuals for clear data interpretation.
4. Optimized dashboard for swift data retrieval.
5. Empowered AtliQ Hardware with data-driven decision-making.

Project video

Live Interactive Dashboard

PowerBI Project

Revenue Insights in Hospitality Domain

Domain/Function: Hospitality Revenue Optimization

Revenue Insights for Atliq Grands: a Power BI project showcasing weekly hotel performance, occupancy trends, revenue by category and executive-level KPI cards

View Project
Engagement

Revenue Insights in Hospitality Domain

Hospitality Dashboard: Key Metrics for Revenue Team's Strategic Decision-Making

Revenue Insights in Hospitality Domain

An interactive Slicer Panel

Project Details

Faced with declining market share and revenue, AtliQ Grands hotel chains needed actionable insights. I created a diagnostic dashboard for their revenue team, using DAX measures to track key metrics such as RevPAR, occupancy %, ADR, and Realization %.

Key Insights:
1) Identified opportunities for dynamic pricing strategies to optimize revenue.
2) Discovered important metrics and trends within the hospitality industry.
3) Emphasized proactive customer engagement for improving ratings and guest satisfaction.

Achievements:
1)Designed a user-friendly slicer panel for seamless navigation.
2)Applied advanced DAX formulas for comprehensive data analysis.

This project showcases the transformative power of data analytics in refining revenue strategies within the hospitality industry.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods: Adhoc Insights

Domain/Function: Consumer Goods

For AtliQ Hardware, I performed ad-hoc analysis addressing 10 key business queries. This enabled a deeper understanding of product catalogs, sales trends by customer segment, and monthly performance, supporting informed decision-making.

View Project
Engagement

View Project
on GitHUB

Consumer Goods: Adhoc Insights

Highest and Lowest manufacturing_cost product

Consumer Goods: Adhoc Insights

Monthly sales analysis over two years (2020-2021)

Project Details

• Background: AtliQ Hardware required deeper insights into product performance, sales trends, and customer behavior to improve business decisions.
• Task: I was tasked with answering 10 business queries related to sales, product performance, and customer purchasing patterns.
• Action: Leveraged SQL for data extraction, and Power BI for visualizations.
• Result: Delivered actionable insights that optimized inventory, refined marketing strategies, and boosted profitability, enhancing decision-making and business performance.

Key learning:
🔹 Advanced SQL Techniques: Applied subqueries, multiple joins, CTEs, and window functions to solve a real-world business problem.
🔹 Power BI: Utilizing DAX and a variety of visualizations, including card visuals, Bar chart, table visuals, Line chart, Maps, Donut chart, and more.

Project video