New Analyze data and generate reports using SQL Server Reporting Services

The course is recommended primarily for business intelligence professionals, BI designers and developers who will be responsible for implementing data analysis and visualization solutions from databases and data warehouses.

• Introduction to business intelligence (BI) systems and data modelling: business intelligence concepts, components, trends, BI solutions, Microsoft BI platforms; simple BI solutions (Reporting Services report, PowerPivot workbook)
• Reporting Services data management: data sources; data relationships (connection strings; data sets; filters and parameters, parameters, parameters, parameters, parameters, parameters and their configuration and use
• Jelentések készítése SQL Server 2017 Reporting Services segítségével: a Using the Report Wizard to create a simple report. Reports publish and view reports
• Implement filters and parameters for reports
• Formatting reports, using images and diagrams. Advanced visualisation elements (databar, sparkline, indicator, gauge, map, KPI) incorporation in reports
• Grouping, aggregating and sorting data in reports. Advanced tips, tricks and practical advice for producing reports
• Scheduled implementation. Cache and snapshot (snapshot technology. Standard and data-driven subscription
• Reporting Services administration, configuration and performance optimization
• Use of expressions and embedded code. extension of SSRS and integration
• Preparing data for mobile reports. Designing mobile reports and and publishing. Drilling down in mobile reports

Windows 8/10 or Windows Server 2012/2016 operator basics, previous SQL Server basics, query and implementation knowledge and experience. Completion of or knowledge of 20461 or 20761 courses required. As the course materials are in English, a basic level of English at document reading level is required. The lecture will be given in Hungarian.