DATA VISUALIZATION

LABORATORY MANUAL
CHOICE BASED CREDIT SYSTEM
(BCSL504- V Semester B.E)
(2022 Scheme)

Prepared by: Approved by

Mr. Muthuramalingam B Dr. G C Bhanu Prakash
Assistant Professor Professor & HOD
Department of ISE Department of ISE

DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING

DEPARTMENT OF ARTIFICIAL INTELLIGENCE AND MACHINE LEARNING
SIR M. VISVESVARAYA INSTITUTE OF TECHNOLOGY
(Affiliated to VTU, Recognized by AICTE and
Accredited by NBA, NAAC)
Bengaluru - 562157
 Sir M. VISVESVARAYA INSTITUTE OF TECHNOLOGY
BENGALURU - 562 157
Institute Vision and Mission

VISION
 To be a center of excellence in technical and management education concurrently focusing on
disciplined and integrated development of personality through quality education, sports, cultural and co-
curricular activities.
 To promote transformation of students into better human beings, responsible citizens and competent
professionals to serve as a valuable resource for industry, work environment and society.

MISSION
1. To impart quality technical education, provide state-of-art facilities, achieve high quality in teaching-
learning & research and encourage extra & co-curricular activities.
2. To stimulate in students a spirit of inquiry and desire to gain knowledge and skills to meet the changing
needs that can enrich their lives.
3. To provide opportunity and resources for developing skills for employability and entrepreneurship,
nurturing leadership qualities, imbibing professional ethics and societal commitment.
4. To create an ambiance and nurture conducive environment for dedicated and quality staff to upgrade
their knowledge & skills and disseminate the same to students on a sustainable long term basis.
5. To facilitate effective interaction with the industries, alumni and research institutions.

DEPT. OF INFORMATION SCIENCE AND ENGINEERING

Vision Mission

 To train the students to have Professional career in IT industry and

 To empower students with knowledge and skills to develop Higher studies through Quality Education.
the competency in the emerging areas of Information
 To provide outstanding Teaching and Research environment by
Technology.
implementing innovative Teaching and Research Methodologies
for Quality Education and Research.
 DATA VISUALIZATION LAB Semester V
Course Code BAIL504 CIE Marks 50
Teaching Hours/Week (L:T:P: S) 0:0:2:0 SEE Marks 50
Credits 01 Exam Hours 100
Examination type (SEE) Practical
Course objectives:
● Understand the Importance of data Visualization for business intelligence and decision making.
● Learn different approaches to understand the importance of visual perception.
● Learn different data visualization techniques and tools.
● Gain knowledge of effective data visuals to solve workplace problems.
[Link] Experiments
1 Getting Started - Tableau Workspace, Tableau terminologies, basic functionalities.
2 Connecting to Data Source – Connecting to Database, Different types of Tableau Joins.
3 Creating a View - formatting charts, adding filters, creating calculated fields and defining parameters.
Dashboard Design and Storytelling – Components of Dashboard, Understanding how to place worksheets in
4
Containers, Action filters and its types.
Introducing Power BI –Components and the flow of work. Power BI Desktop Interface-The Report has five main
5
areas.
6 Querying Data from CSV - Query Editor, Connecting the data from the Excel Source, Clean, Transform the data.
7 Creating Reports & Visualizations - Different types of charts, Formatting charts with Title, Colors.
8 Dashboards - Filters in Power BI, Formatting dashboards.
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.
2. Create a line chart to show the revenue based on the month of the year.
3. Create a bin of size 10 for the age measure to create a new dimension to show the revenue.
9
4. Create a donut chart view to show the percentage of revenue per region by creating zero access in the calculated field.
5. Create a butterfly chart by reversing the bar chart to compare female & male revenue based on product category.
6. Create a calculated field to show the average revenue per state & display profitable & non-profitable state.
7. Build a dashboard.
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.
10 2. Create a bar graph to compare GDP of Belgium between 2006 – 2026.
3. Using pie chart, visualize the GDP of India, Nepal, Romania, South Asia, Singapore by the year 2010.
4. Create a scatter plot or circle views of GDP of Mexico, Algeria, Fiji, Estonia from 2004 to 2006.
5. Build an interactive dashboard.
Analysis of HR Dataset:
1. Create KPI to show employee count, attrition count, attrition rate, attrition count, active employees, and average age.
2. Create a Lollipop Chart to show the attrition rate based on gender category.
3. 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
11 also, edit label.
4. Create a bar chart to display the number of employees by Age group,
5. Create a highlight table to show the Job Satisfaction Rating for each job role based on employee count.
6. 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,
7. Create multiple donut chart to show the Attrition Rate by Gender for different Age group.
Analysis of Amazon Prime Dataset:
1. Create a Donut chart to show the percentage of movie and tv shows
2. Create a area chart to shows by release year and type
12 3. Create a horizontal bar chart to show Top 10 genre
4. Create a map to display total shows by country
5. Create a text sheet to show the description of any movie/movies.
6. Build an interactive Dashboard.
 Course outcomes (Course Skill Set):
At the end of the course the student will be able to:
1. Design the experiment to create basic charts and graphs using Tableau and Power BI.
2. Develop the solution for the given real world problem.
3. Analyze the results and produce substantial written documentation.
Assessment Details (both CIE and SEE )
The weightage of Continuous Internal Evaluation (CIE) is 50% and for Semester End Exam (SEE) is
50%. The minimum passing mark for the CIE is 40% of the maximum marks (20 marks out of 50) and
for the SEE minimum passing mark is 35% of the maximum marks (18 out of 50 marks). A student shall
be deemed to have satisfied the academic requirements and earned the credits allotted to each subject/
course if the student secures a minimum of 40% (40 marks out of 100) in the sum total of the CIE
(Continuous Internal Evaluation) and SEE (Semester End Examination) taken together
Continuous Internal Evaluation (CIE):
CIE marks for the practical course are 50 Marks.
The split-up of CIE marks for record/ journal and test are in the ratio 60:40.
● Each experiment is to be evaluated for conduction with an observation sheet and record write-up. Rubrics for the evaluation of
the journal/write-up for hardware/software experiments are designed by the faculty who is handling the laboratory session and
are made known to students at the beginning of the practical session.
● Record should contain all the specified experiments in the syllabus and each experiment write-up will be evaluated for 10
marks.
● Total marks scored by the students are scaled down to 30 marks (60% of maximum marks).
● Weightage to be given for neatness and submission of record/write-up on time.
● Department shall conduct a test of 100 marks after the completion of all the experiments listed in the syllabus.
● In a test, test write-up, conduction of experiment, acceptable result, and procedural knowledge will carry a weightage of 60%
and the rest 40% for viva-voce.
● The suitable rubrics can be designed to evaluate each student’s performance and learning ability.
● The marks scored shall be scaled down to 20 marks (40% of the maximum marks).
● The Sum of scaled-down marks scored in the report write-up/journal and marks of a test is the total CIE marks scored by the
student.
Semester End Evaluation (SEE):
● SEE marks for the practical course are 50 Marks.
● SEE shall be conducted jointly by the two examiners of the same institute, examiners are appointed by the Head of
the Institute.
● The examination schedule and names of examiners are informed to the university before the conduction of the
examination. These practical examinations are to be conducted between the schedule mentioned in the academic
calendar of the University.
● All laboratory experiments are to be included for practical examination.
● (Rubrics) Breakup of marks and the instructions printed on the cover page of the answer script to be strictly adhered
to by the examiners. OR based on the course requirement evaluation rubrics shall be decided jointly by examiners.
● Students can pick one question (experiment) from the questions lot prepared by the examiners jointly.
● Evaluation of test write-up/ conduction procedure and result/viva will be conducted jointly by examiners.
General rubrics suggested for SEE are mentioned here, writeup-20%, Conduction procedure and result in - 60%, Viva-voce
20% of maximum marks. SEE for practical shall be evaluated for 100 marks and scored marks shall be scaled down to 50
marks (however, based on course type, rubrics shall be decided by the examiners) Change of experiment is allowed only once and
15% of Marks allotted to the procedure part are to be madezero.
The minimum duration of SEE is 02 hours
Suggested Learning Resources:
1. Microsoft Power BI Dashboards Step by Step by Errin O’Connor, 2019 by Pearson Education, Inc
2. Information Dashboard Design: Displaying Data for At-a-glance Monitoring” by Stephen Few
3. [Link] [Link]
4. [Link]
5. [Link]
Course Outcomes - CO
CO1: Design the experiment to create basic charts and graphs using Tableau and Power BI..
CO2: Develop the solution for the given real world problem.
CO3: Analyze the results and produce substantial written documentation

