Home » Archive by category "BI – Intro"

Value of Business Intelligence

Business Intelligence & Return on Investment (ROI): Business Intelligence enables us to take some action based on the intelligence acquired using BI strategy. If this knowledge or information is not utilized properly in the right direction, there is no point in analyzing and finding the intelligence....
Read More

Business Intelligence Environment

BI Environment and Business Flow: Business Intelligence is all about converting large amounts of corporate data into useful information, thereby triggering some profitable business action with the help of knowledge acquired through BI analysis. Implementing BI is a long process and it requires a lot...
Read More

Business Intelligence Tutorial

What is Business Intelligence? Business Intelligence(BI) is a terminology representing a collection of processes, tools and technologies helpful in achieving more profit by considerably improving the productivity, sales and service of an enterprise. With the help of BI methods, the corporate data can be organized,...
Read More

BI Reporting

Business Intelligence Reports: Data is collected from various sources and cleansed or transformed into a form required by data warehouse or data mart decision support systems. BI tools provide a means of taking advantage of these data contained within a data warehouse or data mart...
Read More

ETL & Data Warehouse

ETL Process: ETL, an acronym for ‘Extraction, Transformation and Loading’ is a collection of processes associated with extracting the source data, transforming that data and finally loading that data into a data warehouse. Before loading the required into data warehouse, it should be transformed in...
Read More

Dimensional Modeling

Dimensional Model comprises a fact table and many dimension tables and is used for calculating summarized data. Since Business Intelligence reports are used in measuring the facts(aggregates) across multiple dimensions, dimensional data modeling is the preferred modeling technique in a BI environment. A Fact table...
Read More

Data Modeling

Data Modeling is about representing the real world set of data structures or entities and their relationships in the form of Data Models, required for a database. Simply put, data model is a visual representation of the database. Data Modeling consists of various types and...
Read More