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. Add extra column in Table. Column name Total sales, It should contains sum of all amount.

Product	Category	Sales Amount
Pen	Stationery	100
Pencil	Stationery	80
Notebook	Stationery	200
Chips	Snacks	150
Biscuits	Snacks	120
Juice	Drinks	180

4. 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)

5. 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