Course Description
Module 1: Introduction to Business Intelligence and Data Modelling
In this module students will be introduced to the key concepts in business intelligence, and the Microsoft BI product suite.
Lessons
- Introduction to business intelligence
- The Microsoft business intelligence platform
- Introduction to reporting services
Lab : Exploring an enterprise BI solution
After completing this module, you will be able to:
• Describe key concepts in business intelligence
• Describe the Microsoft BI platform
• Describe key concepts in reporting services
Module 2: Reporting Services Data
Describe various Report Services data sources and how these are configured.
Lessons
- Data connections
- Connection strings
- Filters and parameters
Lab : Configuring a data connection
After completing this module, you will be able to:
• Describe data connections and connection strings
• Describe filters and parameters
Module 3: Implementing reports
Create reports with report designer or report builder. Lessons
- Creating a report with the report wizard
- Creating a report
- Showing data graphically
Lab : Creating a report
After completing this module, you will be able to:
• Create a report using the report wizard
• Show data graphically
Module 4: Creating a Map Report
This module describes how to configure reports with report builder or report designer.
Lessons
- Implementing filters and parameters
- Implementing sorting and grouping
- Publishing a report
Lab : Creating a map report
After completing this module, you will be able to:
• Implement filters and parameters
• Implement sorting and grouping
• Publish a report
Module 5: Creating Mobile Reports
This module describes how to create SQL Server mobile reports.
Lessons
- Overview of SQL Server mobile reports
- Preparing data for mobile reports
- Mobile report publisher
Lab : Mobile reports
After completing this module, you will be able to:
• Describe SQL Server mobile reports
• Prepare data for mobile reports
• Publish mobile reports < br/>
Agenda
Module 1: Introduction to Business Intelligence and Data Modelling
In this module students will be introduced to the key concepts in business intelligence, and the Microsoft BI product suite.
Lessons
- Introduction to business intelligence
- The Microsoft business intelligence platform
- Introduction to reporting services
Lab : Exploring an enterprise BI solution
After completing this module, you will be able to:
• Describe key concepts in business intelligence
• Describe the Microsoft BI platform
• Describe key concepts in reporting services
Module 2: Reporting Services Data
Describe various Report Services data sources and how these are configured.
Lessons
- Data connections
- Connection strings
- Filters and parameters
Lab : Configuring a data connection
After completing this module, you will be able to:
• Describe data connections and connection strings
• Describe filters and parameters
Module 3: Implementing reports
Create reports with report designer or report builder. Lessons
- Creating a report with the report wizard
- Creating a report
- Showing data graphically
Lab : Creating a report
After completing this module, you will be able to:
• Create a report using the report wizard
• Show data graphically
Module 4: Creating a Map Report
This module describes how to configure reports with report builder or report designer.
Lessons
- Implementing filters and parameters
- Implementing sorting and grouping
- Publishing a report
Lab : Creating a map report
After completing this module, you will be able to:
• Implement filters and parameters
• Implement sorting and grouping
• Publish a report
Module 5: Creating Mobile Reports
This module describes how to create SQL Server mobile reports.
Lessons
- Overview of SQL Server mobile reports
- Preparing data for mobile reports
- Mobile report publisher
Lab : Mobile reports
After completing this module, you will be able to:
• Describe SQL Server mobile reports
• Prepare data for mobile reports
• Publish mobile reports