Visualization Assignment in Power BI

Provide the firm with insight into their financial performance using various visualization techniques. Using visualizations available in the Power BI online service, create a fourpage report (one page for each number below) to provide insight into the following business questions.

a) carefully implement the requirements as described below

b) include a visualization title and axis titles

c) include data labels for your visualizations

1. What are the total transaction amounts for the four quarters of 2018 for each of the scenario’s (i.e., actual, budgeted, and forecasted).

-Create one chart and one table that shows the actual, budgeted, and forecasted total transaction amounts for the four quarters of 2018

 Create a slicer that allows the selection of one or more regions to display in the chart and table.

1. What are the actual scenario total transaction amounts recorded for each region in 2018?

 Create one chart that shows the total transaction amounts based on their geographical location. The chart should display a bubble proportional to the total transaction amount for the region.

 Create a slicer that allows the selection of one or more departments to display in the chart.

1. Which region has the largest budgeted scenario total transaction amount, and which department within each region has the largest portion of the budgeted total transaction amount?

 Create one chart that shows the total budgeted transaction amount for each region and the portion of the total associated with each department within that region.

 Create a slicer that allows the selection of one or more quarters to display in the chart.

1. During which months between January 2018 and August 2018 does the budget variance percentage (BVP) exceed 15%? The BVP has been calculated for you; however, BVP is calculated as the difference between the actual total transaction amount and the budgeted total transaction amount divided by the budgeted total transaction amount.

 Create one chart that shows the budget variance percentage for each month.

 Create one table that shows the table view of the data in the chart.

Sample Solution