Finance Analysis Dashboard in Power BI
Originally published: 25/08/2021 10:03
Publication number: ELQ-43271-1
View all versions & Certificate
certified

Finance Analysis Dashboard in Power BI

Finance Analysis Dashboard in Power BI

Description
Power BI is a tool which helps the users to easily visualize dynamic and interactive Reports/Dashboard by utlilizing its Business Intelligence capabilities. Power BI is a tool which makes the decision making easier as it offers a wide range of interactive visualizations along with busniess intelligence capabilities.

This Finance Analysis Dashboard is been designed to provide an overall view of the performance of the Finance Department which would be helpful for the top management to make their decisions based on the performance of the Finance Department.

This Dashboard shows total number of units sold, total sales, total COGS & total profit. Further, various slicers are provided like Years, Months, Country, Product, Segment & Discount to filter out & drill down the required information.

This Dashboards includes the following features:

• At a glance, Country wise performance can be analyzed through Matrix Visual.
• Visuals are used from App Source (Enlighten World Flag)
• Gauge Visuals are been used by mentioning maximum and target value
• Percentage values are calculated by using the CALCULATE & ALL function.

Further, the targeted audience of this dashboard is the managment which in a glance will get to know that which countries,segments or products are performing well and which segments or products requires improvement. For example, this dashboard shows that the Enterprise Segment's COGS is higher than its sales which is point of concern for the management.

This Best Practice includes
1 Power BI File

MOHAMMAD SAAD NAYYAR offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Finance Analysis Dashboard In Power BI?

The user community and author are here to help. Go ahead!


4.7 / 5 (3 votes)

please wait...