MICROSOFT BUSINESS INTELLIGENCE Course Content



Introduction to Microsoft Business Intelligence
Installing and using BI tools
Configuring BI tools
SSIS
INTRODUCTION TO SQL SERVER 2008 INTEGRATION SERVICES
Over view of integration services solutions
Integration Services Tools
DEVELOPING INTEGRATION SERVICES SOLUTIONS
Creating an Integration Services Solution
Using Variables
Building And Running a Solution
IMPLEMENTING CONTROL FLOW
Control Flow Tasks
Control Flow Precedence Constraints
Control Flow Containers
IMPLEMENTING DATA FLOW
Data Flow Sources and Destinations
Data Flow Transformations
Data Flow Pipeline
IMPLEMENTING LOGGING
Overview of Integration Services Logging
Implementing Logging
DEBUGGING AND ERROR HANDLING
Debugging a Package
Implementing handling
IMPLEMENTING CHECKPOINTS AND TRANSACTIONS
Implementing Checkpoints
Implementing Transactions
SSIS ADMINISTRATION
Deploying Packages
Managing Packages
Securing Packages
Scheduling a Package
SSRS
INTRODUCTION TO MICROSOFT SQL SERVER REPORTING SERVICES
Over View of SQL Server Reporting Services
Installing Reporting Services Reporting Services Tools
AUTHORING REPORTS
Creating a Basic Table Report
Formatting Report Pages
Calculating Values
Interactive Navigation
Displaying Data
MANIPULATING DATA SETS
Defining Report Data
Using parameters and Filters
Using Parameter Lists
PUBLISHING AND EXECUTING REPORTS
Publishing reports
Executing reports
Creating Cached instances
Creating Snapshots and Report History
USING SUBSCRIPTIONS TO DISTRIBUTE REPORTS
Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions
SSRS ADMINISTRATION
Server Administration
Performance and Reliability monitoring
Administering Report Server Databases
Security Administration
SSAS
INTRODUCTION TO ANALYSIS SERVICES
OLTP,DWH
OLAP TYPES
SSAS Architecture
Dimension Tables
Fact tables
Cubes
Analysis Services Tools
CUBE DESIGN PROCESS AND CONCEPTS
Dimensions
Measure groups
Creating Simple Calculations
Aggregations and Hierarchies
Dimensions Relationships
Transactions
Perspectives
ADVANCED CUBE DESIGN PROCESS
MDX introduction and Queries
Implementing KPI
Implementing Actions
Using Write back
SSAS ADMINISTRATION
Apply Security Roles
Levels of Security
VLDB with partitioning
OLAP Processing
Monitoring Cube activity
Deployment and Scheduling
Planning for Disaster Recovery
Performance Tuning SSAS

Enquiry Form                         

CONTACT US

  1. 10521 Shadow Ridge Ln Apt 203,
  2. Louisville KY-40241
  3. Contact No : 606 909 4722
  4. Email : contact@coloursit.com

TESTIMONIALS

  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Kranthi Ch
MD, Siri IT Solutions



  I am Pleased to compliment your organization for your efficiency and professionalism.     
– Sreedhar J
Manager, Siri IT Solutions

Copyright © 2014 Colours IT Consulting | All Rights Reserved.