Client had a CSV file with details about clients, sales, revenues, etc. per month. The client wanted to make use of this data and find insights.

The client was able to find out how his revenues and costs fluctuate throughout the year. In addition to that we were able to visualize the productivity of the employees throughout the year. There appears to be a yearly cycle where the productivity peaks during the Spring months and plummets during the Winter months.

The client now understands how to efficiently allocate resources throughout the year.

In addition to that the client requested to know which of his customers spend the most. Date was compiled into a pie chart with customers names (names were hidden to maintain confidentiality) and their yearly spendings.

A step further was taken to plot the loyalty of different customers. The plot includes the number of projects each customer engaged in with the client and the number of projects the customer engaged in with the competitor. (Names were hidden to maintain confidentiality).

Consequently the client has deeper knowledge on how to allocate resources throughout the year, and what customers to give more attention.