Data modeling is critical to making the most of the immense potential of data analytics.
It is therefore critical that we take a step forward in the way we think about data and start thinking in the perspective of facts and dimensions and design our models accordingly.
Let's learn how to tasform an immense classic Excel-style table into a well-structured star schema, using Power Query.
We learn how to optimize the size and performance of our Power Bi data model and why it's so important. We also learn how evaluate the size of our model in memory and how evaluate the size of the data loaded by each query.
We train our minds to think in the right data mindset.