For making it happen, you need to create a relational database, where only contextually related data sets are put together. Then, you need to fetch that data using MySQL or DBMS or BI tools. Some BI tools like Chartio don’t require this kind of fetching. Instead, they allow you to query data with no code.
For visualizing results and making decisions with real time data based dashboards, create a real-time SQL dashboard. Or, you can export your query result from MySQL as a CSV. Later, put it into Google Data Studio or Excel.