Media Planning (analyzing and categorizing data)

Another part of my part-time job involves crunching a lot of data and creating graphs to present this data in a user friendly way. In order to take raw data and determine how to show this visually requires formulas to extract the relevant data, determining the appropriate data for the x and y axes and scaling the data to the proper proportions. In the end, the client appreciates seeing the information clearly presented, instead of a list of numbers.