Maharaja Education Trust® Mysore

MAHARAJA INSTITUTE OF
TECHNOLOGY THANDAVAPURA
NH 766, Nanjangud Taluk, Mysuru – 571302

DEPARTMENT OF ARTIFICIAL
INTELLIGENCE AND DATA SCIENCE

DATA VISUALIZATION LAB

BAIL504
(2022 Scheme)

As per VTU Revised Syllabus for V Semester Ai&Ds

Course In charge: Prof. GAGANA M S

 DATAVISUALIZATION MANUAL
Program 01:

Getting Started-Tableau Workspace, Tableau terminologies, basic functionalities.

1. Introduction to Tableau

 Purpose: Explain that Tableau is a powerful data visualization tool used for transforming raw data into
interactive, insightful visualizations, helping users understand and analyze data patterns and insights.
 Applications: Used in various industries like finance, healthcare, and marketing for data-driven
decision-making.

2. Setting Up the Tableau Workspace

 Connecting Data:
o Step 1: Open Tableau and choose a data source (e.g., Excel, CSV, database).
o Step 2: Connect to your dataset, which will appear in the Data Pane.

3. Tableau Terminologies

 Dimensions and Measures:

o Dimensions: Categorical data (e.g., names, dates).
o Measures: Numerical data, used for calculations (e.g., sales, profits).
 Marks Card: Controls the appearance of data points (color, size, label).
 Rows and Columns Shelves: Define the x and y axes of your visualization by dragging fields to these
areas.
 Filters: Used to refine data shown in the visualization.
 Pages Shelf: Helps create animations over time or other sequential dimensions.
 Sheets, Dashboards, and Stories:
o Sheets: Individual charts or graphs.
o Dashboards: Combine multiple sheets for an overview.
o Stories: Sequence of dashboards or sheets to tell a data story.

4. Basic Functionalities in Tableau

 Creating a Basic Chart:

o Step 1: Drag a dimension (like ‘Category’) to the Columns shelf.
o Step 2: Drag a measure (like ‘Sales’) to the Rows shelf to create a chart.
 Using Marks Card for Customization:
 o Add color, size, and label to enhance visualization.
o Drag ‘Region’ to Color on Marks Card to see the sales distribution by region.
 Filters:
o Drag any field to the Filters pane, select criteria, and apply.
o For example, filter by ‘Year’ to show data only for the selected period.
 Sorting and Organizing Data:
o Use the sort function to arrange data in ascending or descending order.

5. Creating Dashboards and Stories

 Dashboards:
o Step 1: Select ‘Dashboard’ from the navigation menu.
o Step 2: Drag sheets onto the workspace to combine multiple visualizations.
o Step 3: Use layout adjustments to make the dashboard clear and readable.

6. Saving and Publishing Work

 Save Locally or Publish Online:

o Tableau workbooks can be saved locally or published to Tableau Public/Server.
 Export Options:
o Export visualizations as images, PDFs, or embed them in web pages.

Program 02:

Connecting to Data Source - Connecting to Database, Different types of Tableau joins.

Connecting to Data Source in Tableau

 Introduction to Data Connection:

o Tableau supports various data sources, including files (Excel, CSV) and databases (MySQL,
SQL Server, Oracle, etc.), as well as cloud services (Google Sheets, Salesforce, etc.).
 Connecting to a Database:
o Step 1: Open Tableau and click on “Connect” in the Data Pane. Select “To a Server” for
connecting to databases.
o Step 2: Choose the type of database you’re connecting to (e.g., MySQL, PostgreSQL).
o Step 3: Enter database credentials (hostname, port, username, password) to establish the
connection.
o Step 4: After connecting, select the specific database and tables you need.

2. Types of Joins in Tableau

Joins combine data from multiple tables within a database to enrich analysis. Tableau supports four main types
of joins: inner, left, right, and full outer joins.

 Inner Join:
o Returns only rows that have matching values in both tables.
o Example: If you have a “Sales” table and a “Customer” table, an inner join will display only the
customers who have made purchases.
 Left Join:
