How to get started with Power BI?
In this video we’ll tackle the basis of this software through the presentation of a practical case (management of a company’s stock).
Feel free to give me some feedback in the comments down below!
Your project is to develop a dashboard? You need some training?
Contact me → https://www.alexandrestevens.fr/contact
To support my channel → Like and subscribe
Follow me at → Alexandre STEVENS Créateur vidéo YouTube | LinkedIn
To obtain the data:
https://www.youtube.com/redirect?even...
SUMMARY:
00:00 – Intro
I CREATING A FOLDER ARCHITECTURE
01:35 – creating your folder
03:36 – giving your files the right name
04:25 – requesting a folder (with several Excel files)
II MANIPULATING AND TRANSFORMING DATA (POWER QUERY)
05:58 – quality indicator
07:05 – dividing a column
07:45 – replacing a value
08:18 – removing a column
09:10 – removing lines
09:23 – positioning a line in the header
10:05 – renaming headers
10:45 – modifying the data types
11:35 – dealing with errors (analysis and suppression)
12:55 – dealing with empty spaces (analysis and suppression)
14:00 – requesting an Excel file
16:15 – removing empty spaces
16:42 – combining 2 tables (= VLOOKUP with Excel)
18:06 – creating a calculated column
19:02 – creating a conditional column (= IF with Excel)
20:40 – Saving your report
III – CREATING A DASHBOARD (POWER BI)
20:48 – creating a dropdown list (date filter)
21:31 – creating a card (with an issue, if you’re skilled, you’ve seen it before me ;))
22:28 – personalizing a visual
24:16 – creating a quick measure (variation M/M1)
26:24 – creating a conditional column
28:40 – creating a DAX measure (= SUMIF with Excel)
30:30 – creating a line chart
31:00 – modifying the influence of the filters
32:42 – creating a doughnut chart
33:03 – creating a TOP 5
34:08 – adding visual filters
35:30 – OUTRO
Website →Alexandre STEVENS Création tableau de bord Finance Power BI
LinkedIn → Alexandre STEVENS Créateur vidéo YouTube | LinkedIn
Instagram → Alexandre STEVENS (@alexandre.stevens.as) • Photos et vidéos Instagram
Thank you for watching !!