Business Intelligence implementation using Microsoft SQL Server 2016 (based on MOC#20767 and MOC#20768)

The main coal of this five-day instructor-led course is to provide students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

Sihtgrupp

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include implementing multidimensional databases by using SQL Server Analysis Services and creating tabular semantic data models for analysis by using SQL Server Analysis Services.

Eeldused

Working knowledge of relational databases.
Working knowledge of Transact-SQL.
Some experience with database design.
This course is NOT recommended to junior developers.

Programm

Module 1: Designing and Implementing a Data Warehouse
Module 2: Columnstore Indexes
Module 3: Implementing an Azure SQL Data Warehouse
Module 4: Creating an ETL Solution
Module 5: Implementing Control Flow in an SSIS Package
Module 6: Implementing a Data Extraction Solution
Module 7: Enforcing Data Quality
Module 8: Using Master Data Services
Module 9: Implementing Master Data Services
Module 10: Deploying and configuring SSIS Packages
Module 11: Consuming Data in a Data Warehouse
Module 12: Introduction to Business Intelligence and Data Modeling
Module 13: Creating Multidimensional Databases
Module 14: Working with Cubes and Dimensions
Module 15: Working with Measures and Measure Groups
Module 16: Introduction to MDX
Module 17: Customizing Cube Functionality
Module 18: Implementing a Tabular Data Model by Using Analysis Services
Module 19: Introduction to Data Analysis Expression (DAX)
Module 20: Performing Predictive Analysis with Data Mining

Omandatavad oskused

Provision a Database Server.
Upgrade SQL Server.
Configure SQL Server.
Manage Databases and Files (shared).
Describe the components, architecture, and nature of a BI solution
Create a multidimensional database with Analysis Services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis

Lisainfo

Learning methods: Practical exercise, independent work. Assesment methods: Execution of independent work. Assesment form: Independent practical tasks on relevant topics.

Investeering

Hind kokkuleppel

Küsi, millal toimub

Korraldaja

BCS Koolitus

Vaata firma profiili

✨

Vajan seda oma tiimile

Aitame koostada päringu

›

See koolitus toimus viimati septembris 2019. Me ei tea veel, kas ja millal see kordub — seepärast on ta siin alles. Küsi järele, kui see sind huvitab.

Sarnased koolitused, mis praegu toimuvad

Administreerimine

Administering a SQL Database Infrastructure (55316A)

55316A Administering a SQL Database Infrastructure on koolitus, kust saad kõik praktilised oskused ja teadmised SQL andmebaaside infrastruktuuri haldamisest.

16.11 · Lõõtsa 5

15.03 · Lõõtsa 5

Henn Sarv

Nordic Koolitus

1090€+kmVaata

Administreerimine

Administering Microsoft SQL Server Databases (Microsoft SQL Serveri andmebaaside haldamine)

See nelja päevane kursus annab õpilastele teadmised ja oskused Microsoft SQL Server 2022 andmebaasi haldamiseks.

05.10 – 08.10 · Aia 7 · 32 ak. tundi

Gunnar Peipman

BCS Koolitus

1390€+kmVaata

Andmeanalüüs

Äriandmete analüüs ja visualiseerimine: Excelist Power BI-ni

Osalejad omandavad tööriistad ja meetodid, mis võimaldavad neil tõhusalt koguda, töödelda, analüüsida ja esitada andmeid, et toetada ärilisi otsuseid.

22.10 – 30.10 · veebikoolitus · 32 akadeemilist tundi

19.11 – 27.11 · veebikoolitus · 32 akadeemilist tundi