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

Unlock the full course today

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

Shark attack records

Shark attack records - Microsoft Excel Tutorial

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

Start my 1-month free trial

Shark attack records

“

- [Instructor] All right, our next case study is a ton of fun, my all-time favorite. For this one we're actually going to look at shark attack records recorded between 1900 and 2016. So we've got just under 5300 records or observations in our data set, and what's a little bit unique about this data set is that it actually doesn't contain any measures, so there are no numerical variables or quantitative fields. It's all dimensions. And this is relatively common when it comes to things like record-keeping, because what's most relevant is the information contained within those records as opposed to any sort of quantitative field. So we've got a ton of really fascinating dimensions to work with, starting with the case number and the date that the attack took place. We can cut the data by the type of attack, whether it was provoked or unprovoked, where it took place in terms of the country, area, and specific location, what activity the victim was engaged in when they were attacked, their…

Contents