Guided Project — Data Prep in Tableau

  • Guided Project
  • 0.3 hours
  • Beginner
  • Tableau

Practice connecting to data, importing tables, and defining relationships in Tableau to prepare data models for analysis.

Overview

In this project, you'll take on the role of a data analyst working for Dataquest to prepare data for analyzing their online learning platform. You'll connect to an Excel file containing three key tables capturing student engagement, course performance, and content completion rates. Your challenge is to import these tables into Tableau and define the relationships between them to create a unified data model enabling insights into the platform's effectiveness. You'll get hands-on practice with essential data preparation steps in Tableau, building a well-structured foundation for data visualization and analysis. By the end of the project, you'll have a robust data model ready for generating insights on how students interact with the platform and perform in courses, informing future content strategy and platform enhancements. Objective: Prepare Dataquest's online learning platform data using Tableau to enable analyzing student engagement and course effectiveness, by connecting to data, importing tables, and defining table relationships.

What You'll Learn

  • Connect to an Excel file containing three tables on website usage
  • Import the three tables into a data model in Tableau
  • Configure the relationships between the three tables in Tableau

Before You Start

  • Connecting to data sources in Tableau to access the required data
  • Importing data tables into the Tableau canvas
  • Defining relationships between tables in Tableau to combine data
  • Cleaning and filtering imported data in Tableau to prepare it for use

Project Steps

7 steps

  1. 1 Introduction
  2. 2 Connect the Dataset
  3. 3 The Three Data Tables
  4. 4 Import Your First Table
  5. 5 Import and Connect Your Second Table
  6. 6 Import and Connect Your Third Table
  7. 7 Review

Join 1M+ data learners on Dataquest.

  1. 1

    Create a free account

  2. 2

    Choose a learning path

  3. 3

    Complete exercises and projects

  4. 4

    Advance your career