KIND network update
Week beginning Mon 16th September 2024
Dear colleagues,
Welcome to our regular KIND network update. We’re starting our new Tableau for Beginner’s course next week. That uses Tableau Public so should be available to all. Hope to see you there 13.00-15.00 this coming Thursday.
A reminder that we’ll be scheduling training sessions for November and December next week. Please get in touch ASAP if you’d like some training for your team. We can potentially offer any of our multi-session courses or any of our one-off sessions to you and your team free of charge. All that we ask is that you can commit to having 15-20 staff attend the sessions, and that you can take care of any admin and infrastructure requirements such as circulating invites, installing software etc.
Hope to see you at something soon
Brendan
Wins of The Week
In the spirit of #IAmRemarkable, we do a weekly wins of the week thread to celebrate the professional (and personal) achievements of the community. A random selection from last week:
- I succeeded in using INDEX and MATCH to help a colleague onboard data from a separate spreadsheet into the exact rows required. She was so chuffed. 😃 Then replaced the formulas with values using paste special.
- Volunteered to provide a brief summary of work being done by myself and fellow PHIT on developing a Lothian child poverty indicators dashboard at this weeks’ SCODAS meeting. Off the back of that there appears to be further interest for us to present at a future SCODAS session where we present the dashboard
- I ran my first (and only!) half-marathon last Sunday, completing the Great North Run - and, thanks to supporters, raising funds for Parkinson’s UK. Very chuffed with myself!
- Joined the R from Scratch session this week after not using R for almost a year and found that I actually remembered quite a lot of the content that was being taught. Win win for me and I didn’t panic too much as I thought that I had forgotten everything!
Training sessions
| Session | Date | Area | Level |
|---|---|---|---|
| Tidy data in Excel | 09:30-10:30 Tue 17th September 2024 | Excel | 🌶 :beginner-level |
| R from scratch (session 3) | 14:30-15:30 Tue 17th September 2024 | R | 🌶 :beginner-level |
| BI for beginners (service version, session 2) | 10:00-12:00 Thu 19th September 2024 | Power BI | 🌶 :beginner-level |
| Tableau for beginners (session 1) | 13:00-15:00 Thu 19th September 2024 | Tableau | 🌶 :beginner-level |
Events
- 3-4pm, Mon 16th September 2024. All welcome at the Community Meetup - our regular Monday get-together/webinar/tech demo. Full details and joining links via the community meetup channel. The theme this week is joins again, with the third and final sessions on the topic. This session will concentrate on more advanced techniques - rolling joins, non-equi joins etc. As usual, we’ll do a bit of introduction and chat, and then show how these can be implemented in a range of platforms.
- 1-2pm, Tue 17th September 2024. The Scottish Community of Data Analysts is a community of practice for those working with data in territorial NHS Boards. Next week, the presenter will be Lukasz Henszel - Infectious diseases notification exceedance detection (surveillance/ signals for potential outbreaks).
Book of the week
Chris Chambers. 2019. The 7 Deadly Sins of Psychology.
ISBN 9780691192277, Worldcat.
Rosalyn Pearson, a Senior Information Analyst at Public Health Scotland, suggests this book of the week. `I highly recommend The 7 Deadly Sins of Psychology by Chris Chambers. It’s all about pitfalls in real-world scientific methodology and what we can do to combat them. The title says ‘psychology’ but it applies more broadly..