Course Detail

MSBI Course Curriculum

MSBI Course Curriculum - Primark infotech


Course Detail


Course Description

Introduction to Business Intelligence SQL Server 2008R2 Business Intelligence

Course Agenda:
  • SQL Server 2008R2 Integration Services (SSIS)
  • SQL Server 2008R2 Analysis Services (SSAS)
  • SQL Server 2008R2 Reporting Services (SSRS)
SQL Server 2008R2 Integration ServicesIntroduction to SQL Server Integration Services
  • SSIS Package Architecture Overview
  • GUI ETL TOOL
  • CODE BASED TOOL
  • EXTRACTION
  • INTERNAL EXTRACTION AND EXTERNAL SOURCE
  • TRANSFORMATIONS
  • MERGING, CLEANSING,SCRUBBING AND AGGREGATIONS.
  • Development and Management Tools
  • The Import and Export Wizard
  • SQL TO EXCEL AND FLAT
  • EXCEL AND FLAT FILE TO SQL
  • EXCEL TO FLAT AND FLAT TO EXCEL
Guided tour of Business Intelligence Development StudioIntroduction to Data Flow
  • Data Flow Overview
  • Data Sources
  • Data Destinations
  • Data Flow Transformations
  • Data Viewers
Data Sources
  • Excel Source
  • Flat File Source
  • OLE DB Source
  • XML Source
Data Flow Transformations
  • Aggregate Transformation
  • Audit Transformation
  • Character Map Transformation
  • Conditional Split Transformation
  • Copy Column Transformation
  • Derived Column Transformation
  • Data Conversion Transformation
  • Multicast Transformation
  • OLE DB Command Transformation
  • Percentage Sampling Transformation
  • Row Count Transformation
  • Sort TransformationK
  • Union All Transformation
Advanced Data Flow
  • Lookup Transformation
  • Merge Transformation
  • Merge Join Transformation
  • Slowly Changing Dimension Transformation
  • ivot Transformation
  • Export Transformation
  • Import Transformation
  • Unpivot Transformation
Data Flow Destinations
  • Data Reader Destination
  • Excel Destination
  • Flat File Destination
  • OLE DB Destination
Introduction to Control Flow
  • Control Flow Overview
  • Precedence Constraints
  • The Execute SQL Task
  • The Bulk Insert Task
  • The File System Task
  • The FTP Task
  • The Send Mail Task
  • Bulk Insert Task
  • Data Flow Task
  • Execute DTS 2000 Package Task
  • Execute Package Task
  • Execute Process Task
  • Web Service Task
  • XML Task
Advanced Control Flow
  • For Loop Container
  • For Each Loop Container
  • Sequence Container
Variables and Configurations
  • Variables Overview
  • Variable scope
  • SSIS system variables
  • Using variables in control flow
  • Using variables in data flow
  • Using variables to pass information between packages
  • Property expressions
  • Configuration Overview
  • Configuration options
  • Configuration discipline
Debugging, Error Handling and Logging
  • SSIS debugging overview
  • Breakpoints in SSIS
  • Control Flow: The On Error event handler
  • Data Flow: Error data flow
  • Configuring Package Logging
  • Built-in log providers
SSIS Package Deployment
  • Configurations and deployment
  • The deployment utility
  • Deployment options
  • Deployment security
  • Executing packages – DTExec and DTExecUI
SQL Server 2008R2 Reporting ServicesSQL Server Reporting Services (SSRS) Architecture
  • Standard reports
  • integrated repors
  • adhoc reports
  • Data sources: SQL Server, Oracle, OLE DB
Authoring ReportsCreating basic reports
  • Tabular
  • List
  • Matrix
  • Chart
  • Constructing data sources and Datasets
  • Inserting a data region, fields and images
Leveraging expressions
  • Calculating fields
  • Integrating expressions in properties
  • Applying conditional formatting
  • Adding images
Grouping and sorting data
  • Grouping to multiple levels
  • Sorting the results
  • Employing aggregate functions
Implementing Parameters and FiltersBuilding parameters into reports
  • Returning subsets of data with query parameters
  • Mapping report parameters to query parameters
  • Building cascading report parameters
  • Passing parameters to stored procedures
  • Exploiting multivalve parameters
Restricting report data with filters
  • Enhancing performance with filters
  • Filters vs. query parameters
  • Localizing tables and queries
Leveraging Advanced Reporting FeaturesCombining data regions in one report
  • Utilizing sequential and nested regions
  • Producing master/detail reports
  • Linking sub reports
  • Presenting data with appropriate detail
    • Revealing report detail with drill down
    • Displaying related data with drill through
    • Navigating with document maps
Deploying and Delivering ReportsDeploying reports to the server
  • Preparing reports for publishing
  • Configuring project properties
  • Units of deployment: Individual reports, projects, solutions, data sources
  • Checking results with Report Manager
Securing Reporting ServicesSecuring the RS environment
  • Assigning users to roles
  • Setting permissions on report items
  • Granting
SQL Server 2008R2 Analysis ServicesWhat Is Microsoft Business Intelligence?
  • Defining Microsoft Business Intelligence
  • Understanding the UDM
  • Building and Viewing a Sample Cube
  • Viewing a Cube Using Excel
  • Cubes in Reporting Services
  • Using SSAS in BIDS
  • Understanding BIDS
  • Creating Data Sources
  • Creating Data Source Views
  • Creating a Cube Using the Wizard
  • Refining Dimensions and Measures
Intermediate SSAS
  • Creating KPIs
  • Creating Perspectives
  • Creating Translations
  • Creating Actions
  • Advanced SSAS
  • Working with Multiple Fact Tables
  • Using Advanced Dimension Types
  • Working with Changing Dimensions
  • Using the Business Intelligence Wizard
Cube Storage and Aggregation
  • Basic Storage: MOLAP
  • Customized Aggregations
  • Advanced Storage: MOLAP, HOLAP, or ROLAP
  • Implementing Proactive Caching
  • Using Partitions: Relational or SSAS
  • Cube and Dimensions Processing Options
Beginning MDX
  • Understanding MDX
  • About Members, Tuples, and Sets
  • Common MDX Functions Explained
  • New or Updated MDX Functions or Keywords
Introduction to SSAS Clients
  • Using Excel 2007 Pivot Tables
  • Using SQL Server Reporting Services

Institute Overview

Hyderabad, Telangana, India

  Primark Infotech is a multi faceted services Organization that provides Business Consulting, Training and consulting services. We provide not only training; we make them efficient in the area which they choose their carrier. We make t... Read More

Related Courses

Google Map