Here are some tips and tricks for using Power Pivot and Power BI:
Are you trying to take your Excel data modeling to the next level? If you haven't read (MrExcel) work on Power Pivot and Power BI, you are missing out on one of the clearest roadmaps to mastering DAX and the Data Model. power pivot and power bi bill jelen pdf
| Title | Focus | Power Pivot Coverage | Power BI Coverage | Available as Official PDF? | |-------|-------|----------------------|-------------------|----------------------------| | (with Rob Collie) | Deep dive into DAX and data modeling | Extensive (DAX, relationships, measures) | Minimal | Yes (via Holy Macro! Books / MrExcel store) | | MrExcel 2021: Unmasking Excel | Broad Excel features | One major chapter | One major chapter | Yes (digital edition via MrExcel) | | Power BI for the Excel Analyst (by Wyn Hopkins, foreword by Jelen) | Transition from Excel to Power BI | Moderate (as foundation) | Extensive (dataflows, DAX, visuals) | No (print/eBook only) | Here are some tips and tricks for using