Thank you Sam for your feedback. Sorry, I had some urgent things I had to handle. So, I couldn’t submit my thought process( I totally missed challenge 3 too).
How I create some of these reports might not be suitable for a showcase as I am learning and a student teaching a student might not be
a good idea.
But generally, I was thinking of the requirements that was provided and based on that, I created a report which I thought should reflect, if the app the company implemented made a difference on how long it took to deliver to the desired destination by calculating the minute difference between arrival and left columns when it’s scanned or manually entered.
I wanted to create a time calculation by creating a date dimension but, because of the time stamp on the fact table, which I needed the date table to connect, didn’t work. So I figured that if the time the order arrived and left is the same day and this is the main analysis the end users needed, and the dates provided were the same date, I don’t need to create a date dimension. There fore, instead I worked with the dates that were in the fact table.
To calculate the average time it took in minutes between arrival and departure, I used datediff function - Averagex( Deliveries, datediff ( arrival,left, minutes) ) .
When it comes to visualizations, I thought a light and visually not too heavy might keep the clients look deeper to the report.
Obviously, The color palette, should have been better, will improve that and use the EDNA color generator in my future projects.
Thanks and regards
Nebiyu Sahlu