Lab 5 Use #Tableau to Analyze #Twitter Data in #MongoDB
Channel: LBSocial
Date: 22/01/2021

Objectives:
• To get familiar with the NoSQL database
• Learn how to visualize Twitter from the MongoDB database

Data: 
• Twitter data in MongoDB Atlas
Steps:
1. Open Tableau Desktop and connect to the MongoDB Atlas cluster. Connection info is posted on Canvas. Compare how Twitter is organized in MongoDB and in Tableau. 
1.1. Hide the unnecessary fields
1.2. Split the create_at field
1.3. Create a date filed
1.4. Optional: Create a time filed
1.5. Optional: Create a DateTime filed
1.6. Create a latitude field and a longitude field
2. Create a dashboard that contains the following charts with necessary legends and filters: 
2.1. A word cloud showing the number of hashtags
2.2. A bar chart showing the usernames sorted by the number of tweets 
2.3. A line chart showing the number of tweets posted over time
2.4. A map showing the number of tweets in different locations
3. Export the dashboard as a PNG file.