Data Modelling Training
Montage are experienced Power BI trainers, offering training and support services to help you get the most from Power BI.
Choose the content and timing to suit your organisation.
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
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 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
Course Cost
NZD $1,600 per person, excluding GST.
Please contact us for a quote for on-site training for 4+ people.