Bussiness Inteligance and Data Warehousing

Bussiness integance is one of the data minning solutions. Bussiness integance database type is dimensional. This database uses only reporting and analizing data. If you have a large company and you want to learn how to make better your company you chose this solution.

For Bussiness Inteligance,

1. Do datawarehouse with using dimensional model. You may have a few relational database but you have to only one datawarehouse for your solution. You may have a city table each database,But you must concat this table and do matching table for this concated table.
2. Doing ETL(extract-transform-load) to your datawarehouse from your realtional databases
3. If dimensional database schema type is star schema, your cubes will be simple and readable
4. SSIS is one of the ETL solutions. SSIS concept consist of those elements:  packages to write ETL configuration, database to house this packages and SQL Agent to execute this packages a part of time recusively.
5. ETL configuration consists of three main items. Extract : Getting data from relational database, Transform: Change and formating data what you want, Load: Writing this configured data to your datawarehouse. SSIS has a lot of component for extract data from oledb,odbc,exel  databases  and transform this data using c# script, sql query builder components with simple user interface.
6. Creating cube in BIDS. Create your dimension and measure with existing table in your datawarehouse. Then deploy your cube to analysis service
7. Final requirement is browser for viewing data. OLAP browsers create mdx query and send this queries to analysis server. Analysis server execute this query and returns a result. Working with OLAP browser is very simple because all thing drag and drob.