CO-PO Mapping
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12
CO1

CO2

CO3
 PROGRAM OUTCOMES
PO's PO Description
Engineering knowledge: Apply the knowledge of mathematics, science, engineering
PO1
fundamentals, and an engineering specialization to the solution of complexengineering problems.
Problem analysis: Identify, formulate, review research literature, and analyze complex
PO2 engineering problems reaching substantiated conclusions using first principles of mathematics,
natural sciences, and engineering sciences.
Design/development of solutions: Design solutions for complex engineering problems and
PO3 design system components or processes that meet the specified needs with appropriate consideration
for the public health and safety, and the cultural, societal, and environmental considerations.
Conduct investigations of complex problems: Use research-based knowledge and research methods
including design of experiments, analysis and interpretation of data, and synthesis of the information to
provide valid conclusions.
 That cannot be solved by straightforward application of knowledge, theories and techniques
applicable to the engineering discipline as against problems given at the end of chapters in a typical
text book that can be solved using simple engineering theories and techniques
PO4
 That may not have a unique solution. For example, a design problem can be solved in many ways
and lead to multiple possible solutions;
 That require consideration of appropriate constraints / requirements not explicitly given in the
problem statement such as cost, power requirement, durability, product life, etc.; which need to be
defined (modelled) within appropriate mathematical framework; and
 That often require use of modern computational concepts and tools
Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern
PO5 engineering and IT tools including prediction and modeling to complex engineering activities with an
understanding of the limitations.
The engineer and society: Apply reasoning informed by the contextual knowledge to assess
PO6 societal, health, safety, legal and cultural issues and the consequent responsibilities relevant to the
professional engineering practice.
Environment and sustainability: Understand the impact of the professional engineering solutions
PO7 in societal and environmental contexts, and demonstrate the knowledge of, and need for sustainable
development.
Ethics: Apply ethical principles and commit to professional ethics and responsibilities and norms of the
PO8 engineering practice.
Individual and team work: Function effectively as an individual, and as a member or leader in
PO9 diverse teams, and in multidisciplinary settings.
Communication: Communicate effectively on complex engineering activities with the
engineering community and with society at large, such as, being able to comprehend and write
PO10
effective reports and design documentation, make effective presentations, and give and receive clear
instructions.
Project management and finance: Demonstrate knowledge and understanding ofthe engineering
PO11 and management principles and apply these to one’s own work, as a member a n d leader i n a team to
manage projects and in multidisciplinary environments.
Life-long learning: Recognize the need for, and have the preparation and ability to engage in
PO12
independent and life-long learning in the broadest context of technological change.
DATA VISUALIZATION LAB BCSL504

Introduction to Various Data Visualization tools

Data visualization is the practice of translating information into a visual context, such as a map or graph,
to make data easier for the human brain to understand and pull insights from. It is the representation of
information and data through use of common graphics, such as charts, plots, infographics, and
animations. Data visualization is a powerful way for people, especially data professionals, to display data
so that it can beinterpreted easily.
Data Visualization enables decision-makers of any enterprise or industry to look into analytical reports
and understand concepts that might otherwise be difficult to grasp.
Benefits of Data Visualization:
1. It is easy to understand the information with graphics
2. It made data to be represented in attractive way
3. Shows complex relationships
4. Helps to process large datasets
5. Useful for identifying trends
6. Minimizes ambiguity
Data visualization tools provide the ability to see and understand data trends, outliers, and patterns in an
easy, intuitive way. There are various data visualization tools available. One must choose the tool based
on various factors such as its ease of use, types of graphical representations the tool can produce, size of
the dataset the tool can handle etc. some of Data Visualization tools are Tableau, Power BI, Google
Charts, Jupyter, Grafana etc.
The following are some common types of data visualizations:
 Table: A table is data displayed in rows and columns, which can be easily created in a Word
document orExcel spreadsheet.
 Chart or graph: Information is presented in tabular form with data displayed along an x and y axis,
usuallywith bars, points, or lines, to represent data in comparison.
 Geospatial visualization: Data is depicted in map form with shapes and colours that illustrate
therelationship between specific locations, such as a choropleth or heat map.
 Dashboard: Data and visualizations are displayed, usually for business purposes, to help
analysts understand and present data
 Getting Started - Tableau Workspace, Tableau terminologies, basic functionalities

Department of ISE Page | 7

DATA VISUALIZATION LAB BCSL504

Introduction to Tableau and Installation

Tableau is a data visualization tool that provides pictorial and graphical representations of data. It is used for
data analytics and business intelligence. Tableau provides limitless data exploration without interrupting flow
of analysis. With an intuitive drag and drop interface, user can uncover hidden insights in data and make
smarter decisions faster.

Tableau is a Business Intelligence tool for visually analyzing the data. Users can create and distribute an
interactive and shareable dashboard, which depict the trends, variations, and density of the data in the form
of graphs and charts. Tableau can connect to files, relational and Big Data sources to acquire and process data.
The software allows data blending and real-time collaboration, which makes it very unique. It is used by
businesses, academic researchers, and many government organizations for visual data analysis. It is also
positioned as a leader Business Intelligence and Analytics Platform in Gartner Magic Quadrant.
As a leading data visualization tool, Tableau has many desirable and unique features. Its powerful data
discovery and exploration application allows you to answer important questions in seconds. You can use
Tableau's drag and drop interface to visualize any data, explore different views, and even combine multiple
databases easily. It does not require any complex scripting. Anyone who understands the business problems
can address it with a visualization of the relevant data. After analysis, sharing with others is as easy as
publishing to Tableau Server.
Tableau Features
 Speed of Analysis − As it does not require high level of programming expertise, any user with
accessto data can start using it to derive value from the data.
 Self-Reliant − Tableau does not need a complex software setup. The desktop version which is
used by most users is easily installed and contains all the features needed to start and complete data
analysis.
 Visual Discovery − The user explores and analyzes the data by using visual tools like colors,
trend lines, charts, and graphs. There is very little script to be written as nearly everything is done
by drag and drop.
 Blend Diverse Data Sets − Tableau allows you to blend different relational, semi structured and
rawdata sources in real time, without expensive up-front integration costs. The users don’t need to
knowthe details of how data is stored.
 Architecture Agnostic − Tableau works in all kinds of devices where data flows. Hence, the user
need not worry about specific hardware or software requirements to use Tableau.
 Real-Time Collaboration − Tableau can filter, sort, and discuss data on the fly and embed a live
dashboard in portals like SharePoint site or Salesforce. You can save your view of data and allow
colleagues to subscribe to your interactive dashboards so they see the very latest data just by
refreshingtheir web browser.
 Centralized Data − Tableau server provides a centralized location to manage all of the
organization’s
 published data sources. You can delete, change permissions, add tags, and manage schedules in
one convenient location. It’s easy to schedule extract refreshes and manage them in the data

Department of ISE Page | 8

DATA VISUALIZATION LAB BCSL504

server. Administrators can centrally define a schedule for extracts on the server for both
incremental and full refreshes

Working on Tableau ---Some important screen shots and steps of sheets( Not Related to Programs )

Connecting to Data and preparing data for visualization in Tableau

Tableau supports connecting to a wide variety of data, stored in a variety of places. For example, data
might be stored on computer in a spread sheet or a text file, or in a big data, relational, or cube
(multidimensional) database on a server in enterprise or the data can be from a public domain available on
the web.
Data can be imported in Tableau Public from Connect panel on left side. For example, an Excel sample
dataset was loaded into Tableau as follows:

Department of ISE Page | 9

DATA VISUALIZATION LAB BCSL504

After clicking on open, screen is as follows:

The data store page appears as above. The left pan shows that above dataset consists of 3 worksheets. If wedrag
orders table, screen appears as follows: Tableau automatically identifies the data type of each column

