Curriculum

6 Chapters · 57 Lessons

  1. 1

    UVOD

    1. (Included in full purchase)

      Uvod u finansijske izveštaje u Power BI-u

    2. (Included in full purchase)

      Kviz: Uvod

  2. 2

    UVOZ PODATAKA IZ BAZE PODATAKA

    1. (Included in full purchase)

      Izvlačenje podataka iz baze podataka

    2. (Included in full purchase)

      Preuzimanje Azure Data Studio

    3. (Included in full purchase)

      Povezivanje i istraživanje baze podataka

    4. (Included in full purchase)

      Entity Relationship Diagram

    5. (Included in full purchase)

      Planiranje SQL Query-ja

    6. (Included in full purchase)

      Pisanje SQL Query-ja

    7. (Included in full purchase)

      Kreiranje SQL View

    8. (Included in full purchase)

      Kviz: Uvoz podataka iz baze podataka

  3. 3

    DATA MODEL U POWER QUERY-U

    1. (Included in full purchase)

      Kreiranje Data Model-a

    2. (Included in full purchase)

      Staging Query

    3. (Included in full purchase)

      Tabele činjenica i podataka

    4. (Included in full purchase)

      Kreiranje Data Modela i vizuala matrix

    5. (Included in full purchase)

      Kreiranje SUM mere

    6. (Included in full purchase)

      Kviz: Data model u Power Query-u

  4. 4

    BILANS USPEHA U POWER BI-U

    1. (Included in full purchase)

      Bilans uspeha

    2. (Included in full purchase)

      Finansijski izveštaji u postojećem data modelu

    3. (Included in full purchase)

      Kreiranje tabele zaglavlja u Excel-u

    4. (Included in full purchase)

      Importovanje tabele zaglavlja u Power BI

    5. (Included in full purchase)

      Kreiranje mere za vrednosti u bilansu uspeha

    6. (Included in full purchase)

      Kreiranje mere za iznose međuzbirova u bilansu uspeha

    7. (Included in full purchase)

      DAX funkcije za bilans uspeha

    8. (Included in full purchase)

      Kreiranje mere uz pomoć SWITCH()

    9. (Included in full purchase)

      Kreiranje mere % od prihoda

    10. (Included in full purchase)

      Formatiranje mere % od prihoda

    11. (Included in full purchase)

      Finalizacija mere bilans uspeha

    12. (Included in full purchase)

      Kreiranje Subcategory Display Filter

    13. (Included in full purchase)

      Kompletiranje bilansa uspeha

    14. (Included in full purchase)

      Dodavanje datuma osvežavanja podataka

    15. (Included in full purchase)

      Formatiranje Power BI izveštaja

    16. (Included in full purchase)

      Kreiranje Waterfall grafikona

    17. (Included in full purchase)

      Kviz: Bilans uspeha u Power BI-u

  5. 5

    BILANS STANJA U POWER BI-U

    1. (Included in full purchase)

      Popunjavanje ostatka strane Bilansa Uspeha

    2. (Included in full purchase)

      Bilans stanja

    3. (Included in full purchase)

      Ažuriranje tabele zaglavlja

    4. (Included in full purchase)

      Kreiranje mere za vrednosti u bilansa stanja

    5. (Included in full purchase)

      Kreiranje mere kumulativnog iznosa

    6. (Included in full purchase)

      Kreiranje mere međuzbira bilansa stanja

    7. (Included in full purchase)

      Krerianje mere bilansa stanja uz pomoć SWITCH()

    8. (Included in full purchase)

      Kreiranje početne mere za neraspoređenu dobit

    9. (Included in full purchase)

      Kreiranje mere za neraspoređenu dobit

    10. (Included in full purchase)

      Kreiranje mere za ukupan kapital

    11. (Included in full purchase)

      Kreiranje mere za ukupne obaveze i kapital

    12. (Included in full purchase)

      Kompletiranje bilansa stanja

    13. (Included in full purchase)

      Kviz: Bilans stanja u Power BI-u

  6. 6

    CUBE FUNKCIJE

    1. (Included in full purchase)

      Popunjavanje ostatka strane Bilansa Stanja

    2. (Included in full purchase)

      Dodavanje detalja i kreiranje dodatnih izveštaja

    3. (Included in full purchase)

      Uvod u Cube formule

    4. (Included in full purchase)

      Šta su Cube formule

    5. (Included in full purchase)

      Korišćenje slajsera uz pomoć Cube formule

    6. (Included in full purchase)

      Definisanje konteksta za godine za potrebe bilansa uspeha

    7. (Included in full purchase)

      Cube funkcije Bilans Uspeha

    8. (Included in full purchase)

      Cube funcije Bilans Stanja

    9. (Included in full purchase)

      Uvod u cash flow

    10. (Included in full purchase)

      Cube funkcije Cash flow

    11. (Included in full purchase)

      Kviz: Cube funkcije