How to Build a Front End Data Visualization

In an ideal scenario, the steps should be handled essentially sonsit right in two a point. And then once you have that, your tools should let you just start to drag those things into your model and join them together. There is always some sort of a pain point going from, well, i have to get my customer transaction data from this data base, but the customer idea is different one ad all over again. Just walk me through some of the pain points and other ways to avoid any of the confusion when you're trying to build the really front end data visualizations.