Unit 1

1. Defining Data Visualization (DV) and Its Advantages

Data Visualization (DV) is the method of presenting data in a visual format, such
as charts, graphs, maps, and dashboards, to make patterns, trends, and key
insights easily accessible. This graphical representation allows users to quickly
grasp information, unlike reading extensive tables of numerical data.

Key Advantages:

● Better Comparison: Facilitates rapid comparison of datasets or scenarios

without needing to analyze large tables.
● Enhanced Understanding: Uses pictorial forms (charts and graphs) for
simpler comprehension (e.g., as seen in Google Trends).
● Easy Data Sharing: Visual data is more compelling and simpler to
communicate than raw numbers.
● Accurate Analysis: Clearly highlights trends and patterns, leading to more
informed decision-making.
● Sales Analysis: Supports understanding of product performance, customer
behavior, and regional sales via charts and heat maps.

2. Data Visualization Structure

The structure of data visualization is based on the type of data being represented
graphically to easily identify patterns, trends, and comparisons. It is primarily
categorized into two types:
Data Type Description Sub-Types Examples Common
Charts

1. Numerical
Data Deals with Continuous Height, Line chart,
Visualization measurable or Data: Takes any weight, histogram
countable value within a temperature,
quantities and range; includes time
numbers. decimals.
 Discrete Data: Number of Bar chart
Takes fixed, students,
countable number of
values; no cars
decimals.

2. Categorical Represents Binary Data: Yes/No,

Data groups or Has only two Male/Female
Visualization categories distinct , Pass/Fail
rather than categories.
numerical
values.

Nominal Data: Blood group, Bar chart, pie

Categories colors, chart
without any country
inherent order or names
ranking.

Ordinal Data: Grades (A,

Categories that B, C),
have a specific satisfaction
order or ranking. level (High,
Medium,
Low)

Importance of This Structure:

● It is crucial for selecting the most appropriate chart types.

● It enhances the accuracy of data analysis.
● It makes data interpretation simpler.
● It prevents misrepresentation of data.
3. Tableau Application Suite

The Tableau Application Suite is a collection of tools designed to manage the entire
data visualization workflow, from data preparation to sharing finalized dashboards.
Component Primary Function Key Features

🔷 1. Tableau Desktop
The core tool for creating Connects to various data
visualizations. sources (Excel, SQL,
CSV, etc.). Used to build
charts, dashboards, and
stories. Supports data
analysis with filters and
calculated fields.

🔷 2. Tableau Prep Tool for data cleaning and Helps in removing nulls,
Builder preprocessing. merging tables, and
standardizing data types to
prepare clean data for
Tableau Desktop.

🔷 3. Tableau Server Platform for publishing Enables collaboration and

and sharing dashboards access control. Allows
within an organization. users to view and interact
 with dashboards via a web
browser.

🔷 4. Tableau Online A cloud-based, hosted Eliminates the need for

(Tableau Cloud) version of Tableau Server. local server hardware
installation. Provides
access to dashboards from
any location with an
internet connection.

🔷 5. Tableau Public Free version for public Used to publish

dashboard sharing. visualizations publicly
online. Ideal for students
and portfolio
development; however,
data is not private.

🔷 6. Tableau Reader Tool for viewing Users can only view

dashboards offline. dashboards; editing or
creation of visualizations
is not possible. Useful for
users without Tableau
Desktop access.

4. Data Pre-Processing Steps

Data pre-processing is the essential process of transforming raw data into a clean,
usable, and suitable format for analysis or visualization.
The Main Steps Are:

1. Data Cleaning:
● Focuses on removing errors and 'noise' from the data.
● This involves handling missing values, eliminating duplicates, and
correcting inconsistent or inaccurate data
● e.g., removing blank cells, fixing spelling errors .
2. Data Integration:
● This is the second phase of pre-processing after Data Cleaning
● Combines data from disparate sources into a single, cohesive dataset,
preventing conflicts and data duplication
● e.g., merging sales data from different company branches.
3. Data Transformation:
● This is the third step after Interagrating the data .
● Converts the data into an appropriate format for analysis.
● This includes techniques like normalization, aggregation, and encoding
● e.g., converting text fields to numerical values, grouping records
4. Data Reduction:
● This is the fourth step in Pre- processing , after the data is transformed
into business insights .
● Aims to decrease the volume of the data while preserving critical
information.
● This improves processing speed
● e.g., removing columns or records that are not essential
5. Data Validation:
● This is the last step in Pre - Processing
● Ensures that the data conforms to defined rules and constraints,
verifying correctness before visualization
● e.g., checking that an 'age' field is not a negative number.
5. The Tableau Workspace Components

