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