In my DAVA project, I and my groupmates made a dashboard from raw data. There were many problems in the data, and I identified problems in the data, then I did preparations and transformations to the data. Besides preparing the data for research, I also created a data dictionary of all the data – the prepared and transformed data along with the newly derived variables.
On the other hand, I also worked on a hotel booking dataset to figure out trends inside
To use the HOTEL_BOOKINGS dataset to perform data preparation work and gather insights such as when is the best time of year to book a hotel room? The optimal length of stay to get the best daily rate.
To apply Linear Regression to predict the total number of special requests for the Hotel Booking Analytics project.
Raw data in KNIME Analytics Platform
Prepared data in KINME Analytics Platform
I learned to use KNIME and Power BI in Data Visualisation and Data Analytics. I used KNIME to clean the data and gather insights. And use Power BI to create charts and Dashboard. Work submitted includes workflow, charts and dashboard. We needed to create a diagram to help us find the relationship between two different variables. We learned many different diagrams in Temasek polytechnic and we would use them to compare different variables in situations like this. Data can be shown in a different format so we must clean the data before analysing it.
LOMA: We learn about many different formulas and one of them was the recursive formula we use all these formulas to find a pattern in the data and to predict what might be the outcome in the future.
KNIME
Microsoft Power BI
Logic and Mathematics