Power BI Dashboards
- Project 1: Revenue Reporting Dashboard
Objective:
To create a comprehensive dashboard presenting revenue metrics such as Revenue Added Yesterday, Revenue by Month & Station, and Revenue by Industry, helping stakeholders analyze trends and make data-driven decisions.
Process Details:
As per requirements, we connected to the SQL Server database and accessed a view containing all the required data. In this project, we created a dashboard using a standard background image with specific colors, a company logo, and the report name to maintain a consistent look and feel across all report tabs. Standard filters were added to allow users to filter data in visuals easily, along with a "Clear all filters" button to reset the selections.
Each report tab primarily used tables, matrix, and a combination of bar and line charts to present the data effectively.
In the first tab, which focuses on current month metrics, we presented advertiser-wise revenue added yesterday using a table. For market-wise revenue, we used a bar and line chart to compare data for 2020, 2022, the current year, and forecasted values. This allows users to analyze current revenue in comparison to past performance and future forecasts.