Practical Questions

 Practcal Exam Questions of Data Visualization using Power BI

1. Students Data, display subject and marks in Pie chart.

Student Name

Subject

Marks

Aditi

Math

85

Aditi

Science

78

Rahul

Math

90

Rahul

Science

88

Sneha

Math

70

Sneha

Science

75

2. Sales Data, Display Category and sales amount in Funnel chart.

Product

Category

Sales Amount

Pen

Stationery

100

Pencil

Stationery

80

Notebook

Stationery

200

Chips

Snacks

150

Biscuits

Snacks

120

Juice

Drinks

180

3. Import CSV data display sales and region in Stacked Column Chart.

Product,Region,Sales,Quantity,Date

Laptop,West,50000,2,01-01-2024

Mobile,East,20000,3,02-01-2024

Tablet,South,15000,1,03-01-2024

Laptop,North,45000,2,04-01-2024

Mobile,West,25000,4,05-01-2024

4. Import CSV data, 

    a. Display name and marks in Stacked column chart.

    b. Display Subject and Marks in Pie Chart

    c. Total Marks of all student in Card visual.

Name,Subject,Marks,City

Rahul,Maths,78,Pune

Sneha,Science,85,Mumbai

Amit,Maths,65,Nagpur

Priya,Science,90,Pune

Rohit,Maths,88,Mumbai

5. Removing Duplicates & Handling Missing Values

Name,Marks,City

Rahul,80,Pune

Sneha,90,Mumbai

Amit,,Nagpur

Rahul,80,Pune

Priya,85,

Rohit,70,Mumbai

  •  Display Clustered Bar Chart with name and marks.
  •  Display Pie Chart with city, name


6. Import data and handle missing values and duplicate duplicate entries.

ProductQuantityCategory
Laptop15Electronics
Mobile25Electronics
Chair(Missing)Furniture
Laptop15Electronics
Table12(Missing)
Sofa8Furniture
  •  Display Stacked column chart with Product vs Quantity
  •  Display Funnel Chart with Products by Category


7. Import data and visualize the data.

StudentIDFull NameDOBPercentageCity-State
101Rahul Sharma15-08-200382.5Pune-MH
102Sneha Patil22-01-200491Mumbai-MH
103Amit Verma10-12-200378Nagpur-MH

Perform the following operations using Power Query Editor:

  1. Change StudentID data type to Whole Number.
  2. Change DOB data type to Date.
  3. Rename Percentage column to Marks.
  4. Split City-State into City and State using the "-" delimiter. 

  • Display Full Name and Marks in Clustered Bar Chart.


8. Customer Data

Customer IDCustomer NameAgeMobile NoIs Premium
C101Rahul Sharma229876543210TRUE
C102Sneha Patil219123456789FALSE
C103Amit Verma239988776655TRUE

Perform the following operations using Power Query Editor:

  1. Change Age data type to Whole Number.
  2. Change Mobile No data type to Text.
  3. Change Is Premium data type to True/False.
  4. Rename Customer Name to Name.
  5. Rename Is Premium to Premium Customer.
  6. Display Name and Age in a Clustered Bar Chart.


9. Create Custom Columns and Transform Data using Power Query Functions.

a) Example 1: Monthly Expenses

MonthFoodTransportRent
January6000200012000
February5800220012000
March6200210012000
April6500230012000

Perform the following operations using Power Query Editor:

  1. Create a custom column Total Expense = Food + Transport + Rent.
  2. Rename Food to Food Expense.
  3. Display Month and Total Expense using a Line Chart.

b) Example : Library Books

BookCopiesPrice
Python25450
Java18500
SQL20400
C++15350

Perform the following operations using Power Query Editor:

  1. Create a custom column Inventory Value = Copies × Price.
  2. Rename Copies to Available Copies.
  3. Display Book and Inventory Value using a Donut Chart.


10. Design basic visualizations using Bar, Column, Line, and Pie Charts.

a) Example 1: Monthly Sales Report

MonthSales Amount
January45000
February52000
March48000
April60000
May55000
June68000

