Summary
This chapter 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 data type conversion best practices and how to reduce the number of steps by avoiding unnecessary steps and using query parameters. We then discussed the importance of having naming conventions.
In the next chapter, we will discuss data modeling components and building a star schema.
Join us on Discord!
Join The Big Data and Analytics Community on the Packt Discord Server!
Hang out with 558 other members and enjoy free voice and text chat.