Department of ISE Page | 10

DATA VISUALIZATION LAB BCSL504

Now drag Returns table onto the Canvas to the right of Orders table. This shows the relation between the
twotables Orders and Returns.
If we click on the link between Orders and Returns table names at the top gives the summary of the relationship
between the tables. Now rename the data store and click on Sheet1 at the bottom left to proceed. This step creates a
data extract which improves query performance.

Data aggregation and statistical functions

We can apply various aggregation and statistical functions on data such as count, minimum, maximum,
standard deviation, variance etc. This is shown below. This can be done by right clicking on the required
fieldof dataset, click on Default properties and click on aggregation

Department of ISE Page | 11

DATA VISUALIZATION LAB BCSL504

Or the above operation can be done by creating a calculated field as shown below. To create a calculated field,click on
the down arrow button beside search tab above Tables panel, drag a field to that calculated field window

Then click on apply and results are shown below:

In the same way we can apply any aggregate or statistical function on data with the help of calculated
fields.
Data Visualization
We can perform various visualization operations on data in Tableau. Some of them are bar cart,
histogram,bubble chart, gantt chart, scatter plot, heat map etc.
Bar chart:
Bar charts can be created in 3 variations in Tableau: Horizontal bars, stacked bars, side-by-side bars.
Horizontal bars can be created by selecting that type of chart from Show Me menu on right hand side

Department of ISE Page | 12

DATA VISUALIZATION LAB BCSL504

of Canvas. The type of chart in box on right hand side represents horizontal bar graph

Side-by-side bar chart can be created in following way.

Department of ISE Page | 13

DATA VISUALIZATION LAB BCSL504

Line graph: Line graph can be continuous or discrete.

Discrete line graph is shown below

Department of ISE Page | 14

DATA VISUALIZATION LAB BCSL504

Pie chart:

Bubble chart:

Department of ISE Page | 15

DATA VISUALIZATION LAB BCSL504

Dashboards

Dashboard is a way of displaying various types of visual data in one place. Usually, a dashboard is
intended to convey different, but related information in an easy-to-digest form. And oftentimes, this
includes things like key performance indicators (KPI)s or other important business metrics that
stakeholders need to see andunderstand at a glance.
Dashboards are useful across different industries and verticals because they’re highly customizable. They
can include data of all sorts with varying date ranges to help you understand: what happened, why it
happened, what may happen, and what action should be taken.
For example, category of sales across months in a year, region is the field added. The first view is shown
below. This can be renamed at the bottom of the screen.

 Now go to 2nd sheet for creating the 2nd view. The second view is shown below. A bubble chart was
drawn between profit and subcategory. Then rename the sheet.
 Next 3rd view is created as follows for profit for each subcategory in the category with averages.
 After creating individual views, now a Dashboard can be created by clicking on create dashboard at the
toolbar.

Department of ISE Page | 16

DATA VISUALIZATION LAB BCSL504

Now the sheets or views which are created earlier can be drag and dropped on this dashboard. The
above three created views are placed in the dashboard as follows. One can follow their own way of
importing sheets on the dashboard. After creating dashboard, title can be given to the dashboard from

Department of ISE Page | 17

DATA VISUALIZATION LAB BCSL504

Dashboard tab. Dashboard can be customized in terms of its appearance by the user if required.
Dashboard once created can be saved onusers system and can be retrieved whenever required.

Department of ISE Page | 18

DATA VISUALIZATION LAB BCSL504

POWER BI

What is Power BI?

Power BI is a business intelligence tool that allows you to connect to various data sources, visualize the
datain reports and dashboards, and then share them with anyone you want. Power BI is a Data Visualization
and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI
reports.

What is Power BI Used For

Power BI is a tool in the category of Business Intelligence (BI). The purpose of BI is to track Key
Performance Indicators (KPIs) and uncover insights in business data so as to better inform decision-making
across the organization.
Power BI is used in different ways depending on the role of the individual, from developers, analysts,
managers, and directors, to everyone in between.
How Does Power BI Compare to Other Tools Like Tableau and Excel?

Power BI and Tableau are both business intelligence tools and have a lot of overlap in terms of their
capabilities. There are 2 key differences between Power BI and Tableau:

1. Power BI only works on Windows, whereas Tableau supports both Windows and MacOS.
2. Pricing options differ between Power BI and Tableau. However, Tableau is generally the more
expensive option.

Why Power BI?

“DATA “ Analysis and Decision Making
Organizations need a tool that can help them understand the large amount of data that they are
collecting. Itis a powerful data visualization and analysis tool that allows businesses to turn raw data into
actionable insights and reports.
Microsoft Power BI comes with a free or paid version. The free version only provides Power BI tools like
Power BI Desktop and Power Q&A to dashboards. Whereas, in the Pro version they provide services like
live report sharing, Power View, and more Power BI apps.
Key Differences Between Power BI and Tableau

Power BI Tableau
Power BI uses DAX for measuring and
Tableau deploys MDX for dimensions and measures.
calculating columns.
Tableau can handle huge columns of data and still offer
Power BI is best for a limited volume of data.
better performance.

Power BI offers many data points for data

Tableau has better data visualization.
visualization.

Department of ISE Page | 19

DATA VISUALIZATION LAB BCSL504

Program 1: Getting Started - Tableau Workspace, Tableau terminologies, Basic

functionalities.
Working with Tableau that focuses on understanding the Tableau Workspace, Tableau terminologies, and
basic functionalities.

REQUIRED DATA SET : [Link]

Steps to be followed
1. Go to Start Page: Toggle between the active sheet and the Desktop Start Page.
2. Data Pane: Includes dimensions and measures, populated from your selected data source. May also include
calculated fields, parameters, or sets.
3. Analytics Pane: Includes options you can use to apply reference lines, forecasts, trend lines, to add totals to
crosstabs, and to build boxplots.
4. Workbook Name: The file name of our workbook.
5. View Cards: Used for modifying the worksheet.
6. Toolbar Icons: Icons are available for quick access to popular features.
7. Worksheet/View: Workspace for building your visualizations.
8. Go to Data Source: Returns you to the data source specification page.
9. Worksheet Tabs: Click to view a specific worksheet, dashboard, or story
10. New Worksheet, Dashboard, and Story Tabs: Click to create a new Worksheet, Dashboard, or Story.
11. Status Bar: Displays data about the fields and marks included in the view.

Department of ISE Page | 20

DATA VISUALIZATION LAB BCSL504

Steps:
Tableau Workspace Setup: Connect to Data:
Open Tableau, and on the "Start Page," select Connect -> To a File -> Text File.
Browse to the location of [Link] and open it.
Data Preview:
After loading, Tableau will show a preview of the data. You can rename columns if necessary
Click on the "Sheet 1" tab at the bottom to go to your first worksheet.

1. Tableau Terminologies:

 Dimensions: These are qualitative fields. In [Link], examples include Platform, Genre,and
Publisher.
 Measures: These are quantitative fields used for calculations. Examples are Global_Sales, NA_Sales,
and Year.
 Rows and Columns Shelf: Drag dimensions and measures to the Rows or Columns shelves to build
the structure of your visualization.
 Marks: Controls the appearance of the data. You can set marks to be circles, bars, or other shapes and
control size, color, and label.
 Filters: Used to limit the data displayed in the view.

 Pages Shelf: Used for creating animations or segmenting your view by categories.
2. Basic Functionalities:
a. Basic Visualization (Bar Chart of Global Sales by Genre):
 In your worksheet, drag Genre to the Columns shelf.
 Drag Global_Sales to the Rows shelf.
 You should see a bar chart. If the data isn’t aggregating correctly, check if the aggregation is
set toSUM by right-clicking Global_Sales -> Measure -> Sum.
b. Sorting:

Department of ISE Page | 21

DATA VISUALIZATION LAB BCSL504

 Click on the Global_Sales axis and sort descending to show the genres with the most sales first

c. Filtering:
 Drag Year to the Filters shelf.
 Choose the range of years you want to display (e.g., 2000-2016).
 Add Year to the Pages shelf to create a dynamic view of how sales changed over time.

3. Additional Functionalities:
Dashboards: Combine different sheets to create a comprehensive dashboard. Go to the Dashboard tab, drag
your created sheets to the layout, and arrange them accordingly.
a. Add one more worksheet - Global Sales Trend by Year
 Drag Year to the Columns.

Department of ISE Page | 22

DATA VISUALIZATION LAB BCSL504

 Drag Global_Sales to the Rows.

 Create a line chart to show how global sales have trended over time.
 Add Genere to the Marks
 Apply color to Genere

 Go to the Dashboard tab in Tableau.

 Add multiple visualizations to a single dashboard. (To increase dashboard size - select size-
Automatic)
 Arrange charts (e.g., a line chart for yearly sales, a bar chart for top genres, etc.)

Reference Video Link

[Link]

Department of ISE Page | 23

DATA VISUALIZATION LAB BCSL504

Program 2 : Connecting to Data Source – Connecting to Database, Different types of

Tableau Joins.
Dataset used: [Link] : Contains 4 sheets: Demographics, Salary, Department ,Job Title
1. Connecting to Excel Files in Tableau:
 Open Tableau and click on Connect in the left pane.
 Under To a File, choose Microsoft Excel.
 Browse and select your Excel file ([Link]).
 Tableau will display the sheets from the Excel file in the Data Source tab.
 Drag the relevant sheets to the workspace
2. [Link] Dataset: has four Excel sheets
 Demographics:
 EMPLOYEE_ID
 FIRST_NAME
 LAST_NAME
 EMAIL
 PHONE_NUMBER
 HIRE_DATE
 JOB_ID
 MANAGER_ID
 DEPARTMENT_ID
 Salary:
 EMPLOYEEID
 EMPLOYEESALARY
 Department
 DEPARTMENT_ID
 DEPARTMENT_NAME
 MANAGER_ID
 Job Title
 JOB_ID
3. These sheets have a relationship based on the EmployeeID, JOB_ID , DEPARTMENT_ID and you can
join them using these fields.
1. Drag and drop New Table Extension in the canvas
2. Drag and drop the required Tables in the canvas to establish different kinds of Joins
(Inner, Outer, Left and Right)

Department of ISE Page | 24

DATA VISUALIZATION LAB BCSL504

4. Creating a Visualization Based on Joins:

After performing the joins, you can build different visualizations.
Press on Sheet 1:
Bar Chart: Number of employees and their salary.
 Drag NameofEmployee to Columns. From Demographics Table
 Drag EmployeeSalary to Rows. From Salary Table 
This chart will display the Name of the employees and their salary based on the type of join.
Right click on the chart and choose option Sort on Ascending / Sort on Descending

Reference Video Link –

[Link] 1hjhk8GwbqoVmo_5zuhOa0Tcl3xC&index=4

Department of ISE Page | 25

DATA VISUALIZATION LAB BCSL504

Program 3. Creating a View - formatting charts, adding filters, creating calculated fields
and defining parameters
REQUIRED DATA SET : [Link]
Step 1: Connect to Data
Open Tableau Desktop.
Connect to Your Data Source:
Click on Connect on the left sidebar.
Choose your data source by selecting text file and load your [Link] dataset into Tableau.

Step 2: Create a Basic Visualization Create a New Worksheet:

a) Click on the Sheet tab at the bottom of the screen.
b) Drag Fields to Shelves:
a. Drag Year to the Columns shelf.
b. Drag Global Sales to the Rows shelf.
c. Drag EU Sales to the Rows shelf. That gives the line graph visualization.

Department of ISE Page | 26

DATA VISUALIZATION LAB BCSL504

 Change Visualization Type

In the Show Me panel on the right, select a bar chart or any other type that suits your needs.
Step 3: Format the Chart
 Format Axes:
a) Right-click on the Global Sales axis and select Format.
b) In the Format pane, adjust the font style & size as needed.
 Add Titles and Annotations:
a) Click on the chart title area and enter a descriptive title - Global Sales by Year.
b) Add annotations if needed to highlight specific data points – Right click the on the chart
which you want to highlight - Select Annotate - Select Mark - Press Ok

Step 4: Add Filters

 Add a Filter for Year:
o Drag Year to the Filters shelf.

Department of ISE Page | 27

DATA VISUALIZATION LAB BCSL504

o Choose the range of years you want to display (e.g., 2000-2016).

Step 5: Create Calculated Fields

Create a Calculated Field for Sales Category:
 Right-click on Global Sales - Select Create - Calculated Field.
 Give name to your calculations as Global Sales - EU Sales
 Do calculations as per your need - [Global Sales] - [EU Sales]
 Press Ok
Add Calculated Fields to Visualization:
 Drag Global Sales-EU Sales to the Rows shelf to show Global Sales over Year with Global Sales-EU
Sales over Year.

Step 6: Create a Parameter:

Name of the Field: "NewGenre"
 Data Type: String

Department of ISE Page | 28

DATA VISUALIZATION LAB BCSL504

 Values: List (e.g., "Action", "Adventure", "Shooter") or Add values from Genre.
Create a Calculated Field:
 Name: "Sales by Genre"
 Formula:
 IF [Genre] = [NewGenre] THEN [Global Sales] ELSE 0 END
Build the Visualization:
 Columns: Drag "Year".
 Rows: Drag "Sales by Genre".
 At the right side of your sheet you can select required Genre and can see different
VisualizationVisualization by Genre: Fighting

Visualization by Genre: Puzzle

Reference Video Link - [Link]

Program 4 : Dashboard Design and Storytelling – Components of Dashboard, Understanding how to place
worksheets in Containers, Action filters and its types.
CREATING A STORY WITH TABLEAU PUBLIC

Department of ISE Page | 29

DATA VISUALIZATION LAB BCSL504

With Tableau public, you are able to organize your data in order to tell a meaningful story. This is beneficial
when you are doing a presentation, creating an article, or uploading to a website, as it helps your audience
understand your data.
Stories are created through assembling the different worksheets and dashboards. We can highlight important
data points, add text box and pictures to help convey our story. However, there are many different ways to
tell a story. For example, one technique is called “tailoring in” where the story starts with a big picture view
and zooms in on a specific detail.
In contrast, a story can also be told by starting with a case and zooming out to that big picture view. We are
going to return to our health expenditure worksheets to create a tailoring in story and illustrate the changes in
Canada’s spending in a meaningful way.
To begin, select “New Story” at the bottom right of your screen.

Drag “Sheet 1” and “Sheet 2” on to “Drag a sheet here”. We can rename each storyboardby clicking “Add a caption”.
Rename Sheet 1 to “Provincial Health Expenditure in 2016”.

Department of ISE Page | 30

DATA VISUALIZATION LAB BCSL504

Use the arrows located on the side of the caption field to navigate to Sheet 2. Click on “Add a caption”and rename Sheet 2
to “Provincial Health Expenditure from 1975-2018”.

In this story, we will focus on the province or territory with the highest health expenditure. Duplicate "Sheet 1" and place
the copy between the two existing sheets. Choose "Add a caption" and rename it to "Ontario."

Department of ISE Page | 31

DATA VISUALIZATION LAB BCSL504

Click on the province of Ontario on the map, then go to the caption field and select "Update." Ontario will now be
highlighted, distinguishing it from the rest of Canada on your screen.

Department of ISE Page | 32

DATA VISUALIZATION LAB BCSL504

Click the right arrow to navigate to "Provincial Health Expenditure from 1975-2018." Hover over Ontario's line and
select the data point for health expenditure in 2016. Then, click "Update." Your screen should now appear as follows:

To label the highlighted point, drag "Drag to add text" onto the line graph to create a textbox. In the textbox, enter a key
message, like "Ontario had the highest health expenditure in Canada in 2016, spending $87,195.70M." Then, click
"OK."

To edit the textbox, select "More options," which will open a dropdown menu. Expand the textbox by dragging its
borders to display the full message..

Department of ISE Page | 33

DATA VISUALIZATION LAB BCSL504

We have now created a story with three sheets illustrating how Ontario had the highest health expenditure in 2016.
Adding a dashboard will enable your audience to interact with the data. You can navigate through the story as shown
below:

SAVING AND PUBLISHING YOUR TABLEAU PUBLIC WORKBOOK

