Microsoft SQL Server: Introduction to SQL Server Business Intelligence

Course Overview

This course is intended to give delegates an overview of what SQL Server Business Intelligence is all about and how Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS) might benefit their organisation.

It will offer an introduction to each of the three services which contribute towards the SQL Server Business Intelligence Solutions and through demonstrations will show each service in action. By the end of the course delegates will have an insight into the role of business intelligence, will be able to identify whether it has a place in their organisation's data management solutions and will be able to identify which of the services they require.

This course serves as a good lead in to the more hands-on and specialist courses aimed at configuring and maintaining SSIS, SSAS,SSRS; and creating, deploying and securing SSIS packages, OLAP Cubes, Reports.

This Microsoft training course will help you stay competitive, sharpen your skills and could enhance your Microsoft career prospects.

Related Courses

• Microsoft SQL Server: Optimisation / Performance Tuning - Advanced, Optimization
• Microsoft SQL Server: Analysis Services: Hands-On
• Microsoft: Introduction to Microsoft Tools (SQL Server, Excel SharePoint) for Business Intelligence: Hands-On
• Microsoft SQL Server: Introduction to Microsoft Business Intelligence with SQL Server
• Microsoft SQL Server: Expert Business Intelligence with SQL Server
• Microsoft SQL Server Upgrade Training Course
• Microsoft SQL Server: Advanced Queries & Transact SQL Programming
• Microsoft SQL Server: Advanced SQL, Stored Procedures & Triggers for Microsoft SQL Server
• Microsoft SQL Server: Introduction to Transact SQL
• Microsoft SQL Server: SQL Introduction For SQL Server

Examinations

Related Brands

• Microsoft® >>

Related Paths

• MCTS Microsoft Certified Technology Specialist >>
• MCITP Microsoft Certified IT Professional >>

Related Tracks

• Microsoft Dynamics GP 10.0 certifications >>
• Microsoft Certified IT Professional: Installation and Deployment for Microsoft Dynamics CRM 4.0 >>

Related Exams

• Exam MB3-532 Microsoft Dynamics GP 10.0 Project Series >>
• Exam MB3-532 Elective: Microsoft Dynamics GP 10.0 Project Series >>

Prerequisites

This course is ideally suited to anyone who wishes to know a bit more about SQL Server's Business Intelligence services: Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).

It would suit IT management or Data Management/Data Analyst decision makers who would like to understand what SQL Server Business Intelligence can offer their organisation, the role of each of the three services and how they could implement all or some of them to satisfy their data analysis and reporting needs.

It would also suit any individuals who may need to work with these services, but would like to get an overview of what each service does and how they work together before moving on to in depth and specific training. scheduled dates / price

Course Outline

INTRODUCTION TO BUSINESS INTELLIGENCE

• What Is Business Intelligence?
• Data Warehousing
• Populating Data Warehouses
• Data Analysis
• Reporting
• What Business Intelligence Tools does SQL Server offer?
• Integration Services (SSIS)
• Reporting Services (SSRS)
• Analysis Services (SSAS)
• Business Intelligence Development Studio (BIDS)

INTRODUCTION TO SQL SERVER INTEGRATION SERVICES (SSIS)

• Integration Services Features and Architecture Overview
• What is ETL?
• SSIS Tools
• BIDS
• SSIS Wizards
• SSMS
• SSIS Packages
• Control Flow
• Data Flow
• Transformations
• Data Sources
• Connection Managers
• Error Handling
• Creating and Deploying a Simple Package
• Automating Package Deployment
• Miscellaneous Features of SSIS
• Maintenance Plan Tasks
• Analysis Services Tasks
• Database Transfer Tasks

INTRODUCTION TO SQL SERVER REPORTING SERVICES (SSRS)

• Reporting Services Features and Architecture Overview
• SSRS Tools
• BIDS
• Report Manager
• SSMS
• Data Sources
• OLTP - SQL
• OLAP -MDX
• SSRS Reports
• Report Types
• Ad-hoc Reports
• Report Models
• Creating and Deploying a Simple Report
• Automating Report Deployment

INTRODUCTION TO ANALYSIS SERVICES

• Analysis Services Features and Architecture Overview
• Analysis Service Tools
• BIDS
• SSMS
• Data Warehouse
• Data Sources
• Data Source Views
• OLAP Cubes
• Dimensions
• Measures
• Partitions
• Creating and Deploying a simple Cube
• Creating A Cube Without a Data Source
• Creating A Cube For An Existing Data Source
• Process The Cube
• Aggregating Data
• Automating Cube Deployment
• Querying Cubes
• Viewing Cube Data With SSMS
• Viewing Cube Data With MDX
• Miscellaneous Analysis Services Features
• Cube Perspectives
• Key Performance Indicators (Kpis)
• Data Mining
• Security and Roles
• Creating A Report Based On A Cube

Microsoft SQL Server: Introduction to SQL Server Business Intelligence / cm68821

Request availability or enquire by clicking a date: