Koorsadan waxay ku baraysaa sida xogta loo nadiifiyo, loo qaabeeyo, loona falanqeeyo adoo isticmaalaya Power Query, Power Pivot, iyo DAX ee Excel. Casharo practical ah oo gacanta lagu samaynayo ka dib, waxaad ku baran doontaa sida xogta looga soo qaado ilo kala duwan, loo maareeyo xogaha aan habaysanayn, loo dhiiso moodallo xogeed oo la ballaarin karo, iyo sida loo sameeyo xisaabin sare. Dhammaadka koorsada, waxaad awood u yeelan doontaa inaad samayso warbixino dynamic ah, aad si hufan ugu shaqayso xogaha adag, aadna adeegsato xirfado falanqayn oo la adeegsado goobaha shaqada dhabta ah, iyo weliba inaad hesho shahaado aad ku muujiso xirfadaada.
Manhajka Koorsada
Shuruudaha
Xirfadaha aasaasiga ah ee Excel (formulas, tables)
Fikirka falanqaynta iyo rabitaanka waxbarashada
Laptop/PC uu ku rakiban yahay Excel
Natiijooyinka
Faham aasaaska PivotTables, Power Query, iyo Power Pivot
Kasoo geli data ilo kala duwan gudaha Excel
Nadiifi, beddel, oo habee data-da adoo adeegsanaya Power Query
Dhis data models adoo adeegsanaya xiriirada gudaha Power Pivot
Qor formula-yada aasaasiga ah ee DAX ee xisaabinta
Abuur warbixino adoo adeegsanaya taaballo kala duwan iyo data model isku xiran
