UtivaHR Analytics Student
Apr. 2021 - Jul. 2021Using Microsoft Excel and Power BI, Agile HR Analytics Program is designed to introduce professionals to the nitty gritty of HR Analytics using data from the foundation to the advanced knowledge. ⭐️ Data Processing: Sorting and filtering lists, building formulas, use of Paste Special, the IF function, cell references, linking worksheets, summarising data using Subtotal, Excel charts and using Pivot Tables.
⭐️ Data Analysis: Using time-saving keyboard shortcuts, convert and clean data types including text, times and dates, build impressive logic functions and conditional aggregations.
⭐️ Data Modelling: Building models for data by creating relationships among the data sources. Also integrating the tables, enabling extensive analysis using PivotTables, Power Pivot, and Power View.
⭐️ Data Segmentation: Breaking down or combine data into meaningful groups, and then comparing those groups to identify meaningful relationships in your data.
⭐️ Data Visualization: Interacting with data to find business insights. Using Microsoft PowerBI custom visuals, or selecting from lists of available visuals in building dashboards.