o Returns all rows from the left table and matched rows from the right table. Unmatched rows
from the right table will show as null.
o Example: Joining “Customers” with “Sales” using a left join will show all customers, including
those who haven’t made purchases (those rows will display nulls for “Sales” data).
 Right Join:
o Returns all rows from the right table and matched rows from the left table. Unmatched rows
from the left table will show as null.
o Example: Joining “Sales” with “Products” using a right join will show all products, even those
without sales (those rows will display nulls for “Sales” data).
 Full Outer Join:
o Returns all rows when there’s a match in either the left or right table. Rows without matches in
both tables will show nulls where data is missing.
o Example: Joining “Employees” and “Departments” using a full outer join shows all employees
and departments, even if some employees are not assigned to departments or some departments
have no employees.

3. Performing Joins in Tableau

 Step 1: After connecting to your data source, select the first table you want to work with in the Data
Pane.
 Step 2: Drag a second table to the workspace. Tableau will automatically prompt you to define the join
type.
 Step 3: Choose the appropriate join type and set the matching field(s) (called keys), which should be
common in both tables.
 Step 4: You can add more tables and joins if required, but keep in mind that each additional join can
impact performance.

4. Best Practices for Using Joins in Tableau

 Minimize Complex Joins: Complex joins can affect performance, so try to use only necessary fields
and consider using data extracts for efficiency.
 Use Filters Post-Join: Apply filters to narrow down the dataset after the join is created, keeping only
relevant data for faster processing.
 Review Join Results: Check for nulls and ensure data integrity after joining tables, especially with outer
joins.
Program 03:

Creating a View formatting charts, adding filters, creating calculated fields and defining
parameters.

1. Creating a View in Tableau

 Starting with a View:

o A "view" in Tableau is a specific chart or visualization created on a sheet.
 Steps to Create a View:
o Step 1: Connect to your data source.
o Step 2: Drag a dimension (e.g., Category) to the Columns shelf and a measure (e.g., Sales) to the
Rows shelf to create a basic chart, like a bar chart.
o Step 3: Customize further by adding more fields to define the view in a meaningful way.

2. Formatting Charts

 Basic Formatting Options:

o Titles and Labels: Double-click on titles or labels to edit and format text (font, color, size).
o Axis Customization: Right-click on an axis to edit labels, tick marks, and scales.
 Colors and Borders:
o Use the Marks Card to add colors based on specific fields (e.g., Region) to enhance chart
readability.
o Adjust borders and shading by selecting Format > Borders or Format > Shading.
 Tooltips:
o Customize tooltips (pop-up text) by clicking on Tooltip in the Marks Card. Add or modify text,
data fields, and formatting to provide useful details.

3. Adding Filters

 Purpose of Filters:
o Filters limit the data displayed in a view to focus on specific aspects, making visualizations more
relevant.
 Steps to Add Filters:
o Step 1: Drag a field (e.g., Year or Category) to the Filters shelf.
o Step 2: Choose filter options. For example, select individual years or categories to filter.
o Step 3: Right-click the filter on the Filters shelf and choose “Show Filter” to add a dynamic filter
control to the view, allowing users to interactively change filter settings.

4. Creating Calculated Fields

 Purpose of Calculated Fields:

 o Calculated fields perform custom calculations on your data, which can be used as dimensions or
measures in the view.
 Steps to Create a Calculated Field:
o Step 1: Click on “Analysis” in the top menu and choose “Create Calculated Field.”
o Step 2: Enter a field name and a formula. Formulas can involve arithmetic operations, string
manipulations, conditional logic, etc.
o Example: To calculate profit ratio, create a calculated field with the formula SUM([Profit]) /
SUM([Sales]) * 100.
o Step 3: Drag the calculated field to the view or apply it to another calculated field or filter.

5. Defining Parameters

 Purpose of Parameters:
o Parameters are dynamic values that can be used as filters, for calculated fields, or to allow users
to customize the view.
 Steps to Define a Parameter:
o Step 1: In the Data Pane, click the drop-down menu next to Parameters and select “Create
Parameter.”
o Step 2: Name the parameter, select its data type (e.g., integer, string), and define allowable
values.
o Step 3: Use the parameter in calculations or filters. For example, you might use a parameter to
select a specific category or change a threshold.
o Step 4: Right-click the parameter and select “Show Parameter” to add a control to the view,
allowing users to adjust the parameter value interactively.

