Cursuri Power BI

Cursuri Power BI online
Durata: 2 zile
Pret: 350 Euro
Nivel: Incepator-Mediu

Curs Analiza datelor cu ajutorul Power BI

Un curs practic predat de catre traineri certificati cu o durata de 16 ore de studiu in cadrul caruia vor fi prezentate conceptele de baza in ceea ce priveste lucrul cu aplicatia Power BI.

Despre curs

Audienta:Persoane fizice+Persoane juridice
Technologie:Microsoft Excel 2013/2016/ Microsoft Power BI
Nivel: Incepator-Mediu
Modalitate de desfasurare: Sala de curs
durata: 16 ore, program 9:00-17:00 oricare 2 zile din cursul saptamanii (L-V)
durata: 18 ore, program 18:00-21:00, 2 zile/saptamana (L-V), durata proiect 3 saptamani

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
  • Operatori matematici si ordinea operatiilor(adunare, scadere, inmultire, impartire, procent)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
Formular inregistrare:




Campurile marcate cu * sunt obligatorii!



Te-ar putea interesa si: