Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started