Tableau Network map and Path functionality

I know Tableau very well however I have stuck in - Tabeau Path creating (Source city and destination city) and - Network map (displaying social graph) All i need to learn is how to prepare a data for Tableau so i can start creating above dashboard. i know lot about Tableau however i find difficulties using above functions. I dont want to use R or any third party software so please make data preparation either in excel or access. Only one Hour training is required online. I have my dataset available which is easy for you to understand. Happy to take one on one training.