You require easy, efficient and complete BI system to support and assure your business strategy.

Currently, BI has become a crucial area in terms of company’s strategy and executing, and also causes great challenges in making decisions. As we know, precise and objective data is the premise of scientific decisions. All decisions of departments should depend on data analysis and support, first, on reality and then on truth.

	Executive information systems (EIS)
	Decision support systems (DSS)
	Data warehousing (DW) and business intelligence (BI)

	MIS systems provided business data.
	Reports were developed on request.
	Reports provided little analysis capability.
	Decision support tools gave personal ad hoc access to data.

	Data structures are complex.
	Systems are designed for high performance and throughput
	Data is not meaningfully represented.
	Data is dispersed.
	OLTPsystems may be unsuitable for intensive queries.

5.Data Extract Processing　 Back
	End-user computing offloaded from the operational environment
	User’s own data

7.Productivity Issues with Extract Processing　 Back
	Duplicated effort
	Multiple technologies
	Obsolete reports
	No common metadata

	No common time basis		Different calculation algorithms		Different levels of extraction
	Different levels of granularity		Different data field names		Different data field meanings
	Missing information		No data correction rules		No drill-down capability

	Controlled
	Reliable
	Quality information
	Single source of data

	No duplication of effort		No need for tools to support many technologies		No disparity in data, meaning, or representation
	No time period conflict		No algorithm confusion		No drill-down restrictions

“Business intelligence is the process of transforming data into information and through discovery transforming that information into knowledge.” – Gartner Group

	Know the business		Reinvent to face new challenges		Invest in products
	Invest in customers		Retain customers		Invest in technology
	Improve access to business information		Provide superior services and products		Be profitable

	Provide supporting information systems
	Get quality information:
- Reduce costs - Streamline the business - Improve margins

	Efficient design of data warehouses		Enterprise reporting		Ad hoc query and analysis (relational and multidimensional)
	Advanced analytics		Integration with portals		Easy administration
	Integrated environment and/or tools

	Microsoft SQL Server Integration Services (SSIS)		Microsoft SQL Server Analysis Services (SSAS)		Microsoft SQL Server Reporting Services (SSRS)
	Microsoft PerformancePoint Server 2007		Microsoft Sharepoint Server 2007		Microsoft Search Server 2008
	Microsoft Project Server 2007		Microsoft Communication Server 2007