Thursday, 26 November 2015
What is Business Intelligence?
Most companies have plenty of data but not always the right data.
Data is not information. Data is often spread across heterogeneous systems and is not consistent across those systems.
Business Intelligence(BI) is the process of turning data into information so business can make better decisions faster. The process often involves consolidating data from different data sources and using tools to view the consolidated data. It helps as a decision support system and to easily access the data.
BI is an extension of Data Warehousing. Data warehousing is the process of taking data from one or more sources and consolidating it. Once the data is in a warehouse, a variety of tools can be used to view and analyze the data.
Data mining is a process of using statistical algorithms to
- Identify relationships between data elements
- Find trends in the data
- Forecast future performance
- And so forth
Users of a BI Solution
- Nearly anyone in an organization can benefit from a BI solution, including:
- Executive and business decision makers
- Information Workers
- Analysts
- Line Workers
- Even external vendors and customers
These users often need to interact with the data in different ways.
A single BI Solution can often deliver data to a wide variety of users throughout an organization.
BI is all about helping organization decision makers to take decisions using existing data.
Using BI we can create scorecards and dashboards.
Scorecards give an overview of the health of an organization in a single glance.
Dashboards contains one or more scorecards and other elements such as reports.
Information workers are non-management professionals. These workers typically need more detailed access than executives and business decision makers. Reports can often satisfy the needs of information workers.
Reports may be based on multidimensional cubes or a relational data warehouse.
Reports may be static or have some interactivity
- Reports may contain parameters the user can select,
- Reports may allow for limited drill up and drill down capabilities.
Analysts are a special group of information workers.
Analysts need powerful tools to explore the data in depth.
Analysts typically examine the data in detail and may employ data mining.
Analytic application provide rich access to the data. Analytic applications include:
-ProClarity
-Excel
-PerformancePoint Server
Line workers are those on the front lines, such as:
- Clerks in stores or in call centers
- Manufacturing employees on the shop floor
These workers may use BI data as part of their daily work without realizing it.
Custom Application Integration:
BI data can be leveraged in custom applications.
This extends the power of a BI solution to line-of-business applications.
Microsoft BI data is easily accessible to .NET developers for integration with web and windows applications.
External Customers and Vendors:
A BI solution may provide access to external users.
In nearly every case this access comes via Web interfaces.
Web interfaces to BI data can be provided by:
- PerformancePoint Server
- ProClarity Analytic Server
- Excel Services
- SQL Server Reporting Services
Most companies have plenty of data but not always the right data.
Data is not information. Data is often spread across heterogeneous systems and is not consistent across those systems.
Business Intelligence(BI) is the process of turning data into information so business can make better decisions faster. The process often involves consolidating data from different data sources and using tools to view the consolidated data. It helps as a decision support system and to easily access the data.
BI is an extension of Data Warehousing. Data warehousing is the process of taking data from one or more sources and consolidating it. Once the data is in a warehouse, a variety of tools can be used to view and analyze the data.
Data mining is a process of using statistical algorithms to
- Identify relationships between data elements
- Find trends in the data
- Forecast future performance
- And so forth
Users of a BI Solution
- Nearly anyone in an organization can benefit from a BI solution, including:
- Executive and business decision makers
- Information Workers
- Analysts
- Line Workers
- Even external vendors and customers
These users often need to interact with the data in different ways.
A single BI Solution can often deliver data to a wide variety of users throughout an organization.
BI is all about helping organization decision makers to take decisions using existing data.
Using BI we can create scorecards and dashboards.
Scorecards give an overview of the health of an organization in a single glance.
Dashboards contains one or more scorecards and other elements such as reports.
Information workers are non-management professionals. These workers typically need more detailed access than executives and business decision makers. Reports can often satisfy the needs of information workers.
Reports may be based on multidimensional cubes or a relational data warehouse.
Reports may be static or have some interactivity
- Reports may contain parameters the user can select,
- Reports may allow for limited drill up and drill down capabilities.
Analysts are a special group of information workers.
Analysts need powerful tools to explore the data in depth.
Analysts typically examine the data in detail and may employ data mining.
Analytic application provide rich access to the data. Analytic applications include:
-ProClarity
-Excel
-PerformancePoint Server
Line workers are those on the front lines, such as:
- Clerks in stores or in call centers
- Manufacturing employees on the shop floor
These workers may use BI data as part of their daily work without realizing it.
Custom Application Integration:
BI data can be leveraged in custom applications.
This extends the power of a BI solution to line-of-business applications.
Microsoft BI data is easily accessible to .NET developers for integration with web and windows applications.
External Customers and Vendors:
A BI solution may provide access to external users.
In nearly every case this access comes via Web interfaces.
Web interfaces to BI data can be provided by:
- PerformancePoint Server
- ProClarity Analytic Server
- Excel Services
- SQL Server Reporting Services
I really like your blog because it has valuable information for learners and experts also. so please keep share on MSBI Online Training
ReplyDelete