Once satisfied with your workbook, which includes sheets, dashboards, and stories, you can publish it to
the Tableau Public website. This is the only way to save your work whenusing Tableau Public, so make
sure to do it if you wish to return to the workbook in the future. Once ready to publish, select the “Save to
Tableau Public As…” option under the “File”tab.

Department of ISE Page | 34

DATA VISUALIZATION LAB BCSL504

CREATING A DASHBOARD WITH TABLEAU

Dashboards are a great way to combine your data visualizations and have them interact with one another.
A lot of businesses use dashboards to keep up-to-date in real time about key performance indicators at a
glance. In this example, we will combine just twoof our data visualizations, the map and the line graph
from the first section of the tutorial,but in reality, it can be used to combine many visualizations at once.
The first step in creating your dashboard is to open up the Dashboard tab at the bottom of the screen:

After clicking this icon, your screen should open to this:

This is your Dashboard Sheet. On the left, you'll see a list of sheets created from your current data source.
Department of ISE Page | 35
DATA VISUALIZATION LAB BCSL504

To build your dashboard, drag the desired sheets into the center area labeled "Drop sheets here." For this
example, we need to drag in Sheet 1 and Sheet 2, which contain the map and line graph. As you drag, a
shaded area will indicate where each graph will appear when placed. Arrange your dashboard to resemble
the layout shown below.

To add titles to the selected graphs, double-click on the automatically generated titles (based on the sheet
names). A new window will appear; enter a descriptive title for each graph, as shown here:

Additional titles and objects can be added to the dashboard by selecting an object from the Objects side
panel and dragging it onto the dashboard. We’ll add titles to the bottom line graph to distinguish the

Department of ISE Page | 36

DATA VISUALIZATION LAB BCSL504

Canada line from the provincial data. To do this, drag a title to the area near the orange line representing
the total provincial expenditure over the years and type "Canada." Then, drag another title to label the
remaining provinces. Your bottom graph should now appear as follows:

To add an interactive layer between the graphs, we can select one graph to serve as a filter for the other.
We’ll use the line graph as a filter for the map. To do this, click on the line graph, and a grey sidebar will
appear. From this sidebar, click the filter icon to enable this graph as a filter:

Now, when you click a given line, it will be highlighted on the above map:

Department of ISE Page | 37

DATA VISUALIZATION LAB BCSL504

Congrats, now you have an interactive dashboard that is ready to be published or saved!

Department of ISE Page | 38

DATA VISUALIZATION LAB BCSL504

Program 5 : Introducing Power BI –Components and the flow of work. Power BI Desktop Interface-The Report
has five main areas.
Solution :
Power BI includes the following components
 Power BI Desktop − This is used to create reports and data visualizations on the dataset.
 Power BI Gateway − You can use Power BI on-premises gateway to keep your data fresh by
connecting to your on-premises data sources without the need to move the data. It allows you to query
large datasets and benefit from the existing investments.
 Power BI Mobile Apps − Using Power BI mobile apps, you can stay connected to their data from
anywhere. Power BI apps are available for Windows, iOS, and Android platform.
 Power BI Service − This is a cloud service and is used to publish Power BI reports and data
visualizations

Flow of work
 A typical Power BI workflow involves more than one type of content.
 A Power BI designer (yellow in the diagram) collects data from semantic models, brings it into Power BI
Desktop for analysis, and creates reports full of visualizations that highlight interesting facts and insights.
 The designer pins visualizations from reports to dashboards, and shares the reports and dashboards with
business users like you (black in the diagram).

Department of ISE Page | 39

DATA VISUALIZATION LAB BCSL504

A visualization (or visual), is a type of chart built by Power BI designers. The visuals
display the data from reports and semantic models. Because they're highly interactive,
you can slice, filter, highlight, change, and even drill into visualizations.
A semantic model is a container of data. For example, it might be an Excel file from the
World Health Organization. It might also be a company-owned database of customers, or
it might be a Salesforce file. And it might be all three if the designer combines them into a
. single model. Designers manage semantic models. The data contained in semantic models
is used to build reports, dashboards, and apps that designers share with you
A dashboard is a single screen with tiles of interactive visuals, text, and graphics. A
dashboard collects your most important metrics, or a focused set of metrics, on one screen,
to tell a story or answer a question. The dashboard content comes from one or more
reports and one or more semantic models.
A report is one or more pages of interactive visuals, text, and graphics that together make
up a single report. Power BI bases a report on a single semantic model. Often, the designer
organizes report pages to each address a central area of interest or answer a single
question.
An app is a way for designers to bundle and share related dashboards, reports, and
semantic models together. Business users receive some apps automatically but can go
search for other apps created by colleagues or by the community. For example, out-of- the-
box apps are available for external services you may already use, like Google Analytics
and Microsoft Dynamics CRM.
Power BI Desktop Interface-The Report has five main areas.
Downloading and Installing Power BI Desktop
Power BI Desktop is available in both 32-bit and 64-bit versions. To download the latest version, you can use
the following link –
The Steps to be followed
1. Download from the link
[Link]

Department of ISE Page | 40

DATA VISUALIZATION LAB BCSL504

1. Click on Products-Power BI--Desktop

2. Click on Advanced Download option

Select the Language as English and Click on download , choose PBIDEsktopSetup_x64.exe

Department of ISE Page | 41

DATA VISUALIZATION LAB BCSL504

Download Begins and you will get exe file which will be downloaded in yourdownloads folder

PBIDesktopSet up_x64(2).exe

Double click on the .exe file ,to get the installation wizard

 Click on Next button until you get Finish button and finally installation will be done.
 Once the Installation is done ,double click on Power BI App
When you launch the application, Power BI Desktop will start with a blank report. Let's go over the
components of the Power BI Desktop Interface
 Ribbon - the top ribbon contains most of the controls and options needed for building the report.
 Views - this is made up of the report view, the data view, and the model view.
 Canvas - this is the main design area where visualizations and other elements are added.
 Page selector - for navigation to other pages in the report.
 Filters - fields can be added here to filter the data.
 Visualizations - this contains the list of available visualizations.
 Fields - this section contains the tables and fields that are available in the data model

Department of ISE Page | 42

DATA VISUALIZATION LAB BCSL504

The Major Components of Power BI Desktop Interface are

Power Query Editor
It is the process of cleansing and transforming data and permits users to access datasets connecting from
multiple sources. It is included on the Power BI desktop. Business users may view the data from distinct
databases like MySQL, SQL servers, DB2, and many more.
Power View
It is a data visualization tool that assists users in developing stunning charts, and colourful maps,that turn
data into a story.
Power Map
It is a 3D map visualization tool to identify geospatial data on Map visuals. It helps organizations to
examine the maximum sales production geographically, visualizing the demographic populations of
specific regions.
Power Pivot
It is a Data Modelling technique that is used to create relationships between datasets. It performscomplex
computations by utilizing DAX functions.
Power Q & A
When dealing with giant datasets, it becomes crucial to get to know the in-depth details of the data.
Luckily, it is done through natural language where users may ask questions and obtain the answer
through Power Q & A
Build Reports :
In Power BI Desktop Report view, you can build visualizations and reports. The Report view has six
main areas:
1. The ribbon at the top, which displays common tasks associated with reports andvisualizations.
2. The canvas area in the middle, where you create and arrange visualizations.
3. The pages tab area at the bottom, which lets you select or add report pages.
4. The Filters pane, where you can filter data visualizations.
5. The Visualizations pane, where you can add, change, or customize visualizations, and apply drill
through.

Department of ISE Page | 43

DATA VISUALIZATION LAB BCSL504

6. The Format pane, where you design the report and visualizations.
7. The Fields pane, which shows the available fields in your queries. You can drag these fields onto
the canvas, the Filters pane, or the Visualizations pane to create or modify visualizations

Department of ISE Page | 44

DATA VISUALIZATION LAB BCSL504

PROGRAM 6: Querying Data from CSV - Query Editor, Connecting the data from the Excel Source, Clean,
Transform the data.
RESOURSE REQUIRED : Revaluation_2023_24.xlsx
Power BI Desktop also includes the Power Query Editor, which opens in a separate window In Power Query Editor,
you can build queries and transform data, then load the refined datamodel into Power BI Desktop to create reports.

