MOC 10990 – Analyzing Data with SQL Server Reporting Services
In questo corso Microsoft, MOC 10990 Analyzing Data with SQL Server Reporting Services, gli allievi apprendono come implementare una soluzione di data analysis basata su SQL Server 2016 Reporting Services. Viene approfondito l’utilizzo degli strumenti dedicati alla creazione, alla gestione di report e alla implementazione di soluzioni di Business Intelligence self-service.
Obiettivi del corso
Al termine del corso gli allievi saranno in grado di:
- Describe reporting services and it’s components
- Describe reporting services data sources
- Implement paginated reports
- Work with reporting services data
- Visualize data with reporting services
- Aggregate report data
- Share reporting services reports
- Administer reporting services
- Expand and integrate reporting services
- Describe mobile reports
- Develop mobile reports.
Prerequisiti
Per partecipare con profitto a questo corso è necessario che gli allievi:
- conoscenza di base dei sistemi operativi Windows e delle loro funzionalità core;
- esperienza di lavoro con i database relazionali;
- esperienza di lavoro con il linguaggio Transact-SQ
Dettaglio contenuti
Module 1: Introduction to Reporting Services
- Introduction to reporting services
- Reporting services components
- Reporting services tools
Module 2: Reporting Services Data Sources
- Data sources
- Connection strings
- Datasets
Module 3: Creating Paginated Reports
- Creating a report with the report wizard
- Creating a report
- Publishing a report
Module 4: Working with Reporting Services Data
- Data filters
- Report parameters
- Implementing report filters and parameters
Module 5: Visualizing Data with Report Services
- Formatting data
- Images and charts
- Databars, sparklines, indicators, gauges, and maps
Module 6: Summarizing Report Data
- Sorting and grouping
- Report sub-reports
- Drilldown and drill through
Module 7: Sharing Reporting Services Reports
- Schedules
- Report caching, snapshots, and comments
- Report subscription and delivery
Module 8: Administering Reporting Services
- Administering reporting services
- Reporting services configuration
- Reporting services performance
Module 9: Extending and Integrating Reporting Services
- Expressions and embedded code
- Extending reporting services
- Integrating reporting services
Module 10: Introduction to Mobile Reports
- Overview of mobile reports
- Preparing data for mobile reports
- Mobile report publisher
Module 11: Developing Mobile Reports
- Designing and publishing mobile reports
- Drillthrough in mobile reports
Destinatari
amministratori di database, sviluppatori, professionisti della Business Intelligence
Date del corso
1/02/2021
3/05/2021
02/08/2021
Lingua
Sede
Durata
Prezzo
per conoscere prezzi, dettagli e condizioni speciali per la tua azienda