1. 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
2. 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
3. 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
4. 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
5. Intermediate SSAS
- KPIs
- Perspectives
- Translations cube
metadata and currency localization
- Actions regular,
drill-through and reporting
6. Advanced SSAS
- Using multiple fact
tables
- Modeling intermediate
fact tables
- Modeling M:M
dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write
back dimensions
- Modeling changing
dimensions Dimension Intelligence w/ Wizard
- Using the Add Business
Intelligence Wizards write-back, semi-additive measures, time
intelligence, account intelligence
7. 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
8. Beginning MDX
- Basic syntax
- Using the MDX query
editor in SQL Server Management Studio
- Most-used Functions
& Common tasks
- New MDX functions
9. New MDX functions
- Adding calculated
members
- Adding scripts
- Adding named sets
- NET Assemblies
10. SSAS Administration
- Best practices health
monitoring
- XMLA scripting (SQL
Mgmt Studio)
- Other Documentation
methods
- Security roles and permissions
- Disaster Recovery
backup / restore
- Clustering high availability
11. Introduction to Data Mining
- What and why?
- Examples of using each
of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MSSequence Clustering, MS
- Time Series, MS
Association Rules, MS Neural Network)
- Data Mining dimensions
- Data Mining clients
- Processing mining
models
12. Introduction to Reporting
Clients
- Excel 2003 Pivot Tables
- SQL RS & Report
Builder
- SPS RS web parts &
.NET 2.0 report viewer controls
- Raising Errors
- Business Scorecards
2005 & ProClarity
13. 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)
14. SQL Server 2005 Integration
Services Introduction to SQL Server Integration Services
- Product History
- SSIS Package
Architecture Overview
- Development and
Management Tools
- Deploying and Managing
SSIS Packages
- Source Control for SSIS
Packages
15. SSIS for DBAs: Using SQL
Server Management Studio
- The Import and Export
Wizard
- Importing and Exporting
Data
- Working with Packages
- Database Maintenance
Plans
- Creating Database
Maintenance Plans using SSMS
- Scheduling and
Executing Plans
- Examining Database
Maintenance Plan Packages
- Changes in SQL Server
2005 Service Pack 2
16. Business Intelligence
Development Studio
- Launching BIDS
- Project templates
- The package designer
- The Toolbox
- Solution Explorer
- The Properties window
- The Variables window
- The SSIS menu
17. Introduction to Control Flow
- Control Flow Overview
- Precedence Constraints
- The Execute SQL Task
- The Bulk Insert Task
- The File System Task
- The FTP Task
- The Send Mail Task
18. ADVANCED CONTROL FLOW - Control Flow Overview
- Precedence Constraints
- The Execute SQL Task
- The Bulk Insert Task
- The File System Task
- The FTP Task
- The Send Mail Task
| 19. ADVANCED CONTROL FLOW - Containers grouping and looping
- The Web Service Task
- The WMI tasks
- The Analysis Services tasks
- The Execute Process Task
- The Execute Package Task
20. VARIABLES AND CONFIGURATIONS - ariables Overview
- Variable scope
- SSIS system variables
- Using variables in control flow
- Using variables in data flow
- Using variables to pass information between packages
- Property expressions
- Configuration Overview
- Configuration options
- Configuration discipline
21. DEBUGGING, ERROR HANDLING AND LOGGING - SSIS debugging overview
- Breakpoints in SSIS
- SSIS debugging windows
- Control Flow: The On Error event handler
- Data Flow: Error data flow
- Configuring Package Logging
- Built-in log providers
22. ADVANCED DATA FLOW - Revisiting data sources and destinations
- The Lookup Transformation
- Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
- The Multicast Transformation
- The Merge and Merge Join Transformations
- The Derived Column Transformation
- The Data Conversion Transformation
- The Slowly Changing Dimension Transformation
23. EXTENDING SSIS THROUGH CUSTOM CODE - Introduction to SSIS scripting
- The SSIS script editor
- The SSIS object model
- Script in Control flow: The Script Task
- Script in Data flow: The Script Component
- Introduction to SSIS component development
24. SSIS PACKAGE DEPLOYMENT - Configurations and deployment
- The deployment utility
- Deployment options
- Deployment security
- Executing packages DTExec and DTExecUI
25. SSIS PACKAGE MANAGEMENT - The SSIS Service
- Managing packages with DTUtil
- Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent
26. SQL SERVER 2005 REPORTING SERVICES INTRODUCTION TO SQL SERVER REPORTING SERVICES - Tour of Features
- Reporting Services Architecture
- Reporting Services Terminology
- Reporting Services Editions
- Taking Reporting Services for a Spin
27. CREATING REPORTS - Deconstructing Reporting Services
- Shared Data Sources
- Creating Reports from Scratch
28. CALCULATIONS AND FORMATTING - Creating Expressions
- Using the Global Collections
- Formatting Items
- Conditional Formatting
29. GROUPING AND SORTING - Creating Groups
- Calculating Totals and Percentages
- Interactive Sorting
- Creating Drill-Down Reports
30. REPORT PARAMETERS - Creating Report Parameters
- Creating Drop-Down Parameters
- Multi-Valued Parameters
- Debugging Parameter Issues
31. CREATING MATRIX REPORTS AND CHARTS - Creating Report Parameters
- Creating Drop-Down Parameters
- Multi-Valued Parameters
- Debugging Parameter Issues
32. `CREATING MATRIX REPORTS AND CHARTS - Chart
- Exploring the Charting Possibilities
33. MANAGING REPORTING SERVICES - ports and Printing
- Using the Web-Based Report Manager
- Using SQL Server Management Studio-based Reporting Services Manager
34. REPORTING SERVICES SECURITY - Two Parts to Reporting Services Security
- Securing Access to Reports
- Data Source Security
35. PROGRAMMING REPORTING SERVICES - The Many Reporting Services APIs
- Integrating Reporting Services into Applications using URL Access
- Using the Report Viewer Controls
36. ADVANCED REPORTING SERVICES PROGRAMMING - Using the Reporting Services
- Web ServiceWorking with Custom Assemblies
37. SNAPSHOTS AND SUBSCRIPTIONS - Caching and Snapshots
- Creating Standard Subscriptions
- Managing Subscriptions
38. AD-HOC REPORTING WITH REPORT BUILDER - The Report Builder Architecture
- Creating Report Model Projects
- Running Report Builde
| 