Along the left side of Power BI Desktop are icons for the three Power BI Desktop
views: Report, Data, and Model, from top to bottom. The current view is indicated by
the yellow bar along the left, and you can change views by selecting any of the icons.

Report view is the default view.

Connect to data (Get Data from different Sources)
With Power BI Desktop installed, we can connect to the world of data. To see the many types of data
sources available,
Once Power BI screen is seen click on blank Report

Department of ISE Page | 45

DATA VISUALIZATION LAB BCSL504

After clicking on blank Report the below screen appears.

Step 1 : Select Get Data in the Power BI Desktop Home tab, and in the Get Data window, scroll through the
list of All data sources.(like Excel,CSV,Oracle….)On the Power BI Desktop Home tab, select Get Data > Excel
workbook

Click on the file you need and open (Revaluation_2023_24.xlsx)

Department of ISE Page | 46

DATA VISUALIZATION LAB BCSL504

At this point Clict the check box beside Revaluation Data in Navigator Window and then select Load to
load the table, or Transform data to make changes in the table before you load it.
When you select Transform data, Power Query Editor launches, with a representative view of the table.
The Query Settings pane is on the right, or you can always show it by selecting Query Settings on the View
tab of Power Query Editor.

To transform the data, you provide Power Query Editor with step-by-step instructions for adjusting the data while
loading and presenting it. Transforming doesn't affect the original data source, only this particular view of the
data.
Transforming the data, includes renaming columns or tables, removing rows or columns, or changing data types. Power
Query Editor captures these steps sequentially under Applied Steps in the Query Settings pane. Notice that the
Applied Steps in Query Settings already contain a few steps. You can select each step to see its effect in the Power
Query Editor

To Change a data type

 Select the column or columns to change.
 Hold down the Shift key to select several adjacent columns, or Ctrl to select non-adjacent columns.
 Either right-click a column header, select Change Type,
 Choose a new data type from the menu, or drop down the list next to Data Type in the Transform

Department of ISE Page | 47

DATA VISUALIZATION LAB BCSL504

group of the Home tab

 Select a new data type.

To Reduce/Delete the Rows

 From the Home tab select
 Reduce Rows > Remove Rows > Remove Bottom Rows.
 In the Remove Bottom Rows dialog box, enter 10, and then select OK.

The bottom 10 rows are removed from the table, and the step Removed Bottom Rows appears in Applied Steps.
To Remove columns
 From Home Tab Select Manage Columns group select Remove Columns.
 You can also right-click one of the selected column headers and select Remove Columns from the menu.
 The selected columns are removed, and the step Removed Columns appears in Applied Steps.

Department of ISE Page | 48

DATA VISUALIZATION LAB BCSL504

Applied steps in the Query setting pane

Right-click any step in the Applied Steps pane and choose to delete it, rename it, move it up
or down in the sequence, or add or delete steps after it.
For intermediate steps, Power BI Desktop will warn you if the change could affect later
steps and break your query.
Once all the required transformations is done for the data updated the the report should be
created in the Power BI Desktop

 Apply the changes in Power Query Editor and load them into Power BI
Desktop
 Selecting Close & Apply from the Home tab of the ribbon.
 You can also select just Apply to keep the query open in Power Query
Editorwhile you work in Power BI Desktop.
 To reopen Power Query Editor from Power BI Desktop
 Select Transform Data on the Home tab of the Power BI Desktop
ribbon.
You can expand and collapse the Filters, Visualizations, and Fields panes by
selecting the arrows at the tops of the panes. Collapsing the panes provides more
space on the canvas to build cool visualizations.
The Visualizations pane shows information about the visualization and lets
youmodify it.
1. The Fields option in the Visualization pane lets you drag data fields to
Legend and otherfield wells in the pane.
2. The Format option lets you apply formatting and other controls to
visualizations.
3. The icons show the type of visualization created. You can change the type of
a selected visualization by selecting a different icon, or create a new
visualization by selecting an icon with no existing visualization selected
4. The options available in the Fields and Format areas depend on the type of
visualization and data you have. You want your map visualization to show
only the top 10 weather states.

Department of ISE Page | 49

DATA VISUALIZATION LAB BCSL504

Department of ISE Page | 50

DATA VISUALIZATION LAB BCSL504

Program 7 : Creating Reports & Visualizations - Different types of charts, Formatting charts with Title, Colors
19 Most Common Charts available in Power BI:
1. Bar Chart 2. Box Plot
3. Line Chart 4. Maps
5. Scatterplot 6. Tables
7. Sparkline 8. Indicators
9. Pie Chart 10. Area Chart
11. Gauge 12. Radar or Spider Chart
13. Waterfall Chart 14. Tree Map
15. Funnel Chart 16. Open Power BI Desktop
17. Heat Map / Matrix 18. Click on Get data in ribbon pane
19. Histogram
Click on Excel worksheet option
Choose specific dataset and open it. HR Analytics [Link]

Click on Transform Data button

Department of ISE Page | 51

DATA VISUALIZATION LAB BCSL504

Power Query Editor window will open.

 Perform some transformation on this table -> Select Row 1 and Click on Use First Row as Header
 Then, we have to create new column for Attrition Count. For this, Goto Add Column Menu and
Click on Conditional Column
 A Message box will apper as shown below image. Click on Insert Button.
A New Window will open then add details as follows. Once you are done with this, attrition count column
will be added as a last row of the table

1. In New Column Name Text Box enter Attrition Count

2. Under Column Name Select Attrition from the dropdown list
3. Select the Operator as equals
4. Value as Yes
5. Output value as 1 Else as 0
6. Click on Ok
7. The newly inserted column (Attrition Count )will displayed at the end (last Column)
8. Change the Datatype of this column to Whole Number
9. Click on Close & Apply.
Department of ISE Page | 52
DATA VISUALIZATION LAB BCSL504

You will be back on canvas area with table loaded in Data Pane (in right side).

The Card visual in Power BI is a versatile tool for presenting key metrics in a visually appealing format.
 Click on Card Visual from visualization panel
 Select Employee Count from Data panel
 Drag and drop it on to Fields in visualization panel
 Under Visualization panel -> Format Visual -> Visual ->Callout Value for
formatting the Values (Bold,Color)
 Under Visualization panel -> Format Visual -> Visual ->Category for
formatting the label

 Change the WallPaper Color of the page by Clicking on Format Page tab
 You can update following information under Format Page Tab
1. Update and modify Page Information
2. Update Canvas settings
3. Update Canvas background
4. Update Wallpaper
5. Filter Pane
6. Filter Cards

Insert Text-Box from the Insert Menu

 The format text box will appear in place of visualization on right panel
 In general option we can modify the following
1. Properties
2. Title(ON)
3. Effect
4. Header icons
5. Alt text

To modify the title of the panel Click on Title option on

Format Text-Box
 Enter the title
 Select the heading and other formatting features for title
 To bring in special effect for the title of the page
 Click on Effects as shown in the figure
 Change the background color and visual borders
(Rounded corners) by enabling on option

Department of ISE Page | 53

DATA VISUALIZATION LAB BCSL504

Adding Pie Chart to the Panel.

 Select Pie Chart from Visualization Panel
 Drag and drop the Department from Data panel to Legends under
Visualization Panel
 Drag and drop the Attrition Count from Data panel to Values under
Visualization Panel
Adding Stacked Bar Graph
 Go to Home Menu -> Transform Data->Add Column -> Add Conditional Column
 Create a New column with a name “CF_Age_Band”
 Add following formula in formula bar for creating new Column Name CF_Age_Band

 Create a new column with a name “Sort_Age”

 Apply the same procedure for as done above

 The formula bar in Power BI's Power Query Editor shows the formula for each step of a query.
 Add following formula in formula bar for creating new Column Sort_Age
 Change datatype to whole number
 Once sort_age column is created. Click on “Close & Apply” from Home Menu
Add Stacked Column chart on to the canvas
 Now, select CF_age_band from data pane and drop it on x-axis in visualization pane
 Select sort_age from datapane and drop it on x-axis in visualization pane
Department of ISE Page | 54
DATA VISUALIZATION LAB BCSL504

 Select sum of employee count from data pane and drop it on y-axis in visualization pane
 Select Gender from data pane and drop it on legend in visualization pane
 Finally, output will be as follows

