Pages

Monday, April 21, 2014

Microsoft Business Intelligence Highlights [MSBI]:SQL Server 2008, R2 and 2012 versions



SQL SERVER INTEGRATION SERVICES (SSIS)SQL SERVER ANALYSIS SERVICES (SSAS)SQL SERVER REPORTING SERVICES (SSRS)
Need for SSIS & Scope of UseMultidimensional DataWarehouseNeed for SSRS & Report Tools
SSIS Configuration & Catalog DBMultidimensional, Tabular ModesSSRS 2012 Configuration & Keys
Control Flow & Data Loads (ETL)SSAS Architecture & SchemasWeb Services & Service Accounts
Data Integrity & ConsistencyCube Design & Format OptionsData Sources & Shared Data Sets
Dynamic Precedence & LoadingCube and Dimension BrowsersRemote Data Sets & Report Parts
SSIS Configuration OptionsHierarchies & Attribute KeysTable Reports and Matrix Reports
SSIS Variables and ParametersSSAS 2012 Deployment IssuesReport Designer Paging Options
SCD Types and DatawarehouseMDX Queries, Joins and FunctionsGlobal Variables and Data Sets
OLTP and DW Delta LoadsMDX Calculations and ScriptsDrill-down Reports & Bar Charts
Checkpoints & SSIS LoggingCube Partitions & Storage ModesParameters & DataSet Filters
Transactions and Isolation LevelsSSAS Aggregations and TuningSSRS 2012 Dashboard Design
CHECKSUM Transformation & DWParent, Child KPIs and ActionsChart Reports & Map Reports
Error Handling & Event HandlingAggregations & PerspectivesJoining Local, Shared Datasets
TDS Packets & Buffer SizingTime based Expressions & KeysSSRS 2008 R2 Report Models
.NET Integration & ScriptingProactive Caching & KPI TuningSSRS Deployment & Options
SSIS 2012 Deployment ToolsExcel Pivot Tables & Pie ChartsCache Refresh and Snapshots
Package Deployment & SecurityData Mining & Forecasts (DMX)SSRS Snapshots and History
Scheduling SSIS Package JobsXMLA & DAX : Security OptionsSecurity Management & Roles
Package Migrations & ReportsDeployment Process & MigrationsCube Based Reports with MDX
Package Backups & UpgradesBI Enhancements & GranularityReport Builder Configuration)
SSIS Performance Tuning TipsNew Features in SSAS 2012SSRS Report Monitoring & Tuning
Realtime Case Study on SSISRealtime Case Study on SSASRealtime Case Study on SSRS

No comments:

Post a Comment