Once we have some basic understanding of the type of data that is stored in the MySQL database. We will now see what types of we can answer from this data.
Uni-dimensional insights:
- How many employees are there in the organisation?
- What is the total salary paid for all employees in the organisation?
- How many departments are there?
Multi dimensional insights
- What is the total salary paid for every year?
- What is the total salary per department?
- Who is the top paid employee for every year?
If we think along these lines we should be able to answer very important questions regarding the data and should be able generate nice graphics.
Lets take few examples of what types of visualisations we can generate ...
