1. Introducing the Dataset

 
Subtitles Enabled

Sign up for a free trial to access more free content.

Free trial

Reshaping Data in Tableau Prep

7 lessons , 3 exercises

Preview Course

Overview

This lesson introduces the datasets that we will be using in this course. All datasets relate to the fees generated by a pharmaceuticals company distribution company.

Summary

Lesson Goal

Examine the data and determine data cleaning steps required

Reorganizing sales data

In this course, we’ll work with new data from the pharmaceutical company Alvetica. In this lesson, we investigate the company’s sales data.

The data is spread across 5 Excel files, one for each year between 2012 and 2016. Within each Excel file, there are 4 sheets, one for each of the products: Lomina, Samtan, Tridesta, and Wedicare. In total, we have 20 separate datasets.

In this course, we’ll demonstrate how to combine all 20 into a single dataset and we’ll then combine this master sales dataset with the customer address dataset from the previous Tableau Prep course.

Transcript

> Tableau Tableau for data visualization
Reshaping Data in Tableau Prep

Contents

My Notes

You can take notes as you view lessons.

Sign in or start a free trial to avail of this feature.

Free Trial

Download our training resources while you learn.

Sign in or start a free trial to avail of this feature.

Free Trial