Minute 12:00 — 13:00

that’s why i’m doing it like this this is for you dad because he should be in this old category to be fair so now we have adolescent adolescent middle age and old these are three categories so we can now have these buckets these different Categories groups of ages and it’s much more usable than these individual ages

and so we will be using this in our in our dashboard for sure now our next one is the purchased bike and we’re not going to do anything with that so you know that is that is that one and you know there wasn’t a ton to clean up here we removed some duplicates

i don’t know why it says that what did i do married married what does this mean even mean i did i write that did i mess this up guys oh [Music] when i did the m and the s replacement in there and it replaced it with married and single it’s supposed to say marital status oops thanks for catching that guys thanks for catching that i hope that’s how you spell marital

we’ll see so we are going to keep it just like this now what we are going to now Pivot Tables now what we are going to do is build pivot tables with this data so we had our raw data we have our working sheet and now we want to create pivot tables and pivot tables is how you actually help build your dashboard to help build your visualizations so we’re going to go right here we’re going to hit whoops let me get rid of that we’re gonna go right here we’re gonna insert and we’re gonna say pivot table and it’s gonna ask us what range so we’re gonna go back to the working sheet and we’ll just click here and hit control a