There are a lot of options in the Business Intelligence (BI) world. It can be confusing trying to sort out which solution is right for which project.
One of the largest division lines is speed. Are you able to wait 30 seconds for your data to show up or no you need to immediately see your data rendered so you can move on to your next query?
Here is a light-hearted but handy flow chart reference detailing what SQL, reports, Tableau, and Cubes are good for.
Let me know what you think at firstname.lastname@example.org!