Sökning: onr:"11749181" >
Smart Business Inte...
Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008
-
Langit, Lynn. (författare)
-
Goff, Kevin. (författare)
-
Mauri, Davide. (författare)
-
visa fler...
-
Malik, Sahil. (författare)
-
Welch, John. (författare)
-
visa färre...
- ISBN 9780735638341
- Sebastopol : O'Reilly Media, Inc. 2009
- Engelska 1 online resource (1800 p.)
Innehållsförteckning
Abstract
Ämnesord
Stäng
- Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008; Acknowledgments; Davide Mauri; Sahil Malik; Introduction; What This Book Is About; Part II, "Microsoft SQL Server 2008 Analysis Services for Developers"; Part III, "Microsoft SQL Server 2008 Integration Services for Developers"; Part IV, "Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence"; Prerelease Software; Hardware and Software Requirements; Find Additional Content Online; Support for This Book; I. Business Intelligence for Business Decision Makers and Architects.
- OLTP and OLAPOnline Analytical Processing; Common BI Terminology; Data Marts; Cubes; Decision Support Systems; Data Mining Systems; Extract, Transform, and Load Systems; Report Processing Systems; Key Performance Indicators; Core Components of a Microsoft BI Solution; SQL Server 2008 Reporting Services; SQL Server 2008; SQL Server 2008 Integration Services; Optional Components of a Microsoft BI Solution; Query Languages Used in BI Solutions; DMX; XMLA; RDL; Summary; 2. Visualizing Business Intelligence Results; Components of BI Solutions.
- Understanding Business Intelligence from a User's PerspectiveOpening the Sample in BIDS; Connecting to the Sample Cube Using Excel 2007; Understanding Data Mining via the Excel Add-ins; Viewing Data Mining Structures Using Excel 2007; Elements of a Complete BI Solution; ETL-Getting the Solution Implemented; Data Mining-Don't Leave It Out; Common Business Challenges and BI Solutions; Measuring the ROI of BI Solutions; Summary; 3. Building Effective Business Intelligence Processes; Microsoft Solutions Framework for Agile Software Development; Applying MSF to BI Projects.
- Phases and Deliverables in the Microsoft Solutions FrameworkPlanning; Building; Stabilizing; Deploying; Skills Necessary for BI Projects; Creating the User Interface; Understanding Extract, Transform, and Load Processes; Optimizing the Data Sources; Optional Skills; Creating the User Interface; Understanding Extract, Transform, and Load Processes; Optimizing the Data Sources; Forming Your Team; Architecture; Program Management; Development; Test; User Experience; Release Management; Summary; 4. Physical Architecture in Business Intelligence Solutions.
- Assessing Current Service Level AgreementsDetermining the Optimal Number and Placement of Servers; Considerations for Logical Servers and Services; Understanding Security Requirements; Data in Transit: Security on the Wire; Processing Layer: ETL; SSAS Data; On the User Client: Excel or SSRS; Excel as a Data Mining Client; SSRS as an OLAP Client; Security Considerations for Custom Clients; Backup and Restore; Backing Up SSIS; Backing Up SSRS; Auditing and Compliance; Source Control; Summary; 5. Logical OLAP Design Concepts for Architects; Dimension Tables; Denormalization; Back to the Star.
- Design Approaches.
- Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008-whether you're new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you'll master the concepts, tools, and techniques for building solutions that deliver intelligence-and business value-exactly where users want it. Discover how to: Manage the development life cycle and build a BI teamDig into SQL Server Analysis Services, Integration Services, and Reporting Service
Ämnesord
- Business intelligence.
- Client/server computing.
- OLAP technology.
- SQL server.
Genre
- Electronic books. (LCSH)
Publikations- och innehållstyp
- HD38.7 .S63 2009 (LCC)
- 005.75/85 (DDC)
- Pubdhz (kssb/8 (machine generated))
Hitta via bibliotek
Till lärosätets databas