A picture is worth a thousand words is an old phrase that is also true in the data science domain. Having a large amount of numbers will not be as useful as representing them with a graph or other graphics element. SQL Server does provide two major services used for data visualization or representation: SQL Server Reporting Services and Power BI Report Server. Both run locally on your SQL Server and offer you a variety of development options for data visualization projects. Another option would be the machine learning services and the available packages for Python and R. Both languages have their own set of visualization packages with different options.
Developing a visualization solution requires numerous roles, proper planning, and design for a successful rollout in the enterprise environment. Usually these visualization projects are handled by the business...