Procedure for adding Matrix to canvas

 Select matrix from visualization pane and drop it in the canvas
 Drag Job Role from data pane and drop it in rows of the
visualization pane
 Drag job satisfaction from data pane and drop it in columns of
the visualization pane
 Drag Sum of Employee Count from data pane and drop it in
values of the visualization pane
 Final output will be as follows

A doughnut chart is similar to a pie chart in that it shows the relationship of parts to a whole. The only
difference is that the center is blank and allows space for a label or icon.

Department of ISE Page | 55

DATA VISUALIZATION LAB BCSL504

Doughnut charts work best when you use them to compare a particular section to the whole, rather than
comparing individual sections with each other.
Now apply the same steps for creating and implementing Donut chart and slicers

Slicers: A slicer is a standalone chart that can be used to filter the other visuals on the page. Slicers come in
many different formats (category, range, date, etc.) and can be formatted to allow selection of only one,
many, or all of the available values.

Department of ISE Page | 56

DATA VISUALIZATION LAB BCSL504

Program 8: Dashboards - Filters in Power BI, formatting dashboards Filters remove all but the data you want
to focus on.
DATA SET : HR Analytics [Link]
Filter Pane: You can apply filters in the Filters pane, or make selections in slicers directly on the report page itself. The
Filters pane shows the fields in individual visuals and any other filters the report designer adds.
 There are four standard types of filters that you create in the Filters pane.
 Visual filter applies to a single visual on a report page. You see visual-level filters when you select a visual on
the report canvas. Even if you can't edit a report, you can select a visual and filter it.
 Page filter applies to all the visuals on the report page.
 Report filter applies to all pages in the report.
 Drill through filter With drill through in the Power BI service and Power BI Desktop, you create a destination
report page that focuses on a specific entity, such as a supplier. From the other report pages, users can right-
click a data point for that entity and drill through to the focused page.

 Extending same dashboard with using filters & let’s format the final dashboard. Let’s apply filter for
department (Particular visual).
 Drag Department from Data Pane to Filters
 Under Filters type on filter panel, select BasicFiltering, Advanced Filtering & Top N
 Now, you can see, if HR dept. is selected and now in below picture, you can see that only HR data is
visible, whereas, R&D and Sales data will not be shown.

Department of ISE Page | 57

DATA VISUALIZATION LAB BCSL504

Advanced filter
 Let’s find out results for salary less than or equal to 10000.
 Drag and drop Monthly Income in filter
 Filter type: advanced filtering
 Show items when the value: is less than or equal toValue: 10000

 Now, try for Top N filtering.

 Try to display Top 4 Job roles having highest job satisfaction.
 Select “Job satisfaction” from Data panel and drop on By value field
in Filters on this visual
 In Filters Pane, Filters on this visual-> Top N: Top : 4
 By value: Sum of Job Satisfaction
 Click on Apply filter

Department of ISE Page | 58

DATA VISUALIZATION LAB BCSL504

Program 9 : BUILDING DASH BOARD

Data Set used: Sample_Super [Link]
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.
2. Create a line chart to show the revenue based on the month of the year.
3. Create a bin of size 10 for the age measure to create a new dimension to show the Revenue
4. Create a donut chart view to show the percentage of revenue per region by creatingzero access in the calculated field.
5. Create a butterfly chart by reversing the bar chart to compare female & male revenue based product category.
6. Create a calculated field to show the average revenue per state & display profitable &non-profitable state.
7. Create a Dash board
Solution:
Step1: Upload the Sample_Super [Link] dataset
Step2: In the power query editor as part of transformation remove the unnecessary columns (Remove the last
null column)
Question 1: Create a choropleth map (fill the map) to spot the special trends to showthe state which has the highest revenue.

Step 2: Set Up the Map:

 Rename Profit field as Revenue
 Drag the state field to the "Location" field well.
 Drag the Revenue field to the "Legend" field well.
 Drag the Sales field to the "Bubble Size" field well.

Step3: Customize: In the "Format Your Visual" pane, adjust settings such as color, size, and
tooltips to enhance readability. You can use color gradients to indicate different
revenue levels, helping tospot trends

Department of ISE Page | 59

DATA VISUALIZATION LAB BCSL504

Question 2:Create a line chart to show the revenue based on the month of the year.
Step1:Add a Line Chart: Select the "Line chart" visualization from the Visualizations pane.
Step2: Configure the Chart:
 Drag the Ship Date->Month field to the "X-axis" field well.
 Drag the Revenue field to the "Y-Axis" field well.
Step3: Format: In the "Format" pane, you can customize the line color, axis titles, and otheraspects to clearly
present the revenue trend throughout the year

Question 3: Create a bin of size 10 for the age measure to create a new dimension to show the revenue.
Step1: Create Bins for age
 Go to the "Data" view and select the age field.
 Right-click on the age field and choose "New group".
 In the "Group" window, select "Bin" and set the bin size to 10.
Step2: Add to Visualization:
Create a new visualization (e.g., bar chart or column chart). Here we used Stacked column chart. Drag the
new age bins field to the "X Axis" and the Sales and Revenue field to the "Y axis”

Department of ISE Page | 60

DATA VISUALIZATION LAB BCSL504

Question 4: Create a donut chart view to show the percentage of revenue per region by creating zero access in the calculated
field.
Step1: Add a Donut Chart:
 Select the "Donut chart" visualization from the Visualizations pane.
Step2: Set Up the Chart:
 Drag the Region field to the "Legend" field well.
 Drag the Revenue field to the "Values" field well
Step3: Create Zero Access:
 Go to the "Format" pane, select "Detail labels", and set the "Label position" to "Inside" to
create a zero access effect.
 Adjust the "Detail" and "Percentage" settings as needed.
Note: The "zero access effect" is a visual design technique often used in data visualizations to emphasize or clearly
show zero values or the absence of certain data. This effect is particularly useful in charts where you want to highlight
how values are distributed relative tozero, or where zero plays a significant role in the interpretation of the data.

Question 5: Create a butterfly chart by reversing the bar chart to compare female & male revenue based on product
category.
Step1: Create a New Measure
TotalRevenue = SUM(Orders[Revenue])
Step 2: Create 2 stacked column chart (Male and Female)

Step 3: Configure the First Bar Chart (e.g., Female Revenue):

 Drag and drop ProductID to the "X-Axis" field.
 Drag and drop TotalRevenue to the "Y-Axis" field.
 Drag and drop Gender to the Legend
Apply a Filter:
In the "Filters" pane, add a filter to show only Female Revenue.
Configure the Second Bar Chart (e.g., Male Revenue) Follow Step 3 for Male Revenue
Step 4: Reversing the Bars:
 Swap the data of X-Axis and Y-Axis for butterfly effect of chart

Department of ISE Page | 61

DATA VISUALIZATION LAB BCSL504

Question 6: Create a calculated field to show the average revenue per state & display profitable & non-profitable state.
Step1: Create a New Measure
 Go to the Modeling tab and select "New Table"
 Create the AverageRevenuePerState:
 Enter the following DAX formula to calculate the average revenue per state:
