Database functions are important and useful when you are dealing with large collections of data as you can manipulate the data to
make it present the information you are seeking in a better viewáble format. For example, I need to gather metrics from a database
that stores our customers information, which also stores information that is used by multiple departments; this ends up being a very
big database to wade through. I use a lot of aggregate functions to pull metrics for my team members. I use the COUNT function to
get the breakdown of how many customers to each employee I have. I use the SUM formula to calculate the outstanding balances
from each customer for the group and for each team member. I will do AVERAGE functions to determine where the team is at, as a
whole. When I want some metrics to stand out more than others, I will apply Conditional Formatting so that my eyes are drawn to
certain metrics, like when a team member falls below expectations, then it will highlight that red. This tools are beneficial and
effective when used correctly to make data more practical and useful to individual needs.



Answer :

Other Questions