MS BI Syllabus

Microsoft Business Intelligence Course Syllabus


SSRS – SQL Server Reporting Services
 Getting Started·
1. Understanding Reporting (Authoring,Management,Delivery)
2. Installing Reporting (Native Mode, SharePoint Integration mode)
3. Building your first report
 Authoring Reports·
1. Developing Basic Reports (RDL,wizard,designer,datasource,dataset,formatting)
2. Working with expressions (expression to calculate value, Agg functions, exp for objects)
3. Organizing Data (Data Regions, Table, Matrix, Chart, List)
4. Advance Report (Parameter, drill down, drill through, links,
5. Report Model (Data Source, Data Source View, Model , Report Builder 3.0)
 Managing Report ( Report Manager)·
1. Managing Content (deploying report, folders, linked reports, datasources, value etc)
2. Managing Security (Item Level , Site navigation, localhost – sql)
3. Managing Server Config (Config Manager, Report Manager, Report Server DB)
 Delivering Report·
1. Accessing Report (Viewing Report, Report History, saving in diff format, printing)
2. Rendering Report ( online – mhtml, doc – pdf,tiff, data – excel,csv)
3. Managing Subscription (Standard subscription, Data driven subscription)
 Programming Report·
1. Using Code.
2. Using Reporting Service
3. Custom Assembly
SSIS – SQL Server Integration Services
 Getting Started With SSIS·
1. Introduction
2. Import and Export wizard
3. Building first package
4. Components
 Designing Packages·
1. Extracting and Loading Data
2. Using Dataflow Transformations
3. Control Flow
4. Scripting Task
5. Debugging
6. Managing Package Execution
 Managing Packages·
1. Detecting and Handling Processing errors.
2. Configurations and deployment.
 Applying SSIS to DW·
1. DW Concepts
2. Populating DW structures
3. General Principles 
SSAS – SQL Server Analysis Services

· Getting Started
1. Business Intelligence and Data Warehousing
2. OLAP and Analysis Services
3. First Cube
· Design Fundamentals
1. Data Source and Data Source Views (Creating and Modifying)
2. SSAS Cube (Creating and Modifying)
3. Dimensions (Creating and Modifying , hierarchies , assigning dimension to cube)
4. Measure Group (Creating, adding measure group and measure)
5. Adding KPIs (Goal,Status,Trend), Actions (URL,DrillThrough,Reporting) etc.
6. Storage Modes – MOLAP,ROLAP,HOLAP
7. Perspective
8. Translations.
· Production Management
1. Deployment (impersonation mode, processing cube)
2. Partitions (partitions), Aggregations (Aggregations Design , Usage based optimization)
3. MDX - introduction