5 day - Jet Enterprise for BI Developers Masters Course (Onsite)
SKU:
£3,250.00
£3,250.00
per item
The Jet Data Manager (JDM) replaces Visual Studio / SQL Server Data Tools as the GUI (graphic user interface) of choice for customizing your Microsoft BI Stack.
Any variation of Jet Data Manager training (online or onsite) can be customized for content and duration according to the skills and needs of the audience.
This training is recommended for Data Analysts with a strong understanding of database & table structure within your ERP and SQL Developers.
This training is probably not appropriate for mid-level managers and C-Level executives.
Standard Topics include:
Any variation of Jet Data Manager training (online or onsite) can be customized for content and duration according to the skills and needs of the audience.
This training is recommended for Data Analysts with a strong understanding of database & table structure within your ERP and SQL Developers.
This training is probably not appropriate for mid-level managers and C-Level executives.
Standard Topics include:
- Introduction to Dimensional Modeling
- SQL ETL (extract, transform, load) using the Jet Data Manager
- Data architecture and flow through the business intelligence environment
- Cube development and OLAP Security using the Jet Data Manager
- Basic MDX Business Functions
- Integrating data from multiple databases
- Integrating custom procedures, functions and scripts into the ETL workflow
- Advanced data modeling patterns including Bridge Tables and Many to Many Relationships in the cubes.
- Slowly changing Dimensions 2 and higher
- Working with hypercubes and advanced dimension properties and relationships
- Performance optimization and best practices.
