DATA VISUALIZATION

UNIT 1:
1. Discuss the role of data visualisation in shaping professional skills and career opportunities.

2. Explain the concept of the "citizen data scientist" and the role of data visualisation in this context.

3. Discuss the crucial role of data visualisation in military applications.

5. Explain how data visualisation impacts the field of Business Intelligence.

6. Explain the concept and utility of a Bubble Map in data visualisation.

UNIT 2:
1. Explain the importance of understanding data types in Excel for effective data visualisation.

2. Describe how spreadsheet organisation can impact the ease and effectiveness of creating visualisations in
Excel.

3. Discuss three types of charts that are most effective for showing trends over time and justify your choices.

4. What are some essential formatting techniques to enhance the readability and interpretability of Excel
charts?

5. Outline the steps involved in creating a pie chart in Excel and discuss when it is most appropriate.

6. Describe the role of Excel's 'Pivot Table' feature in data visualisation.

7. Compare and contrast the uses of column charts and line charts in Excel.

8. How can conditional formatting be utilised for data visualisation in Excel?

9. Explain the significance of data formatting in Excel and its impact on visual representation.
10. Discuss the main challenges a working professional might face when new to Excel and how they can
overcome them.
11. Enumerate the steps to change the chart title and axis labels in Excel.

12. Why is it essential to evaluate the effectiveness of various Excel chart types in representing different data
sets?
13. Describe the basic building blocks of an Excel spreadsheet and their roles.

14. How can Excel's sorting and filtering features aid in data visualisation?

15. Discuss the use cases where Excel for data visualisation is preferable over more specialised software like
Tableau.

16. Explain how to customise the colour scheme of a chart in Excel.

17. What are some of the limitations of using Excel for data visualisation, and how can they be mitigated?
18. How does understanding the formatting options in Excel contribute to better data visualisation?

19. Describe the steps to create an Excel bar graph and explain when to use it.

20. Discuss how the knowledge of Excel can give you a competitive edge in today's data-driven world.
UNIT 3:
1. Explain the fundamental principles for creating an effective pie chart. What should be considered when
organising source data, and how does the number of data categories impact chart readability?

2. Describe the steps involved in customising a pie chart in Excel. Discuss the various options for enhancing
a pie chart's appearance and clarity.

3. In what scenarios would you recommend using a pie of pie or bar of pie chart in Excel? How can you
control which data categories are moved to the secondary chart?
4. Discuss bar graphs' primary purposes and suitability for different data comparisons. Explain the concept
of a Gantt chart and its significance in project management.
5. How can you adjust the width of bars and the spacing between them in Excel bar graphs? What are the
implications of changing these settings on the chart's visual presentation?

6. Explain the techniques for sorting data on a bar chart in Excel. Outline the steps to reverse the order of
data categories on a chart without modifying the source data, both through the Select Data Source dialog and
data series formulas.

UNIT 4:
1. Explain the fundamental purpose of a histogram in statistics. Provide a step-by-step process for creating a
histogram, including how to determine the number of bins and their boundaries. Illustrate your explanation
with an example.

2. Discuss the significance of Gantt charts in project management. Describe the key components of a Gantt
chart and explain how they help project managers plan and monitor projects effectively. Provide an example
of a project and create a simplified Gantt chart to represent its timeline.
3. Define what a heat map is and describe its primary applications in data visualization. Explain the concept
of conditional formatting in creating heat maps using tools like Microsoft Excel. Provide a real-world
scenario and demonstrate how to create a heat map to visualize the data effectively.

4. Compare and contrast histograms with other types of data visualization, such as line charts and bar charts.
Highlight the situations in which histograms are more suitable for representing data distribution and
patterns. Provide examples to support your comparisons.

5. Describe the challenges and limitations associated with using Gantt charts in project management.
Discuss how Gantt charts handle complex projects with multiple dependencies and constraints. Offer
strategies for overcoming these challenges and maximizing the benefits of Gantt charts.

6. Explain the role of color selection and gradient scales in creating informative and visually effective heat
maps. Discuss the psychological aspects of color perception and how they impact data interpretation.
Provide guidelines for choosing appropriate color schemes for different types of data and objectives.

UNIT 5:
1. Explain the components of a box and whisker plot and their significance in summarizing a dataset's
distribution. Provide a step-by-step example of how to create and interpret a box and whisker plot using a
sample dataset.
2. Describe the main characteristics and use cases of area charts in data visualization. Provide an example of
a situation where an area chart is more suitable than other chart types, and explain why.
3. Discuss the purpose and benefits of using a waterfall chart in representing financial data or cumulative
effects. Provide a step-by-step guide on how to create a waterfall chart in Excel and explain the significance
of its different components.

4. Compare and contrast the box and whisker plot, area chart, and waterfall chart in terms of their primary
functions, strengths, and limitations. Explain when each chart type should be used and under what
circumstances they might not be appropriate.

5. Identify and describe real-world scenarios or industries where box and whisker plots, area charts, and
waterfall charts are commonly used for data analysis. Explain how these charts add value in those contexts
and what insights they help reveal.

