Skip to content

raunvk/data-visualisation-dashboard

Repository files navigation

data-visualisation-dashboard

Description : Web Application to Browse & Visualise large scale Data

Tech Stack : Spring Batch, Spring Boot, MySQL, ReactJS, ChartJS, Bootstrap

Overview :

  1. Spring Batch : Transfers large-scale data from CSV files to MySQL database efficiently
  2. Spring Boot : Creates REST endpoints to fetch and manipulate data from MySQL database
  3. MySQL Database : Stores and manages the data transferred from CSV files using Spring Batch
  4. ReactJS : Uses React components to constructs dynamic user interfaces for frontend rendering
  5. ChartJS: Visualises the data using interactive bar graphs and pie charts for presentation
  6. Bootstrap : Provides responsive design and layout utilities for enhanced UI presentation

How to Run (Windows) :

  1. Create Database called "dashboard" in MySQL [create database dashboard;]
  2. Goto path "Backend/dashboard/" in Terminal
  3. Run Backend by running the command [mvn spring-boot:run]
  4. Goto path "Frontend/dashboard/" in Terminal
  5. Run commands [npm install] for necessary Node Modules
  6. Run Frontend by running the command [npm start]
  7. Go to http://localhost:3000 on your Browser to access the Application

Sample Screenshots :

API Documentation :

  1. Retrieve All Data -> GET /
  2. Retrieve Data by ID -> GET /id/{id}
  3. Retrieve Data by Start Year -> GET /startyear/{year}
  4. Retrieve Data by End Year -> GET /endyear/{year}
  5. Retrieve Data by Topic -> GET /topic/{topic}
  6. Retrieve Data by Sector -> GET /sector/{sector}
  7. Retrieve Data by Region -> GET /region/{region}
  8. Retrieve Data by SWOT -> GET /swot/{swot}
  9. Retrieve Data by PESTLE -> GET /pestle/{pestle}
  10. Retrieve Data by Source -> GET /source/{source}
  11. Retrieve Data by City -> GET /city/{city}
  12. Retrieve Data by City -> GET /city/{city}
  13. Retrieve Data by Country -> GET /country/{country}
  14. Retrieve All Start Years -> GET /startyear/
  15. Retrieve All End Years -> GET /endyear/
  16. Retrieve All Topics -> GET /topic/
  17. Retrieve All Sectors -> GET /sector/
  18. Retrieve All Regions -> GET /region/
  19. Retrieve All SWOT Analyses -> GET /swot/
  20. Retrieve All PESTLE Analyses -> GET /pestle/
  21. Retrieve All Sources -> GET /source/
  22. Retrieve All Cities -> GET /city/
  23. Retrieve All Countries -> GET /country/
  24. Retrieve Start Year Frequency for Chart -> GET /chart/startyear/
  25. Retrieve End Year Frequency for Chart -> GET /chart/endyear/
  26. Retrieve Topic Frequency for Chart -> GET /chart/topic/
  27. Retrieve Sector Frequency for Chart -> GET /chart/sector/
  28. Retrieve Region Frequency for Chart -> GET /chart/region/
  29. Retrieve SWOT Frequency for Chart -> GET /chart/swot/
  30. Retrieve PESTLE Frequency for Chart -> GET /chart/pestle/
  31. Retrieve Source Frequency for Chart -> GET /chart/source/
  32. Retrieve City Frequency for Chart -> GET /chart/city/
  33. Retrieve Country Frequency for Chart -> GET /chart/country/