Category: Data Analytics

I monitor temperature and humidity in my sunroom. An interesting trend can be seen when overlapping humidity and temperature. As the sunroom is an uncontrolled environment when temperature increases during the day humidity drops down but at night when temperature comes back down humidity comes back up.

Analyzing my aquarium total dissolved solids (TDS) a neat trend can be noticed. A water change was completed on the 9th which resulted in a dramatic drop in TDS but over time the TDS had risen back to its previous levels. As this the aquarium has an open top, water will evaporate and lead to an increased solids concentration. A water top up was completed on the 8th and there was a drop in TDS related to that as well.

A follow up for some of the takeaways of the previous post (https://adam-s.ca/understanding-fridge-temperature/). Repeating the experiment in a different part of the fridge showed some cleaner results. In-fact there were oscillations present at a much more realistic interval (30min). This was very surprising as this is a mechanical fridge with a thermostat and the oscillating period was dead on 30min almost as if it was computerized.

The temperature logger was able to go for 4.5 days on the external battery bank.

One of my Power BI reports has reached the top 1% of all Power BI reports for the whole international company. A few keys to getting my report to this point.

• Value to users: I tailored many aspects of the report to be more suitable to users in different departments giving them a reason to use it and widening the amount of people interested.
• Automated Reports: Many daily and weekly status and trends were automated through power automate where users could quickly see top issues and then links were added to go to the Power BI report for further trends.
• TRAINING, TRAINING, TRAINING: Many users are still new to Power BI and are unaware of what data is available. Training sessions and more commonly training videos were a key in getting users more engaged and involved.