Program 04

Dashboard Design and Storytelling Components of Dashboard, Understanding how to

place

Dashboard Design Essentials

 Components of a Dashboard:
o Sheets: These are individual visualizations (charts, graphs, or maps) created on separate sheets
and combined within a dashboard.
o Filters: Allow viewers to adjust the dashboard data dynamically.
o Parameters: Add interactivity, letting users change values or control specific fields.
o Text and Titles: Provides context, explanations, or calls to action.
o Images and Web Objects: Logos, explanatory visuals, or external links can enhance
engagement.
o Tooltips: Offer additional details when hovering over a specific data point.

2. Setting Up Your Dashboard in Tableau

  Step 1: Start a New Dashboard
o In Tableau, select “New Dashboard” from the toolbar. A blank dashboard canvas will open,
ready for components.
 Step 2: Configure Dashboard Size
o Choose a fixed or automatic size to fit the target screen (like a desktop, tablet, or mobile).
o For best results, select a custom size if you have specific screen dimensions in mind.
 Step 3: Drag Sheets onto the Canvas
o From the Sheets list, drag individual visualizations to the dashboard. Arrange them to create a
flow that matches the narrative or analytical purpose of the dashboard.
o Adjust each visualization’s size, ensuring enough space to avoid crowding and maintain
readability.

3. Understanding Layout and Placement

 Hierarchy and Flow:

o Place the most important data at the top or center where it’s easily visible.
o For example, key metrics or KPIs (Key Performance Indicators) should be prominent, with
supporting charts or filters positioned nearby.
 Grouping Related Visuals:
o Place similar visuals together to allow for easy comparison. For instance, if your dashboard
includes regional sales and profits, positioning these charts side by side aids comparison.
 Using Containers:
o Containers help you organize and align multiple sheets and objects (horizontal or vertical).
o Group filters and legends in a container on the left or right side for a cleaner layout, making it
easy for users to find interactive elements.
 Whitespace:
o Use whitespace strategically to avoid clutter. It enhances readability and helps emphasize
important data.
 Legends and Filters:
o Place legends and filters where they’re easily accessible. Position filters near the top or side of
the dashboard for straightforward user interaction.

4. Storytelling with Dashboards

 Defining the Narrative:

o Decide on a clear story or goal for the dashboard, such as “highlighting quarterly growth” or
“analyzing customer demographics.”
o Arrange visuals to guide the viewer through a logical flow that supports this narrative.
 Using Stories in Tableau:
o Stories are a sequence of dashboards or sheets designed to convey a complete narrative.
o Step 1: Create a new Story in Tableau. Each Story point is a new view (like a slide in a
presentation).
 o Step 2: Add dashboards and sheets in sequence, each Story point representing a step in the
narrative.
o Step 3: Add descriptions or titles to each Story point to highlight key insights and transition
smoothly between points.

5. Adding Interactive Elements for Enhanced Engagement

 Filters and Parameters:

o Show filters in the dashboard for user-driven exploration. For example, if analyzing sales by
region, include a region filter to allow users to view specific areas.
 Actions (Filter, Highlight, URL):
o Use Filter Actions to let users click on one view and filter another.
o Highlight Actions emphasize related data points across visualizations.
o URL Actions direct users to external resources or reports for additional information.

6. Finalizing and Testing the Dashboard

 Preview and Test for Usability:

o Preview your dashboard and test for interactivity, responsiveness, and user-friendly navigation.
o Confirm that actions, filters, and parameters work as intended.
 Share and Publish:
o Save the dashboard locally or publish it to Tableau Server/Tableau Public as needed. Ensure that
permissions are set correctly for your intended audience.

Program05
Introducing Power BI -Components and the flow of work. Power BI Desktop Interface-
The Report has five main areas.

Introduction to Power BI

o Power BI is a powerful business analytics tool by Microsoft that allows users to visualize data,
gain insights, and make data-driven decisions. It enables users to connect to various data sources,
transform data, create interactive reports, and share them across the organization.
 Components of Power BI:
