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