walidazab
07-28-2008, 06:13 PM
AppDev SQL Server 2005 Analysis Services
Modules: 8
Run Time: 12
Pages: 450
In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services. Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%
In this course, you will:
Learn the core concepts in building solutions using Microsoft Business Intelligence with SSAS.
Understand OLAP (cube) modeling and data mining.
See how to develop solutions using Business Intelligence Development Studio (BIDS).
Understand advanced storage design including MOLAP, ROLAP, and HOLAP.
Learn the fundamentals of MultiDimensional Expressions (MDX).
See best practices for SSAS administration using SQL Server Management Studio (SSMS) and XMLA (XML for Analysis).
Work with OLAP reporting clients including Microsoft Excel and SQL Server Reporting Services.
See integration with Microsoft Office 2007 and Microsoft SharePoint 2007.
Prerequisites: This course does not require any prior experience with Analysis Server 2005. It is assumed that students have working experience with SQL Server 2000 or 2005; basic relational database concepts (e.g., tables, queries, and indexing); data transformation services; Excel 2003; and SharePoint Server 2003.
What Is Microsoft BI?
Core concept - BI is the cube or UDM
Example cube as seen using Excel pivot table
MS BI is comprehensive - more than Analysis Services on SQL Server
Demonstration of SQL Reporting Services with cube as data source
OLAP Modeling
Modeling source schemas�stars and snowflakes
Understanding dimensional modeling� Dimensions (Type 1, 2, or 3) or rapidly changing
Understanding fact (measures) and cube modeling
Other types of modeling�data mining etc�
Using SSAS in BIDS
Understanding the development environment
Creating Data Sources and Data Source Views
Creating cubes � using the UDM and the Cube Build Wizard
Refining Dimensions and Measures in BIDS
Intermediate SSAS
KPIs
Perspectives
Translations � cube metadata and currency localization
Actions � regular, drill-through and reporting
Advanced SSAS
Using multiple fact tables
Modeling intermediate fact tables
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions
Modeling changing dimensions � Dimension Intelligence w/ Wizard
Using the Add Business Intelligence Wizards � write-back, semi-additive measures, time intelligence, account intelligence
Cube Storage and Aggregation
Storage topics � basic aggregations, MOLAP
Advanced Storage Design � MOLAP, ROLAP, HOLAP
Partitions � relational and Analysis Services partitions
Customizing Aggregation Design - Processing Design
Rapidly changing dimensions / ROLAP dimensions
Welcome to the Real Time � Proactive Caching
Cube processing options
Beginning MDX
Basic syntax
Using the MDX query editor in SQL Server Management Studio
Most-used Functions & Common tasks
New MDX functions
Intermediate MDX
Adding calculated members
Adding ******s
Adding named sets
.NET Assemblies
SSAS Administration
Best practices � health monitoring
XMLA ******ing (SQL Mgmt Studio)
Other ********ation methods
Security � roles and permissions
Disaster Recovery � backup / restore
Clustering � high availability
Introduction to Data Mining
What and why?
Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Na�ve Bayes, MS Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
Data Mining dimensions
Data Mining clients
Processing mining models
Introduction to Reporting Clients
Excel 2003 Pivot Tables
SQL RS & Report Builder
SPS RS web parts & .NET 2.0 report viewer controls
Business Scorecards 2005 & ProClarity
Future Directions � Integration with Office 12
SharePoint 12 and AS
Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter
Excel Services 12 and AS (Web Services)
--------------------------------------------------------------------------------
Your Instructor
Lynn Langit is a trainer and consultant who specializes in designing and implementing Business Intelligence solutions using Microsoft Analysis Server. She has been training and working with SSAS since 2000. Lynn also has over 10 years experience as a business manager, with full P & L responsibility. This unique combination of technical knowledge and business experience makes her particularly qualified to implement OLAP training. Lynn holds the following certifications - MCT, MCITP (SQL Administration and Development), MCDBA, MSCD and MSF.
--------------------------------------------------------------------------------------------------------------------
---------------------------------
------------------------------------------- Links ----------------------------------------------------------
22 rar files (48.8 MB) + 1 rar (9.53 MB) Including Videos, Labs and E-books
http://rapidshare.com/files/128479755/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part01.rar
http://rapidshare.com/files/128479756/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part02.rar
http://rapidshare.com/files/128479758/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part03.rar
http://rapidshare.com/files/128479761/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part04.rar
http://rapidshare.com/files/128484022/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part05.rar
http://rapidshare.com/files/128484025/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part06.rar
http://rapidshare.com/files/128484027/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part07.rar
http://rapidshare.com/files/128484028/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part08.rar
http://rapidshare.com/files/128489408/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part09.rar
http://rapidshare.com/files/128489410/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part10.rar
http://rapidshare.com/files/128489411/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part11.rar
http://rapidshare.com/files/128489414/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part12.rar
http://rapidshare.com/files/128495682/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part13.rar
http://rapidshare.com/files/128495685/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part14.rar
http://rapidshare.com/files/128495686/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part15.rar
http://rapidshare.com/files/128495688/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part16.rar
http://rapidshare.com/files/128499893/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part17.rar
http://rapidshare.com/files/128499894/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part18.rar
http://rapidshare.com/files/128499896/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part19.rar
http://rapidshare.com/files/128499900/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part20.rar
http://rapidshare.com/files/128507860/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part21.rar
http://rapidshare.com/files/128507862/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part22.rar
http://rapidshare.com/files/128508768/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part23.rar
http://rapidshare.com/files/128508769/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.sfv
Password: filecatchers.com
edited to remove live links
thank you debsan for reporting
Modules: 8
Run Time: 12
Pages: 450
In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services. Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%
In this course, you will:
Learn the core concepts in building solutions using Microsoft Business Intelligence with SSAS.
Understand OLAP (cube) modeling and data mining.
See how to develop solutions using Business Intelligence Development Studio (BIDS).
Understand advanced storage design including MOLAP, ROLAP, and HOLAP.
Learn the fundamentals of MultiDimensional Expressions (MDX).
See best practices for SSAS administration using SQL Server Management Studio (SSMS) and XMLA (XML for Analysis).
Work with OLAP reporting clients including Microsoft Excel and SQL Server Reporting Services.
See integration with Microsoft Office 2007 and Microsoft SharePoint 2007.
Prerequisites: This course does not require any prior experience with Analysis Server 2005. It is assumed that students have working experience with SQL Server 2000 or 2005; basic relational database concepts (e.g., tables, queries, and indexing); data transformation services; Excel 2003; and SharePoint Server 2003.
What Is Microsoft BI?
Core concept - BI is the cube or UDM
Example cube as seen using Excel pivot table
MS BI is comprehensive - more than Analysis Services on SQL Server
Demonstration of SQL Reporting Services with cube as data source
OLAP Modeling
Modeling source schemas�stars and snowflakes
Understanding dimensional modeling� Dimensions (Type 1, 2, or 3) or rapidly changing
Understanding fact (measures) and cube modeling
Other types of modeling�data mining etc�
Using SSAS in BIDS
Understanding the development environment
Creating Data Sources and Data Source Views
Creating cubes � using the UDM and the Cube Build Wizard
Refining Dimensions and Measures in BIDS
Intermediate SSAS
KPIs
Perspectives
Translations � cube metadata and currency localization
Actions � regular, drill-through and reporting
Advanced SSAS
Using multiple fact tables
Modeling intermediate fact tables
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions
Modeling changing dimensions � Dimension Intelligence w/ Wizard
Using the Add Business Intelligence Wizards � write-back, semi-additive measures, time intelligence, account intelligence
Cube Storage and Aggregation
Storage topics � basic aggregations, MOLAP
Advanced Storage Design � MOLAP, ROLAP, HOLAP
Partitions � relational and Analysis Services partitions
Customizing Aggregation Design - Processing Design
Rapidly changing dimensions / ROLAP dimensions
Welcome to the Real Time � Proactive Caching
Cube processing options
Beginning MDX
Basic syntax
Using the MDX query editor in SQL Server Management Studio
Most-used Functions & Common tasks
New MDX functions
Intermediate MDX
Adding calculated members
Adding ******s
Adding named sets
.NET Assemblies
SSAS Administration
Best practices � health monitoring
XMLA ******ing (SQL Mgmt Studio)
Other ********ation methods
Security � roles and permissions
Disaster Recovery � backup / restore
Clustering � high availability
Introduction to Data Mining
What and why?
Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Na�ve Bayes, MS Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
Data Mining dimensions
Data Mining clients
Processing mining models
Introduction to Reporting Clients
Excel 2003 Pivot Tables
SQL RS & Report Builder
SPS RS web parts & .NET 2.0 report viewer controls
Business Scorecards 2005 & ProClarity
Future Directions � Integration with Office 12
SharePoint 12 and AS
Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter
Excel Services 12 and AS (Web Services)
--------------------------------------------------------------------------------
Your Instructor
Lynn Langit is a trainer and consultant who specializes in designing and implementing Business Intelligence solutions using Microsoft Analysis Server. She has been training and working with SSAS since 2000. Lynn also has over 10 years experience as a business manager, with full P & L responsibility. This unique combination of technical knowledge and business experience makes her particularly qualified to implement OLAP training. Lynn holds the following certifications - MCT, MCITP (SQL Administration and Development), MCDBA, MSCD and MSF.
--------------------------------------------------------------------------------------------------------------------
---------------------------------
------------------------------------------- Links ----------------------------------------------------------
22 rar files (48.8 MB) + 1 rar (9.53 MB) Including Videos, Labs and E-books
http://rapidshare.com/files/128479755/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part01.rar
http://rapidshare.com/files/128479756/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part02.rar
http://rapidshare.com/files/128479758/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part03.rar
http://rapidshare.com/files/128479761/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part04.rar
http://rapidshare.com/files/128484022/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part05.rar
http://rapidshare.com/files/128484025/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part06.rar
http://rapidshare.com/files/128484027/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part07.rar
http://rapidshare.com/files/128484028/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part08.rar
http://rapidshare.com/files/128489408/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part09.rar
http://rapidshare.com/files/128489410/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part10.rar
http://rapidshare.com/files/128489411/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part11.rar
http://rapidshare.com/files/128489414/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part12.rar
http://rapidshare.com/files/128495682/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part13.rar
http://rapidshare.com/files/128495685/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part14.rar
http://rapidshare.com/files/128495686/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part15.rar
http://rapidshare.com/files/128495688/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part16.rar
http://rapidshare.com/files/128499893/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part17.rar
http://rapidshare.com/files/128499894/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part18.rar
http://rapidshare.com/files/128499896/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part19.rar
http://rapidshare.com/files/128499900/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part20.rar
http://rapidshare.com/files/128507860/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part21.rar
http://rapidshare.com/files/128507862/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part22.rar
http://rapidshare.com/files/128508768/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.part23.rar
http://rapidshare.com/files/128508769/filecatchers.com_Appdev.SQL.Server.2005.Analysis.S ervices.sfv
Password: filecatchers.com
edited to remove live links
thank you debsan for reporting