GANPAT UNIVERSITY

FACULTY OF ENGINEERING & TECHNOLOGY

Programme

Bachelor of Technology

Branch/Spec.

Computer Science & Engineering

Semester

VII

Version

1.0.0.0

Effective from Academic Year

2025–26

Effective for the batch Admitted in

June 2022

Subject code

2CSE714

Subject Name

DATA ANALYSIS AND VISUALIZATION

Teaching scheme 

Examination scheme (Marks)

(Per week)

Lecture

(DT)

Practical

(Lab.)

Total

CE

SEE

Total

L

TU

P

TW

Credit 

2

0

1

0

3

Theory 

40

60

100

Hours

2

0

2

0

4

Practical

30

20

50

Pre-requisites:

Database Management System, Data Mining and Warehouse

Learning Outcome:

After successful completion of the course students will be able to:

• Explain the importance of data analysis in decision-making and business processes.
• Design and implement interactive visualizations for dynamic data exploration.
• Solve business intelligence related queries using Data Visualization tool, i.e., tableau.
• Apply Advance concepts related to big data in projects/real life scenarios

Theory syllabus

Unit

Content

Hrs

1

Introduction to Data Analysis and Visualization

Overview, Types of data analysis, introduction to Data Visualization and its importance in decision making and business intelligence

2

2

NoSQL Databases

Introduction to NoSQL database, Types of NoSQL databases, MongoDB: Architecture, Operators, CRUD operations, Aggregation Framework, Indexing, Administration

16

3

Data Visualization

Tableau:

Data types, file types, show me menu, Type of data sources supported by, connecting different data sources, edit metadata, filtering fields, types of charts, group, set, hierarchy, parameters, pivot, data joining, data blending, calculated fields, preparing dashboards and storyboards.

12

Practical content

Practicals will be based on:

• MongoDB CRUD Operations
• MongoDB Aggregation Framework
• Tableau: Preparing Dashboards and Stories using various tableau features

Text Books

1

MongoDB: The Definitive Guide by Shannon Bradshaw , Eoin Brazil

Reference Books

1

Visual Analytics Using Tableau: Structured approach for turning raw data to powerful insights by NehaSingh Rajput and Sulabh Bhatt

2

Tableau For Dummies by Molly Monsey and Paul Sochan

Course Outcomes:

Cos

Description

CO1

Explain the importance of data analysis in decision-making and business processes.

CO2

Design and implement interactive visualizations for dynamic data exploration.

CO3

Solve business intelligence related queries using Data Visualization tool like tableau, PowerBI

CO4

Apply Advance concepts related to big data in projects/real life scenarios

Mapping of CO and PO: