Get startedGet started for free

Breaking a file into multiple tables

Frequently, a data scientist or business analyst will receive a single, wide file containing a variety of fields. It's often desirable to break out a single table into a more structured format in order to reduce duplication (thus saving space).

In addition, if you are breaking out a reference table from a wide table, this can make it easier for certain visuals such as slicers to show the appropriate options available. In the next chapter, we will expand on this, but for now, create your own lookup table on NAICS codes.

This exercise is part of the course

Data Modeling in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise