In this blog I am giving an overview of Business Intelligence terms and Microsoft tools used for Business Intelligence
Why we need Business Intelligence?
During the course of business, the following questions must be asked. The functions of monitoring, analyzing, and planning look into these questions.
- What has happened?
- What is happening?
- Why?
- What will happen?
- What do we want to have happen?
To find answers for these questions Organization’s need Business Intelligence.
What is Business Intelligence?
The term Business Intelligence (BI) represents the tools and systems that used for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. Business intelligence (BI) simplifies information discovery and analysis, making it possible for decision-makers at all levels of an organization to more easily access, understand, analyze, collaborate, and act on information, anytime and anywhere. BI applications have evolved to include multiple initiatives to measure, manage, and improve on the performance of individuals, processes, teams, and business units.
How to Implement Business Intelligence in Organization?
For Business Intelligence enterprises have to make a Data Warehouse
Data Warehouse is a giant storehouse of all your Data. It’s an Aggregation of data from multiple or single systems. A data warehouse is a relational database which is used for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.
Advantages of Data Warehouse
· Combine data from multiple systems and resolve inconsistencies between those systems.
- Make Reporting Easier.
- Reduce the Load on Production Systems.
- Provide for Log Term Store Data.
- Provide consistency among system transitions.
Process for Business Intelligence and Microsoft tool Set
SSIS (SQL Server Integration Services)
SQL Server Integration Services is a Microsoft ETL (Extract- Transform-Load) Tool. It helps for data migration from different kind of sources. It extracts data from wide range of sources, performs calculation based on need loads into Database tables.
SSAS (SQL Server Analytical Services)
SQL Server Analytical Services is a Microsoft online analytical processing (OLAP), data mining and reporting tool. It helps for multidimensional analysis of Data .It analyze large quantities of data by storing data in axes and cells instead of the traditional relational two-dimensional view in rows and columns.
SSRS (SQL Server Reporting Services)
SQL Server Reporting Services is a server-based report generation software system from Microsoft. With Reporting Services, We can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. Reports can include rich data visualization, including charts, maps, and sparklines.