SQL Server 2022 Business Intelligence

Planning a BI solution - Elements of a MS SQL Server BI solution - Planning a BI project - BI platform from Microsoft

Planning an MS SQL Server BI infrastructure - Planning a Data Warehouse infrastructure - Planning an ETL infrastructure - Planning an Analysis Services infrastructure - Planning a Reporting Services infrastructure

Designing a MS SQL Server Data Warehouse solution - Logical schema - Physical schema

Design of a MS SQL Server ETL solution - Data Extraction - Data Transformation - Data Loading - SSIS Package Deployment

MS SQL Server Analytical Data Model - Options - Design Considerations

MS SQL Server BI Delivery Solution - Considerations - Choosing the Right Approach

SharePoint Server BI Solution - Introduction to SharePoint Server as a BI Platform - Security in a SharePoint Server BI Solution - Reporting Services Configuration - PowerPivot Configuration - PerformancePoint Services

Monitoring and Optimization - Overview of BI Monitoring - Monitoring and Optimization of Data Warehouse - Monitoring and Optimization of Analysis Services - Monitoring and Optimization of Reporting Services

MS SQL Server BI Operations - Overview of BI Operations - Automating ETL Tasks - Publishing ETL Tasks - Planning a Backup Strategy

MS SQL Server Reporting Services - Designing reports - Report execution considerations - Planning a reporting solution

Excel-based reporting - Working with Excel for data reporting and analysis - PowerPivot in Excel, Power View in Excel

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

We offer seminars with a high practical relevance. The contents and exercises are geared to your daily tasks in the company and completely dispense with advertising references to other products of the software manufacturer.

All our training courses are manufacturer-independent. This enables us to offer critical considerations of the products themselves and comparisons with competitors of the manufacturer in the seminar. The course contents are our own and derived from the practical experience of our trainers in projects.

Of course, the contents of company seminars can be individually adapted to your needs. Please do not hesitate to contact us.

• Implementation guarantee - Implementation guarantee for two or more participants
• Mobile classrooms - the ideal complement for company seminars
• Free support - for questions after the seminar
• Delivery on account - no prepayment required
• Interview with the trainer / quality assurance - get to know and assess the trainer in advance
• Clarify seminar requirements - review your knowledge with the trainer
• Assistance with travel costs - we cover part of the costs of hotel accommodation
• Meals - all day cold / hot drinks and a full lunch in the restaurant
• Location of training centres - always centrally located and easily accessible
• Discount - we have attractive prices, take advantage of our additional discounts
• Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars