This five day course provides students with the knowledge and skills to develop Microsoft End
to-End business solutions using SQL Server 2008 R2 in an integrated environment with
SharePoint 2010 and Office 2010. The course introduces the students to Microsoft Unified Data Model, SQL 2008 R2 Analysis Services, Integration Services, Re-porting Services, Report Builder 3.0, SharePoint 2010 Integration, Reporting Services Content Types, PerformancePoint Services, Dashboard Designer, Excel Services, Power Pivot and Data Mining. The intention of this course is to allow a business to more accurately understand the scope of a BI project, the resources, the potential pitfalls, the state of the art and perhaps most importantly understand why it may produce for an organization an unmatched competitive edge.
SharePoint Training Audience:
Project mangers, developers, I.T. Professionals, end-user ombudsman, analyst
SharePoint Training Prerequisites
Understanding Of Relational Database Concepts and goals of Business Intelligence.
SharePoint Training Course duration
5 days
SharePoint Training Course outline
1. The Business Intelligence Stack
- SQL 2008R2 BI Platform
- Enterprise Extract Transform Load with Integration Services
- Analysis Server
- DBMS Management System
- Understanding Multidimensional Space Terminology
- Reporting Services
- Understanding Terminology
- Data Mining
- Dashboards/ Scorecards
- SharePoint 2010 Services 2010
- Web Server
- Content Database
- Web Application / Collection
Tools
2. The Unified Data Module
- Data Sources
- Data Views
- Proactive Caching
- When It Is Inappropriate to Use UDM
3. SQL Server Integration Services
- Data Import/ Export Wizard
- Extract Transform Load Tool
- Control Flow and Data Flow Engine
- Application Platform
- New or Changed Features
- Script Task and When to Use It
- MERGE operation in an SQL statement
- Change Data Capture
- Data Flow Improvements
- Data Profiling Task and Viewer
- Enhanced Performance and Cashing for the Lookup Transformation
- New Debug Dump
- New SSIS Connection Project Wizard
4. Extract Transform Load
- ETL Life Cycle
- Extract
- ADO Net Source
- Excel Source
- Flat File Source
- Raw File Source
- XML Source
- Transform
- SSIS Logging
- Best Practices for Design
5. SQL Server Analysis Services
- Cubes
- Multi Dimension Space
- Measures / Groups / Dimensions
- Granularity
- Dimension Hierarchies
6. MDX
- MDX Query Editor
- Select Statement
- Select Clause
- From Clause/ Where Clause
- Tuples
- Cells
- Partial Tuples
- Sets
- Functions
- Limiting Sets
- Time
7. SQL Server Reporting Services
- Integration with SharePoint
- Integrated Install
- Report Processing and Rendering
- Report Processing Options
- Report Authoring Environments
- Data Access
- Datasets
- Charts
- Report Builder 3.0
- Subscriptions
- Integration with SharePoint 2010
- SharePoint is the Repository
- SharePoint Security
- Storage Security
- Decomposition Tree
- Improved Scorecards
- Improved Time Intelligence with Dynamic Filters
- Linking of PerformancePoint Web Parts
- KPI Details Report
- Analytics Reports
- Navigating Dashboard Designer
- Visual Reports
- Types of Visual Reports
- PPS Filters
8. Excel Services
- What Excel Services Is Not
- Single Version of The Truth
- Differences when in the Browser
- Preparing and Publishing a Workbook
- Excel Web Part
- Visio Services
9. PowerPivot
- PowerPivot and Excel
- PowerPivot and SharePoint
- Enterprise Business Intelligence & PowerPivot
- VertiPaq Engine
- Importing Data
- Enriching Data
- Refreshing Data
- Formatting Data
- Sorting and Filtering
- Creating Relationships
- Calculations
- SharePoint Sharing
10. Data Mining
- What is Data Mining
- Why Data Mining
- Problems Addressed
- Notable Uses of Data Mining
- Data Mining Tasks
- Microsoft Algorithms
- Microsoft Decision Trees
- Microsoft Time Series
- Microsoft Clustering
- Microsoft Sequence Clustering
- Microsoft Associations Rules
- Microsoft Neural Network
- Matching the Tasks to the Algorithm
- SQL OLAP Mining
- SSIS Data Mining
- Excel and The BI Extensions
- Forecast Table Analysis Tool
- Prediction Calculator Tool
- Shopping Basket Analysis Tool
- Detect Categories Table
- Analyze Key Influences