Perform the following tasks:

  1. Import the data into Power BI.
  2. Change Sales Amount data type to Whole Number.
  3. Rename Sales Amount to Monthly Sales.
  4. Design a Line Chart to show the monthly sales trend.
  5. Design a Clustered Column Chart to compare monthly sales.

Visuals to Create:

  • Line Chart
  • Clustered Column Chart

b) Example 2: Product Sales Distribution

ProductUnits Sold
Laptop120
Mobile180
Tablet90
Printer60
Monitor75

Perform the following tasks:

  1. Import the data into Power BI.
  2. Change Units Sold data type to Whole Number.
  3. Rename Units Sold to Total Units Sold.
  4. Design a Clustered Bar Chart to compare product sales.
  5. Design a Pie Chart to show the percentage contribution of each product to total sales.

Visuals to Create:

  • Clustered Bar Chart
  • Pie Chart


11. Format and customize visualizations using colours, labels, and themes.

a) Example 1: Sales Report

Question

Create a Clustered Column Chart to display the sales of different products. Format the chart by changing colors, adding data labels, and applying a theme.

ProductSales
Laptop85000
Mobile65000
Tablet40000
Printer30000
Monitor45000


b) Example 2: Student Marks Report

Question

Create a Pie Chart to display student marks. Customize the chart using colors, category labels, percentage labels, and a theme.

StudentMarks
Rahul85
Sneha92
Amit78
Priya88
Neha67


12. Create relationships between multiple tables in the data model and represent data in visual forms.

a) Example 1: Sales and Customer Tables

Table 1: Sales

SaleIDCustomerIDProductAmount
1C101Laptop50000
2C102Mouse800
3C101Keyboard1500

Table 2: Customers

CustomerIDCustomerNameCity
C101RahulPune
C102PriyaMumbai


b) Example 2: Orders and Products Tables

Table 1: Orders

OrderIDProductIDQuantity
101P12
102P21
103P13

Table 2: Products

ProductIDProductNamePrice
P1Laptop50000
P2Printer12000




Use Model View

Students

Student ID

Student Name

1

Aditi

2

Rahul

3

Sneha

Marks

Student ID

Subject

Marks

1

Math

85

1

Science

78

2

Math

90

3

Math

70

Create Visual of Table Visual

  • Student Name (from Students table)
  • Marks (from Marks table)

4. Use Model View

Table 1: Customers

Customer ID

Customer Name

1

Amit

2

Neha

Table 2: Orders

Order ID

Customer ID

Amount

101

1

500

102

1

300

103

2

700

Create visual of Table Visual:

  • Customer Name
  • Amount

Comments

Post a Comment

Popular posts from this blog

UNIT I Introduction To Data Visualization

Image
  UNIT I: Introduction To Data Visualization 1.     Definition and Importance of Data Visualization Data Visualization is the process of presenting data in a visual or graphical form such as charts, graphs, maps, and diagrams . It helps to convert large and complex data into a format that is easy to understand and analyze . By using visual elements, data visualization allows users to quickly identify patterns, trends, and relationships in the data. Instead of reading large tables of numbers, people can easily understand information through visual representations. Data visualization is widely used in business, research, education, and data analysis to communicate information clearly and effectively. Importance of Data Visualization Data visualization is important because it helps people understand and analyze data more effectively. Some important points are: 1. Simplifies Complex Data Large datasets can be difficult to understand in raw form. Visual...
Read more

UNIT III : Designing Effective Visualization

  UNIT III : Designing Effective Visualization 1.     Principles of Good Visualization Design Data visualization is the process of presenting data in graphical form such as charts, graphs, and maps. The goal of good visualization is to communicate information clearly, accurately, and efficiently .     Principles of Good Visualization Design 1. Clarity Definition: Clarity means the visualization should be simple and easy to understand. Key Points: Use clear titles and labels Keep design clean and simple Avoid unnecessary elements Example: A bar chart showing marks should clearly display subject names and values. 2. Accuracy Definition: Accuracy means representing data correctly without misleading the viewer. Key Points: Use correct scale and proportions Do not manipulate axes Show actual data values Example: If one value is twice another, the visual representation should refle...
Read more