From the course: Excel PivotTables: Real-World Case Studies

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Wine tasting results

Wine tasting results - Microsoft Excel Tutorial

From the course: Excel PivotTables: Real-World Case Studies

Start my 1-month free trial

Wine tasting results

“

- [Instructor] All right, I'm really excited about this next case study 'cause we're going to talk about wine tasting. And I found a really fun dataset that I'm excited to share with you and I think you'll have a lot of fun playing with. Basically, it includes almost 130,000 records of individual wine tastings, and it will tell us about the actual wine that was being tasted, what variety it is or what type, the winery it came from, the subregion, region, province, and country. And then on the actual metrics or value side, we're going to actually have the point rating for that wine as well as the price for a bottle. So really interesting data. We've got a bunch of dimensions that we're going to use to explore this dataset. On top of those geo fields, like country, province, region, we've got, again, like I said, the wine name, the wine variety, and then actual descriptions that were recorded by the taster, along with the taster's Twitter handle if, for whatever reason, you want to go…

Contents