The participant must know Excel skills such as Pivot Table, SUMIF, COUNTIF, Excel Table, Slicer, DATE related functions.
The is level 1 of fundamental level.
The course will guide the participant to master the most basic steps to start learning Power BI in just 60 minutes.
At the end of the course, the participant will learn how to:
Download Power BI Desktop What is Power BI Desktop? What can it do for strategic HR? Download hr data What is the data about? Get Data Why? dashboard in Power BI vs Excel
The Power BI environment The Powerquery Editor environment Basic data cleaning How to create a visual – donut chart What is DAX DAX Types How to calculate headcount with COUNTA DAX function
Matrix visual Total Salary – SUM measure Monthly salary Formatting CALCULATE
Get Total salary for just HR dept Get Total salary for just HR and Account dept
How to add a slicer How to format a slicer How it affects the Table's visual Add multiple slicers
Why revision 2nd set of HR data Assessment What’s next?
Microsoft Power BI for Strategic HR (Fundamental Level- L1)
No Review found