My winning entry for Maven Analytics challenge! https://www.linkedin.com/posts/maven-analytics_winner-maven-taxi-challenge-activity-6868510166241878...
The challenge info is at https://www.mavenanalytics.io/blog/maven-taxi-challenge?utm_source=linkedin&utm_campaign=taxichallen... and the questions to be answered were:
For any given fiscal week, I'd like to be able to use historical data to answer the following questions:
- What's the average number of trips we can expect this week?
- What's the average fare per trip we expect to collect?
- What's the average distance traveled per trip?
- How do we expect trip volume to change, relative to last week?
- Which days of the week and times of the day will be busiest?
- What will likely be the most popular pick-up and drop-off locations?
On the second page you can see all the DAX and M script I used to create this report.
eyJrIjoiZTkwYTI4NDUtZmIxZC00YWYwLWJhNzMtNjkwNTg2Mzk4YmE3IiwidCI6IjkyOWVlMzI0LTk3YzQtNDk1YS04MjM5LTZhZDg3NDk0MGVlYyIsImMiOjN9
