Experiment No.

1
AIM: Introduction to Data Visualization and Data Visualization Tools.
Objective: To understand the basics of data visualization and explore various data
visualization tools to effectively represent data.
Prerequisites:

 Basic understanding of data and its types.

 Knowledge of Python programming.
Theory
Data visualization is the graphical representation of information and data. By using visual
elements like charts, graphs, and maps, data visualization tools provide an accessible way to
see and understand trends, outliers, and patterns in data.
Popular Data Visualization Tools:
Matplotlib: A low-level library in Python for static, animated, and interactive visualizations.
Seaborn: Built on top of Matplotlib, used for statistical data visualization.
Tableau: A powerful business intelligence tool for interactive and real-time data visualization.
Power BI: A Microsoft tool used for analyzing business data with interactive dashboards.
Steps of Data Visualization:
1. Collect Data: Gather and clean your dataset.
2. Select Tool: Choose a visualization tool (e.g., Tableau, Power BI, Matplotlib).
3. Import Data: Load your dataset into the tool.
4. Create Visualization: Choose and create the appropriate visual representation.
5. Customize: Add labels, titles, and adjust colors for clarity.
6. Analyze: Identify patterns and insights from the visualizations.
7. Present: Prepare a report or presentation with your findings.
Conclusion: Data visualization simplifies data analysis using graphical representations, with
tools like Matplotlib, Seaborn, Tableau, and Power BI enhancing decision-making and
insights.

Note: Print is not required for this experiment.

 Experiment No. 2
AIM: Create a diverse range of plots using Python (Matplotlib and Seaborn) and R
Programming.
2.1 Area Plots 2.2 Histograms 2.3 Bar Charts 2.4 Pie Charts 2.5 Box Plots 2.6 Scatter Plots
Objective: To learn and implement various types of data visualizations using Python libraries
(Matplotlib and Seaborn) and R programming, enhancing the ability to represent data
effectively.
Prerequisites
Basic understanding of Python and R programming.
Familiarity with data structures and statistical concepts.
Installation of necessary libraries: Matplotlib and Seaborn for Python, ggplot2 for R.

Theory:

Data visualization transforms raw data into meaningful insights through graphical
representation. Different types of plots serve various analytical purposes:

1. Area Plots: Used to visualize the magnitude of change over time.

2. Histograms: Display frequency distributions of numerical data.
3. Bar Charts: Represent categorical data with rectangular bars.
4. Pie Charts: Show proportions of different categories within a dataset.
5. Box Plots: Summarize data distribution using quartiles and outliers.
6. Scatter Plots: Show relationships between two continuous variables.

Steps:

R Programming
1. Setup:
 Install ggplot2: install.packages("ggplot2")
 Load library: library(ggplot2)
2. Area Plots:
 Use geom_area().
3. Histograms:
 Use geom_histogram().
4. Bar Charts:
 Use geom_bar().
5. Pie Charts:
  Use geom_bar() with coord_polar().
6. Box Plots:
 Use geom_boxplot().
7. Scatter Plots:
 Use geom_point().
Python (Matplotlib and Seaborn)

1. Setup:
 Install libraries: pip install matplotlib seaborn
 Import libraries: import matplotlib.pyplot as plt, import seaborn as sns
2. Area Plots:
 Create data and use plt.fill_between() for Matplotlib.
 Use sns.lineplot() with fill=True for Seaborn.
3. Histograms:
 Use plt.hist() for Matplotlib.
 Use sns.histplot() for Seaborn.
4. Bar Charts:
 Use plt.bar() for Matplotlib.
 Use sns.barplot() for Seaborn.
5. Pie Charts:
 Use plt.pie() for Matplotlib.
6. Box Plots:
 Use plt.boxplot() for Matplotlib.
 Use sns.boxplot() for Seaborn.
7. Scatter Plots:
 Use plt.scatter() for Matplotlib.
 Use sns.scatterplot() for Seaborn.

Conclusion: Creating various plots using Python (Matplotlib and Seaborn) and R (ggplot2)
enhances your ability to visualize data effectively. Each plot type offers unique insights,
making data analysis and communication clearer and more impactful.

Note: Prints of mentioned graph implemented in matplotlib, seaborn and R language

are required
 Experiment No. 3

AIM: Creating Dashboards with Plotly and Dash

1.1 Introduction to Plotly

1.2 Introduction to Dash
1.3 Make Dashboards Interactive

Objective: To learn how to create interactive dashboards using Plotly and Dash, enabling
effective data visualization and real-time data interaction.

Prerequisites

 Basic knowledge of Python programming.

 Familiarity with data visualization concepts.
 Installation of Plotly and Dash libraries (pip install plotly dash).

Theory

Plotly is a graphing library that makes interactive, publication-quality graphs online. It

