Data Warehouse is where data from different source systems are integrated, processed and stored. Data Warehouse is a centralized relation database system used for querying and reporting rather than daily transactions. Business users and higher management authorities use the data warehouse data to analyze, and to make important business decisions. Data warehouse collects large volume of data from variant sources with many different data formats. The ETL(Extraction, Transformation and Loading) process handles these data and transforms it into a more consistent, standard formatted data
Business Intelligence is a technology based on customer and profit oriented models that reduces operating costs and provide increased profitability by improving productivity, sales, service and helps to make decision making capabilities at no time. With the help of BI methods, the corporate data can be organized, analyzed in a better way and then converted into an useful knowledge of information needed to initiate a profitable business action
DWH/BI Concepts:
1)PK,FK,SK,BK,UK
Star schema/snow flake schema
Dimensions/Facts
2)Types of Dimensions
3)Types of facts
Business Intelligence is a technology based on customer and profit oriented models that reduces operating costs and provide increased profitability by improving productivity, sales, service and helps to make decision making capabilities at no time. With the help of BI methods, the corporate data can be organized, analyzed in a better way and then converted into an useful knowledge of information needed to initiate a profitable business action
DWH/BI Concepts:
1)PK,FK,SK,BK,UK
Star schema/snow flake schema
Dimensions/Facts
2)Types of Dimensions
3)Types of facts