Opleiding: Microsoft SQL Server BI 2019

Microsoft SQL Server BI 2019 kan ruwe data transformeren naar informatie waar bedrijven beslissingen op kunnen baseren.

Microsoft SQL Server BI 2019 kan ruwe data transformeren naar informatie waar bedrijven beslissingen op kunnen baseren. In deze training worden SQL Server Integration Services, SQL Server Analysis Services en SQL Server Reporting Services gecombineerd in één project.

Tijdens deze training komen de volgende onderwerpen aan bod:

- BI Fundamentals, Data Conversion and Error Handling, Loops, Variables and Parameters, Packaging and Deployment as well as Measures.
- Data Conversion, Sorting and Merging, Creating a Cube as well as Excel Display and Transactions.
- Reporting, Matrix Tabular Parameters, Data Profiling, Hierarchical Dimensions, Drill downs and Sub reports, KPIS as well as Pivot, Aggregation and Calculations.
- Executing SQL Tasks, Relationships, Script tasks and components, Graphical Reports, Partitions and Additive Measures
- Buffer Size Tuning, Multi-threading, Processing a Cube, Component Types, Architecture and Deployment and DQS.
- Tabular model, MDX, Data Mining, Page Splits and Aggregation.
- ROLAP, MOLAP, HOLAP, Instrumentation, Lookup Caching Mode, and Tabular Training.