arunabellgutteramesh / d3visualization

d3 visualization ofSuicide data of India from the years 2003 to 2012. D3 with Angular 1.6, Node JS and MySQL

d3visualization

Here, suicide dataset is analysed with various appropriate visualisations. A detailed report is attached in the repo.

Application

Front-end : Angular JS, D3.js

Middleware : Node JS, Express

Backend : MySQL DB

Steps:

1. Download the files

DB setup

2. Setup mysql server in local DB
3. Setup mysql work bench
4. create an sql connection
5. update this connection in "db.js" under the "dataAccessLayer" folder
6. create a schema "DMV_Schema"
7. import csv file provided into mysql DB, under DMV_Schema, inside the table structure

Node JS setup

8. instal node and npm
9. install node_modules with the command "npm install" on terminal at the project location
10. once node_modules are installed, run the application with command "node app.js"
11. open http://localhost:8080/