InterConnect

InterConnect is a data-driven project designed to bridge the gap between students, faculty, and clubs by providing actionable insights through interactive dashboards. It enhances communication, aligns teaching methods with student needs, supports career guidance, and highlights the impact of club activities on overall development.

---

📊 Project Overview

• Name: InterConnect
• Duration: 13th Oct 2024 – 18th Dec 2024
• Objective: Build a dashboard that collects insights from students, teachers, and club members by streamlining the data through a data warehouse.

---

🛠️ Tech Stack

• Google Forms – Data collection with separate forms for students, teachers, and clubs.
• Google Sheets – Data cleaning, validation, and integrity checks.
• Google BigQuery – Served as a temporary data warehouse for integration with Power BI.
• Power BI – Built interactive dashboards with multiple visualizations.

---

📈 Visualizations Used

• Clustered Bar Graphs – Compare responses across groups
• Decomposition Tree – Explore diversity in data
• Donut Charts – Show category percentage breakdowns
• Matrix Charts – Display rating counts
• Cards – Highlight key metrics
• Filters – Enable interactive exploration

---

📂 Repository Contents

• /Dashboards/ → Images of dashboards
• /Data/ → Cleaned data files in Excel
• InterConnect.pbix → Power BI dashboard file

---

🚀 How to Use

1. Clone the repository
2. Open InterConnect.pbix in Power BI Desktop
3. Explore interactive dashboards
4. Review /Dashboards for quick visuals
5. Check /Data for sample datasets

---

---

🤝 Contributors

• Harsha K L
• Pavan D
• Eshwar R
• Varchas V

---

📌 License

This project is for academic and learning purposes.