I am beginning to delve into data analysis via excel and I would like to learn more about the terminology in terms of some data I’m playing with.
I’ve created a sample data set for mock invoice charges with different products per invoice listed as unique line items. What type of data set is this called? I want to understand so I can dial in my research and questions moving forward. Image link below.
Now from here, I’m seeking advice on how to answer some complex questions using pivot tables.
1.) Since values like ‘week’ repeat, how can I get a count of distinct weeks that a customer bought product? (i.e. How many weeks in the year did Customer A buy product?)
2.) Using the data from above, how can I get some average performance analysis for each unique customer by week?
I’m trying to look at data points like:
- Using Customer A’s weeks sold, on average how much do they buy a week?
- Using Customer A’s products sold, on average how many units of each product do they buy a week?
I appreciate your patience as I’m aware this is poorly worded, I’m fairly new at using these types of forums.
