SQLBits 2024

Let's define Entities and attributes for tabular models in 20 minutes.

Examples from real-life projects that demonstrate the issue and improve the design of entities for the tabular models.

The tabular model in Power BI is composed of tables and relations. Tables should be model entities. Attributes integrate the entities.
There are several scenarios where tables cannot be identified as real entities.
This session will show examples from real-life projects demonstrating the issue and improving the models. Power Query will be the environment for the session.

Ana Maria Bisbe York's other proposed sessions for 2026

Querying data and metadata with T-SQL, M and DAX - 2026

SQL Fabric, the perfect combination of experience and youth - 2026

To filter or not to filter, that is a question - 2026

Ana Maria Bisbe York's previous sessions

Let's define Entities and attributes for tabular models in 20 minutes.

Examples from real-life projects that demonstrate the issue and improve the design of entities for the tabular models.

Lets play with a date field & Time Intelligence in Power BI

Date fields play an important role in virtually all cases of advanced analytics. The "problem & solution" style session can be very useful given the large number and variety of scenarios that may arise

Lets do the cleansing with M and / or Python languages

This short session will cover some scenarios of cleansing data in Power Query using M, Python, or both languages.

Some transformations that can save your ETL in Power BI

To build analytical models, we need to start by extracting, transforming, cleaning, preparing and loading the data. This session analyzes a set of scenarios that may happen during the ETL step using the Power Query in Power BI.