PROJECT WORK

End-to-End Automated Sales Data Analytics Pipeline (n8n)
GitHub Repository: https://github.com/komalvinayak/end-to-end-automated-data-analytics-pipeline-n8n

Overview

This project focuses on building a fully automated sales data analytics pipeline that transforms raw sales data into actionable business insights. The system automatically processes data from Google Sheets and delivers structured, email-ready analytics reports without manual intervention. The project simulates real-world business reporting workflows, where data ingestion, cleaning, KPI calculation, visualization, and report distribution are handled automatically. The solution is designed to improve reporting efficiency, reduce manual effort, and enable faster decision-making.

Key Features

• Automated data ingestion from Google Sheets using workflow triggers

• Data cleaning and preparation to ensure consistency and accuracy

• Calculation of key business KPIs such as revenue, quantity sold, and average order value

• Generation of visual insights including category-wise revenue and payment method analysis

• Creation of a structured HTML sales analytics report

• Automatic email delivery of reports to stakeholders

• End-to-end workflow execution with minimal manual involvement

Technologies Used

• n8n – Workflow automation

• Google Sheets – Data source

Outcome

This project demonstrates how analytics can move beyond static dashboards to fully automated reporting systems. By eliminating repetitive manual tasks, the solution ensures consistent, reliable, and timely insights that support business decision-making.

Skills Applied

Data Analytics · KPI Design · Data Cleaning · Workflow Automation · Automated Reporting · Business Insight Generation

Comparative Analysis of E-Commerce Platforms
GitHub Repository: https://github.com/komalvinayak/Ecommerce_Analysis
YouTube Demo: https://youtu.be/jAeH3v5VpAs

Overview

This project focuses on optimizing hospital operations through data-driven decision-making using structured datasets from various hospital departments. It was developed during an industrial training program at Pisoft Informatics Pvt. Ltd. Key datasets include OPD, IPD, Lab, Inventory, and Staff Scheduling. The project leverages Power BI, Python, and Excel to generate actionable insights and support hospital administration.

Key Features

• Built dynamic Power BI dashboards with KPIs, filters, and visual trends.

• Performed descriptive, diagnostic, and prescriptive analytics on hospital operations.

• Identified department-wise revenue trends, peak operation hours, and staff workload issues.

• Suggested operational improvements like adding more OPD staff on Mondays and replacing high-cost suppliers.

• Integrated recommendations based on patient demographics and service usage.

Technologies Used

Power BI, Python (Pandas, NumPy, Matplotlib, Seaborn), DAX, Excel

Overview

This project is a case analysis on how Generative AI is transforming market research, developed as part of the Marketing Management subject. The analysis explores how organizations are using GenAI to improve research speed, generate synthetic data, fill insight gaps, and support better decision-making, while also addressing key limitations and ethical concerns.

The focus was on applied learning, structured thinking, and presenting insights through a clear business narrative.

Key Focus Areas

• Role of Generative AI in modern market research

• Supporting and replacing traditional research practices

• Use of synthetic data and digital twins

• Filling insight gaps where real data is limited

• Ethical, bias, and accuracy-related limitations

• Human and AI collaboration in decision-making

Key Learnings

• Gained a strong understanding of GenAI applications in market research

• Learned to analyze opportunities and limitations in a balanced way

• Improved ability to translate theory into real business implications

• Strengthened storytelling and presentation skills for management topics

• Developed an industry-oriented and decision-focused mindset

This project reflects my ability to analyze emerging technologies from a business perspective, structure complex ideas clearly, and communicate insights in a professional and industry-relevant manner. 

Deliverables

• Case analysis PPT with structured insights