Name: bda_assignments1_report
Uploaded: 2021-10-21
Duration: 4 min 51 s
Description: . . VISVESVARAYA TECHNOLOGICAL UNIVERSITY,. BELAGAVI.

. . VISVESVARAYA TECHNOLOGICAL UNIVERSITY,. BELAGAVI. 

Scene 1

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING

ALVA’S INSTITUTE OF ENGINEERING AND TECHNOLOGY

. . ALVA’S INSTITUTE OF ENGINEERING AND TECHNOLOGY. 

Scene 2

This is to certify that, assignment work for the subject “Big Data Analytics

(17CS82)” has been successfully completed and report submitted by Name

APEKSHA RANE USN 4AL17CS010 during the academic year 2020– 2021. It

is certified that all corrections/suggestions indicated presentation   session

have   been   incorporated   in   the   report   &   scored_ _ _ marks out of 10

and deposited in the departmental library.

Scene 3

APOORVA H P USN 4AL17CS011during the academic year 2020– 2021. It is

certified that all corrections/suggestions indicated presentation   session   have

been   incorporated   in   the   report   &   scored_ _ _ marks out of 10 and

Scene 4

APOORVA K N USN 4AL17CS012 during the academic year 2020– 2021. It

Scene 5

ARUN K USN 4AL17CS013 during the academic year 2020– 2021. It is

Scene 6

ASHA TOTAGI USN 4AL17CS015 during the academic year 2020– 2021. It is

. . ACKNOWLEDGEMENT. The satisfaction and euphoria that accompany a successful completion of any task would be. 

Scene 7

The satisfaction and euphoria that accompany a successful completion of any task would be

incomplete without the mention of people who made it possible, success is the epitome of hard

work and perseverance, but steadfast of all is encouraging guidance.

So, with gratitude we acknowledge all those whose guidance and encouragement

served as beacon of light and crowned the effort with success.

We thank our Subject faculty Mrs. Veena, Assistant Professor in Department of

Computer Science& Engineering, who has been our source of inspiration. She has been

especially enthusiastic ingiving her valuable guidance and critical reviews.

We sincerely thank, Dr. Manjunath Kotari, Professor and Head, Department of

Computer Science & Engineering who has been the constant driving force behind the

We thank our beloved Principal Dr. Peter Fernandes, for his constant help and support

We are indebted to Management of Alva’s Institute of Engineering and Technology,

Mijar, Moodbidri for providing an environment which helped us in completing our task in

Also, we thank all the teaching and non-teaching staff of Department of Computer

Science & Engineering for the help rendered.

. . TABLE OF CONTENTS. CHAPTER. NO.. DESCRIPTIONS. 

Scene 8

. . Alva’s Institute of Engineering & Technology. 

Scene 9

Alva’s Institute of Engineering & Technology

Apeksha Rane,Apoorva H P,Apoorva K N,Arun K,Asha Totagi

Abstract: data analysis is the process of 
collecting and organizing data in order to 
draw helpful conclusions from it. The 
process of data analysis uses analytical and 
logical reasoning to gain information from 
the data. The main purpose of data analysis 
is to find meaning in data so that the derived 
knowledge can be used to make informed 
decisions. 
Preparing data 
for 
analysis

requires many steps that each take a long 
time to do manually. The data must be 
cleansed, standardized, transformed, etc. 
This is where a lot of the outdating happens. 
By the time the data is ready, it is not as 
recent and there is newer data out there.

The data was exported from general ledger 
data.gov.in and basically it contains  details 
of a percentage of school with electricity of 
the year 2013-2016 so each row in the data 
here contains information for specific state. 
So you can see we have the state, 
year,primary_only,Primary_with_U_Primay,
Primary_with_U_Primary_Sec_HrSec,U_O
nly… like different columns. There are total 
13 rows and 111 columns in the dataset 
considered. This data set contain the 
information about different states with the 
different school like primary, high school 
with the electricity.

Here we used pivot table an in-built function 
of Excel Sheet to analyze data. Pivot 
diagram was created by dragging different 
fields of data. We process two fields that are 
states and all schools. Applying different 
formulas the total schools are calculated and 
unique values were sorted. It's basically 
filtered the data set for top 10 schools for 
each represent each unique item in that field 
and then calculated the sum of total school. 
We've automatically created a pie chart here 
using pivot chart. Just allows us to visualize 
this information. From the value fields we 
can convert to different metrics. Just drag 
and drop the values for calculating average 
and sum.

Pivot Pal is also one tool offering the same 
kind of options for analyzing our data and 
sorting it. It also has additional features and 
is helpful for larger datasets to give quicker 
results.

Department of Computer Science & Engineering 
Page 1

Scene 10

II Results 
 
A graphical representation shows the total 
number of schools in the different states with 
electricity. From data set it difficult to find 
out the school with electricity but from this 
graph we can easily find out that which and 
all states are having the school with 
electricity. The pie charts shows that 
Lakshadweep, Daman & Diu, Pondicherry, 
Chandigarh ,Delhi, Punjab these state having 
the highest schools with the electricity i.e 
300 and the state Jharkhand has less number 
of school with electricity.

Analyzing of data helps in many ways. Like in 
this case we can establish the number of school 
with electricity in different states. If the data is 
represented in a graphical or visually attractive 
manner it is interesting and easier to work with 
given data. Larger datasets may need splicing, 
segregation or highlighting of the same.

Department of Computer Science & Engineering 
Page 2

bda_assignments1_report

Scene 1 (0s)

Scene 2 (20s)

Scene 3 (47s)

Scene 4 (1m 12s)

Scene 5 (1m 37s)

Scene 6 (1m 53s)

Scene 7 (2m 4s)

Scene 8 (2m 48s)

Scene 9 (2m 59s)

Scene 10 (4m 14s)