In this article I will write about the difference between SQL and Business Intelligence and the difference between SQL Server Developer and BI Developer, and focus on the reporting aspect.
Let's start with SQL and BI. For reporting purposes SQL (T-SQL if we use SQL Server) is used to query data from a database and returns a dataset as a table. On it's own it's rarely useful for reporting purposes, however it's often used with other BI tools.
You can learn more about T-SQL from our tutorial here.
Business Intelligence aim is to produce a report or a dashboard that is useful for business and often uses a combination of BI tools to achieve that. In this SQL is rarely used on it's own and often us combined with Excel, SQL Server Reporting Services (Check our SSRS Tutorial), SQL Server Integration Services (Check our SSIS tutorial) or SQL Server Analysis services (Check our SSAS Tabular tutorial).
Difference between SQL Developer & BI Developer
SQL Developer often are people who develop database and this often is operational databases (Check our T-SQL Developer Tutorial), however sometimes SQL Developer also develop reports or dashboard and if they do it on a regular basis that they become BI Developer. Almost all BI Developers can be T-SQL Developers, as they very frequently have strong T-SQL Skills.
I hope this articles was useful and I recommend to check our website for tutorials we have.