ASSIGNMENT
1. Name and explain any three basic charts available in spreadsheets and mention one
use of each.
2. Differentiate between OLTP and OLAP systems with one example each.
3. Define data visualization and state its importance in data analytics.
4. What is data visualization in Python? Mention any two advantages of using Python
for data visualization.
5. Define data cleaning. Mention any two common data cleaning techniques.
6. Differentiate between batch processing and stream processing.
7. Write a Python program using Pandas and Matplotlib to:
a. Import a CSV dataset containing numerical data.
b. Plot a line chart and a bar chart from the cleaned data with proper labels and titles.
8. Compare relational databases and NoSQL databases in terms of structure, scalability,
and use cases.
9. Explain data modeling concepts with reference to E–R diagrams, normalization, and
denormalization.
10. Explain the process of data generation, collection, storage, processing, and analysis in
spreadsheets with a neat flow.
11. Explain how visualizations are used in Exploratory Data Analysis (EDA) to identify
patterns, trends, and outliers.
12. Explain the steps involved in setting up a Python environment for data visualization
using Anaconda or Google Colab. And Discuss the process of data cleaning and
preprocessing using Pandas with suitable examples.
13. Write a python program using Seaborn to:
Load a dataset using Pandas
Create a box plot and heatmap
Analyze and comment on the presence of outliers and correlations in the
dataset.
14. An online food delivery platform wants to monitor live order data, delivery status, and
customer activity in real time. The data is generated continuously from mobile
applications and APIs. Design a data visualization workflow for this system by
explaining:
a) Appropriate data collection methods (batch vs streaming)
b) Data processing and transformation approach
c) Suitable visualization techniques for real-time dashboards
15. Analyze the importance of interactive visualizations using Plotly and Bokeh. Explain
how they enhance data interpretation.
16. Explain the role of data integration and data quality in multi-source data visualization
systems. And Design a Python program using Plotly to:
Import a dataset (CSV or Excel)
Create an interactive dashboard with at least two different visualizations.
Enable user interaction such as hover information or filtering.