starting: https://youtu.be/UXhGRVTndQA?si=G-G3r93O_YVDx9Hw
AIMS grid in project envoronment
- KPIs
- powerbi is the only chart that comes with animation in default that is in scatter plot
- gauge chart usecase
- Cosmetic part in text cart and number card
- multi row and multi column card
- ETL
- If the column name is state, city , or postalcode, it is automatically considered as geographical data type
- When we are appending the files like csv and excel , the data should be clean
- fact table and dimenstion table
- dax is the language that is used to calculate things in pworbi or more importantly in powerpivot
- data modeling
- if u want to grow powerbi skills, don’t create implict measures , instead create it explicityly using dax
- meausre will not contain in any table, but rather it is laid out to it, that’s why we use like this
- base measures and composite measures, base meaures when we creating using dax first
- calculate method in powerbi which can over write
- wahat is measure- it will return a single vaue
- null vs blank