Introduction to SQL Server Business Intelligence Course

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 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.

Topics covered on the 1 day Introduction to SQL Server Business Intelligence course

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 & 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 & 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 & 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 & Roles
• Creating A Report Based On A Cube