MS-BI 2008 R2 Course

Microsoft has dubbed SQL 2008 R2 as the BI release.

MS-BI 2008 R2 Online Training

In customer scenarios with the requirement to integrate data out of SAP BW with some non-SAP data sources people usually recommended to first consolidate and load everything into a single system ( either SAP BW or SQL Server / SSAS ).

What you will learn

Any kind of reporting or data analysis would then go against SAP BW or the SQL Server/SSAS based data mart. There are some pros and cons with this approach. Especially query performance would be very likely better in case the data would be persisted in a central “single-point-of-truth” compared to a kind of distributed query which has to access and join multiple data sources. But extracting data from SAP BW and persist it in SQL Server or SSAS has some challenges too ( e.g. mapping of BW roles, data redundancy, synchronization between both systems … ).

  • INTEGRATION SERVICES

MS-BI 2008 R2 (SSIS,SSAS,SSRS) Online Training Course Content

 

  • INTEGRATION SERVICES (SSIS)
  • ANALYSIS SERVICES (SSAS)
  • REPORTING SERVICES (SSRS)
  • Need for SSIS & Scope of Use
  • Multidimensional DataWarehouse
  • Need for SSRS & Report Tools
  • SSIS Configuration & Catalog DB
  • Multidimensional, Tabular Modes
  • SSRS 2012 Configuration & Keys
  • Control Flow & Data Loads (ETL)
  • SSAS Architecture & Schemas
  • Web Services & Service Accounts
  • Data Flow Transformations
  • Cube Design & Format Options
  • Data Sources & Shared Data Sets
  • Dynamic Precedence & Loading
  • Cube and Dimension Browsers
  • Remote Data Sets & Report Parts
  • SSIS Configuration Options
  • Hierarchies & Attribute Keys
  • Table Reports and Matrix Reports
  • SSIS Variables and Parameters
  • SSAS 2012 Deployment Issues
  • Report Designer Paging Options
  • SCD Types and Datawarehouse
  • MDX Queries, Joins and Functions
  • Global Variables and Data Sets
  • OLTP and DW Delta Loads
  • MDX Calculations and Scripts
  • Drill-down Reports & Bar Charts
  • Checkpoints & SSIS Logging
  • Cube Partitions & Storage Modes
  • Parameters & DataSet Filters
  • Transactions and Isolation Levels
  • SSAS Aggregations and Tuning
  • SSRS 2012 Dashboard Design

 

  • CHECKSUM Transformation & DW
  • Parent, Child KPIs and Actions
  • Chart Reports & Map Reports
  • Error Handling & Event Handling
  • Aggregations & Perspectives
  • Joining Local, Shared Datasets
  • TDS Packets & Buffer Sizing
  • Time based Expressions & Keys
  • SSRS 2008 R2 Report Models
  • .NET Integration & Scripting
  • Proactive Caching & KPI Tuning
  • SSRS Deployment & Options
  • SSIS 2012 Deployment Tools
  • Excel Pivot Tables & Pie Charts
  • Cache Refresh and Snapshots
  • Package Deployment & Security
  • Data Mining & Forecasts (DMX)
  • SSRS Snapshots and History
  • Scheduling SSIS Package Jobs
  • XMLA & DAX : Security Options
  • Security Management & Roles
  • Package Migrations & Reports
  • Deployment Process & Migrations
  • Cube Based Reports with MDX
  • Package Backups & Upgrades
  • BI Enhancements & Granularity
  • Report Builder Configuration
  • SSIS Performance Tuning Tips
  • New Features in SSAS 2012
  • SSRS Report Monitoring & Tuning
  • Realtime Case Study on SSIS
  • Realtime Case Study on SSAS
  • Realtime Case Study on SSRS
Back to top