📊 Real-time Company Data Analysis

This project focuses on analyzing real-time company sales data to generate valuable insights into revenue trends, profit margins, product performance, and customer behavior.
It uses Excel-based data modeling, Power Query transformations, and Power BI/Excel dashboards to visualize company metrics interactively.

---

🚀 Project Overview

The Real-time Company Data Analysis project aims to help businesses make data-driven decisions by providing an automated process for cleaning, transforming, and visualizing sales data.

Key Objectives:

• Combine sales and profit data from multiple sources.
• Perform year-wise, month-wise, and category-based analysis.
• Enable real-time filtering and KPI tracking.
• Create insightful dashboards for management reporting.

---

🧩 Features

• Automated data import and refresh from multiple sources.
• Year-wise filtering for COGS (Cost of Goods Sold), Sales, and Profit.
• Power Query transformations for clean, structured data.
• Data modeling with relationships between sales, customers, and products.
• Interactive visual dashboards using Power BI or Excel.

---

🗂️ Project Structure

Real-time-company-data-analysis/ │ ├── Sales Analysis/ │ ├── Sales_analysis.xlsx # Main dataset and dashboard file │ └── Data Models/ # Supporting Excel models │ ├── Data Sources/ │ ├── fact_sales_monthly.csv │ ├── sales_monthly.csv │ └── customers.csv │ ├── Scripts/ │ └── power_query_steps.txt # Power Query transformations │ ├── README.md # Project documentation └── project_link.txt # Google Drive file link (below)

---

🔗 Data Files

Due to GitHub’s file size limits, the original Excel dataset is hosted in Google Drive:

📎 Access the full dataset here:
Google Drive - Real-time Company Data Files

---

🧠 Tools & Technologies Used

• Microsoft Excel (2016 & above)
• Power Query / Power Pivot
• Power BI (optional)
• Git & GitHub for version control

---

📈 Insights Generated

• Year-wise COGS, Sales, and Profit comparison.
• Monthly and quarterly performance visualization.
• Identification of top-performing products and customers.
• Real-time KPIs and trend analysis.

---

⚙️ How to Use

1. Clone the repository:

   git clone https://github.com/Manojsv20/Real-time-company-data-analysis.git

2.Download the datasets from the Google Drive link above. 3.Open Sales_analysis.xlsx in Excel or Power BI. 4.Refresh data connections to view the latest analysis.

👨‍💻 Author

Manoj S V 🎓 B.E -Velammal College of Engineering and Technology 📧 Contact on manojsv2003@gmail.com