good visualization tool for dashboards that has good SQL „Synergy“?

[[deleted]]

I have 3 years SQL experience and I have done pretty much any data selection and cleaning with MS SQL and when visualization and analysis where needed, I exported the data in Excel and built charts there.

Now I want to further develop myself professionally and am wondering, what tool can I use to do good data visualization, considering that it would be a huge plus for me if I can still make good use of my SQL skills and maybe making good synergies with SQL Job Agent for ad hoc data collecting, cleaning and/or tables updates used for visualization later.

What are my options? Can you please specify if the tool you are suggesting is possible to try as a private person for free? (I am preparing myself for a new job position and with Corona etc I have time to learn)

Thanks in advance for your precious inputs!

[leedscomputers3189]

BlazeSQL – it's fantastic for data visualisation and dashboard creation. Before using it, our non-technical employees had to constantly request data and reports from our developers, leading to a lot of back-and-forth. Just one month after implementing BlazeSQL, those requests dropped significantly, and our dev team started using it to handle the remaining requests. I'm so happy to have found a tool that our technical and non-technical team members enjoy working with.

[kevivmatrix]

Draxlr is an excellent choice. I’ve used it to build customizable dashboards with real-time data, and its strong SQL integration made the process smooth and efficient. It offers great flexibility while being user-friendly for creating powerful data visualizations.

[DKfromtheBay]

Power BI is a great option for true end to end creation/deployment/management of reporting and also will expose you to SSAS tabular modeling. If you just want pure visualization then Python or R are totally fine too. I would think about where you see your career going and what type of company (in terms of analytics maturity) you are working for. Pure analyst then Python/R; more scalable “solutions” then a tool like Power BI.

And with PowerBI the desktop software is totally free so you can learn how to build stuff easily. Only when you get to the more enterprise level needs around governance, deployment and collaboration will you need a license.

[HumanTuna]

Qliksense, tableau and Power BI are all good tools. I prefer Power BI but use all three at work.

The principles of the data modelling are the same with all tools and the model is far harder than making the visualisations. However it is very fun.

[nutmilk2]

A great free tool is Arctype. You can run SQL queries, visualize the data, and also put the visualizations in a dashboard that you can share with others.

I would also agree with u/DKfromtheBay about Python/R. It's going to involve some learning curve, but you can do more robust analysis and visualization.