Question: a) As the data analyst, you are required to develop the prototype into a dashboard using Power BI. The dashboard will not only inform on

a) As the data analyst, you are required to develop the prototype into a dashboard using Power BI. The dashboard will not only inform on costs by behaviour, but also allow the management team to determine break-even batches based on proposed selling price per batch. The process to create the dashboard is broken into the following tasks: Task 1: Develop a visualization of total variable costs per unit and a visualization of total annual fixed costs using the Card function. Steps 1 and 2 Appendix Task 2: Develop a visualization that illustrates the variable costs using a bar chart and a visualization that illustrates the fixed costs using a bar chart. Steps 3 and 4 Appendix Task 3: Develop a visualization that illustrates the proportion of period and product costs for fixed costs using a pie chart and a visualization that illustrates the proportion of period and product costs for variable costs using a pie chart. Steps 5 and 6 Appendix

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!