PowerBI Hands-on

Dauer

2,00 Dag(Deeg)

Sprooch(e) vun der Déngschtleeschtung

EN FR

Nächst Sessioun

Wien organiséiert dës Formatioun?

Mir stäerken souwuel d'individuell Entwécklung wéi och d'Effizienz andeems mir d'IT-Expertise an d'Managererfahrung vun eise Léierpersonal deelen. Mir bidden iwwer 300 Coursen op Franséisch an Englesch an eisem Zentrum zu Capellen un. Dës Coursen konzentréiere sech op Infrastruktur, Entwécklung, Projetmanagement, Governance a Soft Skills.

Méi gesinn

Den Inhalt vun dëser Säit ass net op Lëtzebuergesch verfügbar

Virkenntnisser

To follow this Power Bi training, it is mandatory to master the pivot table functionality of Excel

Ziler

This Power Bi training course is aimed at people who are familiar with the Office 365 environment, for whom Excel is their daily routine and who want to share effective visuals of company data with members of their organisation.

Inhalt

Load data from Power BI

if necessary know how to adapt to data with Power Query

Transform data with power Query

Manage columns and rows to keep
Rename headers
Sort/Filter
Split columns
Group data (subtotals)
Adapt data types to analysis needs (+ automatic detection)
Create header row
Replace/Adapt Values
Make calculated operations
On Numbers (Stat, Rounding, Information...)
On Dates (Year, Birthday...)
Group columns to create structured data

Add columns operation with power Query

Adding column from selection
Adding custom columns
Column duplication
Format columns
Retrieve data from columns

Once the data is fully usable, upload it to Power Bi

The Report view

Once the data is prepared, learn to master the Fields, Visualizations, and Filters panes to create a visually appealing and dynamic presentation in Power BI

Illustration of pages

Graphics
Classics: stacked bars, stacked histogram, grouped bars, curves, areas, sectors...
365: Ribbons, waterfalls, funnels, Hierarchies, Maps
Gauges
Performance indicators
Segments
Value maps
Tables and matrices
Key Influencers