o Power BI Desktop: The main application used to connect, transform, and visualize data. Reports
and dashboards are created here.
o Power BI Service (Cloud): An online platform for sharing, collaborating, and publishing reports
created in Power BI Desktop.
o Power BI Mobile: Mobile applications for viewing and interacting with Power BI reports and
dashboards on Android, iOS, and Windows devices.
 o Power BI Report Builder: A tool for creating paginated reports that are ideal for printing and
detailed reporting.
o Power BI Gateway: A bridge between on-premises data sources and the Power BI service,
enabling real-time or scheduled data refreshes for reports.

Power BI Workflow (Flow of Work)

1. Connect to Data:
o Use Power BI Desktop to connect to various data sources (e.g., Excel, databases, cloud services).
2. Data Transformation (Data Preparation):
o Use the Power Query Editor within Power BI Desktop to clean, transform, and shape the data.
This step includes actions like removing duplicates, filtering data, creating calculated columns,
and adjusting formats.
3. Data Modeling:
o Define relationships between different tables and create calculated measures and columns as
needed. Data modeling allows for logical structuring and prepares data for analysis.
4. Visualization:
o Build visualizations on report pages using various chart types (bar, line, pie charts, maps, etc.),
and combine them into a cohesive report.
5. Publishing:
o Once the report is ready, publish it from Power BI Desktop to the Power BI Service, where it can
be shared with others or embedded in applications.
6. Sharing and Collaboration:
o Users can share reports and dashboards with others through the Power BI Service, enabling
collaboration, feedback, and interaction.

Power BI Desktop Interface – Main Report Areas

In Power BI Desktop, the Report view is the primary workspace where visualizations are created. This area
consists of five main sections:

1. Canvas:
o This is the central workspace where you build and arrange visualizations for each report page.
The canvas allows you to add multiple visualizations, organize them, and create interactive, data-
driven reports.
2. Visualizations Pane:
o This pane contains different chart types and visualization options, such as bar charts, line charts,
maps, and tables.
o Use this area to select and customize visualizations, add filters, and adjust properties like axis
labels, colors, and interactions.
3. Fields Pane:
o Displays all the data fields and tables connected to the report. You can drag fields from this pane
to the canvas to create visualizations, use them in filters, or add them to visual elements on the
canvas.
 o The Fields Pane is also where you’ll find calculated columns and measures created during data
modeling.
4. Filters Pane:
o Allows you to add and manage filters for the entire report, individual pages, or specific
visualizations.
o Filters can be applied globally (across all pages) or specifically to control what data is displayed
in a particular visualization, enabling users to refine data views dynamically.
5. Pages Tab (Report Pages):
o Located at the bottom, this section lets you create multiple report pages within a single Power BI
report. Each page can have its own layout and visualizations, providing flexibility to structure
reports by topic or analysis focus.

Program06
Querying Data from CSV-Query Editor, Connecting the data from the Excel Source,
Clean, Transform the data

1. Connecting to a CSV or Excel Data Source

 Step 1: Open Power BI Desktop.

 Step 2: Click on Home > Get Data. Choose either Text/CSV (for CSV files) or Excel (for Excel files)
from the list of sources.
 Step 3: Select the file you want to import, then click Open.
 Step 4: Power BI will load a preview of the data. For a CSV, verify the delimiter and click Load if
ready, or Transform Data to open it in the Query Editor.

2. Query Editor (Power Query Editor)

 The Query Editor allows you to apply various data cleaning and transformation operations before
loading it into Power BI. Here, you can shape data as needed.

3. Cleaning and Transforming the Data

Once in the Query Editor, you can use various tools to prepare your data:

 Remove Unnecessary Columns:

o Click on columns you don’t need and select Remove Columns from the Home tab.
 Filter Rows:
o Use filters on each column to exclude unwanted data, such as removing blank or irrelevant rows.
 Remove Duplicates:
o Select a column and use Remove Duplicates to keep only unique records in that column.
 Rename Columns:
o Rename columns by double-clicking on the header and typing a new name. This helps make
column names more descriptive and clear.
  Data Type Transformation:
o Adjust data types (e.g., text, number, date) for each column to ensure accuracy. Click on the
column header, select Data Type, and choose the correct type.

