Data Modelling in Excel in Very Simple Steps | No VLOOKs | No INDEX & MATCH functions
In this video, I explained data modelling in excel without writing complex excel formulas like INDEX & MATCH, VLOOK, HLOOKUP or XLOOKUP in easy and simple steps. Data modelling via Power Pivot is a very powerful technique especially when you have multiple excel tables or files to analyse.
Watch this video to see my Data Modelling in PowerBI: • Step by Step Guide to Data Modelling in Po...
#powerbi #powerpivot #data #datascience #datamodelling #dataanalysis