Power BI assignment and excel

In this example, a large amount of data is generated by sensors. This data represents the movement of warehouse workers and is an important measure of our interest. Each move by the employee is recorded and automatically generates a unique identification number (UIN) which provides the basis for advanced visualization. If an employee performs two times, two distinct entries are generated which in the excel form would appear as two rows. Data generated is huge as there are about 28000 entries that needs to be analyzed. The objective is to find:

  1. How many employees are actively working in the warehouse? Active employees are those who make a move and thus their data is generated
  2. How many total tasks were recorded? (This may contain some duplicated data)
  3. How many unique tasks were recorded? (This cannot contain duplications)
  4. How many tasks were executed each month?
  5. Which employee (name) has the greatest output? How much is their output?
  6. Show visualization of employees output?
  7. At what hour of the day are employees most productive?
  8. An employee named paula is most productive what time, in general without giving consideration to the month. And what about an employee named Grant?

Report Expectations:

  1.  Cover page  Your identification 
  2. First-page  A Microsoft word report should provide a tabular summary with answers to all the above questions
  3. The second page onwards  copy-paste high-quality visuals from Power BI to word file. These visuals must have appropriate titles, labels, etc.

 

 The data does not contain a separate hours column rather it is combined with the date in the first column. To convert it into hours, first, duplicate the date column and name it Hour, then in the duplicated one, right-click transform hour hours. If you use it as such, it will be summed up, to avoid that convert into text right click change type text.