Curs initiere Microsoft Power BI | Cursuri Microsoft

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.

Formular inregistrare:

Te-ar putea interesa si:

Sorry, no posts matched your criteria.