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
- 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.
- 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.
- 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.
- 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
pplicable to non-EU family members in Art 6 (2). Directive 2004/38 establishes the rights of family members to reside with a Union worker. In terms of his rights to free movement as a family member, under Art. 9 (2)of the Directive , he is required to apply for a residence card not more than 3 months from his arrival in the Member State. Residence cards are valid for at least 5 years which would still be in date if he had applied for it. However, the facts do not suggest that Luis has applied for his residence card. Non EU family members who have lived with a Union citizen in the host Member State for 5 years can acquire the right to permanent residency under Art. 16 subsection 2 of the Directive 2004/38 . The right to âreside on the basis of this directive in the host Member State and enjoy equal treatment of the nationals of that Member Stateâ under Article 24 (1) of Directive 2004/38 is extended to family members who have the right of residence which Luis does. Under Art. 20 TFEU , Bjarne is an EU citizen as he is a Swedish national. He also comes under the definition of a âfamily memberâ to Charlotte in Article 3 (2) (a) of the Directive 2004/38 . He is 11 years old and has learning difficulties which means he is a âdependant direct relativeâ of Charlottes under Article 3 (1) (d) . As he is an EU citizen, he is also entitled to free movement. He has the right of residence in any Member State for up to three months without any conditions. He has been able to stay for the 4 years as he is a dependant family member of Charlottes which means he has the right to stay in London as long as she is. He is entitled to all the rights set out in Article 20 (2) TFEU and 21 TFEU . Most importantly, Bjarne is entitled to equality in terms of social right under the Regulation 492/2011 which means he is entitled to go to the special needs school. Article 18 TFEU prohibits any discrimination on the grou>
pplicable to non-EU family members in Art 6 (2). Directive 2004/38 establishes the rights of family members to reside with a Union worker. In terms of his rights to free movement as a family member, under Art. 9 (2)of the Directive , he is required to apply for a residence card not more than 3 months from his arrival in the Member State. Residence cards are valid for at least 5 years which would still be in date if he had applied for it. However, the facts do not suggest that Luis has applied for his residence card. Non EU family members who have lived with a Union citizen in the host Member State for 5 years can acquire the right to permanent residency under Art. 16 subsection 2 of the Directive 2004/38 . The right to âreside on the basis of this directive in the host Member State and enjoy equal treatment of the nationals of that Member Stateâ under Article 24 (1) of Directive 2004/38 is extended to family members who have the right of residence which Luis does. Under Art. 20 TFEU , Bjarne is an EU citizen as he is a Swedish national. He also comes under the definition of a âfamily memberâ to Charlotte in Article 3 (2) (a) of the Directive 2004/38 . He is 11 years old and has learning difficulties which means he is a âdependant direct relativeâ of Charlottes under Article 3 (1) (d) . As he is an EU citizen, he is also entitled to free movement. He has the right of residence in any Member State for up to three months without any conditions. He has been able to stay for the 4 years as he is a dependant family member of Charlottes which means he has the right to stay in London as long as she is. He is entitled to all the rights set out in Article 20 (2) TFEU and 21 TFEU . Most importantly, Bjarne is entitled to equality in terms of social right under the Regulation 492/2011 which means he is entitled to go to the special needs school. Article 18 TFEU prohibits any discrimination on the grou>
