Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008

• 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))