Chapter 6: Star Schema Preparation in Power Query Editor
We learned about some common data preparation steps in the previous chapter, including data type conversion, split column, merge columns, adding a custom column, and filtering rows. We also learned how to create summary tables using the Group By feature, appending data, and merging queries.
This chapter will use all the topics we discussed in the past few chapters and help you learn how to prepare a Star Shema in Power Query Editor. Data modeling in Power BI starts with preparing a Star Schema. In this chapter, we'll use the Chapter 6, Sales Data.xlsx file, which contains flattened data. This is a common scenario many of us have faced; we get a set of files containing data that have ...
Get Expert Data Modeling with Power BI now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
