Twelve spreadsheets replaced by one screen — a yearly report.

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.

This project helped me improve my skills in Power BI, work with real-world data, and deal with challenges related to data collection, cleaning, organization, and visualization.