supports a wide range of chart types and is highly customizable.

Dash is a Python framework for building analytical web applications. It is built on top of
Plotly and Flask, allowing for the creation of interactive, web-based dashboards.

Steps:

1. Initialize Environment:

 Install necessary libraries: Plotly and Dash.

 Import required modules.

2. Setup Plotly:

 Define data for the plot.

 Create a layout for the plot.

 Combine data and layout into a Plotly figure.

 Render the plot to verify its correctness.

 3. Initialize Dash App:

 Create a Dash application instance.

 Define the layout of the app using HTML and core components.

4. Create Basic Plot in Dash:

 Embed the Plotly figure into the Dash layout using a graph component.

 Set up the server to run the Dash app.

5. Add Interactivity:

 Define input components (e.g., input fields, dropdowns, sliders) in the layout.

 Create callback functions to link input components to output components.

 Ensure the callback functions update the output based on user interactions.

6. Update Layout with Interactive Elements:

 Modify the layout to include interactive elements.

 Link these elements to the callback functions.

7. Run and Test the App:

 Run the Dash app.

 Test the interactivity by changing input values and observing the updates in
the output components.

 Debug any issues to ensure smooth functionality.

Conclusion: Plotly and Dash enable interactive, web-based dashboards with real-time user
interactions, enhancing data-driven analysis.

Note: Print of Implemented dashboard in Plotly and Dash is required.

 Experiment No. 4

AIM: Data Visualization and Dashboards with Excel

Objective: To learn how to create basic and advanced visualizations using Excel and to build
and share interactive dashboards, enhancing the ability to tell a data-driven story effectively.

Prerequisites

 Basic knowledge of Excel.

 Understanding of data types and structures.
 Familiarity with basic statistical concepts.

Theory

Data visualization in Excel involves using charts and graphs to represent data visually. This
helps in understanding trends, patterns, and insights from the data.

Basic Visualizations: Line graphs, bar graphs, and pie charts are fundamental tools for
representing data.

Advanced Visualizations: Treemaps, sparklines, histograms, scatter plots, and filled map
charts provide deeper insights and more complex data representations.

Interactive Dashboards: Combining multiple visualizations into a single, interactive

interface allows for dynamic data exploration and presentation.

Steps to Perform the Experiment:

1. Open Excel and Enter Data:

o Input sample data into an Excel spreadsheet.

2. Create Basic Charts:

o Select data and navigate to Insert → Charts to create Line, Bar, and Pie
Charts.

3. Construct Advanced Charts:

o Use Insert → Treemap, Histogram, Scatter Plot, and Map Chart for
complex visualizations.
 4. Enhance Charts for Better Visualization:

o Customize colors, labels, and legends to improve clarity.

5. Build an Interactive Dashboard:

o Use PivotTables and Slicers to filter and analyze data dynamically.

o Combine multiple charts into a single dashboard sheet.

6. Share the Dashboard:

o Save and share via Excel Online, PDF, or Power BI integration.

Conclusion: Excel provides a versatile platform for creating both basic and advanced
visualizations. Interactive dashboards enhance data-driven storytelling, making analysis more
effective and accessible.

Note: Print of Dashboard including charts like line chart, Bar chart, Pie chart, scatter
plots, Pivot tables with slicer is required.
 Experiment No. 5

AIM: Fundamentals of Visualization with Tableau

1. Install Tableau Public Software and create a visualization

2. Examine and navigate the Tableau Public workspace
3. Practice and connect to different data sources

Objective: To understand the fundamentals of data visualization using Tableau Public,

including installation, workspace navigation, and connecting to various data sources.

Prerequisites:

 Basic understanding of data visualization concepts.

 Familiarity with structured data (CSV, Excel, databases).

Theory

Tableau Public is a free software that allows users to create and share interactive data
visualizations online. It is widely used for its user-friendly interface and powerful
visualization capabilities. The software supports various data sources and provides tools to
create a wide range of visualizations, from simple charts to complex dashboards.

Steps:

Install Tableau Public Software and Create a Visualization

1. Download and Install: Go to the Tableau Public website and download the software.
Follow the installation instructions.
2. Open Tableau Public: Launch the software after installation.
3. Connect to Data: Click on "Connect" and choose a data source (e.g., Excel, CSV).
4. Load Data: Select the file and load the data into Tableau.
5. Create Visualization: Drag and drop fields onto the Rows and Columns shelves to
create a basic visualization (e.g., bar chart, line chart).
Examine and Navigate the Tableau Public Workspace

1. Explore the Interface: Familiarize yourself with the Tableau workspace, including
the Data pane, Sheets, and Dashboard tabs.
2. Data Pane: Understand how to use the Data pane to manage data sources and fields.
 3. Shelves and Cards: Learn how to use the Rows, Columns, Filters, and Marks shelves
