I am wondering how good is Prefect to visualize the location data. I have a dataset that has the lat and lon of vehicles collected by IoT devices and want to visualize their route on the map. Currently I did it in Tableau using free trial, and it is costly to buy the licenses. I have 2-3 stakeholders who would use the dashboard for now. Should I use the free plan of Preset for this use case?

You would still need a visualization tool to create your data. Something like Plotly, perhaps. Prefect is a Python package that could help you make sure your data flows to your visualizations on a schedule and notify you if things go wrong. Check out docs.prefect.io if that sounds like something useful.