From the course: Tableau Certified Data Analyst Cert Prep

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Using pivots

Using pivots - Tableau Tutorial

From the course: Tableau Certified Data Analyst Cert Prep

Start my 1-month free trial Buy for my team

Using pivots

“

- [Instructor] If you recently watched chapter one on how to prepare data in Tableau Desktop, you may recall this bad boy of an Excel file. Beautiful design, but awful for using in Tableau. Let's see if we can restructure it to a usable data source in Tableau Prep Builder. In Tableau Prep Builder, we connect to the Excel file called KinetEco_Pivot. If we open this, Tableau automatically inserts an input step for us. The first thing you may notice is that all fields are simply numbered F1 through F11, with mostly null as a preview value. Let's try using the data interpreter again. You can find that on the left hand side. Again, the data interpreter carries the hint that it might be able to clean your Microsoft Excel workbook. I repeat, the data interpreter is not a perfect solution or silver bullet, and ideally you shape your data into a usable structure before connecting to it with a Tableau product, but I know that this is not always feasible. If it was, I wouldn't be recording this…

Contents