Summary
Keywords
Full Transcript
Give it a try 👉 https://chandoo.org/wp/mandatory-trainings-are-we-doing-them-data-analysis-challenge-002/ Ever wondered how actual data analysis work looks like? In this video, let me show you behind curtains scenes of the kind of questions I get and how I answer them with Excel. We are looking at two sets of data - training data & employee data and finding answers to questions about compliance. Specifically, 1) How many employees have completed all mandatory trainings? 2) How many have done at least one mandatory training? 3) Who have not attempted any mandatory trainings? 4) Department-wise report Learn how to use simple Excel formulas like COUNTIFS to elegantly answer business questions like this for MIS reports, dashboards and data analysis work.
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
