Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
- The foundational principles, objectives, and applications of data warehouses for government, including various types of data warehouse servers.
- Establishing and building Extract, Transform, Load (ETL) processes using SQL Server Integration Services (SSIS).
- Fundamental design techniques for creating data cubes in Analysis Services, focusing on measure groups and measures.
- Understanding dimensions, hierarchies, and attributes within the context of data warehousing for government.
- Developing comprehensive project data cubes that incorporate calculated measures, partitions, perspectives, translations, actions, and Key Performance Indicators (KPIs).
- Constructing and deploying data cubes, including the processing of partitions.
- Basic XML/A concepts: Partitioning, incremental processes, deletion of partitions, and aggregation processes.
- An introduction to the Multi-Dimensional Expressions (MDX) language for querying and managing multidimensional data in government applications.
Requirements
Proficiency with Windows, as well as foundational knowledge of SQL and relational databases, is required for government operations.
14 Hours
Testimonials (2)
Deepthi was super attuned to my needs, she could tell when to add layers of complexity and when to hold back and take a more structured approach. Deepthi truly worked at my pace and ensured I was able to use the new functions /tools myself by first showing then letting me recreate the items myself which really helped embed the training. I could not be happier with the results of this training and with the level of expertise of Deepthi!
Deepthi - Invest Northern Ireland
Course - IBM Cognos Analytics
The thorough / hands-on knowledge the trainer has.
