In Employee Data Analysis, => Apply filtering => Creating Pivot Table and Pivot Charts => Apply Conditional Formatting => Using countif() function => Use Vlookup for finding required values => Plot Charts for visulaization => Use index() and match() function => Creating Multilevel Pivot Table => Create Dynamic Chart => Use sumproduct() function => Create Dashboard
In HR Data Analysis, => Apply filtering => Creating Pivot Table and Pivot Charts => Apply Conditional Formatting => Creating Relationship between tables using Power BI => Use DAX for calculating values for a column using Power BI => Creating visual charts using Power BI => Follow Star Schema => Creating Hierarchy by drill down it using Power BI => Using sumifs() function => Use What-If Analysis