4. Applying Transformations

 Replace Values:
o Right-click on a column and select Replace Values to replace specific data entries.
 Split Columns:
o If a column has multiple values separated by a delimiter, you can split it by Delimiter (e.g.,
comma, space) or by a specific character count.
 Combine Queries:
o Use Merge Queries or Append Queries to combine data from multiple sources (like additional
CSV files or tables) into a single dataset.
 Add Calculated Columns:
o You can create custom columns based on calculations or expressions by selecting Add Column
> Custom Column.

5. Closing and Applying Changes

 Step 1: Once you’ve made all necessary transformations, click on Close & Apply. Power BI will load
the transformed data into the Data Model.
 Step 2: You can now use this clean, transformed dataset to create visuals, build reports, and perform
further analysis in Power BI Desktop.

Program07
Creating Reports & Visualizations Different types of charts, Formatting charts with Title,
Colors.

1. Selecting Chart Types

Power BI offers various chart types to help display data effectively. Here are some commonly used ones:

 Bar/Column Chart:
o Useful for comparing categories or showing changes over time when categories are organized
along the x-axis.
 Line Chart:
o Ideal for showing trends or patterns over time (e.g., monthly sales trends).
 Pie/Donut Chart:
o Displays proportions of a whole, great for visualizing percentage contributions.
 Map Visualizations:
o Shows data distribution geographically, excellent for location-based data like sales by country or
state.
  Scatter Plot:
o Useful for showing relationships or correlations between two numerical values.
 Tree Map:
o Represents hierarchical data, where each category is displayed as a rectangle proportionate to its
value.
 Table/Matrix:
o A table presents data in rows and columns, while a matrix adds more layers to display data
hierarchically, similar to pivot tables.

2. Creating a Chart

 Step 1: Drag the desired fields from the Fields pane onto the report canvas.
 Step 2: Power BI will auto-generate a visualization based on the data type. You can change the
visualization type by selecting it from the Visualizations pane.
 Step 3: Once the chart appears on the canvas, you can further refine it by dragging additional fields to
areas like Axis, Legend, Values, etc., in the Visualizations pane.

3. Formatting Charts

To make charts more readable and visually appealing, Power BI offers various formatting options:

 Chart Title:
o Go to the Format pane and enable the Title option.
o Customize the title text, font, color, and alignment to match the report style.
 Axis Labels:
o Enable Axis Titles in the Format pane to label the x-axis and y-axis clearly.
o Adjust font size, color, and title names to improve readability.
 Data Colors:
o Use the Data Colors section to change the color of bars, lines, or other chart elements.
o Customize based on the data categories or use brand colors to maintain consistency.
 Legends:
o Enable and position the legend to help viewers understand the chart’s colors or categories.
 Data Labels:
o Enable Data Labels to show specific values on each chart element. Customize label size, font,
and position for better readability.

4. Adding Advanced Formatting Options

Power BI offers additional options to enhance the presentation of charts:

 Conditional Formatting:
o For certain visualizations (like tables and bar charts), you can apply conditional formatting to
color-code values based on rules or scales (e.g., green for high values, red for low).
 Background and Borders:
 o Set a background color for the chart or add borders to improve contrast with the report’s overall
layout.
 Tooltips:
o Customize tooltips to display more information when hovering over chart elements, adding
valuable context without cluttering the chart.

5. Finalizing the Report

After adding and formatting charts, you can arrange them on the canvas to create a cohesive report layout:

 Organize charts based on logical flow, ensuring that key insights are front and center.
 Add slicers, filters, or additional elements like shapes or text boxes to guide the viewer through the
report.

Program08
Dashboards-Filters in Power BI, Formatting dashboards.

1. Adding Filters to Power BI Dashboards

Filters in Power BI allow users to narrow down the data displayed on the dashboard based on specific criteria.
Filters can be applied at different levels:

 Visual-Level Filters:
o Apply filters directly to specific visualizations. This means that only the filtered data will display
on that particular chart or table.
o To add a visual-level filter, select the visualization, go to the Filters pane, and drag a field into
the Filters on this visual area.
 Page-Level Filters:
