From the course: The Data Skills Survival Kit

Unlock this course with a free trial

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

Using Pivot Column to look at Text data in a pivot

Using Pivot Column to look at Text data in a pivot

From the course: The Data Skills Survival Kit

Start my 1-month free trial Buy for my team

Using Pivot Column to look at Text data in a pivot

“

- [Instructor] You know, pivots are pretty important, pivot tables, pivot tools, pivot displays, crosstabs. When you're a data professional, which everybody one day will be, you're going to be reading pivot displays, and sometimes, there's no better way to see our data than to leverage pivot column, so here's our scenario. I could go pivot this agenda data and list out and count speakers and see if we have coverage. I could map it all out with a pivot table. I mean, it doesn't take very long to see. I can go click analyze data, and it can begin to do these speaker counts, gimme my session title. That's fantastic, but I want to produce a schedule, and I can't do that with a regular pivot table, but I can absolutely do it with Power Query and pivot column. Okay, so I'm going to go to the data tab, and I'll choose from table range. Going to pick up all my agenda data. This is such a quick and effective technique, it's just…

Contents