Back to Courses

Microsoft Msbi Online Training

Online Training by SV Soft Solutions

Inquire Now

Online / Training

Inquire to Request Schedule

View this Course

Inquire for Price

Inquire Book Now

RESPONSE RATE

Details
About the Provider

Book Now

Inquire

Details

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

Reviews

Be the first to write a review about this course.

Write a Review

SV Soft Solutions is a premier IT Training and Placement Institute. We attempt best quality courses in areas of PeopleSoft, SAP, Oracle, Android, Microsoft, Servicenow, Datawarehousing, Hadoop, Amazon Web services and Tibco. Our online training institute is the best place for you to brush up your technical leading and build a good career ahead in IT related technologies. Our main assets are our Trainers who have minimum 8 years of experience in IT. Our training takes place with well prepared training materials. We provide excellent documentation and preparation materials for learners.

Online Learning Course Benefits