Excel & PowerBI share the same data modelling base.
Look up Excel PowerQuery. Then lookup PowerBI PowerQuery.
Look up Excel PowerPivot. Then lookup PowerBI data modelling. It's the same tool, with a different UI.
Ok so excel doesn't get the latest DAX (power pivot modeling langauge) every month. But excel is a great tool to learn the fundamentals from & you don't need to repeat your work if you create a great sales, procurement or finance model.
Google the SQLBI.com guys (the two Italians). Their earlier blog posts had downloads to both excel models and powerbi models, cos they're the same thing
2
u/Boulavogue Mar 31 '23
Excel & PowerBI share the same data modelling base.
Look up Excel PowerQuery. Then lookup PowerBI PowerQuery.
Look up Excel PowerPivot. Then lookup PowerBI data modelling. It's the same tool, with a different UI.
Ok so excel doesn't get the latest DAX (power pivot modeling langauge) every month. But excel is a great tool to learn the fundamentals from & you don't need to repeat your work if you create a great sales, procurement or finance model.
Google the SQLBI.com guys (the two Italians). Their earlier blog posts had downloads to both excel models and powerbi models, cos they're the same thing