o Apply filters to an entire report page so that all visuals on that page respond to the filter criteria.
o Use the Filters pane and place the desired field in the Filters on this page section.
 Report-Level Filters:
o Set filters across all pages in a report, affecting every visual on every page.
o In the Filters pane, drag the field into the Filters on all pages section to apply it globally.
 Slicers:
o Slicers are visual filters that provide an interactive way for users to filter data by selecting
options directly on the dashboard.
o You can add a slicer by selecting it from the Visualizations pane and choosing the field you want
to filter by (e.g., Date, Region, Product Category).
 Drillthrough Filters:
o These filters allow users to right-click a data point and drill through to another page with more
details. This can be especially useful for displaying detailed information on a separate page
based on the selected data.

2. Formatting Dashboards in Power BI

  Layout and Alignment:
o Arrange visuals consistently by aligning them to ensure a clean layout. Use the gridlines and
snapping tools in Power BI to align elements precisely.
o Balance space between visuals to avoid clutter and allow the dashboard to breathe, making it
easier to read.
 Colors and Themes:
o Apply a color theme to keep your dashboard consistent with your organization’s branding. In
Power BI, go to View > Themes to choose a built-in theme or customize colors.
o Use a limited color palette for charts and visualizations, and maintain consistent colors for the
same categories across multiple visuals.
 Text and Titles:
o Use clear and descriptive titles for each chart or table. Titles help viewers quickly understand
what each visual represents.
o Customize font size, style, and color for readability, especially for titles, axis labels, and data
labels.
 Backgrounds and Borders:
o Add borders to individual visuals to separate them visually, or use background shading for
sections of the dashboard to group related visuals.
o Avoid heavy borders and use subtle shading to maintain a clean look.
 Tooltips and Interactivity:
o Customize tooltips to show additional context when hovering over data points. Tooltips allow for
more information without overcrowding the dashboard.
o Add bookmarks or buttons for navigation if your dashboard includes multiple views, providing a
more dynamic and interactive experience.
 KPIs and Cards:
o Highlight key metrics using KPI visuals or cards to bring important numbers (e.g., total sales,
average revenue) into focus at the top of the dashboard.

3. Finalizing and Testing the Dashboard

 Review the dashboard to ensure it’s easy to interpret and visually appealing.
 Test all filters, slicers, and drillthroughs to verify they’re functioning correctly and providing the desired
interactivity.
 Share the dashboard and solicit feedback, as well-placed filters and formatting can significantly enhance
the dashboard’s usability and impact

Program 09

Analysis of revenue in sales dataset:

 1) Create a choropleth map (fill the map) to spot the special trends to show the state
which has the highest revenue.

ii) Create a line chart to show the revenue based on the month of the year.

iii) Create a bin of size 10 for the age measure to create a new dimension to show the
revenue.

iv) Create a donut chart view to show the percentage of revenue per region by creating
zero access in the calculated field.

v) Create a butterfly chart by reversing the bar chart to compare fernale & male
revenue based on product category

vi) Create a calculated field to show the average revenue per state & display profitable
& non-profitable state.

vii) Build a dashboard

1) Choropleth Map: Show State with Highest Revenue.

 Steps:
o Data: Use the State and Revenue fields.
o Build:
 Map State to the geographic field.
 Set Revenue as the measure and use it in the Color field to fill the states by revenue.
o Labels: Display revenue figures for each state.

2) Line Chart: Revenue by Month of the Year.

 Steps:
o X-Axis: Month (using the date field, aggregated by month).
o Y-Axis: Revenue.
o Build: Select Line Chart type and plot Revenue over Month.

3) Binned Revenue Analysis by Age (Bin Size: 10)

Steps:

o Data: Use Age and Revenue.

o Build:
 Create bins for Age in increments of 10 (e.g., 20-30, 30-40).
  Drag Age bin and Revenue to the view to visualize revenue by age groups.

4) Donut Chart: Percentage of Revenue per Region

 Steps:
o Data: Use Region and Revenue.
o Build:
 Create a pie chart using Region and SUM(Revenue).
 Adjust it into a donut by adding an empty center.
 Calculate zero-axis values to position the labels.

