Tableau in Institutions for Better Insight

 

Objective

To implement the business intelligence in institutions using Tableau for the better insight using Tableau Projects. This will help the institutions to enhance their process.

Project Overview

The mark and attendance of the student are used for the analysis, extracting the relationship among attributes in several constraints and possibilities. Attendance and mark analysis system are built with facilitating easy analysis by highlighting the hidden association in the data set. The more stable working environment needs to be developed.

Existing System

Most of the institutions use some type of software to maintain their data in digital format. The main focus of the software is to store, update and retrieve the required data easily. The existing system mainly concentrates on the data storage in the single repository rather the analysis of the data, is much difficult to process. This existing mark and attendance reporting system satisfy only the basic needs of the end users. Weekly, monthly and daily reports can be extracted from the existing system but extracting complex community reports is impossible in the existing system. This project adds over that and focuses more on the data analytics.

Problem Definition

This system satisfies only the basic requirements such as the monthly, weekly and daily report of attendance record of the students along with the course description.

Proposed System

Proposed System of this project can be stated in terms of different categories as visualizing, comparing and analyzing. In this system, requirements such as analysis and relationship of the complex reports are achieved using the following,

• Basic Statistics and Business Intelligence
• Data Analytics

This also includes the extraction of association between various attributes and the hidden relationship between them. Finally, data analytics is used to filter those required data from the entire dataset.

Module 1 : Requirement Analysis and Data Pre-Processing:

In this module, the requirements are collected from faculties and students. Some of the requirements include:

• Finding the students who secured top and bottom 5 marks.
• Comparative analysis among students.
• Finding the Impact on marks due to attendance.
• For analysis, student internal marks along with their attendance and assignment marks will be collected from the institutions.

Module 2: Statistics

In this module, the marks and attendance of students are analyzed. From this above statistics, we get the average details of the given dataset, like maximum minimum internal grade and highest lowest percentage. With the above statistics, we are going to analyze the marks of the students in different constraints using various tools.

Module 3: Business Intelligence

The concept of business intelligence is included in the project by using Tableau tool. The tool helps in finding the relational flow graph for the student course wise, exam wise top5 and bottom 5. It is also helpful in finding attendance and mark based on different categories.

Module 4-Data Mining

The concept of data mining is included in the project by using the Rapid Miner and R tool. The algorithm of data mining is imported from the rapid miner and working part of the algorithm is implemented as built-in and the required graph is displayed.

Apriori Algorithm

The Apriorialgorithm is implemented in Rapid Miner as it includes the property of the association.

• Rules (Top 5 – Support)
  • Top 5 support is used to segregate the top 5 records from the entire dataset, which helps in easy retrieval and analysis of the statistical data.
• Rules (Bottom 5 – Support)
  • Bottom 5 support is used to segregate the bottom 5 records from the entire dataset, which helps in easy retrieval and analysis of the statistical data.

Software Requirements

• MySQL Server
• Tableau
• R
• RapidMiner

Hardware Requirements

• Hard Disk – 1 TB or Above
• RAM required – 8 GB or Above
• Processor – Core i3 or Above