The Microsoft data warehouse toolkit : with SQL server 2008 R2 and the Microsoft Business Intelligence toolset / Joy Mundy and Warren Thornthwaite, with Ralph Kimball.

By: Mundy, Joy, 1961-Contributor(s): Thornthwaite, Warren, 1957- | Kimball, RalphMaterial type: TextTextPublisher: Indianapolis, IN : Wiley, ©2011Edition: 2nd edDescription: (xlvi, 648 pages) : illustrationsContent type: text Media type: computer Carrier type: online resourceOther title: Data warehouse toolkitSubject(s): Data warehousing | SQL server | Client/server computing | SQL server | Computer science | Data warehousing | Client/server computing | SQL server | SQL server | Client/server computing | Data warehousing | SQL server | Data warehousing | Client/server computingGenre/Form: Electronic books. | Electronic books.Additional physical formats: Print version:: Microsoft data warehouse toolkit.DDC classification: 005.74 LOC classification: QA76.9.D37 | M95 2011
Contents:
Requirements, realities, and architecture -- Defining business requirements -- Designing the business process dimensional model -- The toolset -- System setup -- Building and populating the databases -- Creating the relational data warehouse -- Master data management -- Designing and developing the ETL system -- The core analysis services OLAP database -- Design requirements for real-time BI -- Developing the BI applications -- Building BI applications in reporting services -- PowerPivot and Excel -- The BI portal and SharePoint -- Incorporating data mining -- Deploying and managing the DW/BI system -- Designing the implementing security -- Metadata plan -- Deployment -- Operations and maintenance -- Present imperatives and future outlook.
Summary: Best practices and invaluable advice from world-renowned data warehouse expertsIn this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming "Business Intelligence release" of SQL Server, referred to as SQL Server 2008 R2.℗¡In this new edition, the authors explain how SQL Server 2008 R2 provides a collection of powerful new tools that extend the power of its BI toolset to Excel and SharePoint users and they show how to use SQL Server to build a successful data warehouse that supports the business intelligence requirements that are common to most.
Tags from this library: No tags from this library for this title. Log in to add tags.
    Average rating: 0.0 (0 votes)

Requirements, realities, and architecture -- Defining business requirements -- Designing the business process dimensional model -- The toolset -- System setup -- Building and populating the databases -- Creating the relational data warehouse -- Master data management -- Designing and developing the ETL system -- The core analysis services OLAP database -- Design requirements for real-time BI -- Developing the BI applications -- Building BI applications in reporting services -- PowerPivot and Excel -- The BI portal and SharePoint -- Incorporating data mining -- Deploying and managing the DW/BI system -- Designing the implementing security -- Metadata plan -- Deployment -- Operations and maintenance -- Present imperatives and future outlook.

Print version record.

Best practices and invaluable advice from world-renowned data warehouse expertsIn this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming "Business Intelligence release" of SQL Server, referred to as SQL Server 2008 R2.℗¡In this new edition, the authors explain how SQL Server 2008 R2 provides a collection of powerful new tools that extend the power of its BI toolset to Excel and SharePoint users and they show how to use SQL Server to build a successful data warehouse that supports the business intelligence requirements that are common to most.

1 2

There are no comments on this title.

to post a comment.