Forum Discussion
Data Modeling in Excel using Power Pivot
Learn how Power Pivot simplifies data analysis. Topics include: multiple tables and relationships, editable linked tables, DAX formulas, custom calendars, and measure concepts, with a focus on demonstrating each of these capabilities.
Hi Olaf.
Enjoyed the Video. Thank you for sharing it.
Can you recomend so called "full blown courses on DAX" as referenced by Mr. Dickerman ?
Do you knwo who is teaching DAX and where ?
I did the Lynda Class (https://www.linkedin.com/learning/excel-power-pivot-dax/next-steps) "Excel-power-pivot-dax" and can very much recomend it, though I'd still feel there is so much more to learn. In particular on the "create Functions" and the use of the "Advance Editor" section.
- This site has a lot of resources https://powerpivotpro.com/
Also take a look at this course. https://www.edx.org/xseries/microsoft-excel-data-analystI'd add sqlbi.com, in particular https://www.sqlbi.com/p/introducing-dax-video-course/. In general google/bing Alberto Ferrari, Marco Russo, Rob Collie (sorry for not mentioned more) - you'll find a lot of resources and great books on Amazon.
