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.
- Working knowledge of relational databases.
- Working knowledge of Transact-SQL.
- Some experience with database design.
- This course is NOT recommended to junior developers.
- 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
- 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
Price on request
This course last ran in September 2019. We do not know yet whether or when it will run again — that is why it is still here. Ask us if you are interested.
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
Andmeanalüüs
Power BI Basics
Power BI 3-day training introduces a powerful tool to help you make information-based decisions. Using Power BI data can be collected, organized, and merged into a data model.
17.02 – 19.02 · Aia 7 või veebikoolitusena · 24 ak. tundi
Virve Räni
BCS Koolitus
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.
19.11 – 27.11 · veebikoolitus · 32 akadeemilist tundi
Silver Toompalu
OfficePoint
Andmeanalüüs
Power BI edasijõudnutele
3-päevane Power BI edasijõudnutele koolitus tutvustab võimsat tööriista, mis aitab hõlbustada läbimõeldud otsuste tegemist. Tegemist jätkukursusele Power BI põhikursus.
14.12 – 16.12 · Aia 7 või videokonverentsi keskkonnas Zoom · 24 ak. tundi
10.02 – 12.02 · Aia 7 või videokonverentsi keskkonnas Zoom · 24 ak. tundi
+ 1 toimumist
Margus Sakk
BCS Koolitus
Tell me when this course runs again
This course is not running at the moment. Leave your contact details and we will let you know when it, or a similar course, is back in the calendar.
Otsid midagi muud?
Aitame leida sarnase koolituse või koostada tiimile eraldi pakkumise — vestle meiega.