Learn
  • Learn
  • University
  • Community
  • Documentation
  • Support
  • Go to GoodData.com
Try it now
  • Home
  • Courses
    • Getting Started
      • Introduction
      • Create Workspace
      • Connect Your Data
      • Build Logical Data Model
      • Create Visualizations
      • Create Metrics
      • Create Dashboard
      • Embed Into Your Web App
    • Understand Logical Data Model
      • Introduction To Data Model
      • LDM in Detail
      • LDM and Analyzing Data
      • Summary
    • Designing Data Models
      • Introduction
      • Data Model Examples
      • Dimensional Approach
      • Summary
      • Bonus Lessons
    • Nested Aggregations
      • Introduction
      • Nested Aggregations
      • Inline Nesting
      • Summary
  • Tutorials
    • Getting Started
      • Getting started with GoodData Cloud
    • Managing Organizations
      • Authentication in GoodData Cloud
      • Common SSO Issues & Tips on GoodData Platform
      • Custom Fields in GoodData Cloud
      • Embed Dashboard with a Silent Login via Okta SSO
      • Getting started with SSO
      • GoodData.CN: Collecting Diagnostics - Support Bundle
      • Localization and Internationalization
      • Okta SSO Integration Guide with GoodData.CN
      • Provisioning and Change Management Automation in GoodData Platform
      • Setting up Single Sign-On between Azure Active Directory and GoodData
    • Connecting Data
      • ADD - Incremental Data Loading
      • Output Stage Naming Conventions
    • Data Modeling
      • Logical Data Model in GoodData - Introduction
      • Objects of the Logical Data Model
      • Basic Rules of Data Modeling in GoodData
      • Logical Data Model - Five Pro-Tips for Data Modelling
      • Logical Data Model and Performance
      • Created/Updated timestamps in LDM
      • Data Modeling - Time
      • How-To: Display Null or Missing Values
      • Simplified Declarative API In GoodData.CN 2.0
      • Using Date Dimensions in GoodData
    • Creating Metrics
      • Benchmarking Against the Average Value
      • Best Practices: Naming Conventions for MAQL Measures
      • Calculate a Simple Linear Regression
      • Cohort Analysis
      • Covariance and Correlation and R-Squared
      • Geometric Mean and Product Aggregate Function
      • GoodData.CN: Metrics Management 101
      • How to Use MAQL Count in GoodData Platform
      • How to Use MAQL Count in GoodData.CN
      • Hypothesis Testing - One Sample T-Tests and Z-Tests
      • Hypothesis Testing - One Way Analysis of Variance (ANOVA) with F-Test
      • MAQL With/Without Parent Filter
      • Normality Testing - Skewness and Kurtosis
      • Running Total Function in GoodData Platform (Sum vs Runsum)
      • Running Total Function in GoodData.CN (Sum vs Runsum)
      • Time in MAQL (Time Macros & Time Transformation in GoodData.CN)
      • Time Series Analysis - Lagged Correlation and R-Squared
      • Time Series Forecasting
    • Adding Interactivity
      • Drilling Into Visualizations
    • Developer Tools
      • Embedding Dashboards into your Application
      • Embedding via iFrame vs GD.UI DashboardView
      • GoodData.UI: PGP SSO Example
      • GoodData.UI: SAML SSO Example
      • How to Get Metadata Object Identifiers in GoodData Platform
      • How to Get Metadata Object Identifiers in GoodData.CN
      • How to Test Web Components
      • Import GoodData OpenAPI schema to Postman API Platform
      • Raw Executions on GoodData Cloud

Designing Data Models

About this course

This course will explain why and how to build logical data models in GoodData. It will give you examples and tools to build star schemas derived from business requirements, as well as the basic principles of dimensional data modeling.

Introduction

The semantic layer simplifies and standardizes complex data for easy user interaction and effective business decision-making.

Data Model Examples

This section teaches how to transform operational data models into star schemas for effective analytics, covering simplification, aggregation, and handling data changes.

Dimensional Approach

Learn how to transform operational data models into star schemas for effective analytics, focusing on simplification, aggregation, and handling data changes.

Summary

A recap of what you've learned about transforming operational data models into star schemas for effective analytics.

    • Start trial
    • Request a demo
    • See pricing
    • Product Overview
    • Business Intelligence
    • Artificial Intelligence
    • Analytics Lake
    • Trust & Security
    • Analytics as Code
    • Headless BI
    • Embedded Analytics
    • Data Visualization
    • Data Monetization
    • Query Acceleration
    • Solutions Overview
    • Professional Services
    • Software
    • Healthcare
    • E-commerce
    • Finance
    • Insurance
    • Real Estate
    • Pharma
    • ESG
    • Restaurants
    • Banking
    • Documentation
    • University
    • Community
    • Support
    • Certification Program
    • Python SDK
    • React SDK
    • Examples Gallery
    • API References
    • Release Notes
    • All resources
    • Product Tours
    • Case Studies
    • Whitepapers
    • Analyst Reports
    • E-books
    • Videos
    • Webinars
    • Events
    • BI Blog
    • Company
    • Customers
    • Partners
    • Careers
    • Newsroom
    • Brand
Copyright© 2007 - 2025 GoodData Corporation. All Rights Reserved.
Privacy Policy
Legal
Support Policy