The year as the numbers tell it — a yearly report that gives a clear view of revenue performance all year long.

A revenue dashboard that breaks down the data by category across the four quarters of the year. The dashboard shows revenue, total beds, total persons, and the average for each category.

This project was an extension of a previous dashboard I created. After reviewing the first dashboard, the team requested more detailed insights and additional information, so I developed this version to meet those requirements.

I chose this case because we were facing some challenges finding the correct numbers and getting clear insights from the sales team.

The data was collected from several Excel sheets. The data was not ready for analysis and was spread across different files, so I gathered everything, cleaned and organized the data, and then created a final dataset containing the information I needed.

Most of the data was numerical, which made it suitable for further analysis and comparison.

I used Excel to store and organize the data, Python for data processing and cleaning, and Power BI to build the dashboard and visualize the results.

After reviewing the dashboard, we found that some categories needed more attention and further analysis.

Through this project I improved my Power BI skills and learned more about working with real-world data, including running into data problems and finding solutions for them during the analysis.