5) Butterfly Chart: Compare Female & Male Revenue by Product Category

 Steps:
o Data: Use Gender, Product Category, and Revenue.
o Build:
 Create a bar chart with Product Category on the Y-axis and split bars for Revenue by Gender.
 Reverse one axis for a butterfly effect, showing Female on one side and Male on the other.

6) Calculated Field: Average Revenue per State & Profitability

 Steps:
o Calculated Field: Create a field to calculate Average Revenue per State.
o Logic: Add profitability logic (e.g., profitable if above a revenue threshold).
o Build: Display profitable and non-profitable states by color coding.

7) Build the Dashboard

 Steps:
o Arrange the choropleth map, line chart, and butterfly chart on the dashboard.
o Add interactive filters for states, age bins, and regions.
o Include profit/non-profit insights for easy reference.

Program 10

Analysis of GDP dataset

1) Visualize the countries data given in the dataset with respect to latitude and longitude
along with country name using symbol maps.

ii) Create a bar graph to compare GDP of Belgium between 2006-2026.

iii) Using pie chart, visualize the GDP of India, Nepal, Romania, South Asia, Singapore by
the year 2010.

iv) Visualize the countries Bhutan & Costa Rica competing in terms of GDP.

) Create a scatter plot or circle views of GDP of Mexico, Algeria, Fiji, Estonia from 2004
to 2006.

vi) Build an interactive dashboard

1) Symbol Maps: Visualize Country Data

Fields:

 Latitude: Latitude of each country.

 Longitude: Longitude of each country.
 Country Name: The name of the country (used as a label on the map).

2) Bar Graph: Compare GDP of Belgium (2006-2020)

Fields:

 Year: Filter to include years from 2006 to 2020 (this will be on the X-axis).
 GDP: The GDP value for Belgium for each year (this will be on the Y-axis).

3) Pie Chart: Visualize GDP for Selected Countries (2010)

Fields:

 Country Name: The names of the countries (India, Nepal, Romania, South Asia, Singapore).
 GDP: The GDP value for each of these countries specifically for the year 2010.

4) Compare GDP of Bhutan & Costa Rica

Fields:

 Year: Filter for the years in which you have GDP data for Bhutan and Costa Rica (this will be on the X-
axis).
 GDP: The GDP value for Bhutan and Costa Rica (this will be on the Y-axis).
 Country Name: Used for coloring and labeling the lines or bars (e.g., Bhutan in one color and Costa
Rica in another).

5) Scatter Plot: GDP of Mexico, Algeria, Fiji, Estonia (2004-2006)

Fields:
  Year: Years 2004, 2005, and 2006 (this will be on the X-axis).
 GDP: The GDP values for each of the specified countries (this will be on the Y-axis).
 Country Name: Used for differentiating data points by country (different colors or shapes for each
country).

6) Build an Interactive Dashboard

Fields:

 Include all the fields used in the previous visualizations to ensure interaction.
 Filters: Add interactive filters for:
o Year: Allow users to select specific years.
o Country Name: Allow users to filter based on selected countries.

Program 11

Analysis of HR Dataset:

1)Create KPI to show employee count, attrition count, attrition rate, attrition count,
active employees, and average age.

ii) Create a Lollipop Chart to show the attrition rate based on gender category.

iii) Create a pie chart to show the attrition percentage based on Department Category-
Drag department into colours and change automatic to pie. Entire view, Drag attrition
count to angle. Label attrition count, change to percent, add total also, edit label.

iv) Create a bar chart to display the number of employees by Age group, v) Create a
highlight table to show the Job Satisfaction Rating for each job role based on employee
count

vi) Create a horizontal bar chart to show the attrition count for each Education field
Education field wise attrition-drag education field to rows, sum attrition count to col,

vii) Create multiple donut chart to show the Attrition Rate by Gender for different Age
group

1) KPIs for Employee Analysis

KPIs to Create:
  Employee Count: Total number of employees.
 Attrition Count: Total number of employees who have left the company.
 Attrition Rate: (Attrition Count / Employee Count) * 100.
 Active Employees: Total number of employees currently active (Employee Count - Attrition Count).
 Average Age: Average age of employees.