6. Discuss the best practices for creating effective box and whisker plots, area charts, and waterfall charts.
Highlight common challenges or misconceptions that users may encounter when working with these chart
types and suggest strategies to overcome them.

UNIT 6:
1. Explain the step-by-step process of creating a timeline chart in Excel. Include details on how to input
data, customize the chart's appearance, and add labels for better clarity. Provide an example scenario where a
timeline chart would be particularly useful in project management or data presentation.
2. Discuss the advantages and disadvantages of using a timeline chart over other visualizations, such as
Gantt charts or bar graphs, when displaying chronological data. Provide specific examples of situations
where a timeline chart excels in conveying information effectively.

3. Define and illustrate the concept of correlation in the context of a scatter plot. Explain the differences
between positive, negative, and zero correlations, using graphical representations and real-life examples to
aid your explanation. Additionally, discuss the implications of strong versus weak correlations.

4. When dealing with a dataset for which you intend to create a scatter plot, what considerations should you
keep in mind regarding data preprocessing and data cleaning? Describe potential challenges related to
outliers and missing values and propose strategies for addressing these issues to ensure the accuracy of your
scatter plot.
5. Provide a comprehensive guide to creating a pictogram chart in Excel, covering the selection of
appropriate symbols, resizing and arranging them, and assigning numerical values. Explain how the use of
pictogram charts enhances data visualization and improves the audience's understanding of complex data
sets, giving examples.

6. Compare and contrast pictogram charts with bar graphs when representing categorical data in Excel.
Highlight the strengths and weaknesses of each visualization type, and justify why you might choose one
over the other for different types of data presentations. Provide real-world scenarios as examples.

UNIT 7:
Terminal Questions

1. Explain the importance of proper indentation in Python code. Provide examples illustrating how
indentation defines code blocks and influences program execution.

2. Describe the critical characteristics of Python variables, including naming conventions, data types, and
their role in storing data. Provide examples to illustrate variable declarations and assignments.

3. Compare and contrast Python's print() function and comments (#). Explain how each is used in Python
code and provide examples.
4. Explore the data types in Python, including integers, floats, and strings. Please provide examples of each
data type and explain their practical applications in programming.

5. Discuss the role and significance of Matplotlib in Python's data visualisation landscape. Provide examples
of different types of plots that can be created using Matplotlib.

6. Compare and contrast Seaborn and Plotly as Python data visualisation libraries. Highlight their key
features, use cases, and advantages. Provide examples to showcase the types of visualisations that can be
created with each library.
7. Write a short note on Interactive Python Notebooks.

8. List the steps for efficient best practices for code visualisation.

UNIT 8:
1. Explain the step-by-step process of creating a Word Cloud in Python. Include details on text pre-
processing, word frequency calculation, and the use of Python libraries.
2. Discuss the advantages and disadvantages of using a Word Cloud to visualise text data. Provide examples
to illustrate your points.
3. Describe the steps involved in creating a Frequency Distribution table for numerical data in Python.
Include code snippets to demonstrate each step.
4. Compare and contrast Frequency Distributions and Histograms. Explain how Frequency Distributions are
used to generate histograms, and provide a real-world example of when each is more suitable for data
analysis.

5. Imagine you have a dataset containing customer reviews for a product. Explain how you could use both
Word Clouds and Frequency Distributions to analyse and gain insights from this dataset. Provide a step-by-
step approach, including text pre-processing and data visualisation.

6. Discuss the limitations and challenges associated with using Word Clouds and Frequency Distributions
for large-scale text data analysis. How might these challenges be addressed in practice?
7. Explain how a frequency distribution table can be used in market research?

8. What is tokenisation and why is it important in text data cleaning?

9. How does sentiment analysis visualisation aid in understanding public opinion?

10. What does a sentiment analysis score of -1 indicate?

UNIT 9:
1. Explain the concept of Density Maps in data visualisation.

2. Describe the types of Geographic Plots,

4. Explain what Kernel Density Estimation (KDE) Maps are and how they differ from traditional Density
Maps. Describe the steps involved in creating a KDE Map using Python and provide a code example.
5. Define Contour Maps and explain their significance in visualising continuous data over two-dimensional
spaces. Provide an example Python program demonstrating the creation of a Contour Map.
6. Compare and contrast the applications and trade-offs of Density Maps, Geographic Plots, and Correlation
Matrices in data analysis. Highlight scenarios where one visualisation technique may be more suitable than
the others.

7. How did financial analysts use correlation matrices in the provided case study?

8. In what way did urban planners utilize density maps for city development?

9. Explain a real time scenario where how geographical maps are used in public health.

10. Explain the types of correlations with a simple example.

UNIT 10:
1. Explain the key components of a Bubble Chart. How are Bubble Charts useful in visualising three-
dimensional data? Provide a step-by-step example of creating a Bubble Chart in Python using a specific
dataset and library.

