Event Review: Real-Time Business Intelligence with SQL Server 2005 Analysis Services (Session ITPROSQL-09)
Welcome to the material supporting page for this session. The materials on this page have been selected as the best matches to the content covered in the live event session.
Session Outline
There is an increasing demand to make business intelligence (BI) "real-time"; however, this can be a challenge. This session discusses the challenges of real-time BI, and shows how some of these can be overcome by new features available in Microsoft SQL Server 2005 Analysis Services, along with other components of Microsoft SQL Server 2005. Although barriers preventing complete real-time BI still exist, SQL Server 2005 makes your information close enough to real time to support better and faster business decisions.
Session Agenda
- What are the barriers to real-time Business Intelligence (BI)?
- How can Microsoft SQL Server 2005 Analysis Services be used to make BI more real-time?
Session Media
This session consists of a Windows Media presentation and demonstrations:
| Download the full session
Download the full multimedia recording of this session. |
| Download all slides and transcripts
Download just the slides and transcripts of this session. |
| Demo: Linking Integration Services (SSIS) and Analysis Services Directly
In this demonstration, you will see how to push data directly into an analysis cube from a relational database using SQL Server Integration Services.
Download |
| Demo: Using MOLAP, Reverting to ROLAP when Latency Exceeded
In this demonstration, we will see how to configure a cube using MOLAP that reverts to ROLAP when the MOLAP cache is out of date.
Download |
| Demo: Using Automatic MOLAP with Polling Queries and Incremental Refresh
In this demonstration, you will learn how to configure MOLAP to automatically update the MOLAP cache periodically using an incremental refresh of the cache data.
Download |
Related Links
Use the following resources to learn more about topics covered in this briefing.
Microsoft Press Books
- Microsoft SQL Server 2005 Administrator's Pocket Consultant
Summary: Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005.
- Microsoft SQL Server 2005 Analysis Services Step by Step
Summary: Your hands-on, step-by-step guide to building business intelligence solutions for the enterprise. Teach yourself the fundamentals of SQL Server Analysis Services one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization. Discover how to: Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers, Create dimensions and measure groups to build, browse, and modify OLAP cubes, Design objects to handle unique financial analysis requirements, Improve query performance with aggregations and user hierarchies, Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques, Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes, Manage role-based security and restrict data access, Deploy and maintain a database in a production environment. The included CD features all practice exercises and answer files, and a fully searchable eBook.
Third-Party Books
- Delivering Business Intelligence with Microsoft SQL Server 2005
Summary: Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here--from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.
- SQL Server 2005 Distilled
Summary: SQL Server 2005 Distilled offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more.
- Microsoft SQL Server 2005 A Beginner's Guide
Summary: This bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench, T-SQL, automated administration tasks, security, and analysis.
- Microsoft SQL Server 2005 The Complete Reference
Summary: Filled with practical solutions and real-world examples, this resource includes full details on: Enterprise data management capabilities, including security and clustering Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0 Business Intelligence features, such as Integration Services, data warehousing, and reports.
- Professional SQL Server Analysis Services 2005 with MDX
Summary: Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases
Training and Certification
- Course 2942: New Features of Microsoft SQL Server 2005 Analysis Services
Summary: In this course you administer and program SQL Server 2005 Analysis Services. In addition, you design and deploy a Unified Dimensional Model as well as work with data mining solutions. This course is intended for architects, database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server. This course also helps prepare you for certification exam 70-445.
- Course 2794: Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005: Two days; Instructor-Led
Summary: The purpose of this 2-day instructor-led course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a BI solution architecture. Students will be taught the importance of keeping all components of the solution and stages of the lifecycle in mind. The first day focuses on foundational standards and practices for the enterprise. The second day focuses on a project-specific lifecycle for capturing requirements and deriving a solution architecture. This is the first course in the Business Intelligence curriculum and will serve as the entry point for other courses in the curriculum.
- Course 2796: Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services: Three days; Instructor-Led
Summary: The purpose of this 3-day course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a multidimensional solution architecture that supports their BI solution. Students will go through the entire process from capturing business and technical requirements to deploying a multidimensional solution to production. Students will also be taught to develop custom functionality and optimize a multidimensional solution.