This project saw me creating a PowerBI dashboard to report on check-in data at my gym. I had to write SQL queries to create calculated fields from data which is unlabeled and partially unstructured.
The main calculated fields I created include the age category (adult/youth) of a visitor based on birthday and the aspects of whether a visitor is on the team or not on the team. This one required a much more complex query as the database does not store the information directly as a separate field. Instead, you can either query on a regex of add-on product purchases or you can check for another field that has the be within a range of values which can be queried for.
To avoid showing sensitive company data, the photo below has only the graphs with the filters cropped out of the image. However, the actual dashboard allowed for executives to check by month, week day, time block, location, age, and team.
