Data Modelling Training

Our two-day course will provide participants with the conceptual background and hands-on experience to understand data modelling concepts and techniques. The course covers key principles, best practices, and hands-on exercises to equip participants with the knowledge and skills needed to create effective data models.

Data modelling is a critical skill for data professionals, as it forms the foundation for designing data warehouses, data marts, analytical systems, data visualisations and reporting outputs.

This course is ideally suited to anyone who regularly handles and analyses data in their role.....

• Business Analysts 

• Data visualisation professionals 

• Data / information analysts 

• Database developers 

• Anyone interested in business intelligence, analytics and data modelling 

Overview 

This two-day course will provide participants with the conceptual background and hands-on experience to understand data modelling concepts and techniques.  

Data modelling is a critical skill for data professionals, as it forms the foundation for designing data warehouses, data marts, analytical systems, data visualisations and reporting outputs.  

This course will cover key principles, best practices, and hands-on exercises to equip participants with the knowledge and skills needed to create effective data models. 

Outcomes  

• Attendee Outcomes: 
  • Practical data modelling skills that you can apply immediately  
  • Develop the ability to build data models that enable analysis and insightful reporting 
  • Understand data strategy and how to implement – from defining business needs to implementing scalable data models 

• Organisational Outcomes: 
  • Maximising your investment by getting value of the data you have in your organisation  
  • Enhanced data governance leading to better decision-making across the organisation 
  • Scalability and flexibility allowing your organisation to respond to changing data needs and growth efficiently 
  • Investing in your team’s capability and development, leading to greater engagement, improve retention and enhanced use of tools  

Course Outline  

• Introduction: What is Data Modelling?
  • Importance of Data Modelling
  • Types of Data Models
•  Dimensional Modelling Basis
  • Understanding Dimensions and Facts
  • Star Schema vs. Snowflake Schema
  • Facts, Measures and Aggregations
• Identifying Business Requirements
  • Gathering Requirements for Data Modelling
  • Defining Metrics and KPIs
• Designing Dimension Tables
  • Hierarchical Structures
  • Attributes, Hierarchies and Levels
  • Slowly Changing Dimensions
• Designing Fact Tables
  • Identifying Measures
  • Grain of Fact Tables
  • Fact Table Relationships
• ETL/ELT Processes
  • Extract, Transform, Load (ETL), Extract, Load, Transform (ELT) Overview
  • Data Sources and Data Transformation
• Data Quality and Governance
  • Data Quality Best Practices
  • Data Governance and Metadata
  • Managing Historical Data
• Hands-On Exercises

Our Trainers 

Montage trainers are active consultants and practitioners in their fields. They are not just smart on the theory, they know how to use the tools in real-world settings and are great problem-solvers.   

Prerequisites 

Basic understanding of data and databases. 

Course Cost 

NZD $1,600 per person, excluding GST.

Please contact us for a quote for on-site training for 4+ people.  

Book Now