Anand malviya - Data analyst I BI developer

SQL-Based Employee Management System SQL-Based Employee Management System I designed and implemented an SQL-based Employee Management System that automates employee record handling using triggers and stored procedures . This project ensures that every new employee entry is logged in an audit table, maintaining data integrity and historical tracking. Key Features: ✅ Employee Table – Stores essential details like name, position, salary, and hire date. ✅ Audit Table – Automatically records employee changes with timestamps for tracking modifications. ✅ Trigger for Data Auditing – A SQL trigger (AFTER INSERT) ensures that all new employee records are mirrored in the audit table. ✅ Stored Procedure for Employee Addition – Simplifies employee insertion while enforcing consistency. Technologies Used: SQL (MySQL / PostgreSQL) Triggers & ...

Excel Invoice Generator for Kalyan Jewellers Excel Invoice Generator for Kalyan Jewellers I developed an Excel-based invoice generator for Kalyan Jewellers using advanced Excel formulas and automation techniques. This project allows users to input customer details, product weight, and current gold prices in the "Input" sheet, and it automatically generates a detailed and professional tax invoice in the "Invoice" sheet. Key Features: Automated Invoice Generation: User inputs are processed dynamically to generate accurate invoices. Formula-Based Calculations: Includes gold price calculations, discounts, making charges, and GST. User-Friendly Interface: Easy-to-use structured input sheet for seamless data entry. Dynamic Pricing Update: Adjusts the final invoice based on the latest gold rates and applicable taxes. This...

Supermarket Sales Dashboard – Excel Interactive Visualization Supermarket Sales Dashboard – Excel Interactive Visualization I developed an interactive Supermarket Sales Dashboard using Microsoft Excel , incorporating key business metrics and visual analytics to provide actionable insights. Key Features: 📊 Total Revenue & Sales Overview: Displays key performance indicators (KPIs) such as total revenue, total quantity sold, gross income, and average rating. 📦 Product & Category Insights: Showcases revenue distribution across different product lines and branches. 👥 Customer Segmentation: Includes slicers for filtering data by branch, product category, customer type, city, and payment method for in-depth analysis. 📈 Trend Analysis: A dynamic line chart visualizing sales performance over time. 💳 Payment Method Analysis: A pie chart illustrating the distributi...

E-commerce Dashboard Overview E-commerce Dashboard Overview In today's data-driven world, making informed decisions is crucial, and this dashboard is designed to empower you with the insights you need to drive success in your e-commerce business. Here's a quick overview of what you'll find in this comprehensive dashboard: 1️⃣ Total Sales, Returns, and Quantity: Get a quick snapshot of your e-commerce performance with real-time data on total sales, returns, and the quantity of products sold. 📈 2️⃣ Sales by Segment: Explore the distribution of your sales across different customer segments through an intuitive pie chart. 🍰 3️⃣ Sales by Market: Gain insights into your market share with a colorful donut chart that showcases your sales distribution across different markets. 🌐 4️⃣ Top 5 Customers by Profit: Identify your top-performing customers based on their...

Bank Churn Analysis Project 📊 Exciting Bank Churn Analysis Project Results! 📊 I am thrilled to share the key insights from my recent project on Bank Churn Analysis . We delved deep into customer data to understand the factors influencing churn, and the results are truly eye-opening. Here are the key findings at a glance: 🔹 Customers by Product Name 📈 We analyzed customer distribution by product name, providing a clear overview of our customer base. This column chart reveals where our strengths lie and where there may be room for growth. 🔹 Customers by Gender 🍩 Gender is a significant factor in our analysis, as shown by the donut chart. Understanding gender distribution helps us tailor our services to better meet the needs of all our customers. 🔹 Customers by Activity Status 🍩 It's vital to identify act...