Agree with @Raffel!
Definition hanging out at the DBA site: Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community....
A DB professional (DBA, DB Programmer, DB designer) may choose to get involved in Business Intelligence projects as they play the part contributing to build databases and the data warehouse by applying database techniques and security skills. We need a vessel to store the data; Vessel has to be secured & managed in its own manner; Through out BI we do use SQL and our knowledge in database technology. But it doesn't DEFINE BI, BI practices or what BI provides to the audience.
So we shall not submerge our view of a database & its technologies with Business Data and Analytics. The very need and the underlying concept/essense of Business Intelligence is driven on modeled DATA AND Analytics with a presentation layer.
We all know how different that is from running a query...
Instead of wasting time and money to build a decision supporting platform on n-number of sources to deliver those dashboards, scorecards to satisfy the management, why don't we just give a set of department databases access to our CEO & his team and watch how long it takes query that 'tangled' data...
Can we say the efficiency of a Database design is measured over its ability to peform on transactional data? Where as BI is able to provide best dimensions and metrics on Denormalized data? Does it alarm the different between OLTP and OLAP to us...?
Following areas are helpful to understand how DB as a technology is used to build and support Business Intelligence and how different they are from either other:-
- Data Analysis
- Database Mechanics
- Data Modeling
- SQL Scripting
In terms of the Data Analysis, independent existence and execution of BI have become extremely important with a set of built-in or third party tools - since techniques used are beyond SQL. Whether you and I like it or not. Rigorous analysis demand tools such as R, Matlab to be in the picture slowly but surely.
BI has evolved into a cohesive self-servicing process wrapping and connecting disparate data sources, permitting users to execute upon data without the assistance of technical staff within an organization.
According to a Analyst firm Forrester refers to BI evolution as "the only way to make BI more pervasive, delivering insights into every decision-important or mundane-that drives your business. It's the key to empowering users with actionable insights while removing many mundane BI development and maintenance tasks from IT's crushing workload."