Tembo Hotel had been tracking all of their bookings in Excel, but the data had grown messy over time inconsistent formatting, duplicate entries, and mixed date formats made it impossible to get reliable answers out of it. I was tasked with cleaning the dataset and turning it into something the CEO could actually use to understand the business.
Here's how I approached it, from raw CSV to a working Power BI dashboard.
The cleaning process started by deleting duplicates .
Then standardization values and trimming to remove extra space.
the changing the data format and data type from text to data
after the cleaning process is over I loaded the clean data on table which I will use for analysis.
The CEO wanted to know about his business . Analysis started by answering major business questions
ANALYSIS
- Revenue analysis
- Guest insighs
- staff performance
- Cancellation and revenue lost
One of the more important findings: a meaningful share of potential revenue was lost specifically to cancellations, concentrated in certain room types more than others.
I created it as view so that it so that it could be easy to import then on power bi for visulation
Presenting the outcome
- Dashboard
2.The revenue analysis
- Guest insight
- cancelation and revenue lost on it .
REPORT
Top comments (0)