Dataset Description using Orange tool. and generate dashboard using data of Orange tool
DataBase
I am using this database for this practical. https://archive.ics.uci.edu/ml/machine-learning-databases/00426/. In this dataset there are list of students and its score. students are from different different country they connect with different relation. We analys this dataset perform given task.
Task 1
In this task first we visualize data without pre-processing and after that we pre-process that data and visualize that. And compare result of both.
One we start practical In that first we create without pre-processing. In that first we take data from file and plot that in data table in that we gave Class as target value. After that we test that data and from that we generate KKN and confusion matrix.
Now we pre-process data. After pre-processing we store that data in one data table and after that we do same above process in that like test that data and from that we find KNN and confusion matrix.
We store that data table because we have to use that table in PowerBI practical
We create this type of diagram in orange tool.
In pre-process we set this type of information
In this preprocessing we input missing value, normalize feacture so data converted from 0 to 1.
After pre-process data we store that in table. Sothat table is like this.
In this all data are between 0 to 1 formate but in this we set ID and Age as meta so it will not convert.
Now we test this data.
We can see result of data testing. This data set more acurate that previous one. Because In that we arrange data and set missing value so we can find accurate answer from this.
Now we see confusion matrix.
This is confusion matrix after pre-processing.
Now we save our pre-processed data and start task-2 which is in powerBI.
Task 2
Generate the Dashboard of preprocessed dataset from task-1.
Now we import data in powerBI.
Now we create dashboard from this database.
In this DashBoard we comaper as asian and non asian students id and after that we see the list of student which are conect to other relation. and last we find ratio of male and female.
And at last we comapre students which are in the calss.
Thank you.