AverageRevenuePerState = SUMMARIZE(Orders,Orders[State],"Average Revenue”, AVERAGE(Orders[Revenue]))

Step 2: Create a Calculated Column to Categorize States

 Next, create a calculated column to classify states as profitable or non-profitable based on theaverage
revenue.
1. Go to the Modeling tab and select "New Column".
2. Create the ProfitabilityStatus Column:
 Enter the following DAX formula to create a column that categorizes states asprofitable or non-
profitable:
ProfitabilityStatus = IF(Orders[AverageRevenuePerState] > 75, "Profitable",
"Non-Profitable")
Step 3: Display the Results

Question 7: Dash Board

Department of ISE Page | 62

DATA VISUALIZATION LAB BCSL504

Program10 : Analysis of GDP dataset: GDP by Country per Year_data.xlsx

Solution:
Question 1: Visualize the countries data given in the dataset with respect to latitude and longitude along with
country name using symbol maps.
Step 1: Load Data set GDP by Country per Year_data.xlsx into Power BI
Step 2: Click on Report View
Step 3: Select Map from Visualization Panel

Step 4: Select Latitude and Drop on Latitude field in Visualization pane

Step 5: Select Longitude and Drop on Longitude field in Visualization pane
Step 6: Select Country and Drop on Legend field in Visualization pane
Step 7: Select Total GDP and Drop on ToolTips field in Visualization pane
Step 8: Click Format Visual->Legend->Options->Position Select Center Right
Step 9: Click Format Visual->Legend->Options->Text Select Font Bold

Department of ISE Page | 63

DATA VISUALIZATION LAB BCSL504

Question 2: Create a bar graph to compare GDP of Belgium between 2015 – 2020.
Step 1: Select Table from Visualization pane
Step 2:Drag and Drop Country, 2015,2016,2017,2018,2019,2020 into Columns
Step 3:Click on Down Arrow and Select Don’t Summarize
Step 4: Select Slicer from Visualization Pane
Step 5: Drag and Drop Country Field onto Field in Visualization Pane
Step 6: In Filter pane Select Basic Filtering ->Select India, Belgium,China..
Step 7: Select Bar Chart from Visualization Pane
Step 8: Drag and Drop 2015,2016,2017,2018,2019,2020 into Y-Axis
Step 9: Format the Bar Chart

Question 2: Using pie chart, visualize the GDP of India, Nepal, Romania, South Africa, Singapore by the year
2010.
Step 1: Drag and Drop Country field to Filter panel
Step 2: Click on Pie Chart in Visualization Panel
Step 3: Drag and Drop 2010 field from Data panel to Value field in Visualization
Step 4: Under Filter->Country -> Basic Filter Select the Countries India, Nepal, Romania, South
Africa, Singapore
Step 5: Under Visualization Panel select Format Visual and format Chart Title , Colors

Department of ISE Page | 64

DATA VISUALIZATION LAB BCSL504

Program 11: Analysis of HR Dataset:

Dataset Required : HR Analytics [Link]
Question 1: Create KPI to show employee count, attrition count, attrition rate, attrition count, active employees, and
average age.
Step 1: Right Click on HR Analytics Data in Data panel and select New Measure
Step 2: Create New Measure Employee_Count Enter the Formula
Employee_Count = COUNT('HR Analytics Data'[EmployeeNumber])
Step 3: Create New Measure Attrition Count Enter the Formula
Attrition Count = COUNTROWS(FILTER('HR Analytics Data','HR Analytics Data'[Attrition]="Yes"))
Step 4: Create New Measure Attrition Rate Enter the Formula
Attrition Rate = DIVIDE([Attrition Count],[Employee_Count],0)
Step 5: Create New Measure Active Employees Enter the Formula
Active Employees = [Employee_Count] - [Attrition Count]
Step 6: Create New Measure Average Age Enter the Formula
Average Age = AVERAGE('HR Analytics Data'[Age])
Step 7: Create Different KPI for above Created Measures
Select KPI card in the Visualization->drag and drop the Employee_Count to values in visualization
pane and Employee Count field on to Target Axis. Format your visuals of your style
Repeat the Step 7 for all the Measures Created above

Question 2: Create a Lollipop Chart to show the attrition rate based on gender category.
Step 1: Select Line and Stacked Column Chart from Visualization Pane
Step 2: Drag and Drop Gender Field on to X-Axis and Employee_Count Measure on to Column Y-Axis
Step 3: Drag and Drop Attrition Rate Measure to Line Y-Axis
Step 4: Format the Graph

Question 3: Create a pie chart to show the attrition percentage based on Department Category
Step 1: Select Pie Chart from Visualization Pane
Step 2: Drag and Drop Department Field onto Legend
Step 3: Drag and Drop Attrition Count Measure onto Values
Step 4: Format the Pie Chart
Adjust Colors:
 Go to the Data Colors section in the Format pane.
 Customize colors for each department by clicking on the color next to the department name and
choosing the color you prefer.
Edit Labels:
 Customize the text in the labels, using Data Label formatting options to adjust font size, color,
and display units.

Department of ISE Page | 65

DATA VISUALIZATION LAB BCSL504

Question 4: Create a Bar Chart to display the number of employees by Age group,
Step 1: Select Age Field in Data Pane, Right Click->New Group
Step 2:Select Bar Chart, Drag and Drop Age (Bin) onto Y-Axis and Employee_Count Measure onto
X-Axis
Step 3: Format the Chart

Question 5: Create a highlight table to show the Job Satisfaction Rating for each Job role based on employee count.
Step 1: Select Matrix visual from the Visualizations pane.
Step 2: Drag and Drop the Job Role field to Rows
Step 3: Drag and Drop the Job Satisfaction Rating field to Columns
Step 4: Drag and Drop the Employee Count measure to Values
Step 5: Format the Matrix Visual

Question 6 : Create a horizontal bar chart to show the attrition count for each Education field Education field wise
Step 1: Select Clustered Bar Chart / Stacked Bar Chart from the Visualizations pane.
Step 2: Drag and Drop the Education field to Y-Axis
Step 3: Drag and Drop the AttritionCount Measure to X-Axis
Step 4: Format the Clustered Bar Chart / Stacked Bar Chart

Department of ISE Page | 66

DATA VISUALIZATION LAB BCSL504

Question 7: Create Multiple Donut Chart to show the Attrition Rate by Gender for different Age group.
Step 1: Choose Donut Chart from Visualization pane
Step 2: Drag and Drop Gender to Legend
Step 3: Drag and Drop Attrition Rate Measure onto Value.
Step 4: Drag and Drop Age (Bin) into Filter pane
Step 5: Select Basic Filter and Check Numbers less than 30
Step 6: Format the Chart Title as Attrition Rate Under 30
Step 7: Repeat Step 1 and 6 for creating Donut Chart for Attrition Rate Grater than 30

Department of ISE Page | 67

DATA VISUALIZATION LAB BCSL504

Program 12: Analysis of Amazon Prime Dataset:

Question 1: Create a Donut Chart to show the percentage of Movie and TV shows
Step 1: Choose Donut Chart from Visualization pane
Step 2: Drag and Drop Type Field onto Legend
Step 3: Drag and Drop Show_Id or Title Field onto Values
Step 4: Use Basic Filters in filter pane for filtering Movie and TV show.
Step 5: Format the Donut Chart

Question 2: Create a Area Chart to shows by release year and type.

Step 1: Choose Area Chart from Visualization pane
Step 2: Drag and Drop Release Year Field onto X-Axis
Step 3: Drag and Drop Drag the Title Field onto Y Axis
Step 4: Drag and Drop Drag the Type Field onto Legend
Step 5: Use Basic Filters in filter pane for filtering Movie and TV show.
Step 5: Format the Area Chart

Question 3: Create a horizontal bar chart to show Top 10 genre

Step 1: Select listed_in Field->rightClick->Rename Rename the column Genre
Step 2: Choose Bar Chart from Visualization Pane
Step 3: Drag and Drop the Genre Field to the X-Axis
Step 4: Drag and Drop the Title Field onto Y-Axis.
Step 5: In the Filters pane, filter the Top N to display the Top 10 Genres.
Step 6: In Filters Pane under By Value , Drag and Drop Title field
Step 7: Change the Aggregation as Count of Title
Step 8: Click on Apply Filter
Step 9: Format the Bar Chart

Department of ISE Page | 68

DATA VISUALIZATION LAB BCSL504

Question 4: Create a map to display total shows by country.

Step 1: Choose Filled Map from Visualization Pane
Step 2: Create a new Measure as
Count_showid = count(amazon_prime_titles[release_year])
Step 3: Drag and Drop the Country field to the Location
Step 4: Select Count_showid Field on Data Pane

Question 5: Create a text sheet to show the description of any movie/movies.

Step 1: Select Table from the Visualization Pane
Step 2: Drag and Drop the Title and Description Field onto Columns

Department of ISE Page | 69

DATA VISUALIZATION LAB BCSL504

Question 6: Build an interactive Dashboard

Step 1: Create New Measure for Counting Number of Countries
Step 2: Create New Measure for Counting Number of Ganre
Step 3: Insert 3 Slicer
 For Ganer
 For Duration
 For Country

Department of ISE Page | 70