Nandini Agnihotri

Data Analyst

[email protected] +91 9826811203

Resume

Hello, I am

Nandini Agnihotri.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About Me

Welcome to my portfolio! I'm a recent graduate with a degree in Mass Communication, bringing a unique blend of storytelling and analytical skills to the world of data analytics. My passion lies in transforming complex data into clear, actionable insights that drive decision-making. Equipped with a strong foundation in data analysis, visualization, and statistical techniques, I am adept at using tools like Excel, SQL, and Power BI. I thrive in collaborative environments and am eager to leverage my communication background to convey data-driven stories that resonate with diverse audiences. Let's explore the power of data together!

Key Skills

SQL

My Projects

Sales and Finance Analytics

Business Insights 360

Finance and Supply Chain Analytics

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/nandini-agnihotri-49a422192/

Call Me

+91 9826811203

GitHub

https://github.com/nandini2907

Excel Project

Sales and Finance Analytics

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

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets

Project Details

Objective 👍 : Create a comprehensive customer performance report and
compare the
market Performance Vs Sales Targets

Highlights:
➡️ Sales Report
➡️ Finance Report
➡️ P&L Statement Report

🔄 ETL Methodology
🔄 Power Query
🔄 Power Pivot
🔄 DAX

✅ Determine effective customer discounts, facilitate negotiation, and explore
Business expansion opportunities

PowerBI Project

Business Insights 360

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exist in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights.

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design.

Data modelling involving 10+ tables.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made 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
10. Stakeholder management
and many more

Live Interactive Dashboard

SQL Project

Finance and Supply Chain Analytics

Use of MySQL for Finance and Supply chain domains to extract valuable insights from the data to empower our company to make more informed and strategic decisions

View Project
on GitHUB

Report generation using Stored Procedure

Table creation using Views

Project Details

As the size of our Excel files continues to grow, we are encountering performance issues, causing them to become unresponsive and inefficient. To address this challenge, AtliQ Hardware has initiated a project to incorporate a team of data analysts who will use MySQL as their database management system and to extract valuable insights from the data. These insights will empower our company to make more informed and strategic decisions, ultimately optimizing our operations and performance.