Fields:

 Employee ID: To count unique employees.

 Attrition: A binary or categorical field indicating whether an employee has left (Yes/No).
 Age: For calculating average age.

2) Lollipop Chart: Attrition Rate by Gender

Fields:

 Gender: Category for each gender (X-axis).

 Attrition Rate: Calculate the attrition rate for each gender (Y-axis).

3) Pie Chart: Attrition Percentage by Department

Fields:

 Department: Drag to color to distinguish each department.

 Attrition Count: Drag to angle to determine the size of each slice.
 Label: Set to show attrition count as a percentage and total.

4) Bar Chart: Number of Employees by Age Group

Fields:

 Age Group: Create age bins (e.g., 20-29, 30-39) for grouping.
 Employee Count: Count of employees in each age group (Y-axis).

5) Highlight Table: Job Satisfaction Rating by Job Role

Fields:

 Job Role: Drag to rows to list each job role.

 Job Satisfaction Rating: Drag to columns or as the measure to show ratings.
 Employee Count: Use as a secondary measure to provide context.

6) Horizontal Bar Chart: Attrition Count by Education Field

Fields:
  Education Field: Drag to rows.
 Attrition Count: Sum of attrition count (Y-axis).

7) Multiple Donut Charts: Attrition Rate by Gender for Different Age Groups

Fields:

 Gender: Category for splitting the donut charts.

 Age Group: Different age groups for multiple charts (e.g., 20-29, 30-39).
 Attrition Rate: Calculate and represent the attrition rate for each combination of gender and age group.

Program 12

Analysis of Amazon Prime Dataset:

1) Create a Donut chart to show the percentage of movie and tv shows

ii) Create a area chart to shows by release year and type

iii) Create a horizontal bar chart to show Top 10 genre

iv) Create a map to display total shows by country

v) Create a text sheet to show the description of any movie/movies.

vi) Build an interactive Dashboard.

Dataset Fields

Before proceeding with the visualizations, ensure your dataset includes the following fields:

 Title: Name of the movie/show.

 Type: Movie or TV Show.
 Release Year: Year of release.
 Genre: Genre of the movie/show.
 Country: Country where the show/movie was produced.
 Description: Description of the movie/show.

Visualizations

1) Donut Chart: Percentage of Movies and TV Shows

Steps:
  Data Preparation:
o Create a calculated field to count the number of movies and TV shows.
 Build the Donut Chart:
o Outer Circle: Create a pie chart using the calculated field for counts of Movies and TV Shows.
o Inner Circle: Create a smaller pie chart with a blank value to form the donut shape.
 Fields:
o Category: Type (Movies, TV Shows).
o Value: Count of Titles.

2) Area Chart: Shows by Release Year and Type

Steps:

 Data Preparation:
o Use a date field or create a calculated field for release year.

 Build the Area Chart:

o Drag Release Year to the X-axis.
o Drag Count of Titles to the Y-axis.
o Use Type as a filter or color dimension to separate the areas for movies and TV shows.

 Fields:
o X-Axis: Release Year.
o Y-Axis: Count of Titles.
o Color/Filter: Type.

3) Horizontal Bar Chart: Top 10 Genres

Steps:

 Data Preparation:
o Count the number of titles for each genre.

 Build the Horizontal Bar Chart:

o Drag Genre to the Y-axis.
o Drag Count of Titles to the X-axis.
o Sort by Count of Titles to display the top 10.

 Fields:
o Y-Axis: Genre.
o X-Axis: Count of Titles.
4) Map: Total Shows by Country

Steps:

 Build the Map:

o Drag Country to the map.
o Drag Count of Titles to the size or color shelf to visualize the number of shows per country.

 Fields:
o Location: Country.
o Size/Color: Count of Titles.

5) Text Sheet: Movie/Show Description

Steps:

 Create a new text sheet.

 Use a filter or parameter to allow users to select a movie/show.
 Display the Title and Description fields.
 Fields:
o Title: Selected movie/show.
o Description: Description of the selected title.

6) Build an Interactive Dashboard

 Components:
o Donut Chart.
o Area Chart.
o Horizontal Bar Chart.
o Map.
o Text Sheet.