Summary
In this chapter, we discussed some of the most critical best practices for data preparation. We cannot cover all the best practices in a chapter or two, but we tried to cover some of the most important ones in this chapter. We learned how to optimize query sizes in Power Query and discussed how case sensitivity in Power Query could affect our data model. Going ahead, we learned the importance of query folding and how we can identify whether a query is folded. We then looked at some datatype conversion best practices and how to reduce the number of steps by avoiding unnecessary steps. We then discussed the importance of having naming conventions.
In the next chapter, we will discuss data modeling components and building a star schema.
