Answer 1

Those words right there land you in multidimensional queries / aka: hypercubes. Terms you want to look at include "fact tables" and "dimensional tables". Doing this effectively is often a career choice.
You can also just do trivial analysis like you'd do in Excel, but I kind of assumed you know that.