Powered by
Codebasics Data Analytics Bootcamp

Monica Nalawade

Data Aspirant

+91 7498116373 [email protected]

Resume

Hello, I am

Monica Nalawade.

5

PowerBI Projects

1

SQL Project

About Me

Welcome to my world, where the precision of data analysis meets the determination forged through diverse experiences!
With a Bachelor's degree in Computer Engineering as my foundation and a diverse study of UPSC as my armor, I've delved into the complexities of data armed with a unique blend of skills and resilience.
As I immersed myself in the world of data analysis, I found that my diverse background had seamlessly prepared me for the task at hand.
My problem-solving approach, honed through countless hours of preparation, has become second nature to me, guiding me through each dataset with confidence and precision.
Through my portfolio, I invite you to witness the convergence of my experiences and unwavering passion for data analysis. With a foundation built on resilience, adaptability, and a relentless pursuit of excellence, I'm ready to make a lasting impact in the world of data analysis.

Key Skills

Effective Communication

Stakeholder Management

My Projects

Awards & Certificate

AI For Everyone

AI For Everyone

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Power BI Data Analyst Associate

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.

[email protected]

https://www.linkedin.com/in/monica-nalawade/

+ 91 7498116373

PowerBI Project

Business Insights 360

Problem: AtliQ Hardware hit limits with Excel data management. Mission: Excel to Power BI for insights. Objective: Insights into finance, sales, marketing, and supply chain. Volume: 1.8M records. Tools:, Power BI, Excel, SQL, DAX Studio, ChatGPT, Google.

View Project
Engagement

Business Insights 360

Detailed snowflake schema representing the data model for structured analysis.

Business Insights 360

Finance View with relevant KPIs.

Project Details

📝 Planning: Outlined project scope, focusing on Finance, Sales, Marketing, and Supply Chain.
📊 Data Collection: Utilized SQL and Excel.
🔄 Data Integration: Loaded data into Power BI via MYSQL for analysis.
✅ Data Validation: Checked Power BI data against established benchmarks.
🛠 Data Transformation: Employed Power Query to shape data, including column addition and table merging.
🧪 User Acceptance Testing (UAT): Collaborated with stakeholders to ensure dashboard accuracy.
🔄 Feedback Incorporation: Implemented end-user suggestions for improvement.
⚙️ Performance Optimization: Leveraged DAX Studio to enhance system performance.
🚀 Deployment: Utilized Power BI Desktop Service and Gateways for live connection deployment.

Project video

Live Interactive Dashboard

PowerBI Project

Provide Insights to Revenue Team in Hospitality Domain

This project exemplifies the profound impact of data on revolutionizing the hospitality industry through the analysis of key metrics such as Revenue, ADR, RevPAR, Occupancy%, Realization%, Cancellation%, DBRN, DSRN etc

View Project
Engagement

Provide Insights to Revenue Team in Hospitality Domain

Revenue Analysis with relevant KPIs.

Provide Insights to Revenue Team in Hospitality Domain

Executive Dashboard with relevant KPIs and Visuals.

Project Details

Project Description:
AtliQ Grands, renowned for its five-star hotels across India spanning two decades in the hospitality sector, is facing challenges in market share and revenue in the luxury and business hotel segment. Competitors and management decisions have contributed to this decline. To counter this trend, the managing director is spearheading the integration of "Business and Data Intelligence" into their operations to reclaim market dominance and boost revenue.
ACHIEVEMENTS:
1. Defined metrics aligned with strategic objectives.
2. Designed a dashboard reflecting stakeholder requirements.
3. Delivered actionable insights surpassing initial metrics and dashboard expectations.
SKILLS UTILIZED:
1. Proficiency in Power BI for data visualization.
2. Excel for data manipulation and analysis.

Project video

Live Interactive Dashboard

PowerBI Project

Insights to the Product Strategy Team in the Banking Domain

Orchestrated a pilot project analyzing a dataset of 4000 customers across 5 cities over 6 months; crafted an interactive dashboard providing insights that optimized marketing strategies and increased customer retention by 15%.

View Project
Engagement

Insights to the Product Strategy Team in the Banking Domain

Customer Demographics Analysis with insightful visuals.

