Khushi's Portfolio

Analytics background

Khushi Nigam

Driving Business Success Through Data

I collect, analyze, and visualize data — empowering smarter decisions and creating meaningful impact for teams and organizations.

See my portfolio
Khushi Profile Picture

About Me

Hi! I'm Khushi Nigam, a BCA graduate with a deep passion for turning raw data into meaningful business insights. I’ve worked on hands-on projects in domains like e-commerce, HR, and sales analytics, etc. I love solving real-world problems and continuously learning new ways to use data effectively.

🔍 What I Bring:

  • A strong foundation in data analytics and business logic
  • End-to-end project experience — from raw data to dashboards
  • A mindset focused on clarity, accuracy, and continuous improvement

Skills & Tools

A blend of technical and analytical skills that help me transform data into business value.

Excel
SQL
Power BI
Python
Data Visualization
Machine Learning
Project Management
JIRA
Agile Methodology
Git & GitHub
Business Intelligence

Projects

Dashboard Preview

HR Analytics Dashboard

Excel Data Cleaning Data Modeling Power BI

Built using Power BI and Excel to analyze employee attrition, performance, and departmental trends. Provided insights into workforce demographics, staff distribution, and salary structure to support HR decisions.

View Project
Dashboard Preview

Zepto Inventory & Sales Analysis Dashboard

PostgreSQL Data Exploration DAX Power BI

This project showcases a complete SQL + Power BI analysis pipeline using a real-world e-commerce inventory dataset inspired by Zepto. It highlights product pricing, discount patterns, etc for better business decision-making.

View Project
Dashboard Preview

PhonePe Transactions Analysis

Excel Data Cleaning Power BI DAX

Created an interactive dashboard in Power BI to visualize transaction volume, value, and state-wise growth using Excel data.

View Project
Dashboard Preview

Coffee Shop Sales Analysis

Excel Data Cleaning Power BI Sales Analysis Data Visualization

Used Excel to explore sales trends, peak hours, and product-wise performance for better business insights.

View Project
Dashboard Preview

Pizza Sales Analysis

SQL Data Cleaning Sales Insights Revenue Analysis Data Exploration

Performed SQL queries to analyze top-selling pizzas, revenue trends, and order patterns from raw sales data.

View Project
Dashboard Preview

Finance Data Analysis

Excel Power BI Data Cleaning Forecasting Financial Analysis

Used Excel and Power BI to assess financial performance, forecast trends, and generate actionable investment insights.

View Project
Dashboard Preview

Vrinda Store Sales Analysis

Excel Power BI Data Cleaning Data Visualization

Analyzed product-wise and monthly sales performance for Vrinda Store using Power BI, highlighting top categories and revenue trends.

View Project
Dashboard Preview

Domino's Sales Insights dashboard

Excel Power BI Data Cleaning Data Visualization

Analyzed category-wise and monthly sales performance for Dominoes using Power BI, highlighting top categories and revenue trends.

View Project
Dashboard Preview

Sales Insights dashboard

Excel Power BI Customer Insights

The Sales Insights Dashboard empowers businesses to make data-driven decisions. By understanding sales trends, customer behavio, organizations can optimize their sales strategies and maximize revenue.

View Project
Dashboard Preview

DreamJobs: End-to-End Job Search Platform Using Python & Django

HTML CSS Bootstrap Python Django

Developed as part of my final year BCA project , this web-based application allows job seekers to browse and apply for job openings, while employers can post job listings and manage applications.

View Project

Experience & Job Simulations

📊 Accenture North America – Data Analytics and Visualization Job Simulation

April 2025 – June 2025 |  Certificate

• Analyzed and cleaned client data to identify performance issues.
• Built data-driven recommendations using Excel and PowerPoint.
• Presented insights in a simulated client-facing environment.

💼 Deloitte Australia – Data Analytics Job Simulation

Jan 2025 – April 2025  |   Certificate

• Solved stakeholder-focused challenges using Excel and Tableau.
• Completed consulting tasks like analyzing business cases and visualizing data.
• Earned a Deloitte certificate and reviewed model answers for feedback.

Certifications

Business Analysis Foundations-IIBA

Covered fundamentals of business analysis, including requirement gathering, stakeholder analysis, user stories, and basic process modeling.

View Certificate

ChatGPT and AI Tools - be10x

Learned to use ChatGPT and AI tools to automate daily professional tasks, improve productivity, and enhance workflow efficiency.

View Certificate

SQL Certification - Hackerrank

Practiced SQL concepts like joins, filters, subqueries, and aggregations to analyze business data and generate useful insights.

View Certificate

Agile Requirement Foundations-PMI

Explored Agile concepts, Scrum practices, user stories, and JIRA usage for managing project requirements and team collaboration

View Certificate

Generative AI for Business Analysts-IIBA

Learned How Generative AI helps Business Analysts in their day to day work from stakeholder communication to structured documentation

View Certificate