Data Visualization Solution

Data visualization is a graphical representation of data which can be used to identify the patterns,outliers and trending of a data set. Data visualization plays a big role when analyzing a large data set to make data driven decisions.
Build a data visualization dashboard steps
Dataset
Los Angeles Parking Citations dataset(https://www.kaggle.com/cityofLA/los-angeles-parking-citations )
Cleaning Data
I have used the R STUDIO to do the cleaning part rather than doing it in manually.

Here I have removed some unwanted columns from the data set and omit the rows with NA values.After cleaning the dataset I have save it in my local machine by renaming the new dataset.
Batch analytics

Instead of loading the dataset to the tableau I have written the queries to get the output.

I have written queries and save the output to a separate csv file.Then I imported that csv file to the tableau and design the charts.

After selecting the relevant file and designed charts in tableau by dragging and drooping the rows and columns.
Real Time Analytics
To do the real time analytics I have used the wso2 DAS tool.

I have downloaded the tool and run the server and started.


After running some codes the url of the mgt console is appeared.Copied that url and pasted it on the browser.Then the wso2 Management Console UI comes and can sign in to the system.

After login to the UI , a stream event is created to upload the data file for streaming.

I have added the details about stream and created a table as below which is similar to the csv format with the relevant column name and data type.

After that I uploaded the previously formatted csv to this UI and configure the stream and started playing it.

When go to the data explorer tab it shows that loaded data.

Next created the output streams to the all queries with the relevant columns.
Go to the Execution plan import and export the relevant streams.Then executed the siddhi sql queries to get the outputs.
Siddhi SQL Queries




Connect with MY SQL
Created a database in php my admin and created tables with relevant columns.

Then created a data source by configuring the features in MY SQL details.

Save the data source and added a publisher.

After doing the above steps successfully refresh the database.This tool automatically push the data to the database table.
Connect With Tableau

Then visualize the graphs using tableau and got the embedded code and pasted in the html dashboard.

Dashboard

Challenges
- Batch file was not running
Initially my server was not working well.After figuring out the errors I added a new environment variable called CARBON_HOME and added the bin folder’s path.
2.My SQL not connected with the tableau
There I used the My SQL Connector downloaded and install it.