Curs initiere Microsoft Power BI | Cursuri Microsoft
15678
page-template,page-template-full_width,page-template-full_width-php,page,page-id-15678,bridge-core-1.0.6,become_a_teacher,bridge,learnpress,learnpress-page,ajax_fade,page_not_loaded,,qode_grid_1200,qode-theme-ver-18.2,qode-theme-bridge,qode_header_in_grid,wpb-js-composer js-comp-ver-6.0.5,vc_responsive
 

Curs initiere Microsoft Power BI

Durata: 4 zile – 3 ore/sesiune
Prezentare: Online – interactiv, platforma Microsoft Teams
Nivel: Incepator-Mediu

Curs Microsoft Power BI – Incepator

 

Durata cursului este de 12 ore, impartite pe 4 zile de studiu a cate 3 ore fiecare. Cursul este adresat celor ce doresc sa dobandeasca abilitati de baza in lucrul cu Microsoft Power BI Desktop.

Cursul este structurat atat pe parte teoretica, insa se pune foarte mult accent si pe partea practica pentru o mai buna intelegere a materiei prezentate.

Predare va fi realizata de catre traineri certificati Microsoft cu o buna pregatire atat pe parte practica cat si teoretica.

 

Despre curs

 

Audienta:Persoane fizice+Persoane juridice
Technologie: Microsoft Excel 2013/2016/2019, Power BI Desktop
Nivel: Incepator-Mediu
Modalitate de desfasurare: Online – interactiv, pe platforma Microsoft Teams (fiecare participant va avea fisiere de lucru pe care va exersa impreuna cu traierul)
Durata: 12 ore, program 9:00-13:00 sau 17:00-20.00 oricare 4 zile din cursul saptamanii (L-V)

Module

 

Modul 1: Using Excel as a Data Source for Power BI
  • Connecting to Files
  • Importing Excel Files
  • Updating Files in Power BI
  • Data Refresh
Modul 2: Introduction to Power BI
  • What is Power BI
  • Understanding Power BI Tools: Power BI Desktop, Power BI Service, Power BI Mobile and Power BI for Developers
Modul 3: An introduction to Power BI Desktop
  • Workflow in Power BI Desktop
  • Taking a closer look at the Query Editor Interface
  • Introducing the Different Views of the Data Model
Modul 4: Query Editor
  • An Introduction to the Query Editor
  • Connecting Power BI Desktop to our Data Sources
  • Editing Rows
  • Understanding Append Queries
  • Editing Columns
  • Replacing Values Formatting Data
  • Pivoting and Unpivoting Columns
  • Splitting Columns
  • Duplicating and Referencing Queries
  • Merging Queries
  • Creating an Index Column
  • Creating Contitional Columns
  • Performing Basic Mathematical Operations
Modul 5: Working on our Data Model
  • Data & Relationship View Query Editor vs. Data Model
  • Introducing and Understanding Relationships
  • Editing Relationships
  • Understanding Cardinality
  • Cross Filter Selection and Many-to-Many relationships
  • Understanding the differences between the M-Language and DAX
  • M vs. DAX applied: Calculated Columns
  • DAX – Basic information
  • DAX and Calculated Columns
  • Calculated Columns vs. Measures
  • Introducing DAX-Measures
Modul 6: Working in the Report View to Visualize our Results
  • Understanding the Interface of the Report View
  • Creating our First Visualizations
  • Editing Interactions and Adding Tooltips
  • Adding Data Colors
  • Understanding Hierarchies and Adding Drill-Down
  • Formatting Charts and Sorting
  • Introducing Slicers
  • Adding Treemaps and Tables
  • Applying different Filter Types
  • Understanding Combined
  • Visualizations and Waterfalls

Pe langa experienta lor profesionala, persoanele care participă la acest curs ar trebui să aibă una sau mai multe din următoarele notiuni tehnice:

  • Cunoasterea de baza a sistemului de operare Microsoft Windows si a functionalitatii sale principale.
  • Cunostinte despre bazele de date relationale.
  • Notiuni de business din domeniul afacerilor cum ar fi: venituri, vanzari, profitabilitate, indici de perfomanta (KPI).
  • Familiarizarea cu aplicațiile Microsoft Office – în special Excel nivel mediu.
    Sorry, no posts matched your criteria.