For the past few years, I have been manually tracking data reporting on user activity. it hasn't been bad since it is not performed excessively and I want to try to automate it in some manner to alleviate the burden and i thought this was the perfect to to understand and learn BI.
Data is exported daily as Excel files and kept in a folder, here is a modified sample, there are many columns and we are only displaying the ones needed for this exercise.
To track and report daily user activity, I have been manually transposing the data like so.
With this, I can track daily users/group performance and retain a historical log. Note not every user has an activity every day and some days have no activity.
The goal was for me to somehow automate a daily report, can anyone provide guidance on how to perform this in BI or alternative solution? thank you in advance!
Data is exported daily as Excel files and kept in a folder, here is a modified sample, there are many columns and we are only displaying the ones needed for this exercise.
To track and report daily user activity, I have been manually transposing the data like so.
With this, I can track daily users/group performance and retain a historical log. Note not every user has an activity every day and some days have no activity.
The goal was for me to somehow automate a daily report, can anyone provide guidance on how to perform this in BI or alternative solution? thank you in advance!