The Tableau Workspace is the primary interface where users connect to data, create
visualisations, and assemble dashboards and stories.
Component Location/Description Function

1. Menu Bar
Located at the top. Contains core options:
File, Data, Worksheet,
Dashboard, Help. Used for
managing and exporting
worksheets.

2. Toolbar Below the Menu Bar. Provides quick-access

buttons for common
operations like Save,
Undo, Redo, Export, and
Swap.

3. Data Pane Located on the left side. Displays data sources,

tables, fields, Dimensions,
and Measures. Used to
drag fields onto the
worksheet.

4. Rows and Columns Above the View Area. Used for placing fields to
Shelves structure the chart,
controlling the X-axis and
Y-axis.

5. Marks Card Below the Data Pane. Controls the visual

encoding of data: Color,
Size, Label, Detail,
Tooltip, and Shape.
6. Filters Shelf Next to the Marks Card. Used to apply filters to the
data, showing only
specific subsets of records
in the visualization.

7. View Area (Canvas) The central area. Where the final chart or
visualization is displayed.

8. Show Me Panel Available on the right Suggests different chart

side. types, assisting beginners
in selecting suitable
visualizations.

9. Sheet Tabs Located at the bottom. Includes tabs for

Worksheet, Dashboard,
and Story, used for
navigation and creation.

6. Data Quality and the Necessity of Data Remediation

Data quality defines the reliability, accuracy, completeness, and consistency of
data

for effective analysis and decision-making. High-quality data ensures correct

analytical outcomes, whereas poor-quality data leads to faulty conclusions.

Characteristics of Good Data Quality:

● Absence of missing values.

● No duplicate records.
● Data is correct and valid.
● Consistent data formats.
✅ Why Data Remediation is Needed

Data remediation is the process required to correct errors and improve data
quality before any analysis or visualization takes place.

Necessity of Remediation:

● To eliminate duplicate and inaccurate data entries.

● To correctly fill or adjust missing values.
● To ensure and maintain consistent data formats across the dataset.
● To improve the overall accuracy of the final analysis.
● To prevent misleading visualizations and poor business decisions.

7. Importance of Data Visualization

Data visualization is crucial for understanding and analyzing data by presenting it
in accessible graphical forms such as charts, graphs, and dashboards.

Key Importance Factors:

● Easy Data Comprehension: Complex data sets can be quickly understood

using visual formats.
● Identification of Trends and Patterns: Helps in detecting growth, decline,
and underlying relationships within the data.
● Supports Quick Decision Making: Visual insights enable managers to make
faster, more informed decisions.
● Improves Data Communication: Information is more easily shared and
explained to stakeholders.
● Saves Analysis Time: Reduces the effort required compared to manually
reviewing large tables of numbers.
● Business Performance Monitoring: Facilitates tracking of sales, profit, and
customer behavior metrics.
● Detection of Errors and Outliers: Abnormal data points (outliers) are easily
noticed within visual charts.
2 marks

1. Define Data Visualization.

Data Visualization is the graphical representation of data using charts, graphs, maps
and dashboards to understand patterns, trends and insights easily.

2. Write two advantages of Data Visualization.

● Easy understanding of large data

● Quick decision making

3. Write two disadvantages of Data Visualization.

● Wrong visualization can mislead users

● Requires good data quality

4. What is Big Data?

Big Data refers to extremely large and complex datasets that cannot be processed
using traditional data processing tools.

5. Write two roles of Data Visualization in Big Data

● Helps in identifying patterns

● Supports faster decision making

6. Give two examples of Data Visualization.

● Bar Chart
● Line Chart

7. What is structured data?

Structured data is data organized in rows and columns such as tables and
spreadsheets.

8. Define data quality.

Data quality refers to the accuracy, completeness and consistency of data.

9. What is data remediation?

Data remediation is the process of correcting errors and improving the quality of data.

10. What is data pre-processing?

Data pre-processing is the process of cleaning and preparing raw data before analysis
or visualization.

11. Write any two steps in data pre-processing.

● Data Cleaning
● Data Integration
● Data Transformation
● Data Reduction
● Data Validation

12. What is Tableau?

Tableau is a data visualization tool used to create interactive charts and dashboards.

13. Write any two Tableau products.

● Tableau Desktop
● Tableau Server

14. What is Tableau workspace?

Tableau workspace is the main interface where users create visualizations and
dashboards.

15. What are dimensions?

Dimensions are categorical fields used to group data, such as region or category.

16. What are measures?

Measures are numerical fields used for calculations, such as sales or profit.

17. Give two examples for dimensions and measures.

 ● Dimensions: Country, Product
● Measures: Sales, Quantity

18. What is a sheet in Tableau?

A sheet is a workspace where visualizations are created, such as worksheet,
dashboard or story.