Insights to the Product Strategy Team in the Banking Domain

Expenditure Analysis with important KPIs and Visuals

Project Details

Mitron Bank in Hyderabad 🏦 plans to launch new credit cards 💳 to expand its market presence. AtliQ Data Services proposed the project but faces skepticism from Mitron Bank's strategy director, Mr. Bashnir Rover. To gain approval, they must conduct a pilot project using a sample dataset of 4000 customers.

As a Data Analyst 💼, I lead the analysis to provide actionable insights for tailoring credit cards to customer needs and market trends. Success depends on impressing Mr. Bashnir Rover and the strategy team with data-driven recommendations.

➡️ Tools Used:
Dashboard: Microsoft PowerBI 📊
Presentation: Microsoft PowerPoint 🖥️
Canva 🎨
Microsoft Clipchamp 🎥

Proposed short-term and long-term initiatives to expand the customer base and increase transactions per customer. Provided actionable, data-driven recommendations to Mitron Bank's senior management and product strategy team, leading to an additional 20% customer acquisition. 📈

Project video

Live Interactive Dashboard

SQL Project

Insights To Management In Consumer Goods Domain

The project involves solving 10 ad-hoc requests to help management to make data-driven decisions. I used MySQL Workbench to query the database. Used Power BI to visualize queried results.

View Project
Engagement

View Project
on GitHUB

Insights To Management In Consumer Goods Domain

Top 3 products in each division that have high total_sold_quantity

Insights To Management In Consumer Goods Domain

Quarters of 2020 with total sold quantity

Project Details

In this project, I solved 10 ad-hoc requests to help management.
I queried data using MySQL Workbench and derived the required report. by using Power BI I visualized reports.
Core Competencies:
✅ Data Retrieval: Implemented SELECT, WHERE, DISTINCT, LIKE, BETWEEN
✅ Sorting & Filtering: Utilized ORDER BY, LIMIT, OFFSET
✅ Aggregation Mastery: Applied SUM, MIN, MAX, AVG, GROUP BY, HAVING
✅ Advanced Query Tactics: Executed Joins, Subqueries, Correlated Subqueries
✅ Sophisticated Analytics Techniques: Utilized CASE, YEAR, CURYEAR, IF, CTEs, User Defined Functions, Window Functions
✅ Database Administration: Implemented DDL, DML, Data Types, Views.

Project video

PowerBI Project

Shield Insurance

This project is Part of my virtual Internship with Atliq Technologies offered by Codebasics. In this project, we are analyzing data for the Insurance company to make data-driven decisions.

View Project
Engagement

Shield Insurance

Executive view showing all key performance Indicators with major trend analysis

Shield Insurance

Sales Mode Analysis with visible Insights

Project Details

In this project, I have explored, analyzed data of Insurance companies. And made Insightful Power BI reports for higher management.
Generated Key performance Indicators for executive Views.
Analyzed customer age group for their preference of policies, and settlement %.
Analyzed sales mode of policies to better understand and plan future marketing strategies.

Core competencies:
Data Import
Data wrangling in Power Query
Dax measures
Time intelligence DAX functions
Data Visualization in Power BI
Data Visualization techniques like Bookmark, Layering, page navigation
Presenting Insights in front of management

Project video

Live Interactive Dashboard

PowerBI Project

Analysis Of promotions and providing Insights in the FMCG domain

AtliQ Mart is retail giant with 50 supermarket. They ran massive promotions during Diwali and Sankranti on their products. Now, the Sales Director wants to understand how promotions performed and need to make data-driven decisions for next promotion.

View Project
Engagement

View Project
on GitHUB

Analysis Of promotions and providing Insights in the FMCG domain

Product and Category Analysis

Analysis Of promotions and providing Insights in the FMCG domain

Promotion Analysis

Project Details

We are analyzing data of AtiQ Mart.
I have created 4 views: Executive, Promotion Analysis, Store Performance Analysis, Product and category Analysis
I have created 2 most important matrices- 1. Incremental revenue % 2. Incremental Sold Unit %.
I have also fulfilled ad-hoc requests of management to make data-driven decisions using SQL.

Project video

Live Interactive Dashboard