Walk Through Guide for Kusto Detective Agency Season 2, Case #1 Solution
Cases Solutions: 0 1 2 3 4 5 6 7 8 9 10
Get ready to save money on your bills! 💸
The first case riddle is:
The key takeaways from the riddle:
- The monthly bills are calculated for each house, based on water and electricity consumption
- The usage pattern has not changed, yet total bills have risen up
- We are asked to find the best approximation of the right amount to bill
⚠SPOILER ALERT — THE SOLUTION DESCRIBED BELOW⚠
Note: Solution is mine, and non-official
So let’s delve into the data, by leveraging the | take 10, to see some rows.
The Consumption table has; Timestamp, HouseholdId, MeterType, Consumed.
Let’s see Costs table as well:
Nothing exciting, yet 😉
Metrics reporting is error-prone:
Sometimes the same metric is sent again, as it’s better to send same record than to lose it, so let’s hunt duplicates:
Voilà! First luck🌟
Moreover, some telemetry values are faulty.
Let’s see what the value ranges there are:
We definitely don’t want such negativity in our life!
Let’s avoid duplicate rows, by using the distinct operator, and avoid negative values:
We saved the day! …or at least some money for Digitown citizens 🦸♂🦸♀
Enjoyed this article? Feel free to long-press the 👏 button below 😀
Click for Next Case Solution ➡
