You can take a join in tableau.
Are you looking to change your data structure?
yeah think i need to change my tables to dims and facts
Thanks for sharing your table details here. My advice before you make any arrangement changes to your data, come to the business questions that you are trying to solve. List them all. Then you can actually reduce the number of tables. In case you are not doing any hourly analysis then you can use your table which aggregate the data at the daily level.
If you have any specific business question to solve you can list them down here in case you are specifically looking for restructuring for those. Without any requirement or the target no one can suggest you best data design.