Power BI Questions $($Taxation$)$

$3/3$

Question $2$

Further to Question $1,$ management now wants you to use Power BI to further analyze

the product and sales information you have imported to identify the GST errors in

Northern$$s sales system.

Required:

i$.$ Create a table visualization of all products and their applicable tax rate.

ii$.$ Create a table visualization that shows all products with a tax rate greater than $5\%.$

iii. Create a table visualization that shows the total sales and total GST collected on

products using incorrect tax rates.

iv$.$ Create a table visualization that shows the amount that should have been collected

using the correct $5\%$ rate.

v$.$ Create a table visualization that shows the calculation of the known GST error