Business Intelligence in SQL Server 2005: A First Look
Jack Hakim
Program Track:
Technical Briefings
Program Duration:
50 Minutes
Value Category:
Navigation
Key Issues:
How can an enterprise identify patterns, trends, rules, and relationships from volumes of information too large to be processed by human analysis alone?
What is Business Intelligence (BI)?
Is there a BI toolkit designed to help companies use data more effectively and make better decisions?
What are the components of Microsoft’s BI package in SQL Server 2005, and what are some of the problems you can solve with these tools?
Does Microsoft have a perspective on BI?
How does BI improve the speed and reliability of business decisions?
Are there significant architectural changes to SQL Server 2005, and how does it rely on Microsoft’s .NET framework?
What are the new implementations of OLAP (Online Analytical Processing)?
Is there a description of the new tools and techniques in Microsoft’s data mining?
- high - medium - low
Application Development
Architecture and Infrastructure
Business Applications
Business Management
Customer Relationship Management
Data Management
IT Management
Business people are often faced with the challenge of identifying patterns, trends, rules, and relationships from volumes of information too large to be processed by human analysis alone. Business Intelligence (BI) is an approach to turning these large volumes of data into insight and action. Microsoft’s next version of its SQL Server DBMS features an enhanced BI toolkit designed to help companies use data more effectively and make better decisions. In this program, Jack Hakim, CEO and President of EC Wise, a BI practice, examines the components of Microsoft’s BI package in SQL Server 2005, and discusses some of the problems you can solve with these tools. In an interview, Bill Baker, General Manager, Business Intelligence, Microsoft’s Business Intelligence SQL Server Group, offers Microsoft’s perspective on BI. Hakim opens the program with a brief introduction to BI, noting how it can improve the speed and reliability of business decisions. He continues by examining the significant architectural changes to SQL Server 2005, focusing on its reliance on Microsoft’s .NET framework and the availability of the new BI tools. Hakim then turns his attention to new implementations of OLAP, addressing how it differs from previous incarnations, and showing how it can be used to solve typical business problems. He continues by describing new tools and techniques in Microsoft’s data mining, and concludes with a recap and recommendations.
By watching this program, you will learn about:
~ The important new features in SQL Server 2005;
~ The BI components of SQL Server 2005; and
~ How and when they should be used.
Viewers of the online and CD versions of the program will have instant access to Web links that include: ‘SQL Server 2005: Late but Loaded’; ‘ETL,’ from Computerworld Magazine; and numerous pages from the Microsoft Web site, such as ‘Introducing SQL Server 2005, Code-Named Yukon.’ White papers include: ‘Business Intelligence: Data Mining for Dynamic Customer Analysis’ and ‘Business Intelligence: Vendor Solutions, Features and Functionality.’
PROGRAM TOPICS:
INTRODUCTION
PROGRAM ROI
AGENDA
AN INTRODUCTION TO BUSINESS INTELLIGENCE
Questions About Business Intelligence
What is Business Intelligence?
Microsoft’s BI Activities
The Data Leveraging Process
How the Microsoft BI Stack Fits In
WHAT'S EXCITING ABOUT SQL SERVER 2005?
Microsoft BI Development Workbench
SQL Server 2005 Features
Where is Business Intelligence Useful?
ONLINE ANALYTICAL PROCESSING AND HOW IT’S IMPROVED
Online Analytical Processing
Multidimensional Structures: Cubes
IntelliCube Technology
Multidimensional Expressions
Proactive Caching
The Solution Explorer
NEW TOOLS AND TECHNIQUES IN MICROSOFT'S DATA MINING
- high
- medium
- low
