Skip to content

Developed an advanced financial dashboard in Power BI utilizing DAX to compute key metrics such as Total Revenue and Average Revenue, featuring diverse visualisations including pie charts, Treemaps, and ribbon charts for comprehensive financial analysis.

Notifications You must be signed in to change notification settings

DC-x-2003/Financial-Analysis-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Financial-Analysis-Dashboard

This project involves the creation of an interactive financial dashboard using Power BI. The dashboard provides comprehensive insights into various financial metrics and visualizes the data through multiple chart types. It was designed to help stakeholders understand key financial trends and performance indicators.

Features

The dashboard includes the following measures computed using DAX:

  • Total Revenue
  • Average Revenue
  • Total Countries
  • Total Transactions

Visualizations

  • Pie Chart: Total Revenue by Region
  • Stacked Column and Line Chart: Total Revenue and Average Revenue by Country and Region
  • Treemap: Total Revenue by Stores
  • Area Chart: Total Revenue by Quarter
  • Ribbon Chart: Total Revenue by Products and Stores
  • Stacked Column and Line Chart: Total Revenue and Average Revenue by Month
  • Matrix: Sales and Revenue by Each Salesperson

Purpose

The purpose of this dashboard is to:

  • Provide a high-level view of financial performance across different dimensions.
  • Allow users to drill down into specific areas of interest.
  • Facilitate data-driven decision-making by presenting key metrics and trends visually.

Installation

To view and interact with the dashboard, follow these steps:

  • Clone this repository to your local machine.
  • Open the project in Power BI Desktop.
  • Ensure your data sources are correctly linked.
  • Refresh the data to populate the dashboard with the latest information.

Usage

Once the dashboard is open in Power BI Desktop:

  • Use the slicers and filters to explore the data.
  • Hover over the visualizations for detailed insights.
  • Analyze the trends and patterns displayed through the various charts.

Contributing

If you'd like to contribute to this project, please fork the repository and use a feature branch. Pull requests are warmly welcome.

About

Developed an advanced financial dashboard in Power BI utilizing DAX to compute key metrics such as Total Revenue and Average Revenue, featuring diverse visualisations including pie charts, Treemaps, and ribbon charts for comprehensive financial analysis.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published