Sql-server – What can be used with SQL Server 2014 native tools, for Business Inteligence

business-intelligencesql serversql server 2014

We're trying to achieve better reports using native tools from SQL Server 2014.

I'm a DBA, and I don't know so much about c#, c++ and etc.

I know also, that we have Analysis services, SQL Server Data tools, but, long story short, programmers here where I work don't care about anything. They don't want to learn.

Is there a way to help my company, being a DBA ? I love to learn but I have some doubts about what service I can use to achieve reports with graphics, and those reports that bosses love.

If this is a bad question I can delete it with no problem.

My past job, we had an awesome application that uses views and procedures to ( I helped them with views and procedures and query tunning, but not with Visual Basic code ), in real time, update graphics and etc on a web page ( it was awesome ) but we can make it here, because as i said, they don't know and don't have the motivation to learn.

Best Answer

If SQL Server 2016 is on your road-map it provides significantly improved SSRS visuals. This should address the "pretty" factor of reports while also incorporating Mobile support and a few additional out-of-the-box charts/graphics/indicators for users. Report Builder is still available for the elusive "power user" to create their own reports.

The "Power" suite of applications (Power View, Power Map) can be incorporated into Excel and SharePoint to mixed degrees and effects and are free depending on version(s). PowerBI is the evolution, combination and refinement of these tools.

PowerBI is a Microsoft technology that works with a variety of data sources with strong emphasis on both "pretty" and actual insight. This is another tool that has placed emphasis on ease of use to help reduce IT load and specialization.

There are plenty of competing non Microsoft solutions that will undoubtedly work with SQL Server 2014.

How to implement? Show a pretty screen cap to senior management and money may free up? Never under-estimate the value of a prototype. Or note the fringe benefits that may become paramount investment points later: SQL Server 2016 offers increased performance, security... oh and they also have some nifty reporting that's included in the license costs.

Related Question