Live Training: Where is Will? Exploring Cell Phone Data in Tableau

WebinarAugust 2022

Using a real-world data snapshot of cell phone data, we’ll extract useful and interesting insights from the daily routines of a mobile phone user, Will. We’ll use EDA and mapping techniques to find out more about Will’s whereabouts, including his home, office, commute, and holiday itineraries.

Key Takeaways:

Prepare mobile phone data for EDA
Use Tableau visualizations to discover insights on the daily routines of a mobile phone user
Use storytelling techniques to create a narrative

Materials:

Install Tableau Public
Download Session's Dataset

Summary

The live training session on Tableau and exploratory data analysis presented an interesting case study based on real-world cell phone data of an Australian journalist. The data, spanning from 2014 to 2015, offered insights into the journalist's daily routines, including his home and work locations, commutes, and holiday itineraries. Through a detailed examination using Tableau, attendees learned to link data sets, perform basic data quality checks, and create visualizations such as maps and timelines to extract meaningful insights. The session also pointed out the implications of data privacy, as the data revealed personal details of the journalist’s life, such as his work schedule, travel habits, and personal communications. Martin Van Den Broek, the presenter, guided attendees through the technical process of linking to a data source, cleaning data, and creating interactive dashboards, emphasizing the importance of data visualization in storytelling. The session concluded with a discussion on the differences between Tableau and Power BI, and how both tools can be used in data analysis projects.

Key Takeaways:

Understanding the application of exploratory data analysis using real-world cell phone data.
Learning to perform basic data quality checks and data cleaning in Tableau.
Using maps and timelines to visualize data and extract insights into personal routines.
Recognizing the implications of data privacy through metadata analysis.
Exploring the differences and comparative benefits of Tableau versus Power BI.

Deep Dives

Exploratory Data Analysis with Tableau

Using a dataset derived from an Australian journalist's cell phone usage, the training session explored the basics of exploratory data analysis with Tableau. Attendees learned how to connect to a CSV data source within Tableau, ensuring proper data formatting and addressing common issues such as string recognition of numeric data due to locale settings. Through a series of practical exercises, attendees were shown how to create visualizations, such as line and bar charts, to analyze data trends over time. Martin emphasized the importance of visual storytelling, stating, "Tableau allows you to tell stories using data, making complex information accessible and understandable." The session highlighted the usefulness of Tableau in visualizing data patterns, enabling users to make informed predictions about user behavior and patterns.

Data Privacy and Metadata Insights

The analysis of the journalist's cell phone data led to important discussions around data privacy. The dataset, rich with metadata, offered insights into the journalist's daily life, revealing his locations, communication patterns, and travel habits. Martin highlighted the potential of such data to uncover personal details, cautioning attendees about the ethical considerations of data analysis. "It's astounding how much you can deduce from metadata alone," Martin noted, illustrating how companies can unintentionally or intentionally capture and analyze personal data. This part of the training served as a significant reminder of the responsibilities that come with data analysis, urging attendees to be mindful of privacy laws and ethical practices.

Creating Interactive Dashboards

A considerable part of the training was dedicated to demonstrating the creation of interactive dashboards in Tableau. Attendees were guided through the process of combining multiple worksheets into a cohesive dashboard, allowing for flexible filtering and data exploration. By analyzing the journalist's location data, Martin demonstrated how to pinpoint his home and work locations, commuting patterns, and travel itineraries. The interactive nature of the dashboards enabled users to drill down into specific data points, offering a detailed view of the journalist's activities. Martin encouraged attendees to leverage Tableau's capabilities for their projects, commenting, "Interactive dashboards bring data to life, providing an intuitive way to explore and communicate complex information."

Comparative Analysis: Tableau vs. Power BI

The session concluded with an insightful discussion on the comparative strengths of Tableau and Power BI, two leading tools in data visualization. Martin, who has experience with both platforms, provided a balanced perspective on their capabilities. He noted that Tableau excels in ease of use and the ability to create detailed visualizations through a drag-and-drop interface, making it accessible to users with varying levels of technical expertise. In contrast, Power BI offers strong integration with other Microsoft products and features that facilitate more comprehensive data analysis within an organization. "Choosing between Tableau and Power BI often depends on the specific needs of your project and your existing technical environment," Martin advised, encouraging attendees to experiment with both tools to find the best fit for their analytical needs.