Skillwave Training @skillwave.training · Jun 15 When we talk about the “shape” of your data, we mean things like: 🔵 How many tables you import into #PowerBI (and #PowerPivot for #Excel)? 🟩 How many columns are in each table? 🔶 Which columns are in multiple tables? ❤️ Should you unpivot your data so column headings become row values in your table?🧵
2 likes 1 replies
?
Replies
A reason data shape is important is because the shape of data in transactional systems (or relational databases) is seldom the ideal shape for Power BI or Power Pivot. This foundational article by Matt Allington explains the optimal data shape, the ⭐Star Schema: exceleratorbi.com.au/the-optimal-...