Best Practices for Msbi
Best Practices for MSBI
· Extracting data from source systems, transforming it, and then loading it into a data warehouse
· Structuring the data in the warehouse as either third normal form tables or in a star/snowflake schema that is not normalized
· Moving the data into data marts, where it is often managed by a multidimensional engine
· Reporting in its broadest sense, which takes place from data in the warehouse and/or the data marts: reporting can take the form of everything from printed output and Microsoft Office Excel® spreadsheets through rapid multidimensional analysis to data mining.
SQL Server 2008 provides all the tools necessary to perform these tasks [MMD07].
· SQL Server Integration Services (SSIS) allows the creation and maintenance of ETL routines.
· If you use SQL Server as a data source, the Change Data Capture feature simplifies the extraction process enormously.
· The SQL Server database engine holds and manages the tables that make up your data warehouse.
· SQL Server Analysis Services (SSAS) manages an enhanced multidimensional form of the data, optimized for fast reporting and ease of understanding.
· SQL Server Reporting Services (SSRS) has a wide range of reporting abilities, including excellent integration with Excel and Microsoft Office Word. PerformancePoint Server™ makes it easy to visualize multidimensional data.
Moreover, Microsoft Office SharePoint Server® (MOSS) 2007 and Microsoft Office 2007 provide an integrated, easy-to-use, end-user environment, enabling you to distribute analysis and reports derived from your data warehouse data throughout your organization. SharePoint can be used to build BI portal and dashboard solutions. For example, you can build a score card application on top of SharePoint that enables employees to get a custom display of the metrics and Key Performance Indicators (KPIs) depending on their job role.
Design from the
· Extracting data from source systems, transforming it, and then loading it into a data warehouse
· Structuring the data in the warehouse as either third normal form tables or in a star/snowflake schema that is not normalized
· Moving the data into data marts, where it is often managed by a multidimensional engine
· Reporting in its broadest sense, which takes place from data in the warehouse and/or the data marts: reporting can take the form of everything from printed output and Microsoft Office Excel® spreadsheets through rapid multidimensional analysis to data mining.
SQL Server 2008 provides all the tools necessary to perform these tasks [MMD07].
· SQL Server Integration Services (SSIS) allows the creation and maintenance of ETL routines.
· If you use SQL Server as a data source, the Change Data Capture feature simplifies the extraction process enormously.
· The SQL Server database engine holds and manages the tables that make up your data warehouse.
· SQL Server Analysis Services (SSAS) manages an enhanced multidimensional form of the data, optimized for fast reporting and ease of understanding.
· SQL Server Reporting Services (SSRS) has a wide range of reporting abilities, including excellent integration with Excel and Microsoft Office Word. PerformancePoint Server™ makes it easy to visualize multidimensional data.
Moreover, Microsoft Office SharePoint Server® (MOSS) 2007 and Microsoft Office 2007 provide an integrated, easy-to-use, end-user environment, enabling you to distribute analysis and reports derived from your data warehouse data throughout your organization. SharePoint can be used to build BI portal and dashboard solutions. For example, you can build a score card application on top of SharePoint that enables employees to get a custom display of the metrics and Key Performance Indicators (KPIs) depending on their job role.
Design from the