Delivering Business Intelligence with Microsoft SQL Server 2008

Paperback Engels 2009 1e druk 9780071549448
Verwachte levertijd ongeveer 11 werkdagen

Samenvatting

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008

Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.

- Understand the goals and benefits of business intelligence
- Design and create relational data marts and OLAP cubes
- Manage Analysis Services databases using BI Development Studio
- Cleanse data and populate data marts with SQL Server Integration Services
- Take advantage of the flexibility of the Unified Dimensional Model
- Manipulate and analyze data using MDX scripts and queries
- Use data mining to identify data patterns, correlations, and clustering
- Develop and distribute interactive reports with SQL Server 2008 Reporting Services
- Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control

Specificaties

ISBN13:9780071549448
Taal:Engels
Bindwijze:paperback
Aantal pagina's:770
Druk:1
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Over Brian Larson

Brian Larson, MCSD, MCDBA, is a well-known industry expert and member of the Reporting Services development team. He has written for SQL Server Magazine and is the Chief of Technology for Superior Consulting Services in the Twin Cities.

Andere boeken door Brian Larson

Inhoudsopgave

Acknowledgments
The Maximum Miniatures Databases and Other Supporting Materials

Part 1: Business Intelligence
1. Equipping the Organization for Effective Decision Making
2. Making the Most of What You've Got-Using Business Intelligence
3. Seeking the Source-The Source of Business Intelligence
4. One-Stop Shopping-The Unified Dimensional Model
5. First Steps-Beginning the Development of Business Intelligence

Part 2: Defining Business Intelligence Structures
6. Building Foundations-Creating Data Marts
7. Transformers-Integration Services Structure and Components
8. Fill'er Up - Using Integration Services for Populating Data Marts

Part 3: Analyzing Cube Content
9. Cubism-Measures and Dimensions
10. Bells and Whistles-Special Features of OLAP Cubes
11. Writing a New Script-MDX Scripting
12. Pulling It Out and Building It Up-MDX Queries

Part 4: Mining
13. Panning for Gold-Introduction to Data Mining
14. Building the Mine-Working with the Data Mining Model
15. Spelunking-Exploration Using Data Mining

Part 5: Delivering
16. On Report-Delivering Business Intelligence with Reporting Systems
17. Falling into Place-Managing Reporting Systems Reports
18. Let's Get Together-Excel Pivot Tables and Pivot Charts
19. another point of View-Excel Pivot Tablesand Pivot Charts

Index

Managementboek Top 100

Rubrieken

    Personen

      Trefwoorden

        Delivering Business Intelligence with Microsoft SQL Server 2008