Microsoft Msbi Online Training

  • MSBI MARKET REQUIREMENTS
    • INTRODUCTION TO BUSINESS INTELLIGENCE
    • DEFINING BI USING MICROSOFTS TOOLS
    • WHAT MICROSOFT PRODUCTS ARE INVOLVED?
    • BI LANGUAGES
    • UNDERSTANDING BI FROM AN END USERS PERSPECTIVE
    • REASONS TO SWITCH TO MICROSOFTS BI TOOLS

SSIS

  • SQL SERVER INTEGRATION SERVICES
    • WHAT IS SQL SERVER INTEGRATION SERVICES
    • A SHORT INTEGRATION SERVICES HISTORY
    • MAJOR DIFFERENCES BETWEEN DTS AND SSIS
    • SCOPE OF MIGRATING FROM DTS
    • SQL SEVER INTEGRATION SERVICES COMPONENTS
      • RUNTIME ENGINE, DATA FLOW ENGINE, SERVICES ENGINE, OBJECT MODEL, SSIS PLANNED FOR ETL
  • SSIS GETTING STARTED
    • MOVING DATA WITH IMPORT AND EXPORT WIZARD
    • INSTALLING SSIS SERVICES
    • CREATING A SOLUTION AND PROJECT
    • EXPLORING BUSINESS INTELLIGENCE DEVELOPMENT STUDIO
      • SOLUTION EXPLORER, PROPERTIES WINDOW, TOOL BOX, BIDS DESIGN ENVIRONMENT
  • CREATING FIRST PACKAGE
    • CREATING AND USING CONNECTION MANAGERS
    • EXECUTING PACKAGES
  • TASKS
    • CONTROL FLOW TASK
    • FILE SYSTEM TASK
    • CUSTOM SCRIPT TASK
    • EXECUTABLE SQL TASK
    • SEND MAIL TASK
    • FTP TASK
    • DATA FLOW TASK
  • EXTRACTING FROM SOURCE AND LOADING DATA TO DESTINATION TRANSORMATIONS
    • DATA CONVERSION
    • DERIVED COLUMN
    • AGGREGATE
    • SORT
    • LOOKUP
    • ROW COUNT
    • UNION ALL
    • CONDITIONAL SPLIT
    • FUZZY LOOKUP AND GROUPING
    • VARIABLES AND EXPRESSION DEPLOYMENT AND ADMINISTRATION

SSAS

  • SSAS BASICS
    • INTRODUCTION TO OLAP
    • FROM PIVOT TABLES TO DIMENSIONAL PROCESSING
    • DATA WAREHOUSING
    • APPLICATIONS OF OLAP
    • HISTORY OF OLAP
    • SQL SERVER ANALYSIS SERVICES
    • DATA MINING
      • CUBES, DIMENSIONS, AND MEASURES
    • CUBES AND THEIR COMPONENTS
    • DEFINING MEASURES AND DIMENSIONS
    • SCHEMAS
    • DIMENSIONS IN DEPT
    • MEASURES
    • TYPES OF AGGREGATION
  • MULTIDIMENSIONAL EXPRESSIONS (MDX)
  • DATA WAREHOUSES
  • STORAGE
    • STAGING DATABASES
    • STORAGE MODES
  • SERVER ANALYSIS SERVICES REQUIREMENTS
    • HARDWARE
    • VIRTUALIZATION
    • SOFTWARE
    • UPGRADING
    • STANDARD OR ENTERPRISE EDITION?
  • ARCHITECTURE
    • THE UNIFIED DIMENSIONAL MODEL
    • LOGICAL ARCHITECTURE
    • PHYSICAL ARCHITECTURE
    • STORAGE
  • CUBE STRUCTURES IN SSAS
    • DATA SOURCES
    • DATA SOURCE VIEW
    • THE CUBE STRUCTURE ITSELF
    • DIMENSIONS
    • MINING STRUCTURES
    • STORAGE
  • CREATING A DATA SOURCE VIEW
    • CUBES NEED DATA
    • DATA SOURCES
    • DATA SOURCE VIEWS
      • DESIGNING
      • NAMED CALCULATIONS AND QUERIES
  • CREATING DIMENSIONS
  • DIMENSIONAL ANALYSIS
    • REVIEW OF THE DIMENSION CONCEPT
    • STAR OR SNOWFLAKE?
  • DIMENSIONS IN SSAS
    • CREATING A DIMENSION
    • ANALYSIS MANAGEMENT OBJECTS (AMO)
    • DIMENSION PROPERTIES
  • ATTRIBUTES
    • ATTRIBUTE RELATIONSHIPS
    • ATTRIBUTE PROPERTIES
  • PARENT-CHILD DIMENSIONS
  • THE TIME DIMENSION
  • MDX
  • WHY THE NEED?
  • TUPLES AND SETS
    • NOTATION
    • TUPLES
    • SETS
  • MDX QUERIES
    • SELECT
    • WHERE
    • MDX FUNCTIONS
    • CATEGORIES OF FUNCTIONS
  • BUILDING A CUBE
  • DIMENSIONS AND CUBES
    • CREATING CUBES
    • USING MEASURE GROUP TABLES
    • SELECTING DIMENSIONS
    • DEFINING DIMENSION USAGE
  • MEASURES AND MEASURE GROUPS
    • MEASURES
    • MEASURE GROUPS
    • CALCULATED MEASURES
  • DEPLOYING AND PROCESSING
  • DEPLOYING A PROJECT
    • PROJECT PROPERTIES
    • DEPLOYMENT
  • USING THE DEPLOYMENT WIZARD
    • RUNNING THE WIZARD

SSRS

  • INTRODUCING THE REPORTING SERVICES ARCHITECTURE
  • UNDERSTANDING THE BENEFITS OF SSRS
    • SQL SERVER 2008 REPORTING SERVICES ENHANCEMENTS
    • SSRS AND BUSINESS INTELLIGENCE
  • EXPLORING THE SSRS ARCHITECTURE
    • SSRS DATABASES
    • THE SSRS REPORT SERVER
    • CLIENT APPLICATIONS
  • INSTALLING AND CONFIGURING
  • DEPLOYING SSRS SECURELY
  • INTRODUCTION TO REPORTING SERVICES DESIGN
  • EXPLORING THE ELEMENTS OF BIDS
    • SETTING UP A BASIC IDE
    • UNDERSTANDING REPORT DEFINITION LANGUAGE (RDL)
    • ADDING A REPORT
    • SETTING UP DATA SOURCES AND DATASETS SETTING PARAMETERS
    • SETTING UP FILTERS
    • EXPRESSIONS
  • LAYING OUT A REPORT
    • SETTING UP PAGINATION
    • USING REPORT OBJECTS
  • BUILDING REPORTS
  • CREATING A REPORT WITH THE REPORT WIZARD
    • BUILDING REPORTS FROM SCRATCH
    • FORMATTING THE OUTPUT
    • ADDING SUBTOTALS
    • ADDING INTERACTIVITY
  • SETTING REPORT PARAMETERS WITH STORED PROCEDURES
  • WORKING WITH MULTIVALUED PARAMETERS
    • APPLYING A FILTER
    • ADDING A CHART
    • ADDING TABLIX ELEMENTS
    • REPORT AND GROUP VARIABLES
    • ADDING THE NEW GAUGE CONTROL
  • DEPLOYING REPORTS
  • USING REPORT MANAGER
  • USING REPORT BUILDER 2.0