2. Compare and contrast the advantages and disadvantages of Bubble Charts with other data visualisation
techniques, such as bar charts and scatter plots. When is it most appropriate to use a Bubble Chart, and what
considerations should be considered when designing one for effective data communication?
3. Describe the process of preparing hierarchical data for TreeMap visualisation. How does the 'squarify'
library assist in generating Tree Maps in Python, and what customisation options are available for improving
the clarity and interpretability of Tree Maps? Provide a real-world use case of Tree Maps in a business or
organisational context.

4. In the context of Bubble Charts, discuss the significance of choosing appropriate scaling and colour
schemes. How can these choices impact the visual representation and understanding of the data? Provide
examples of good and poor design choices and explain their rationale.

5. Explain how the principles of data storytelling can be applied to both Bubble Charts and Tree Maps.
Discuss the role of titles, labels, and annotations in effectively conveying insights from these visualisations.
Provide practical examples of how data storytelling techniques can make the visualisations more informative
and engaging.
6. Discuss the limitations and potential pitfalls of using Tree Maps for hierarchical data visualisation in data
exploration and analysis. How can these limitations be mitigated, and what alternative visualisation methods
can be considered for conveying hierarchical data effectively? Provide recommendations for best practices
in utilising Tree Maps while addressing their constraints.

7. What makes interactive visuals particularly powerful in data analysis and business intelligence?

8. How does Plotly Express facilitate the creation of bubble charts?

9. How do you customise the appearance of markers in a bubble chart using plotly.graph_objects?

10. Explain different ways of creating bubble charts.

UNIT 11:
1. Explain the importance of addressing missing values in a dataset.

2. Describe the common methods for detecting and handling missing data, providing examples for each.
3. Discuss the concept of data imputation in data analysis.

4. Explain the significance of reshaping and restructuring data in the context of data analysis.
5. Describe the role of aggregation and grouping in data analysis.

6. Describe the process of filtering data in Python.

7. Explain the fundamental differences between querying and sub setting data in Python.

8. What does the dropna() function do, and how can it be customised?
9. Explain the use of the fillna() function with an example.

10. How does the databases are integrated in Python?

UNIT 12:
1. Explain the importance of time series data in data analysis. Provide examples of real-world applications
where time series data analysis is crucial.
2. Describe the key challenges when working with dates and time series data. How does Python's datetime
module help address these challenges? Provide code examples illustrating the manipulation of date and time
data.

3. Explain the concept of resampling in time series data analysis.

4. Discuss the scenarios in which you might prefer downsampling over upsampling, and vice versa. Provide
Python code examples for both cases.

5. Describe the various visualisation techniques used to identify trends and patterns in time series data.
Provide detailed examples using Python, highlighting the types of insights that can be gained from these
visualisations.

6. Compare and contrast the different types of moving averages, including Simple Moving Average (SMA),
Weighted Moving Average (WMA), and Exponential Moving Average (EMA). When and why would you
choose one over the other for smoothing time series data? Provide Python code examples to demonstrate
their applications.

7. Explain the three main types of Exponential Smoothing (Single, Double, and Triple).
8. Describe the scenarios in which you would use each type of Exponential Smoothing technique.

9. What is the significance of seasonal decomposition in time series analysis?

10. What differentiates confidence intervals from prediction bands?

UNIT 13:
1. Explain the process of creating 3D scatter plots in Python.

2. Describe the significance of visualising three-dimensional relationships in data analysis.

3. Provide real-world examples of situations where 3D visualisation is essential and explain how it aids in
gaining insights from complex data.

4. Discuss the components of a 3D mesh and their roles in computer graphics and 3D modelling.

5. Explain how to generate or load 3D mesh data, choose a visualisation library, and render the mesh plot.
6. Explain the steps involved in displaying surface plots using 3D meshes.
7. Discuss the challenges and considerations in 3D visualisation, including issues like overplotting, data
scaling, interactivity, and interpretation.
8. What are some common use cases of 3D scatter plots?

9. What challenges are associated with 3D scatter plots, and how can they be addressed?

10. List the best practices to be considered while creating 3D visuals.

UNIT 14:
1. How do data visualisations, tables, text and labels, images and icons, widgets and controls, and data
sources contribute to the components of data dashboards?

2. Explain the importance of maintaining consistency in dashboard design, including the use of color
schemes, fonts, and styles.

3. Describe the process of building interactive dashboards with Dash/Plotly in Python. What are the key
advantages of using Dash and Plotly for dashboard development?

4. Discuss the principles of adding visual components and interactivity to data dashboards.

5. How does data storytelling play a crucial role in effective dashboard communication?

6. Explain the key elements of data storytelling and how they help users understand complex data sets and
draw meaningful conclusions.

7. Explore the concept of sequencing and storytelling in data dashboards.

8. How can storytelling techniques be employed to guide users through data narratives, and why is
sequencing important in dashboard design?

9. Describe the importance of user-centered design in dashboard development.

10. How does interactivity enhance the utility of data dashboards?

These are sample terminal questions shared only for your