C4-X-MS-DIM (Advanced)

Practical project in hands-on mode for the biGENIUS-X Microsoft SQL Server Dimensional Generator:

1. Setup

2. Setup Solution and Projects

3. Data Stores implementation

4. Stage File implementation

5. Data Solution implementation - Sources

6. Data Solution implementation - Entities

7. Data Solution implementation - Facts

8. Overall load and parallel loading

9. Cleansing action analysis

10. Change requests and delta deployment

11. Data Mart implementation

12. Production deployment

13. Data vizualization

To obtain the biGENIUS-X Expert certification, you need to pass an online exam with 29 questions.

‍

biGENIUS Expert Guidance

Boost your e-learning experience with personalized, on-demand support from our biGENIUS experts. The add-on lets you schedule live 1:1 sessions for guidance on training content and hands-on exercises.

Knowledge prerequisites

Completion of module: C3-X-MS-DIM – Microsoft SQL Server (dimensional modeling)

‍

Technical prerequisites

• Please prepare your training environment as instructed in this biGENIUS-X Knowledge Base article: Target environment for Microsoft SQL Server – Stage File‍‍
• We suggest using a Docker Windows image instead of installing a local SQL server.
• If you use a local installation, you must know how to use and configure SQL Server before starting this training.

No additional support from biGENIUS will be provided regarding your SQL Server installation and configuration.