Introduction

This module explains how to design a semantic model, which is the task you undertake as a data modeler once you apply your Power Query queries. At this point in your development, you have a model comprising one or possibly more tables—but there's more work to be done. Your goal is to develop a model that supports the reporting requirements, and that's user-friendly and intuitive. Essentially, you're developing a semantic layer over the data.

Your first design efforts should focus on configuring the relationships between model tables. You can then move on to enhance the model design by setting table and column properties, and by creating other model objects, like hierarchies, measures, and parameters.