Related Posts
Who wants to go out for valentines dinner 💞
Additional Posts in Data & Analytics Consultants
MS Powerapps - Yay or Nay?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
For Power BI, until you get past a hundred million rows being aggregated performance should be fine unless you have to write complex DAX.
In terms of look up tables (sometimes called dimensions) you’re best off making the model look like a “star schema”, plenty of resources out there for that pattern.
You definitely don’t want only one table in your model, patterns good for Tableau in TDE mode are an anti pattern in Power BI. Assuming the data has dates, you’ll want a separate date table.
Enjoy the journey!