to build visualizations.
4. Toolbar: Explore the toolbar options for saving, undoing, and other functions.

Practice and Connect to Different Data Sources

1. Connect to Different Sources: Practice connecting to various data sources like Excel,
CSV, and databases.
2. Load and Explore Data: Load data from different sources and explore the data
structure.
3. Create Visualizations: Create different types of visualizations using data from
various sources.
4. Save and Share: Save your visualizations and publish them to Tableau Public.

Conclusion: Tableau Public enables interactive visualizations and easy analysis of complex
datasets from various sources.

Note: Print is not required.

 Experiment No. 6

AIM: Visual Analytics with Tableau

1. Create a chart using Tableau

2. Create dates using calculated fields
3. Customize table calculations
4. Customize and create dual layer maps

Objective: To explore advanced visual analytics techniques using Tableau, including creating
charts, using calculated fields for dates, customizing table calculations, and creating dual-
layer maps.

Prerequisites

 Basic understanding of Tableau and its interface.

 Familiarity with data visualization concepts.
 Basic knowledge of data manipulation and calculations.

Theory

Visual Analytics with Tableau involves using advanced features to gain deeper insights from
data. This includes creating various types of charts, using calculated fields to manipulate data,
customizing table calculations for more precise analysis, and creating dual-layer maps for
geographical data visualization.

Create a Chart Using Tableau

1 Open Tableau: Launch Tableau and connect to your data source.

2 Select Data: Choose the relevant data fields for your chart.
3 Drag and Drop: Drag fields to the Rows and Columns shelves to create the desired chart
(e.g., bar chart, line chart).
4 Customize: Use the Marks card to customize the appearance of your chart (e.g., colors,
labels).
Create Dates Using Calculated Fields

1. Open a Worksheet: Start with a new worksheet in Tableau.

2. Create Calculated Field: Go to the Data pane, right-click, and select "Create Calculated
Field."
3. Enter Calculation: Use date functions (e.g., DATEADD, DATEDIFF) to create new
date fields.
4. Apply and Use: Apply the calculated field and use it in your visualizations.

Customize Table Calculations

1. Select a Measure: Choose a measure that you want to apply a table calculation to.
2. Add to View: Drag the measure to the view.
3. Customize Calculation: Click on the measure, select "Quick Table Calculation," and
choose the desired calculation (e.g., running total, percent of total).
4. Edit Calculation: Customize the calculation by selecting "Edit Table Calculation" and
adjusting the settings.

Customize and Create Dual-Layer Maps

1. Connect to Geographical Data: Ensure your data source includes geographical fields
(e.g., latitude, longitude).
2. Create First Layer: Drag geographical fields to the Rows and Columns shelves to
create the first map layer.
3. Add Second Layer: Drag another geographical field to the Detail shelf to create the
second layer.
4. Customize Layers: Use the Marks card to customize each layer (e.g., different colors,
shapes).
5. Combine Layers: Ensure both layers are visible and properly aligned to create a dual-
layer map.

Conclusion: Completing this experiment will boost your Tableau skills, enabling you to
create charts, manipulate dates, customize calculations, and build dual-layer maps for
advanced data analysis and insightful visualizations.

Note: Print of Charts created in Tableau is required.

 Experiment No. 7

AIM: Creating Dashboards and Storytelling with Tableau

1. Combine the data and follow the best practices to present your story
2. Create calculated fields for KPIs to build a figure that will be used to measure progress in
the data
3. Assemble a dashboard

Objective: To learn how to create effective dashboards and tell compelling stories with data
using Tableau, including combining data, creating calculated fields for KPIs, and assembling
a dashboard.

Prerequisites

 Basic understanding of Tableau and its interface.

 Familiarity with data visualization concepts.
 Knowledge of key performance indicators (KPIs) and their importance in data analysis.

Theory

Creating Dashboards and Storytelling with Tableau involves combining various data sources,
following best practices for data presentation, and using calculated fields to create KPIs.
Dashboards are powerful tools for summarizing and visualizing data, allowing users to gain
insights and make informed decisions. Effective storytelling with data helps convey the
message clearly and persuasively.

Steps:

Combine the Data and Follow Best Practices to Present Your Story

1. Connect to Data Sources: Open Tableau and connect to the necessary data sources.
2. Combine Data: Use joins or blends to combine data from different sources.
3. Clean and Prepare Data: Ensure the data is clean and properly formatted for analysis.
4. Follow Best Practices: Use best practices for data visualization, such as choosing
appropriate chart types, maintaining consistency, and focusing on key insights.
Create Calculated Fields for KPIs to Build a Figure That Will Be Used to Measure
Progress in the Data

1. Open a Worksheet: Start with a new worksheet in Tableau.

2. Create Calculated Field: Go to the Data pane, right-click, and select "Create Calculated
Field."
3. Define KPI: Enter the calculation for the KPI (e.g., sales growth, profit margin).
4. Apply and Use: Apply the calculated field and use it in your visualizations to measure
progress.

Assemble a Dashboard

1. Create New Dashboard: Click on the "New Dashboard" icon in Tableau.

2. Add Worksheets: Drag and drop the relevant worksheets onto the dashboard.
3. Arrange and Customize: Arrange the visualizations to create a cohesive and
informative dashboard. Customize the layout, add titles, and include filters for
interactivity.
4. Add Annotations and Story Elements: Use text boxes, images, and annotations to add
context and tell a compelling story with your data.

Conclusion: By completing this experiment, you will learn how to combine data, create KPIs,
and assemble effective dashboards in Tableau. These skills will enable you to present data in
a clear and impactful way, enhancing your ability to communicate insights and support
decision-making.

Note: Print of dashboard created in Tableau is required.

 Experiment No. 8

AIM: Introduction to Power BI

Objective: To introduce the basics of Power BI, including its interface, data import, and basic
visualization creation.

Prerequisites

 Basic understanding of data visualization concepts.

 Familiarity with data sources such as Excel, CSV, and databases.
 A computer with internet access and Power BI Desktop installed.

Theory

Power BI is a business analytics tool by Microsoft that allows users to visualize data and
share insights across their organization. It provides interactive visualizations and business
intelligence capabilities with an interface simple enough for end users to create their own
reports and dashboards. Power BI connects to a wide range of data sources and offers robust
tools for data transformation and visualization.

Steps

1. Install Power BI Desktop

 Download and Install: Go to the Power BI website and download Power BI Desktop.
Follow the installation instructions.
 Open Power BI Desktop: Launch the software after installation.

2. Import Data

 Connect to Data Source: Click on "Get Data" and choose a data source (e.g., Excel,
CSV).
 Load Data: Select the file and load the data into Power BI.
3. Explore the Interface

 Familiarize with the Interface: Explore the Power BI Desktop interface, including the
Report view, Data view, and Model view.
 Data Pane: Understand how to use the Data pane to manage data sources and fields.

4. Create Basic Visualizations

 Select Data Fields: Choose the relevant data fields for your visualization.
 Create Visualization: Drag and drop fields onto the canvas to create a basic visualization
(e.g., bar chart, line chart).
 Customize Visualization: Use the Visualizations pane to customize the appearance of
your chart (e.g., colors, labels).

Conclusion: Completing this experiment will give you a basic understanding of Power BI,
including data import, interface navigation, and creating visualizations, enabling effective
data analysis.

Note: Print is not required.

 Experiment No. 9

AIM: Data Visualization with Power BI

Objective: To learn how to create effective data visualizations using Power BI, including
importing data, creating visualizations, and building interactive reports.

Prerequisites

 Basic understanding of data visualization concepts.

 Familiarity with data sources such as Excel, CSV, and databases.
 A computer with internet access and Power BI Desktop installed.

Theory

Power BI is a powerful business analytics tool by Microsoft that enables users to visualize
data and share insights across their organization. It offers interactive visualizations and
business intelligence capabilities with an easy-to-use interface. Power BI connects to a wide
range of data sources and provides robust tools for data transformation and visualization.

Steps

1. Install Power BI Desktop

 Download and Install: Go to the Power BI website and download Power BI Desktop.
Follow the installation instructions.

Open Power BI Desktop: Launch the software after installation.

2. Import Data

 Connect to Data Source: Click on "Get Data" and choose a data source (e.g., Excel,
CSV).
 Load Data: Select the file and load the data into Power BI.
3. Explore the Interface

 Familiarize with the Interface: Explore the Power BI Desktop interface, including the
Report view, Data view, and Model view.
 Data Pane: Understand how to use the Data pane to manage data sources and fields.

4. Create Visualizations

 Select Data Fields: Choose the relevant data fields for your visualization.
 Create Visualization: Drag and drop fields onto the canvas to create visualizations (e.g.,
bar chart, line chart, pie chart).
 Customize Visualization: Use the Visualizations pane to customize the appearance of
your charts (e.g., colors, labels).

5. Build Interactive Reports

 Create Report Pages: Add multiple pages to your report to organize different
visualizations.
 Add Interactivity: Use slicers, filters, and drill-through features to make your report
interactive.
 Publish and Share: Save your report and publish it to the Power BI service to share with
others.

Conclusion: Completing this experiment will teach you to create visualizations and
interactive reports in Power BI, enhancing your data analysis and presentation skills.

Note: Print of Complete dashboard implemented in Power BI is required.