Další podobné školení nebo kurzy:
[Kurz] Program kurzu (obsah přednášky/semináře/rekvalifikace/studia) ...
Goals After completing this course, students will be able to:
- Describe key features of data modelling within business intelligence
- Describe various report services data sources and how these are configured
- Create reports with report designer and/or report designer
- Configure reports with report designer and/or report builder
- Create SQL Server mobile reports
Main instructor
Marek Chmel Microsoft MVP Marek works as SQL Server Technical Specialist and is part of an international team for managing several thousand of database servers. As a consultant and trainer he has great experience not only in SQL Server, but also with other products of Microsoft such as SharePoint Server, Exchange and Lync Server and Business Intelligence solutions. Since 2013, he is awarded the prestigious Microsoft MVP in SQL Server category. In his free time he is devoted to security issues, lecturing and writing articles and last but not least, is ver
* After completing this course, students will be able to:
- Describe key features of data modelling within business intelligence
- Describe various report services data sources and how these are configured
- Create reports with report designer and/or report designer
- Configure reports with report designer and/or report builder
- Create SQL Server mobile reports
Main instructor
Marek Chmel Microsoft MVP Marek works as SQL Server Technical Specialist and is part of an international team for managing several thousand of database servers. As a consultant and trainer he has great experience not only in SQL Server, but also with other products of Microsoft such as SharePoint Server, Exchange and Lync Server and Business Intelligence solutions. Since 2013, he is awarded the prestigious Microsoft MVP in SQL Server category. In his free time he is devoted to security issues, lecturing and writing articles and last but not least, is very active on the discussion forums. For this activity he received twice awarded Microsoft Community Contributor in 2012.
Outline 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 c