Converting a Flat Table to a Good Data Model in Power Query

When loading a wide Excel table into Power BI, we end up with a suboptimal data model. What can we do to create a good data model? What even is a “good” data model? Let’s dig into it.

Salvatore Cagliari

·

Follow

Published in

Towards Data Science

·

12 min read

·

Dec 22, 2023

--

2

Share