Nisha Jharbade

Data Analyst

[email protected]

Resume

Hello, I am

Nisha Jharbade.

2

PowerBI
Projects

1

Excel
Project

About Me

Hello! I’m a data analyst with 2 years of experience, turning data into clear and useful insights. I’m skilled in Power BI, Excel, SQL, and statistics, and I enjoy finding trends and solving problems. I create easy-to-read visuals that help businesses make better decisions. Let’s work together to make your data simple, smart, and impactful!.

Key Skills

Power BI

SQL

Excel

Python

My Projects

AtliQ Business Insights

Domain/Function: Brick Mortar & E-commerce

CodeEX Marketing Analysis

Domain/Function: Marketing

Adventure Work Sales Analysis

Domain/Function: Sales

My Experience

Wipro Limited, Pune – Data Analyst

Oct 2021 – Nov 2023

•Designed and developed scalable BI solutions, creating dynamic dashboards and analytical reports for various business functions, including finance, sales etc.

• Implemented data extraction, transformation, and loading (ETL) processes and Power Query to streamline data workflows.

• Conducted data modeling by defining relationships, building star and snowflake schemas, and optimizing database structures for improved reporting efficiency.

• Developed Power BI reports with custom visualizations, incorporating advanced analytics to uncover trends, patterns, and actionable insights.

• Worked on Power BI service administration, managing workspaces, scheduling automated data refreshes, and optimizing gateway performance for real-time reporting.

• Managed Power BI workspaces and automated data refresh schedules, improving reporting efficiency and reducing manual intervention by 15%.

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 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.

Mail Me

[email protected]

https://www.linkedin.com/in/nisha-jharbade/

GitHub

https://github.com/nisha854

PowerBI Project

AtliQ Business Insights

Domain/Function: Brick Mortar & E-commerce

Engineered a Power BI dashboard for AtliQ Technologies , analyzing multi-operational functions like Finance, Sales, Marketing etc. with key metrics like Gross Margin, Net Profit, and Forecast Accuracy, Net error to analyze the key issues and trends to enhance the strategy for continuous growth.

View Project
on GitHUB

Other Tools

Excel

MySQL

This is finance report from AtliQs Business Dashboard

Model view of AtliQ Business Dashboard

Project Details

Engineered a comprehensive Power BI dashboard for Atliq, a hardware company selling PCs, mice, and printers through brick & mortar and e-commerce platforms. This dashboard includes crucial metrics like Gross Margin, Net Profit, YTD, YTG, Forecast Accuracy, and Net Error, providing a detailed overview of Atliq Hardware's performance. This initiative transitioned the company from survey-based decisions to data-driven strategic planning.

📊 Key Reports Created:
Finance View:
Detailed P&L statement
Top/bottom product breakdowns by net sales and gross margin
Sales View :
Customer and product breakdowns by net sales, gross margin, and gross margin %
Unit economics with COGS and pre/post deductions
Marketing View:
Insights into product, market, and regional performance
Evaluation of key metrics like net profit % and gross margin %
Supply Chain View:
Analysis of key supply chain metrics such as forecast accuracy, net error, and risk.

Live Interactive Dashboard

PowerBI Project

CodeEX Marketing Analysis

Domain/Function: Marketing

This project focuses on conducting a comprehensive analysis of CodeX Beverage Marketing. identified problem areas, propose solutions, and explore consumer preferences. Additionally, analyzed the competition and assess marketing channels to enhance brand awareness.

View Project
on GitHUB

This is a Home Page of Marketing Analysis Dashboard which contains all the reports button to navigate

This is a codex demographic report

Project Details

CodeX, a German beverage company, launched its energy drink in 10 Indian cities and surveyed 10,000 respondents on purchasing habits, pricing, packaging, and brand perception.

Project Overview:
This project analyzes consumer preferences, competitive landscape, marketing effectiveness, and purchase behavior. Key insights include demographics (60.4% male, 70% aged 15-30), strong preference for natural ingredients, and low brand recognition.

Key Findings & Action Plan:

Online ads most effective for young consumers.
Competitors (Red Bull, Monster) dominate due to brand trust.
Focus cities: Ahmedabad, Chennai, Hyderabad, etc.
Improve availability, packaging, and brand visibility.
Targeted social media & influencer marketing, bundle deals, and seasonal promotions.

Tools: Power BI, Power Query | Language: DAX

Live Interactive Dashboard

Excel Project

Adventure Work Sales Analysis

Domain/Function: Sales

This project analyzes sales data for Adventure Works, a bike company. Perform analysis by uncovering trends, customer behavior, and product profitability to optimize sales and marketing strategies.

View Project
on GitHUB

Adventure Work Sales

Detail Dashboard

Project Details

Overview:
Analyzing Adventure Works' sales data to optimize sales strategies and product development.

Key Areas of Analysis:

Data Cleaning: Fix inconsistencies, handle missing values, and ensure accuracy.
Sales Performance: Track trends, identify top-selling products, and compare with industry benchmarks.
Customer Segmentation: Analyze demographics, purchase behaviors, and tailor marketing strategies.
Product Profitability: Identify high-margin products and optimize costs.
Marketing Effectiveness: Measure ROI of marketing channels like social media and email.
Deliverables:

Cleaned datasets
KPI reports & interactive dashboards (MS Excel)
Actionable sales & marketing recommendations
Benefits:

Data-driven decisions
Better customer insights
Increased profitability