Build a star schema from a single flat file
One wide CSV, thousands of repeated names. By the end you have a fact table, two dimension tables, and a model Power BI actually wants.
Tutorials, tips, and deep dives on Star Schema — every post from bianca.codes tagged Star Schema.
One wide CSV, thousands of repeated names. By the end you have a fact table, two dimension tables, and a model Power BI actually wants.
Three slicers and a card don't turn a spreadsheet into a data model, and the columns you didn't build are exactly where it falls apart.