Curriculum

12 Chapters · 68 Lessons

  1. 1

    ITERATIVNE FUNKCIJE

    1. (Included in full purchase)

      Slicer Selection + measures

    2. (Included in full purchase)

      Tehnike rangiranja

    3. (Included in full purchase)

      Funkcije AVERAGEX i RANKX

    4. (Included in full purchase)

      Iterativne formule, računanje medijane

    5. (Included in full purchase)

      SUMX, MINX, MAXX

    6. (Included in full purchase)

      Napredni RANKX

    7. (Included in full purchase)

      Razlike između funkcija SUM i SUMX

    8. (Included in full purchase)

      Kviz: Iterativne funkcije

  2. 2

    FUNKCIJE ZA OBRADU PODATAKA

    1. (Included in full purchase)

      Funkcija ALL, korišćenje promenljivih u DAX-u

    2. (Included in full purchase)

      Funkcija TOPN, upoređivanje performansi korišćenjem ALL funkcije

    3. (Included in full purchase)

      Funkcija ALLSELECTED

    4. (Included in full purchase)

      Različiti načini za korišćenje TOPN funkcije

    5. (Included in full purchase)

      Poređenje najboljih i prosečnih parametara

    6. (Included in full purchase)

      Kviz: Funkcije za obradu podataka

  3. 3

    LOGIČKE I SKALARNE FUNKCIJE

    1. (Included in full purchase)

      Funkcija LASTNONBLANK, korišćenje SWITCH true logike

    2. (Included in full purchase)

      Funkcija INTERSECT

    3. (Included in full purchase)

      Funkcija EARLIER

    4. (Included in full purchase)

      Funkcija COMBINEVALUES, višestruki IF iskazi

    5. (Included in full purchase)

      Funkcija GROUPBY

    6. (Included in full purchase)

      Kviz: Logičke i skalarne funkcije

  4. 4

    TOTALI I SUBTOTALI

    1. (Included in full purchase)

      Dobijanje odgovarajućih totala naprednijom logikom

    2. (Included in full purchase)

      Upravljanje totalima i subtotalima

    3. (Included in full purchase)

      Kviz: Totali i subtotali

  5. 5

    TABELARNE FUNKCIJE

    1. (Included in full purchase)

      Funkcija CROSSJOIN

    2. (Included in full purchase)

      Funkcija TREATAS

    3. (Included in full purchase)

      TREATS vs USERELATIONSHIP

    4. (Included in full purchase)

      Kviz: Tabelarne funkcije

  6. 6

    FUNKCIJE ZA RAD SA DATUMOM I VREMENOM

    1. (Included in full purchase)

      Funkcija PARALLELPERIOD

    2. (Included in full purchase)

      Upravljanje datumskim kalkulacijama

    3. (Included in full purchase)

      Funkcija DATEADD

    4. (Included in full purchase)

      Izračunavanja u finansijskoj godini

    5. (Included in full purchase)

      Kumulativno poređenje rezultata najboljeg i trenutnog meseca

    6. (Included in full purchase)

      Kreiranje tabele za datum - osnovni i napredni oblik

    7. (Included in full purchase)

      Prikaz datuma i vremena poslednjeg osvežavanja

    8. (Included in full purchase)

      Kviz: Funkcije za rad sa datumom i vremenom

  7. 7

    DINAMIČKO GRUPISANJE I RANGIRANJE

    1. (Included in full purchase)

      Vezivanje i grupisanje u DAX-u

    2. (Included in full purchase)

      Kreiranje dinamičkih vizuala pomoću rangiranja

    3. (Included in full purchase)

      Kombinovanje dinamičkog grupisanja sa rangiranjem

    4. (Included in full purchase)

      Dinamičko menjanje veličine vizuala

    5. (Included in full purchase)

      Otkrivanje šablona i klastera u podacima

    6. (Included in full purchase)

      Dinamičko izolovanje

    7. (Included in full purchase)

      Okidači

    8. (Included in full purchase)

      Algoritmika virtuelnih tabela

    9. (Included in full purchase)

      Dinamičko izdvajanje top 20% kupaca

    10. (Included in full purchase)

      Dinamička segmentacija, dinamički parametri

    11. (Included in full purchase)

      Kviz: Dinamičko grupisanje i rangiranje

  8. 8

    TOTALI

    1. (Included in full purchase)

      Dobijanje odgovarajućih totala naprednijom logikom

    2. (Included in full purchase)

      Popravljanje totala iterativnim funkcijama

    3. (Included in full purchase)

      Kviz: Totali

  9. 9

    KUMULATIVNE KALKULACIJE

    1. (Included in full purchase)

      Kumulativne kalkulacije bez datuma i indeksa

    2. (Included in full purchase)

      Kumulativne kalkulacije po mesecima

    3. (Included in full purchase)

      Kviz: Kumulativne kalkulacije

  10. 10

    VIRTUELNE TABELE

    1. (Included in full purchase)

      Iteriranje kroz virtuelne tabele

    2. (Included in full purchase)

      Analiza potrošačke korpe

    3. (Included in full purchase)

      Prikaz poslednjih prihoda

    4. (Included in full purchase)

      Funkcija COUNTROWS

    5. (Included in full purchase)

      Virtuelno poređenje 2 liste podataka

    6. (Included in full purchase)

      Izgubljeni kupci

    7. (Included in full purchase)

      Kviz: Virtuelne tabele

  11. 11

    NAPREDNE STATISTIKE

    1. (Included in full purchase)

      Pokretni prosek 1

    2. (Included in full purchase)

      Pokretni prosek 2

    3. (Included in full purchase)

      Najbolji kupci u prethodnom i trenutnom periodu

    4. (Included in full purchase)

      Označavanje rasta kupaca

    5. (Included in full purchase)

      Dinamičke procentualne vrednosti

    6. (Included in full purchase)

      Kviz: Napredne statistike

  12. 12

    RAD SA DATUMIMA

    1. (Included in full purchase)

      Razlike u danima između kupovina

    2. (Included in full purchase)

      Otkrivanje datuma poslednje izmene

    3. (Included in full purchase)

      Kviz: Rad sa datumima